This content has been marked as final. Show 5 replies
On most database applications 4Gb is sufficient size for SGA. Usually I allocate about 60% of physical RAM available for Oralce.
Most documentation I've read the largest SGA is 2Gb due to old windows limitations
Really, i've remembered of a recent (not so much) issue of Jeff Hunter, describe on his blog in
Link: [ this post|http://marist89.blogspot.com/2008/05/something-to-be-aware-of-10204.html]
In a comment he specifies his setting:
So i've really to think that all notes refers to old 32 bit notes .
4GB limit I don't think its for x86 64 bit servers. We have setup shmmax to 16GB on xeon 64 bit servers.
i agree, i've setted a value of 9 GB without problems, i was searching some confirmations of the fact that metalink notes are not accurate.
On a 32 bit machine max addressable memory is 2^32-1^ which comes to 2GB considering one parity bit actual usable size for SGA is aroung 1.7-1.8GB. Using VLM/AWE you can increase upto 4gb (which comes to across 3.7GB usable). These are all limits given for 32bit machine which i could come across in metalink but I am not sure where is 4GB limit for 64bit machine specified as i don't have metalink access now. So, I cannot say anything about the doc which haven't seen.