Table fragmented

Table size (with fragmentation)

SQL> select table_name,round((blocks*8),2)||'kb' "size" 2 from user_tables
3 where table_name = 'BIG1';

TABLE_NAME size
------------------------------ ------------------------------------------
BIG1 72952kb

Actual data in table:

SQL> select table_name,round((num_rows*avg_row_len/1024),2)||'kb' "size" 2 from user_tables
3 where table_name = 'BIG1';

TABLE_NAME                     size


------------------------------ ------------------------------------------

BIG1                           30604.2kb

Note = 72952 - 30604 = 42348 Kb is wasted space in table

The difference between two values is 60% and Pctfree 10% (default) - so, the table has 50% extra space which is wasted because there is no data. Received on Thu Dec 04 2008 - 15:03:10 CST