analyze table TABLENAME compute statistics;
SQL> analyze table TABLENAME compute statistics; SQL> SQL> select Num_Rows, /*number of rows*/ 2 Blocks, /*number of blocks used*/ 3 Num_Rows/Blocks /*number of rows per block*/ 4 from USER_TABLES 5 where Table_Name='TABLENAME'; SQL>