What it does matter is the shared memory segment allocated by oracle: so
the SGA. Are you calculating the value correctly?
Look at what the output of the "ipcs -m" command tell you.
> -----Original Message-----
> From: Gabi Draghici [mailto:gabi.draghici@(protected)]
> Sent: 13 February, 2006 11:19 AM
> To: Magni Fabrizio; suse oracle
> Subject: Re: [suse-oracle] methods to increase sga size on SLES 9
> Well, I didn't give you all the info :
> from oracle file : shmmax=3294967296 and shmall=3145728
> I have : sga = 1.5 G
> pga = 512 M
> shared_pool =512 M (but, as you know, this one
> is not used
> + other memory structures !
> So , overall is a "little bit" higher than 1.7 G !!!
> ----- Original Message -----
> From: "Magni Fabrizio" <Fabrizio.Magni@(protected)>
> To: "Gabi Draghici" <gabi.draghici@(protected)"
> Sent: Monday, February 13, 2006 11:09 AM
> Subject: RE: [suse-oracle] methods to increase sga size on SLES 9
> Hello Gabi,
> SLES9 uses only hugetlb (bigpages is an old feature of some
> 2.4 kernel).
> However, if the kernel parameters are set correctly, you
> shouldn't need any "trick" to have a SGA up to 1.7GB (on x86).
> > -----Original Message-----
> > From: Gabi Draghici [mailto:gabi.draghici@(protected)]
> > Sent: 11 February, 2006 12:14 PM
> > To: suse oracle
> > Subject: [suse-oracle] methods to increase sga size on SLES 9
> > Hello !
> > We have Oracle 188.8.131.52 on Sles 9 (SP3) x86 with
> 2.6.5-7.244-bigsmp and
> > 5G of RAM !
> > We want to increase the sga from 1G to 1.5 G. Of course
> when we want
> > to start the database we hit
> > "ORA-27123
: unable to attach to shared memory segment"
> > Now, I've been reading a few documents (most of them for RedHat !)
> > about how it can be done and it seems that mainly there are
> 2 ways to
> > do that : hugetlb and bigpages ! Which is the best way for
> sles 9 and
> > how it can be done with the minimum loss of performance ?
> > GAbi
> __________ NOD32 1.1404 (20060211) Information __________
> This message was checked by NOD32 antivirus system.
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting