Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Configuring SGA greater that 2GB on Red Hat Linux 7.3 / Oracle 9i Rel 2

Re: Configuring SGA greater that 2GB on Red Hat Linux 7.3 / Oracle 9i Rel 2

From: David Sharples <david.sharples3_at_ntlworld.com>
Date: Wed, 20 Nov 2002 23:21:28 -0000
Message-ID: <nPUC9.2918$Lq.110986@newsfep1-gui.server.ntli.net>


your SGA is a bit big, should be aorund 1/3 of total ram (rough guide) knock it down a bit
"Adnan" <adnanans_at_cyber.net.pk> wrote in message news:d29dbd53.0211201519.7b314688_at_posting.google.com...
> i m trying to configure SGA size around 2.3 GB for my
> database on 2 processors / 3 GB Ram machine running
> RedHat linux 7.3 and Oracle 9i R2.
>
> i have tried all the possibilities mentioned in the
> manuals but failed to configure.
>
> the following error comes whenever i tried to start
> the db with sqlplus:
>
> ORA-27102 out of memory
> Linux Error 28 : No space left on device.
>
> the following r the kernel parameter settings:
>
> sem # 200 1500 100 1500
> shmmax # 2 GB
> shmmin # 1
> shmseg # 4096
> shmvmx # 32767
>
> (mount point for shared mem)
> mount -t shm shmfs -o nr_blocks=8g /dev/shm
>
> (initora parameter)
> use_indirect_data_buffers=true
>
>
>
> Regards
> Adnan...
Received on Wed Nov 20 2002 - 17:21:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US