Oracle - Tableサイズ確認

-- TABLEサイズ確認

SELECT

SEGMENT_NAME,

SUM(BLOCKS) BLOCKS,

CEIL(SUM(BYTES)/1024/1024) SIZE_MB

FROM user_SEGMENTS

where SEGMENT_NAME='TABLE_NAME'

GROUP BY SEGMENT_NAME,SEGMENT_TYPE

ORDER BY SEGMENT_NAME,SEGMENT_TYPE;