Oracle Database Discussions

Hi,

We have observed that there are a lot to read of other session waits on two tables in our database and further more the blocks appears to be different each time. I mean that there are very less hot blocks.

read by other session on
2 tables
1 index

We are thinking of increasing the PCTFREE from 10% to 40% for two tables. and rebuild the exisiting indexes after the PCTFREE has been increased for tables.

Here as the documentation says that the PCTFREE for a table willl take effect only for the new blocks that are added to the table not to the exisiting blocks that are already present.

So this is the procedure that we are thinking of following.

Alter table tablename pctfree 40;
Then move the table so that the table will be allocated a new segment and all the blocks will be created again with the new PCTFREE.
Then use the DBMS_REPAIR.SEGMENT_FIX_STATUS to make sure that the PCTFREE is changed for all the blocks
finally rebuild all the indexes for these two tables.


Can any one confirm that this procedure is correct. We have done this on DEV environment and most of the waits are gone now. We are thinking of implementing this on the PROD environment.

Thanks,