asked on

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

SOLUTION

konektor

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

richkeegan

ASKER

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

ASKER CERTIFIED SOLUTION

schwertner

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

konektor

SELECT value FROM v$parameter WHERE name = 'pga_aggregate_target'; -- size of PGA