Thursday, December 10, 2009

How to check whether CPU and/or Windows Bundle patch applied to database

It is possible to check against the registry$history, in the "comments" column, it shows the decription for CPU patch (for example CPUJul2009) or Windows bundle patchs (for example, Patch 18).

For example:

SQL> col action for a15
SQL> col ACTION_TIME for a30
SQL> col COMMENTS for a30
SQL> col version for a15
SQL> set lin 100

SQL> select action,action_time,version,comments from registry$history;

ACTION ACTION_TIME VERSION COMMENTS
--------------- ------------------------------ --------------- ------------------------------
UPGRADE 10-DEC-09 10.47.04.162576 AM 11.1.0.7.0 Upgraded from 11.1.0.6.0
APPLY 10-DEC-09 12.50.17.018749 PM 11.1.0.7 CPUJul2009
CPU 10-DEC-09 12.52.37.373144 PM view recompilation