Re: processes vs sessions

From: Mir M. Mirhashimali <mhyder_at_rice.edu>
Date: Tue, 30 Oct 2007 14:23:34 -0500
Message-ID: <472784B6.6020403@rice.edu>

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

Received on Tue Oct 30 2007 - 14:23:34 CDT