select SEGMENT_NAME,sum(BYTES/1024/1024)||'M' from USER_EXTENTSwhere SEGMENT_TYPE='TABLE' group by SEGMENT_NAMEorder by sum(BYTES/1024/1024) desc
可以分析占用空间最大的表格
来源: http://www.bubuko.com/infodetail-2988890.html