Re: SGA bigger than 50G

From: Harel Safra <harel.safra_at_gmail.com>
Date: Wed, 5 May 2010 07:59:53 +0300
Message-ID: <2292360517437193759_at_unknownmsgid>

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_at_yahoo.com> כתב/ה:

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_at_OneNeck.com>
*To:* "oratune_at_yahoo.com" <oratune_at_yahoo.com>; "smishra_97_at_yahoo.com" <
smishra_97_at_yahoo.com>; "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>
*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.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 04 2010 - 23:59:53 CDT