| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: processes vs sessions
Mir,
I realized my previous email, might have sounded a bit harsh, so here's some more info.
http://www.puschitz.com/TuningLinuxForOracle.shtml
Now, that's for Linux but can be ported to different Unix versions as
well.
Do a search for SEMMSL on that page and you'll see how it impacts the
processes parameter for your instance(s).
I've also seen it recommended to set SEMMSL to:
Instance A: processes=75 Instance B: processes=225 Instance C: processes=100
Technically, these should have been set before the Oracle installation occurred.
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor_at_ingrambarge.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mir M. Mirhashimali
Sent: Tuesday, October 30, 2007 2:24 PM
To: Thomas.Mercadante_at_labor.state.ny.us
Cc: oracle-l
Subject: Re: processes vs sessions
This is the reason i brought up this discussion I have a database which is reporting "ORA-00018: maximum number of sessions exceeded"
So i was wondering if i need to bump up my processes parameter from 150 to a higher number. since this requires modifying kernel parameters. I was wondering if there is a way to calculate what this value be set to.
Thanks
-- Mir M. Mirhashimali Oracle Systems Manager Database Architecture, Enterprise Applications Rice University (713) 348 6365 Mercadante, Thomas F (LABOR) wrote:Received on Tue Oct 30 2007 - 15:11:24 CDT
> One more thing:
> You normally do *not* set the sessions parameter within the init.ora
> file. Just the processes parameter. Sessions is auto-set and
> calculated as a multiplier of processes.
>
> Tom
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l
 |
 |