view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

Oracle assists professionals looking for recovery programs

Between natural disasters, cybercrime and basic human error, organizations are looking for tools that support disaster recovery endeavors, as well as the professionals capable of using them.

A fair number of administrators often use Oracle's advanced recovery features to help them ensure business continuity for database-driven applications. The database vendor recently unveiled a couple of new offerings that tightly integrate with their Oracle Database architecture.

Oracle Sequences and Replication

As I mentioned last week, Oracle sequences are often topics of conversation when discussing replication. Last week we covered the basics of sequences and I pointed out a few important facts; there may be ‘gaps’ in the sequence as Oracle does not guarantee that they will be in order, that there is an option to have […]

rmoug 2015 presentation ready to go ... makes me ( not ) grumpy

All ready to roll with RMOUG 2015 Training days presentation "OS Truth, little white lies, and the Oracle Wait Interface".

Best of course to come to RMOUG 2015 Training days ... but this is link to pdf version of the presentation here: John Hurley RMOUG 2015

If you are out there ( very excited personally my first time at this conference ) please kick me and say hello.  Ok maybe skip the kicking part ...

handy ash queries to look at blocked sessions ( how many when for what event ) ...

Licensing may be required ... please check if applicable.

A query like this can be used to check how much blocking and what session it was ... ( so then you can drill into those blockers sessions ).  Probably can be done easily with some kind of rollup query?

Adjust SAMPLE_TIMEs in where clause below.

select ash_data.*, substr(sqlinfo.sql_text,1,70)
from

Oracle Database Upgrade

Dear All

We are upgrading oracle database version 11.2.0.2 to 11.2.0.4. Before upgrade invalid object count was 0 (Zero). But after upgrade one of the object in Quest schema become invalid. Due to which catsbp.sql is also incomplete. Kindly help..

Part of log file.

*** Invalid Objects after recompiling ***

OWNER OBJECT_ID OBJECT_TYPE OBJECT_NAME
---------------------------------------------------
QUEST 408304 PACKAGE BODY QUEST_SPC_ANALYZE

*** END RECOMPILING OBJECTS ***

Cannot Integrated JDeveloper with SOA Server

When trying to integrated JDeveloper with SOA server the below error Appeared :-Testing JSR-160 Runtime ... failed.Cannot establish connection.Testing JSR-160 DomainRuntime ... skipped.Testing JSR-88 ... skipped.Testing JSR-88-LOCAL ... skipped.Testing JNDI ... skipped.Testing JSR-160 Edit ... skipped.Testing HTTP ... success.Testing Server MBeans Model ... skipped.

Oracle SQL Profile: why multiple OPT_ESTIMATE?

In a previous blog I'v shared my script to retrieve the OPT_ESTIMATE hints from a SQL Profile. In the example I made, I had two lines for each table:

Why is it not possible to raise an exception when handling no_data_needed ?

It seems impossible to raise an exception when handling no_data_needed.
See

StatsPack and AWR Reports -- Bits and Pieces -- 3

This is the third post in this series.
Post 1 is here
Post 2 is here

Singapore Oracle Sessions - Beginnings

Last Monday evening we had the first Singapore Oracle Sessions - an informal meetup of Oracle professionals thrown together at the last minute by a few of us.

view counter