Friday, June 15, 2012

Invalid Objects for applying Patch


Below command can be used to obtain Invalid objects before and after applying patches:

 spool invalid_before_patch.log

col owner for a20
col obj for a30
col typ for a20
set lines 120
set pages 500
compute sum of cnt on report
compute sum of cnt on owner
break on owner on report
select owner,object_name obj,object_type typ,1 cnt from dba_objects where status!='VALID' order by 1,2;

spool off;

Same way do after applying patch. e.g spool invalid_after_patch.log

Once Patching is complete:-
use diff command to check any new invalid got generated with patch Application.

e.g diff invalid_before_patch.log invalid_after_patch.log -- Hit enter key.