Oracle SGA/Memory settings

I have Oracle running on an intel box as:

dual xeon 2.4,
2gb of ram.
c: 4gb - 150MEG free
d: 46gb - 23.7gb free
(all scsi raid 5)

The SGA/Memory settings are as follows but I was wondering if these are too low and could I safely increase them and if so to what?

Shared Pool: 136 MB
Buffer Cache: 80 MB
Large Pool: 1024 KB
Java Pool: 32 MB

TOTAL SGA: 169.76974

Max Concurrent Users: 2950  --- this is what it's set to but we only have about 150 users in reality, though connections are made via mts so perhaps more than 150 connections opened?

Sort Area Size: 512 KB

Thanks,
Rich
richkeeganAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

konektorCommented:
never let all applications running on server exceed 2 gb. system may probable take 500mb, so if there are no running application on the server u have abt 1GB to memory for all your instances (next 500mb is reserve for applications, which are not permanently running, but time to time may be...).
check also size of PGA (u can do it in enterprise manager)
if u exceed the RAM and system begin to swap, it's the end of database performance.
0
richkeeganAuthor Commented:
I can't see a pga box for this server 9.0.1.1.1 ? I can see it on my 9.2 server. If I select the sql plus:

NAME                                            VALUE
---------------------------------------- ------------
aggregate PGA auto target                           0
global memory bound                                 0
total expected memory                               0
total PGA inuse                            11,892,736
total PGA allocated                        17,606,656
maximum PGA allocated                      17,606,656
total PGA used for auto workareas                   0
maximum PGA used for auto workareas                 0
total PGA used for manual workareas                 0
maximum PGA used for manual workareas               0
estimated PGA memory for optimal                    0

NAME                                            VALUE
---------------------------------------- ------------
maximum PGA memory for optimal                      0
estimated PGA memory for one-pass                   0
maximum PGA memory for one-pass                     0
0
schwertnerCommented:
this SGA  can not be 167.76 MB. Something is wrong. I calculate it to 250 MB.
if it really is 167 MB then it is too small for the capacity of your system.
In this case increase the Buffer Cache (to 150 MB) and the Shared Pool (150 MB).
The advisors in the OEM will give you after some period the usage figures for these settings.
Try to keep about 500 MB for SGA. Every connection needs 2-5 MB, so the RAM will be enough.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
konektorCommented:
SELECT value FROM v$parameter WHERE name = 'pga_aggregate_target'; -- size of PGA
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.