remi's adventures in the database realm

./ oracle / new features / 10g

Oracle Advisor - DBMS_ADVISOR

oracle / new features / 10g  September 5th, 2007

Some ADDM dumps. read more →


new explain plan options (dbms_xplan)

oracle / new features / 10g  August 14th, 2007

I still need to upgrade to 10g … read more →


Invalidated synonyms

oracle / new features / 10g  August 30th, 2006 / January 20th, 2008

In Oracle 10G synonyms are marked invalid when you perform DDL on the referenced object. read more →


overcome SP2-0734 when using purge command

oracle / new features / 10g  August 30th, 2006 / January 27th, 2008

Issue new Oracle 10G ‘purge‘ command results in ‘SP2-0734: unknown command beginning “purge user…” - rest of line ignored.’ read more →


Automatic Workload Repository

oracle / new features / 10g  July 2nd, 2006 / August 20th, 2007

A very short howto for the ‘Automatic Workload Repository’, the successor of perfstat. read more →