统计表的大小

SELECT * FROM 
( 
SELECT SEGMENT_NAME, SUM(BYTES)/1024/1024/1024 G 
FROM DBA_SEGMENTS 
WHERE OWNER = user 
GROUP BY SEGMENT_NAME 
ORDER BY 2 DESC 
)