Listing 2: Analyze Table T
SQL> analyze table t compute statistics;
Table analyzed.
SQL> select avg_space, blocks, empty_blocks, num_freelist_blocks
2 from user_tables
3 where table_name = 'T';
AVG_SPACE BLOCKS EMPTY_BLOCKS NUM_FREELIST_BLOCKS
--------- ------ ------------ -------------------
2241 35 28 2
|