4_Count_All_Objetcts.sql

4_Count_All_Objetcts.sql

set line 120

set pagesize 0

set feedback off

ttitle 'RELATORIO DE OBJETOS'

break on report

select '' from dual;

select '************************************************' from dual;

select 'Quantidade tipos de objetos por owner' from dual;

select '************************************************' from dual;

select owner,object_type,count(*) from dba_objects where object_name not like 'QX__%' 

group by owner,object_type order by owner,object_type;

select '' from dual;

select '************************************************' from dual;

select 'Quantidade por tipo de objeto' from dual;

select '************************************************' from dual;

select object_type,count(*) from dba_objects where object_name not like 'QX__%' 

and owner not like 'OPS$%'

and owner not in ('SYSTEM','SYS','OMWB','MDSYS')

and owner not in ('OUTLN', 'WMSYS', 'ORDSYS', 'ORDPLUGINS', 'MDSYS', 'XDB', 'ANONYMOUS', 'WKPROXY')

group by object_type order by object_type;

set feedback on

set pagesize 24

set linesize 80

clear break;

ttitle off;