Re: Why new inserts are not using freelist blocks ?

update pls.

In article <90f49s$3m2$1_at_nnrp1.deja.com>,   new_dba_at_my-deja.com wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 06 2000 - 06:29:01 CST