-
Hi all,
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.
Nagesh
Nagesh
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|