Oracle query all table record number of users ____oracle

Oracle queries all table records of users

Because of the need to upgrade the application in the field, to assess the amount of data for security purposes, Oracle, a command can be done. One need to be aware that users with DBA authority are required to do so.

Select Table_name,num_rows from Dba_all_tables ORDER BY num_rows Desc

such as querying a user:
select table_name,num_rows from Dba_all_tables where owner= ' user uppercase ' ORDER BY num_rows Desc

<span style= "Font-family:tahoma; font-size:14px; line-height:24px; " >oracle query a user all the table records number &LT;/SPAN&GT;&LT;BR style= "margin:0px;" padding:0px; Font-family:tahoma; font-size:14px; LINE-HEIGHT:24PX, "/><p style=" margin-top:0px; margin-bottom:0px; padding-top:0px; padding-bottom:0px; Font-family:tahoma; font-size:14px; line-height:24px; " > </p><p style= "margin-top:0px; margin-bottom:0px; padding-top:0px; padding-bottom:0px; Font-family:tahoma; font-size:14px; line-height:24px; " ><span style= "margin:0px; padding:0px; List-style:none outside none; Word-break:normal; word-wrap:break-word;font-size:14px; " > Query database table information: </span></p><p style= "margin-top:0px; margin-bottom:0px; padding-top:0px; padding-bottom:0px; Font-family:tahoma; font-size:14px; line-height:24px; " > </p><p style= "margin-top:0px; margin-bottom:0px; padding-top:0px; padding-bottom:0px; Font-family:tahoma; font-size:14px; Line-height: 24px; " > </p><pre class= "SQL" name= "code" style= "margin-top:0px; margin-bottom:0px; padding:0px; font-size:14px; line-height:24px; "  >select Num_rows,table_name from Dba_all_tables

Select Num_rows,table_name from Dba_all_tables WHERE owner= ' PIG '

<span style= "Font-family:tahoma; font-size:14px; line-height:24px; " >oracle record table name and table record number </span><br style= "margin:0px; padding:0px; Font-family:tahoma; font-size:14px; LINE-HEIGHT:24PX, "/><span style=" font-family:tahoma; font-size:14px; line-height:24px; " >oracle that system table records both the table name and the number of table records? </SPAN><BR style= "margin:0px; padding:0px; Font-family:tahoma; font-size:14px; LINE-HEIGHT:24PX, "/><br style=" margin:0px; padding:0px; Font-family:tahoma; font-size:14px; LINE-HEIGHT:24PX, "/><span style=" font-family:tahoma; font-size:14px; line-height:24px; " >select table_name, num_rows from user_tables;</span>