>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. > >