Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / SQL PLUS Session Environment

 

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>