Oracle Advisor – DBMS_ADVISOR
Some ADDM dumps. read more →
new explain plan options (dbms_xplan)
I still need to upgrade to 10g … read more →
Invalidated synonyms
In Oracle 10G synonyms are marked invalid when you perform DDL on the referenced object. read more →
overcome SP2-0734 when using purge command
Issue new Oracle 10G ‘purge‘ command results in ‘SP2-0734: unknown command beginning “purge user…” – rest of line ignored.’ read more →
Automatic Workload Repository
A very short howto for the ‘Automatic Workload Repository’, the successor of perfstat. read more →
,