Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Why new inserts are not using freelist blocks ?

Re: Why new inserts are not using freelist blocks ?

From: <jdarrah_co_at_my-deja.com>
Date: Thu, 07 Dec 2000 18:31:10 GMT
Message-ID: <90ol1e$qfe$1@nnrp1.deja.com>

try looking here :
http://www.ixora.com.au/q+a/datablock.htm

In article <90lbea$2cu$1_at_nnrp1.deja.com>,   new_dba_at_my-deja.com wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 07 2000 - 12:31:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US