인덱스 및 테이블 사이즈 보기

select SEGMENT_NAME ,segment_type ,sum(사용량)
from (
      SELECT SEGMENT_NAME , ROUND(SUM(BYTES)/1024/1024) AS "사용량", segment_type
      FROM USER_EXTENTS
      --WHERE SEGMENT_NAME LIKE 'TTXSTAT%'
      GROUP BY SEGMENT_NAME, segment_type)
GROUP BY rollup(SEGMENT_NAME),segment_type