Invalid Objects Check

-----------------------------------
-Invalid Objects Check
------------------------------------

SET PAGESIZE 300
SET LINESIZE 150
col OWNER for a25
col OBJECT_NAME for a30
select OWNER,OBJECT_TYPE, STATUS,count(*)
from dba_objects where STATUS='INVALID' group by OWNER,OBJECT_TYPE, STATUS order by owner
/

select count(*) from dba_objects where STATUS='INVALID'
/
prompt Suggestion : @?/rdbms/admin/utlrp.sql

----------------------
Backup before Patching
----------------------

create table p&patchno as(select *from dba_objects where status='INVALID');

----------------------
Check After Patching
----------------------

select count(*) from dba_objects where status='INVALID' and object_name not in(select object_name from &backup_table);