Re: Chained/migrated rows and PCTFREE

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Fri, 1 Nov 2002 19:37:20 +1000
Message-ID: <vSqw9.67088$g9.189080@newsfeeds.bigpond.com>

Hi Srivenu,

Let me clarify regarding changes to pctfree.

It obviously effects new blocks.

Existing blocks are not rearranged to accommodate the changed pctfree.

BUT, if an existing block were to be put back on the freelist (eg. after a bunch of deletes that drives the data below pctused), then it *will* pick up and use the new pctfree value.

Therefore changes to pctfree potentially effects all blocks and will effect all blocks place on the freelist.

Cheers

Richard
"srivenu" <srivenu_at_hotmail.com> wrote in message news:1a68177.0210312317.62b0a413_at_posting.google.com...
> I think changing PCTFREE affects only new blocks.
> You can use DBMS_SPACE to get space usage info.
> For details on 1 particular block, you can dump that particular block.
> The dump contains the free space info.
> regards
> Srivenu
Received on Fri Nov 01 2002 - 03:37:20 CST