Shared pool and buffer cache tuning
My Sun server has 4GB of memory with 2 900MHz CPU and running in Solaris 9 and act as a Oracle 9i 18.104.22.168.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.
What is the rule of thumb to tune shared pool and buffer cache size?
Re: Shared pool and buffer cache tuning
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.
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 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.
Click Here to Expand Forum to Full Width