OracleSQLメモ_テーブルの容量

Oracle12cDB内のテーブル容量をSQLで

SELECT T.TABLE_NAME,T.NUM_ROWS,S.MB FROM USER_TABLES T
INNER JOIN 
(SELECT SEGMENT_NAME,ROUND(BYTES/1024/1024,2) MB FROM USER_SEGMENTS
) S ON T.TABLE_NAME = S.SEGMENT_NAME
ORDER BY S.MB DESC