I have a table with row chaining with the following details :
Table Average Chain No
Name PCT_FREE PCT_USED Row Len Count Rows
--------------- ---------- ---------- ------- ----- ----------
MST_USER_X 10 75 141 1 2,005
my block size 4K. Please tell me how to set PCT_FREE and PCT_USED to eliminate the rowchaining. Is there any special calculation method to calculate the said parameters.
to begin with your block size is to small it should have been 8k when database was created.
But if this is only an isolated case, you can use that UTLCHAIN.SQL script. For PCT_USED, since you have set it to 75, then the most that you can adjust is up to 85-89 since your PCT_FREE is 10. If this table doesn't made much of UPDATES, then you can lower your PCT_FREE to 5.
Reply With Quote
Bookmarks