Chained/migrated rows and PCTFREE

Hi,

I'm running ORACLE 817 on Solaris 8

In production in a big table (15M rows, 3GB) I have around 5% migrated rows because of a badly initialized PCTFREE parameter (actual value is 10 and should be 20.

I will change this value (alter table xxx pctfree 20;) My question is : what will be the effect on actual table and existing or future blocks
Which blocs will be affected :
-> all blocs
-> existing blocs whose actual free space is < 20% and new ones
-> only new ones
-> none ??

In the last hypothese, this mean that I must rebuild my table. (in the third one too, because now this table is accessed quite only in update(very few deletes and inserts)

And a correlated more question :
how is it possible to know, bloc by bloc, the state of free space ?

Thanks in advance
Regards
Frederic PAYANT - junior DBA ;-) Received on Thu Oct 31 2002 - 15:31:23 CST