Shared pool and buffer cache tuning
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Shared pool and buffer cache tuning

  1. #1
    Join Date
    Apr 2003
    Location
    Kuala Lumpur
    Posts
    59

    Shared pool and buffer cache tuning

    Hi,

    My Sun server has 4GB of memory with 2 900MHz CPU and running in Solaris 9 and act as a Oracle 9i 9.2.0.1.0 database server. Vendor has set the following Oracle memory usage:

    shared pool 128MB
    buffer cache 1008MB
    large pool 32MB
    java pool 32MB

    May I know what's the rationale behind a such a low shared poll and such a high buffer cache? The DB needs to run 24X7 with over 100 users connected concurrently. Tks.

  2. #2
    Join Date
    Apr 2003
    Location
    Kuala Lumpur
    Posts
    59
    What is the rule of thumb to tune shared pool and buffer cache size?

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253

    Re: Shared pool and buffer cache tuning

    Originally posted by richyip

    May I know what's the rationale behind a such a low shared poll and such a high buffer cache?
    You'd do best to ask that of the vendor, but it looks really low to me. I'd expect you to need at least 512Mb, probably more like 1Gb.

    You can always turn on cache advice and see what that says about the effect of changing it, but i'm betting that if you have free memory on your system then you're going to be increasing that shared pool size real fast.

    My laptop instance has a larger shared pool than that, and it's got to share 1Gb with all the other crap i use.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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