5 GB SGA on 8GB RAM HP Server 64Bit
Hi all
Recently three months we installed Oracle 10g Database on HP Server (having 4 XEON Processors) with Windows 2003 (64 Bit) OS and we have 8GB RAM.
We wished to have 5500M as the SGA Target but we could not configure more that 3800M on that machine as after that it would error and the database would not get start.
error messages would be like - Out of memory
OR
???? (not recollecting)
Now we are running with only 3500M as sga_target and not utilizing the full available RAM with us. Of course we are using in addition 1500M for pga_aggregate_target without any problem. Even if we increase pga_aggregate_target to 3000M there is no problem but that is not desired to us. We wish to increase sga_target.
We are getting excellent response timings on 3500M sga_target but as human nature would be , we wish to be more greedy and use the full available RAM with us i.e 8GB out of which we can safely use 7GB for Oracle instance. While deducting 1500M for pga_aggregate_target we would like to use 5500M for sga_target.
Any help is appreciated.
Suresh Bansal