SCRIPT PARA VER TAMAÑO DE ESQUEMAS(SCHEMA) [sin los esquemas de oracle]

col owner format a30
col MB format  9999999
select trunc(sum(bytes)/1024/1024) MB from dba_segments;

select owner,trunc(sum(bytes)/1024/1024) MB from dba_segments
where owner not in ('SYS', 'SYSTEM', 'WMSYS', 'SYSMAN','MDSYS','ORDSYS','XDB', 'WKSYS', 'EXFSYS',
         'OLAPSYS', 'DBSNMP', 'DMSYS','TSMSYS','CTXSYS','WK_TEST', 'ORDPLUGINS', 'OUTLN','ORDDATA')
group by owner
having sum(bytes) >0
order by 2;