Re: Is the effect of modifying PCTFREE/PCTUSED immediate ?

On Tue, 24 Sep 2002 22:21:29 +0800, Hemant K Chitale <hkchital_nospam_at_singnet_nospam.com.sg> wrote:

>
>Is the effect of modifying PCTFREE/PCTUSED immediate ?

Yep.
>
>
>
>If I do an "ALTER TABLE <tablename> PCTFREE 99 PCTUSED1",
>does this take effect immediately, even for existing blocks.
>[If so, existing blocks would not get new rows inserted]

Unless the widht of the row + the existing rows in the block are < 1% of the block size OR the block is empty (then at least one row *of any width* is allowed to be inserted before Oracle discovers that pctfree is exceeded).

• Kenneth Koenraadt

>Or is it effective only in new Extents ? In that case,
>existing blocks in existing Extents still use the old
>PCTFREE/PCTUSED parameters and keep re-entering the
>FreeList.
>
>Hemant
Received on Tue Sep 24 2002 - 13:27:45 CDT