Why new inserts are not using freelist blocks ?

Hi,

For one of my tables, num_freelist_blocks is 5 and avg_space_freelist_blocks is 3819. Blocks is 1039, empty_blocks is 520. pct_free is 10, pct_used is 40, initial_extent is 1MB, next is 1MB, pct_increase is 0, number of extents is 6, num_rows is 3372, avg_space is 822 and avg_row_len is 979.

I want to know :
1. Why empty_blocks are not included in num_freelist_blocks ? Does it indicate that if I insert a new row, the empty_blocks won't be used ?

2. How does Oracle choose a block for new inserts ? I mean, if I insert a new row, would it use :

• space created by deleted rows (assuming pctused condition is satisfied)
• empty_blocks
• allocate a new extent

Recently I faced a situation where there were a lot of freelist_blocks for a table and still Oracle was allocating new extents. I couldn't understand Oracle's behaviour. Could somebody advise ?

Thanks.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Dec 03 2000 - 21:50:20 CST