Friday, November 05, 2010

List CPU patch applied to database

List CPU patch applied to database 

1. sqlplus  as system
2. execute the following sql statement
  set linesize 90 
 
  col action format a7
  col version format a10
  col id format 99999
  col when format a20

  select d.name,to_char(r.action_time,'YYYY/MM/DD.hh24:mi')    when,r.action,r.version,r.id,r.bundle_series
  from v$database d left outer join dba_registry_history r
  on r.bundle_series in ('CPU','PSU');


Hope this helps. Regards Rupam