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
=
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
--
http://www.freelists.org/webpage/oracle-l




--
http://www.freelists.org/webpage/oracle-l

Other related posts: