Purging SYSAUX tablespace (Purging AWR reports)
Dump below is of a session clearing the sysaux tablespace. read more →
Dump below is of a session clearing the sysaux tablespace. read more →
Manually triggering metric collection in Oracle Enterprise Manager (GRID control)
Some additional configuration directives. read more →
So it was decided ‘this batch’ had to be done ‘this weekend’. Thousands of SQL statements some of them would take minutes others hours… And MAKE SURE it’s finished monday. read more →
Here’s how to overcome ORA-20206 in Oracle GRID environment, agent status unclear… read more →
Here’s how to clear alerts from the Oracle GRID manually. read more →
The following objects are invalid after a clean ctxsys install. read more →
Suffering from corruption in your database, it is nearly just as challenging as in real life… read more →
I still need to upgrade to 10g … read more →
Have to delete a large number of records and running out of undo tablespace ‘ORA-30036: unable to extend segment by 8 in undo tablespace ‘UNDO’? Script below does a delete with intermediate commits ever ‘x’ records. read more →
In Oracle 10G synonyms are marked invalid when you perform DDL on the referenced object. read more →
Issue new Oracle 10G ‘purge‘ command results in ‘SP2-0734: unknown command beginning “purge user…” – rest of line ignored.’ read more →
A very short howto for the ‘Automatic Workload Repository’, the successor of perfstat. read more →
Code below will save the information of the ‘blocking session’ in an ORA-00060 situation. read more →
,