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

Pls. write the steps to workout this thing.

Regards,
Adnan

Ban Spam <ban-spam_at_operamail.com> wrote in message news:<Xns92CCAAA578B05SunnySD_at_68.6.19.6>...
> adnanans_at_cyber.net.pk (Adnan) wrote in
> 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...
>
> In V7.3.4.5 the default was the max SGA size was 1.75GB.
> To create an SGA larger than that you had to modify a file (I
> forget/forgot the name of it) & then re-link the oracle executable.
Received on Thu Nov 21 2002 - 05:56:53 CST