#查找失效对象 select t1.owner,t1.object_type,count(1) from dba_objects t1 where t1.status <>'VALID' group by t1.owner,t1.object_type order by t1.owner,t1.object_type;
