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

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 Wed Nov 20 2002 - 18:45:53 CST