Re: SGA bigger than 50G

You should also check the kernel parameter shmall and make sure it's set
correctly.

Btw, 50gb is quity large for a 64gb server. It'll leave to little space for
the PGA/OS and can cause excessive swapping.

Harel Safra
(Sent from my phone, excuse the terseness)

ב-05/05/2010, בשעה 05:31, Sanjay Mishra <smishra_97@xxxxxxxxx> כתב/ה:

Yes it is failing with error like
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device

:/proc/sys/kernel$cat shmmax
48318382080
I tried with
sga_target=38624M
sga_max_size=38624M


Sanjay

 ------------------------------
*From:* "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
*To:* "oratune@xxxxxxxxx" <oratune@xxxxxxxxx>; "smishra_97@xxxxxxxxx" <
smishra_97@xxxxxxxxx>; "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
*Sent:* Tue, May 4, 2010 7:50:55 PM
*Subject:* RE: SGA bigger than 50G

 And what exactly do you mean by “it is only going around 32-25G”?  Are you
getting an error if you try to make it larger than 32G?









------------------------------
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions
and other information in this message that do not relate to the official
business of this company shall be understood as neither given nor endorsed
by it.

Other related posts: