Re: PCTFREE & PCTUSED

The answer is no.

If PCTUSED is 40, then the block must be <40% filled for an insert to occur. PCTFREE has to do with update space only.

Arthur Merar wrote:

> Hello,
>
> I am very new to Oracle. I am reading all the book and I'm not sure I
> understand these parameters and how they work.
>
> PCTFREE is the amount of space that must remain available in the block
> for updates.
> PCTUSED is a threshhold amount where new inserts cannot be done if the
> block is that much filled.
>
> What I do not understand is something like this: If PCTFREE is 20% and
> PCTUSED is 40%, Can inserts be done if the block is 50% filled???
> According to PCTFREE it can, but according to PCTUSED no nre inserts can
> be done.
>
> So, I'm unclear how these work. Can someone please offer some
> assistance?
>
> Thanks,
>
> --
>
> "A real friend is someone who knows all about you and still respects
> you."
>
> Arthur
> amerar_at_unsu.com
> ICQ#:663601
> http://www.unsu.com
Received on Tue Aug 25 1998 - 23:20:52 CDT