Results 1 to 2 of 2

Thread: buffers

  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Question Unanswered: buffers

    Hi,

    there are an example in the book that say how to calculate the buffers in file onconfig.std.

    2 kilobytes in page size.
    100 mb in phisical memory

    the example say I can set the buffers between 10000 and 12500, which allocates between 20 and 25 megabytes of memory.

    how to calculate this value?

    how to calculate the value of locks in the file onconfig.std.


    Thank you.

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Believe me, there is no fixed rule that works for all databases.
    The best way is trial and error.

    Check with onstat -p for the %read cache and %write cache.
    The read cach should be at least 95% and the write cache should be at least 85 %.

    For the locks you should check the amount of lockwaits in onstat -p
    rws

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •