RE: processes vs sessions
- From: "Taylor, Chris David" <Chris.Taylor@xxxxxxxxxxxxxxx>
- To: <mhyder@xxxxxxxx>
- Date: Tue, 30 Oct 2007 15:11:24 -0500
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
=
Total Processes: 400 to set SEMMSL to 410 to 415 (10-15 additional
processes)
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@xxxxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mir M. Mirhashimali
Sent: Tuesday, October 30, 2007 2:24 PM
To: Thomas.Mercadante@xxxxxxxxxxxxxxxxx
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:
> 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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
