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_at_rice.edu] 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