buffer cache
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: buffer cache

  1. #1
    Join Date
    Sep 2000
    Posts
    305
    How to decide the size of the buffer cache generally this is a tendency that you have to give larger size to your buffer cache buthow much is the limit of the buffer cache can anybody give some suggestion for the same

    Thanking You
    Shailendra Singh

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Start off with how much you think it should be and monitor it from there. Monitor your buffer cache hit ratio http://otn.oracle.com/docs/products/...9_mem.htm#1720 . You should aim for a hit ratio of about 95% or better.

    For a small OLTP database (50 concurrent users or so, 100G data), I like to start off with 128M of buffer cache. For apps with a large number of users, I start with 256M and go up from there.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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