Need to appy the CPU patches.
Hi All,
customer want to review the CPU patches status and interested in having latest CPU patches applied.So we need to find out what is the latest CPU patches applied.
For database we have done with the below query:
SQL> select * from dba_registry_history ;
ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS
--------------------------------------------------------------------------- ------------------------------ ------------------------------ ------------------------------ ---------- ------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
05-AUG-09 07.34.49.704740 PM CPU SERVER 10.2.0.3.0 7369190 CPUOct2008
09-FEB-11 07.18.10.309559 PM APPLY SERVER 11.2.0.1 3 PSU PSU 11.2.0.1.3
14-MAR-08 09.59.41.067259 PM CPU 6452863 view recompilation
23-OCT-10 10.56.18.468035 AM VIEW RECOMPILE 8289601 view recompilation
23-OCT-10 10.56.18.801283 AM UPGRADE SERVER 11.2.0.1.0 Upgraded from 10.2.0.3.0
05-NOV-11 01.08.59.550600 PM VIEW INVALIDATE 8289601 view invalidation
05-NOV-11 01.08.59.590124 PM UPGRADE SERVER 11.2.0.2.0 Upgraded from 11.2.0.1.0
customer want to review the CPU patches status and interested in having latest CPU patches applied.So we need to find out what is the latest CPU patches applied.
For database we have done with the below query:
SQL> select * from dba_registry_history ;
ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS
--------------------------------------------------------------------------- ------------------------------ ------------------------------ ------------------------------ ---------- ------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
05-AUG-09 07.34.49.704740 PM CPU SERVER 10.2.0.3.0 7369190 CPUOct2008
09-FEB-11 07.18.10.309559 PM APPLY SERVER 11.2.0.1 3 PSU PSU 11.2.0.1.3
14-MAR-08 09.59.41.067259 PM CPU 6452863 view recompilation
23-OCT-10 10.56.18.468035 AM VIEW RECOMPILE 8289601 view recompilation
23-OCT-10 10.56.18.801283 AM UPGRADE SERVER 11.2.0.1.0 Upgraded from 10.2.0.3.0
05-NOV-11 01.08.59.550600 PM VIEW INVALIDATE 8289601 view invalidation
05-NOV-11 01.08.59.590124 PM UPGRADE SERVER 11.2.0.2.0 Upgraded from 11.2.0.1.0
Tagged:
0