select SEGMENT_NAME,sum(BYTES/1024/1024)||'M' from USER_EXTENTS
where SEGMENT_TYPE='TABLE' group by SEGMENT_NAME
order by sum(BYTES/1024/1024) desc
可以分析占用空间最大的表格
select SEGMENT_NAME,sum(BYTES/1024/1024)||'M' from USER_EXTENTS
where SEGMENT_TYPE='TABLE' group by SEGMENT_NAME
order by sum(BYTES/1024/1024) desc
可以分析占用空间最大的表格
转载于:https://www.cnblogs.com/liwenchaoCode/p/10540232.html