RE: Max number of sessions

[Christopher Spence]

Title: Max number of sessions

Nope it is as I said, really do not know why, but if you look at v$parameter and concepts manuals it mentions this behavior.  I think this is more so because of MTS environments, I hardly ever use MTS. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:    (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863   -----Original Message----- From: George Schlossnagle [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 04, 2001 3:56 PM To: Multiple recipients of list ORACLE-L Subject: Re: Max number of sessions   Isn't that the inverse?  You require one shadow process per session, plus the background processes.  You should always have more procs than sessions (jn a non-MTS environment). George   ----- Original Message ----- From: Christopher Spence To: Multiple recipients of list ORACLE-L Sent: Thursday, October 04, 2001 2:50 PM Subject: RE: Max number of sessions   Oracle uses PROCESSES + 10% + 5 for setting the hard limit of the sessions parameter. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:    (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863   -----Original Message----- From: Yuval Arnon [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 04, 2001 2:16 PM To: Multiple recipients of list ORACLE-L Subject: Max number of sessions   Hi, I would like to find out how to compute/estimate the maximum  number of sessions a db can handle. Preferably based on the init.ora params sessions and processes, size of sga, size of ram, the /etc/system params etc. This is for a db running using MTS.   TIA Yuval.