-- 테이블 단위 사이즈
/* 테이블 사이즈 */
SELECT OWNER 
     , SEGMENT_NAME
     , TABLESPACE_NAME
     , BYTES / 1024 / 1024  AS MB
     , SEGMENT_TYPE     
  FROM DBA_SEGMENTS
 WHERE SEGMENT_TYPE = 'TABLE'
   AND SEGMENT_NAME = 'TEST_TABLE'
   
 UNION ALL
 
/* 인덱스 사이즈 */
SELECT OWNER 
     , SEGMENT_NAME
     , TABLESPACE_NAME
     , BYTES / 1024 / 1024  AS MB
     , SEGMENT_TYPE
  FROM DBA_SEGMENTS
 WHERE SEGMENT_TYPE = 'INDEX'
   AND SEGMENT_NAME LIKE 'TEST_TABLE%'

/*테이블 스페이스 당 테이블 용량 순위 */

SELECT SEGMENT_NAME
     , BYTES / 1024 / 1024  AS MB
     , RATIO_TO_REPORT(BYTES / 1024 / 1024 ) OVER() AS PER 
  FROM DBA_SEGMENTS A
 WHERE A.SEGMENT_TYPE   = 'TABLE'
   AND A.TABLESPACE_NAME = 'SYSTEM'
 ORDER BY 3 DESC