From owner-freebsd-database@FreeBSD.ORG Tue Aug 19 13:30:32 2003 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 42A5016A4BF for ; Tue, 19 Aug 2003 13:30:32 -0700 (PDT) Received: from smtp.web.de (smtp03.web.de [217.72.192.158]) by mx1.FreeBSD.org (Postfix) with ESMTP id A504A43F85 for ; Tue, 19 Aug 2003 13:30:31 -0700 (PDT) (envelope-from g.w.k@web.de) Received: from [217.232.162.122] (helo=[192.168.0.2]) by smtp.web.de with asmtp (WEB.DE 4.99 #448) id 19pD5f-000555-00; Tue, 19 Aug 2003 22:28:27 +0200 From: "Georg-W. Koltermann" To: Brian Ledbetter In-Reply-To: <20030818193529.GA77206@shadowcom.net> References: <20030818145638.GA75929@shadowcom.net> <871xvikdyl.fsf@dellius.nederware.nl> <20030818193529.GA77206@shadowcom.net> Content-Type: text/plain Message-Id: <1061324905.1498.8.camel@bat.localnet> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.3 Date: 19 Aug 2003 20:28:25 +0000 Content-Transfer-Encoding: 7bit Sender: g.w.k@web.de cc: freebsd-database@freebsd.org Subject: Re: Oracle 9i - "Out Of Memory" error? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 19 Aug 2003 20:30:32 -0000 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