Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Freelists
"Mark D Powell" <mark.powell_at_eds.com> wrote in message
news:178d2795.0108080539.3bf61f2e_at_posting.google.com...
> Mick, I can not claim to 100% sure but I believe that when Oracle goes
> to insert a row into a block it checks to see if the block will have
> less than pctfree free space remaining after the insert. If so, the
> block is removed from the free list at that time, and the rdbms looks
> to see if the row will fit in the next block on the free list. There
> may be some variation to this when long/LOB columns are involved.
>
> -- Mark D Powell --
Does this imply that if I insert an unusually large row I could effectively obliterate the free list leading to a large amount of wasted space? Received on Fri Aug 10 2001 - 05:48:03 CDT