oracle 查看所有表的数据量并排序

 

 

select t.table_name,t.num_rows from user_tables t ORDER BY NUM_ROWS DESC;

 

还可以直接查看dblink的：select t.table_name,t.num_rows from user_tables@dblink t ORDER BY NUM_ROWS DESC;