SELECT t.owner, t.segment_name,SUM(bytes)/1024/1024(M) From dba_segments t
WHERE t.tablespace_name = 'USERS'
GROUP BY t.owner,t.segment_name
ORDER BY SUM(bytes) desc;
Oracle 查看索引大小
最新推荐文章于 2024-06-18 13:46:51 发布
SELECT t.owner, t.segment_name,SUM(bytes)/1024/1024(M) From dba_segments t
WHERE t.tablespace_name = 'USERS'
GROUP BY t.owner,t.segment_name
ORDER BY SUM(bytes) desc;