Re: AIX processes - allowable db processes
From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Fri, 1 May 2009 11:49:24 -0500 (CDT)
Message-ID: <8021ca462ff50f8e6eafd8b7e4f52964.squirrel_at_society.servebeer.com>
> I believe on LINUX that the processes parameter in the database cannot
> exceed the SEMMSL server parameter. Does anyone know what the equivalent
> of that is on AIX? How do you find out what it is currently set at on AIX?
> I need to find out what a particular database cannot exceed and also what
> the total of all the databases on the server combined cannot exceed.
Date: Fri, 1 May 2009 11:49:24 -0500 (CDT)
Message-ID: <8021ca462ff50f8e6eafd8b7e4f52964.squirrel_at_society.servebeer.com>
> I believe on LINUX that the processes parameter in the database cannot
> exceed the SEMMSL server parameter. Does anyone know what the equivalent
> of that is on AIX? How do you find out what it is currently set at on AIX?
> I need to find out what a particular database cannot exceed and also what
> the total of all the databases on the server combined cannot exceed.
Ahhh...welcome to AIX! My biggest hangup in going to it was "Where's the kernel recommendations?" in the Oracle Install guide, like with Solaris or Linux.
With AIX, those kernel parameters are dynamic and do not need adjusting. While not in the kernel, you will need an environment variable set (e.g. on login):
export AIXTHREAD_SCOPE=S
(adjust for your particular shell/environment, if needed)
Metalink 458403.1 should help explain that one, recommended for Oracle versions 9.2 and up.
HTH! GL! Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Fri May 01 2009 - 11:49:24 CDT