I have found the auto-tune features of 10 to be somewhat problematic. In
our implementation, the bulk of memory ends up being allocated to the
shared pool. This seems to starve the buffer pool.

Even so, your milage will vary. Just don't assume that what the database
would pick is truly optimal for what you are doing.

I am not sure what Oracles specific recommendations are for the 64 bit
version of Windows are. We have been advised to never allocate more than
half of system memory to Oracle SGA ( For UNIX implementations). My guess
is that windows would be much the same but you might want to post the
question to Metalink.

Are you happy with RAC on Windows. We are with our AIX implementation.
------
A. Paul Singer
Technical Specialist
San Onofre Nuclear Generating Station
-------





"Shirley Shen " <oracledba-ezmlmshield-x63362371.[Email address protected]
02/08/2008 09:58 AM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
SGA & PGA target






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









---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




Oracle LazyDBA home page