RE: processes vs sessions

Kernel parameters? Your kernel parameters are awfully low (meaning you probably didn't set them per the install guide) if more than 150 processes requires changing your kernel parameters.

Someone correct me if I'm mistaken please.

Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor_at_ingrambarge.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mir M. Mirhashimali Sent: Tuesday, October 30, 2007 2:24 PM
To: Thomas.Mercadante_at_labor.state.ny.us
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