Re: SGA bigger than 50G
- From: Surachart Opun <surachart@xxxxxxxxx>
- To: smishra_97@xxxxxxxxx
- Date: Wed, 5 May 2010 15:02:02 +0700
>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
Check *shmall*
$ cat /proc/sys/kernel/shmall
http://surachartopun.com/2009/10/shared-memory-tuning-startup-database.html
>having 64G memory. I want to have SGA around 50G
SGA = System Global Area, that is memory for data buffer, shared pool and
... (on share memory)
But In Oracle ... we have use memory for PGA (private memory) and etc...
and your system need memory as well.
I think You should set SGA = oracle recommend
Example: SGA = 50% of Physical Memory
- For OLTP systems
PGA_AGGREGATE_TARGET = (<Total Physical Memory > * 80%) * 20%
- For DSS systems
PGA_AGGREGATE_TARGET = (<Total Physical Memory > * 80%) * 50%
and then check Oracle Advisor ... to tune them.
Good Luck
Surachart Opun
http://surachartopun.com
Oracle ACE, OCE, OCP
On Wed, May 5, 2010 at 9:34 AM, Sanjay Mishra <smishra_97@xxxxxxxxx> wrote:
> Mark
>
> That is what I want to understand as how it can be checked. Also Is there
> any relation that if hugepages are used, then SGA_Target should be avoided
> or so.
> Sanjay
> ------------------------------
> *From:* "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
> *To:* "Brandon.Allen@xxxxxxxxxxx" <Brandon.Allen@xxxxxxxxxxx>; "
> oratune@xxxxxxxxx" <oratune@xxxxxxxxx>; "smishra_97@xxxxxxxxx" <
> smishra_97@xxxxxxxxx>; "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
> *Sent:* Tue, May 4, 2010 9:28:51 PM
>
> *Subject:* RE: SGA bigger than 50G
>
> In addition to David’s and Brandon’s comments, have you configured
> hugepages.
>
>
>
> -Mark
>
>
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Allen, Brandon
> *Sent:* Tuesday, May 04, 2010 7:51 PM
> *To:* oratune@xxxxxxxxx; smishra_97@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> *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:
