analyze table TABLENAME compute statistics; : analyze « SQL PLUS Session Environment « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. SQL PLUS Session Environment
3. analyze

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>