Hi all,



My questions is regarding how to set up SGA & PGA target values giving
DB server is MS 2003 Enterprise 64 edition sever with 63 GB of RAM. Our
DB's version is 10.2.0.3 and RACed with 2 instances.



Currently our setting for SGA is 23 GB and PGA is 4 GB. I ran the memory
advisor it display different optimal values for those two instances (35
GB and 23 GB for SGA, 5 GB and 4 GB for PGA). Guess our db is not well
balance loaded.



I would like to know if there is any rule(s) that SGA can't be more than
certain percentage of total RAM for the server.



Thanks a lot in advance.



Have a great weekend!!



Shirley








Oracle LazyDBA home page