统计用户表的大小

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 )

 

转载于:https://www.cnblogs.com/jingdian1956/p/4561731.html