VESTATY INFORMÁTICA

Script abaixo mostra o tamanho dos Segmentos ex: ( Table , Indexes ) 

COL Object FORMAT a24;
COL Type FORMAT a5;
SELECT segment_name "Object", segment_type "Type"
,ROUND(SUM(bytes)/1024/1024) "Mb", ROUND(SUM(bytes)/1024) "Kb"
,SUM(bytes) "Bytes", SUM(blocks) "Blocks"
FROM dba_extents
WHERE owner = &OWNER AND segment_type IN ('TABLE','INDEX')
GROUP BY segment_name, segment_type
ORDER BY segment_name, segment_type DESC;