Row chaining
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Row chaining

  1. #1
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    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

  2. #2
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    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
  •  



Click Here to Expand Forum to Full Width