统计oracle表大小

Oracle中统计表的大小

找出大于2G的表

SELECT owner,
segment_name,
SUM(bytes /1024/1024 /1024) sum 
FROM dba_segments
GROUP BY owner,segment_name 
having SUM(bytes /1024/1024 /1024) >2
ORDER BY 3 DESC;