Re: Table fragmented

bad direction
sorry

"astalavista" <nobody_at_nowhere.com> a écrit dans le message de news: 4938458a$0$14393$426a74cc_at_news.free.fr...
> 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:13:27 CST