cancel
Showing results for 
Search instead for 
Did you mean: 

SGA Oracle limitation

SGA Oracle limitation

Hello,

Due to limitations in the size of the SGA on 32-bit Oracle platforms, we have decided to change to a 64-bit platform. My question is: What OS allow us to define a SGA bigger than 4Gb? (weâ re using an Oracle RAC 9.2).

In particular, we're thinking in Linux RHEL or SuSE on a Itanium2 . That would be right?

Than
3 REPLIES
Joseph Loo
Honored Contributor

Re: SGA Oracle limitation

hi,

SGA is dependent on the memory or swap size u have given for the server and not really platform dependent based on current technology.

since the SGA is more than 4GB, i would recommend that the memory be more than 6GB if this database instance is the only application house in the server. besides that, the kernel parameters must be configure accordingly.

there r more on this topic in Oracle Metalink. Do u have any access to it?

regards.
what you do not see does not mean you should not believe
Sanjay Kumar Suri
Honored Contributor

Re: SGA Oracle limitation

Check this thread as well:

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=577849

sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
Ravi_8
Honored Contributor

Re: SGA Oracle limitation

Hi

Shared memory defines the SGA
never give up