oracle查询用户全部表记录数

select TABLE_NAME,NUM_ROWS from dba_all_tables order by num_rows desc

如查询某个用户的：

select TABLE_NAME,NUM_ROWS from dba_all_tables where owner='用户大写' order by num_rows desc