如何查看Oracle数据库中每张表占用空间的大小 按占用空间大小倒序排序

admin

1. SELECT OWNER, SEGMENT_NAME, ROUND(SUM(BYTES)/1024/1024, 2) AS SIZE_IN_MB
   
2.   FROM DBA_SEGMENTS
   
3. WHERE SEGMENT_TYPE ='TABLE'
   
4. GROUP BY OWNER , SEGMENT_NAME
   
5. ORDER BY SIZE_IN_MB DESC ;

复制代码