Date: 19 Aug 2003 20:28:25 +0000 From: "Georg-W. Koltermann" <g.w.k@web.de> To: Brian Ledbetter <brian@shadowcom.net> Cc: freebsd-database@freebsd.org Subject: Re: Oracle 9i - "Out Of Memory" error? Message-ID: <1061324905.1498.8.camel@bat.localnet> In-Reply-To: <20030818193529.GA77206@shadowcom.net> References: <20030818145638.GA75929@shadowcom.net> <871xvikdyl.fsf@dellius.nederware.nl> <20030818193529.GA77206@shadowcom.net>
next in thread | previous in thread | raw e-mail | index | archive | help
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@web.de>
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1061324905.1498.8.camel>