Purging SYSAUX tablespace (Purging AWR reports)
Dump below is of a session clearing the sysaux tablespace. read more →
Manually triggering Metric Collection (clearing -tablespace- Alerts)
Manually triggering metric collection in Oracle Enterprise Manager (GRID control)
Increase idle time for OMS frontend sessions
Some additional configuration directives. read more →
Batch SQL statements in parallel (multiple) sessions
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 →
Really delete (‘corrupt’) Agent from OMS repository
Here’s how to overcome ORA-20206 in Oracle GRID environment, agent status unclear… read more →
Clearing Alerts in Oracle GRID Control
Here’s how to clear alerts from the Oracle GRID manually. read more →
invalid objects after clean ctxsys installation (oracle text)
The following objects are invalid after a clean ctxsys install. read more →
dbverify in nohup
Suffering from corruption in your database, it is nearly just as challenging as in real life… read more →
new explain plan options (dbms_xplan)
I still need to upgrade to 10g … read more →
delete large number of records with intermediate commits
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 →
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 →
dba$log_blocker
Code below will save the information of the ‘blocking session’ in an ORA-00060 situation. read more →
,