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;
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;