Re: Shared Memory Error - shmat error, unable to attach sga

you should set your shmseg to this :
set shmsys:shminfo_shmseg=10

if you don't do this oracle won't get any sga larger than your shmmax.

Frédéric

> < The contents of /etc/system is: >
>
> * Shared memory parameters 40mb x 1024 x 1024
> set shmsys:shminfo_shmmax= 41943040
> set shmsys:shminfo_shmmin=1
> set shmsys:shminfo_shmmni=100
> set shmsys:shminfo_shmseg=1
> set semsys:seminfo_semmni=100
> set semsys:seminfo_semmns=200
> set semsys:seminfo_semmsl=200
Received on Fri Apr 03 1998 - 00:00:00 CST