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;