Archive for October, 2008

Purge USER_TAB_MODIFICATIONS

October 30th, 2008

If you want to get rid of the content of USER_TAB_MODIFICATIONS or DBA_TAB_MODIFICATIONS then you have to execute dbms_stats.FLUSH_DATABASE_MONITORING_INFO
If that is taking a very long time then you might have hit the oracle bug 5709414

Filed under:  Uncategorized | No Comments

How to list the installed patches on Oracle?

October 21st, 2008

Use Opatch.
Look in the Opatch directory in Oracle Home.
‘opatch query -all’ will allow you to query detailed information about a patch.
‘opatch lsinventory’ will list all patches with the applied date chronologically.
‘opatch lsinventory -detail’ will list all patches and which files were modified.

Filed under:  Oracle 10g, Oracle 11g, Oracle 9i | No Comments