统计用户表的大小 

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
)

 

posted @ 2015-06-08 19:11  Tigmer  阅读(138)  评论(0)  编辑  收藏  举报