Oracle 9i - "Out Of Memory" error?

[Georg-W. Koltermann]

On Mo, 2003-08-18 at 19:35, Brian Ledbetter wrote:
> I've set the values on my system to match the list as close as I could,
> and I still get the error.  Here're my current settings - what am I
> missing?  I assume you configured most of these values in your
> /sys/i386/conf/(SYSTEM) file?
> 
> 
> # sysctl -a | grep shm
> kern.ipc.shmmax: 2147483647

Wow that's far more than you need, but won't hurt probably.

> kern.ipc.shmmin: 1
> kern.ipc.shmmni: 4096
> kern.ipc.shmseg: 4096
> kern.ipc.shmall: 8192

That (shmall) might be a bit small.  According to
/usr/src/sys/conf/NOTES this is the max. number of pages for share
memory, system wide.  With 4kB pages this value would mean 32 MB of
shared memory, which, depending on the database parameters, might be too
low.

My values, which still work in 5.1 unchanged from 5.0, are:

        #
        # FreeBSD kernel options for ORACLE
        #
        options         SHMSEG=4096
        options         SEMMNI=100
        options         SEMMNS=256
        options         SHMMAXPGS=131073
        options         SHMALL=131073
        
--
Regards, 
Georg-W. Koltermann <g.w.k at web.de>