Re: SGA bigger than 50G
- From: Sanjay Mishra <smishra_97@xxxxxxxxx>
- To: Harel Safra <harel.safra@xxxxxxxxx>
- Date: Wed, 5 May 2010 04:48:32 -0700 (PDT)
Harel
Will increase the shmall setting to make shmall*shmmni > shmmax and will try
which is currently coming to 32G
Sanjay
________________________________
From: Harel Safra <harel.safra@xxxxxxxxx>
To: "smishra_97@xxxxxxxxx" <smishra_97@xxxxxxxxx>
Cc: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>; "oratune@xxxxxxxxx"
<oratune@xxxxxxxxx>; "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Sent: Wed, May 5, 2010 12:59:53 AM
Subject: 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:
