Listing 3: Deletes and Freelist Updates
SQL> delete from t where x <= 6 -- totally clear blocks 1 and 2;
6 rows deleted.


SQL> delete from t where x = 7  -- remove 1 row from block 3;
1 row deleted.


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
  ---------    ------   ------------   -------------------
       2643        35             28                     4