Query – Listar Tamanho dos schemas – Rodrigo Silva e Silva

Query, listando tamanho dos Schema por ordem de tamanho

SELECT owner, trunc(sum(bytes)/1024/1024/1024,2) "SIZE GB" 
FROM dba_segments 
where owner not in 
	( 'SYSTEM', 'XDB', 'SYS', 'TSMSYS', 'MDSYS', 
	'EXFSYS', 'WMSYS', 'ORDSYS', 'OUTLN', 'DBSNMP') 
group by owner
order by 2 desc;

SELECT owner, trunc(sum(bytes)/1024/1024/1024,2) "SIZE GB"

FROM dba_segments

where owner not in

( 'SYSTEM', 'XDB', 'SYS', 'TSMSYS', 'MDSYS',

'EXFSYS', 'WMSYS', 'ORDSYS', 'OUTLN', 'DBSNMP')

group by owner

order by 2 desc;

OWNER                             SIZE GB
------------------------------ ----------
ORCL                                16.99
APEX_030200                           .14
SYSMAN                                .12
ORDDATA                               .01
CTXSYS                                  0
FLOWS_FILES                             0
FLAVIO                                  0
APPQOSSYS                               0
ADRIANA                                 0

8 rows selected.

OWNER SIZE GB

------------------------------ ----------

ORCL 16.99

APEX_030200 .14

SYSMAN .12

ORDDATA .01

CTXSYS 0

FLOWS_FILES 0

FLAVIO 0

APPQOSSYS 0

ADRIANA 0

8 rows selected.

Fonte: Andre Spadini

Deixe um comentário Cancelar resposta