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: