Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: nproc setting for oracle8.0.4 in hpux 10.20 platform

Re: nproc setting for oracle8.0.4 in hpux 10.20 platform

From: Adrian Hands <AHands_at_sprynet.com>
Date: Thu, 17 Sep 1998 01:18:27 -0400
Message-ID: <36009BA3.2CD87C71@sprynet.com>


Bump it up, way up! 6000 or so should be good.

You've gotta do this with any Unix (Solaris, AIX...) and any RDBMS (Informix, etc...).
You could check your HP-UX manuals (kernel configuration) to see what the max is.
It won't hurt anything - you'll get a fatter kernel, but so what ? Beats the hell out of having fork()s fail... No telling what might happen to your database with that going on.

Move NFILE and NINODE up while you're in there.

Re-boot so the changes'll take effect.

Move 'em way up way so if you have to call support back you say, "Look Cap'tn Kirk - I've got her maxed out as it is! Now send me a patch before this thing starts throwing metal!"

Jenson wrote:
>
> Guru,
>
> I got the error message table full. I phoned up hpux and they suggest me to
> set
> the nproc.
>
> Question:
> What is the value I should set?
>
> FYI
> The existing setting is 680
>
> Any suggestion is much appreciated.

--
Adrian Hands
Raleigh, NC

panic: attempt to recv circular datagram in round socket! panic: stack pointer is read-only!
$ Received on Thu Sep 17 1998 - 00:18:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US