Re: changing pctfree and pctused

pctfree applies to new blocks only ; pctused is in force immediately, as soon as a row is deleted, however no reorganization of existing blocks will take place.

Hth,

Sybrand Bakker, Oracle DBA

Janey <janeyschrock_at_bigfoot.com> schreef in berichtnieuws 3909f948_3_at_news3.prserv.net...
> If you change the pctfree and pctused (block utilization parameters) on a
> table using alter table how does this affect the existing allocated
 blocks?
> I have heard two takes. 1) This change only applies to newly allocated
> blocks. 2) This change applies to all blocks that are touched by Oracle.
 If
> number 2 applies, then as I delete data from this table the blocks that
 are
> deleted from will get the new pctfree and pctused.
>
> I cannot recreate my table so that all blocks can get the new parameters.
> It's too big and I can't get the downtime.
>
> Jane
>
>
Received on Sat Apr 29 2000 - 00:00:00 CDT