-
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.
-
What is the rule of thumb to tune shared pool and buffer cache size?
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|