--按照数据行数排序
select table_name,blocks,num_rows
from dba_tables
where owner not like ‘%SYS%‘ and table_name not like ‘%$%‘ and num_rows is not null
order by num_rows desc;
--按照表占用的数据块
select table_name,blocks,num_rows
from dba_tables
where owner not like ‘%SYS%‘ and table_name not like ‘%$%‘ and blocks is not null
order by blocks desc;
Oracle根据表的大小排序SQL语句
标签：
本文系统来源：http://www.cnblogs.com/luckybird/p/4468437.html
【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！