Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Free space not re-used
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