RE: processes vs sessions

Mir,

Setting the parameter to a high value does not hurt you at all - it just
allows more sessions to connect.

I would at least double it (we have values of 500 as a standard value
and higher in some databases).  Ask your user community what plans they
have for granting more access to the database.  You might need a higher
value.

Tom

-----Original Message-----
From: Mir M. Mirhashimali [mailto:mhyder@xxxxxxxx] 
Sent: Tuesday, October 30, 2007 3:24 PM
To: Mercadante, Thomas F (LABOR)
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

Other related posts: