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;

--------------- ------------------------------ --------------- ------------------------------
UPGRADE 10-DEC-09 AM Upgraded from
APPLY 10-DEC-09 PM CPUJul2009
CPU 10-DEC-09 PM view recompilation