Tamanho dos objetos em um schema oracle

oracle-schema-objects-size.sql

-- Todos os objetos do schema
select 
   owner,
   sum(bytes)/1024/1024/1024 schema_size_gig
from 
   dba_segments 
group by 
   owner;

-- Tamanho por tipo de objeto
select 
   sum(bytes)/1024/1024/1024 as size_in_gig, 
   segment_type
from 
   dba_segments
where 
   owner='USER' 
group by 
   segment_type;