Tuesday, July 1, 2014

Check database upgrade history


You can check quickly in your oracle database when was last time any patch upgrade or recompile happened by checking DBA_REGISTRY_HISTORY view

select  to_char(ACTION_TIME,'MON-DD-YYYY:HH24:MI:SS')ACTION_TIME,ACTION,namespace,VERSION,ID,BUNDLE_SERIES,COMMENTS from DBA_REGISTRY_HISTORY ;