Scripts To Check Invalids
Number Of Invalid Objects
select object_name,status,owner from dba_objects where status='INVALID';
select owner,object_type,count(object_name) INVALIDS from dba_objects where status='INVALID' group by owner,object_type order by 1;
select count(*) from dba_objects where status='INVALID';