Oracle counts the number of rows for all tables of users

DECLARE CURSOR C1 is select table_name from User_tables; V_table_name User_tables.  Table_name%type;  V_CNT number; V_sql VARCHAR2 (2000); BEGIN for V_table_name in C1 loop v_sql: = ' select count (1) from ' | |     V_table_name.table_name;     Execute immediate v_sql into v_cnt; Dbms_output.put_line (V_table_name.table_name | |  ', ' | |  V_CNT); End Loop;end;

This article is from the "focus on Oracle Performance Tuning" blog, so be sure to keep this source http://5073392.blog.51cto.com/5063392/1539276