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: Free space not re-used

Re: Free space not re-used

From: Olivier <oberco_at_club-internet.fr>
Date: Mon, 21 Feb 2000 00:11:00 +0100
Message-ID: <38B07484.1DF99843@club-internet.fr>


No Mark, I did'nt think about this, but as you said, now I will take care of it !
If I have well understand explanations of Steve, the table freelist has its 5 firsts free blocks
not enought large to be used so as Oracle search only the 5 first blocks in the freelist, it doesn't
find one so it allocate one extent. Is it right Steve ? But I don't understand very well the impact of the pctused in this case. What a smaller pctused (50%, 60%)
would be better and resolve the problem of this 5 blocks? Sorry if I have some problem to understand with your clear explanations but I'm newbie in this part!
However, thanks to everybody for your help.

Olivier Received on Sun Feb 20 2000 - 17:11:00 CST

Original text of this message

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