Select count(*) from dba_objects where status = 'INVALID';
Select count(*) from dba_indexes where status = 'UNUSABLE';
Select count(*) from dba_triggers where status = 'DISABLED';
Select owner,object_name,object_type from dba_objects where status = 'INVALID';
Select owner,index_name from dba_indexes where status = 'UNUSABLE';
Select owner,trigger_name from dba_triggers where status = 'DISABLED';
Sem comentários:
Enviar um comentário