테이블 사이즈 구하기

select /*+ ALL_ROWS */
  segment_name,
  round(sum(bytes),2) Mb ,
  sum(decode(extent_id, 0, bytes, 0)) initial_ex,
  sum(decode(extent_id, 1, bytes, 0)) next_ex ,
  max(extent_id)+1 extents ,
  sum(bytes) ttlsize
from
  dba_extents
Where segment_type in ('TABLE', 'TABLE PARTITION')
and (segment_name like 'FRA%'
         or segment_name like 'BIS%'
         or segment_name like 'DAS%'
         )
AND  SEGMENT_NAME NOT IN('FRA_60MIN_VIEW_INFO','FRA_30MIN_VIEW_INFO','FRA_15MIN_VIEW_INFO')         
and (OWNER = 'VAS')
group by segment_name
order by   round(sum(bytes)/1024/1024,2) desc

--- 인덱스 사이즈
select /*+ ALL_ROWS */
segment_name,
  round(sum(bytes)/1024/1024,2) Mb ,
  sum(decode(extent_id, 0, bytes, 0)) initial_ex,
  sum(decode(extent_id, 1, bytes, 0)) next_ex ,
  max(extent_id)+1 extents ,
  sum(bytes) ttlsize
from
  dba_extents
Where segment_type in ('INDEX', 'INDEX PARTITION')
--and segment_name=:tblname
and (OWNER = 'VAS')
group by segment_name