有下面几种方法不知道是否可靠。
Select Segment_Name,Sum(bytes)/1024/1024 as sz From User_Extents Group By Segment_Name order by sz desc;
select segment_name,bytes/1024/1024 as sz from user_segments order by sz desc;
select table_name,num_rows * avg_row_len as sz from user_tables order by sz desc;
阅读(2164) | 评论(0) | 转发(0) |
