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
 
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

• Original Message -----
  <DIV
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: Christopher Spence To: <A href="mailto:ORACLE-L_at_fatcity.com" title=ORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L Sent: Thursday, October 04, 2001 2:50 PM Subject: RE: Max number of sessions

<SPAN

  style="COLOR: navy; FONT-FAMILY: Arial; FONT-SIZE: 10pt">Oracle uses PROCESSES   + 10% + 5 for setting the hard limit of the sessions   parameter.   

<SPAN

  style="COLOR: navy; FONT-SIZE: 12pt; mso-no-proof: yes">"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."
<SPAN

  style="COLOR: navy; FONT-FAMILY: 'Comic Sans MS'; FONT-SIZE: 18pt; mso-no-proof: yes">Christopher   R. Spence<SPAN
  style="COLOR: navy; mso-no-proof: yes"> <FONT color=navy   face="Comic Sans MS" size=2><SPAN
  style="COLOR: navy; FONT-FAMILY: 'Comic Sans MS'; FONT-SIZE: 10pt; mso-no-proof: yes">Oracle   DBA<SPAN
  style="COLOR: navy; mso-no-proof: yes"> <FONT color=navy   face="Comic Sans MS" size=2><SPAN
  style="COLOR: navy; FONT-FAMILY: 'Comic Sans MS'; FONT-SIZE: 10pt; mso-no-proof: yes">Phone:   (978) 322-5744<SPAN
  style="COLOR: navy; mso-no-proof: yes"> <FONT color=navy   face="Comic Sans MS" size=2><SPAN
  style="COLOR: navy; FONT-FAMILY: 'Comic Sans MS'; FONT-SIZE: 10pt; mso-no-proof: yes">Fax:      (707) 885-2275<SPAN
  style="COLOR: navy; mso-no-proof: yes">
<SPAN

  style="COLOR: navy; FONT-FAMILY: 'Comic Sans MS'; FONT-SIZE: 10pt; mso-no-proof: yes">Fuelspot<FONT   color=navy>
<SPAN

  style="COLOR: navy; FONT-FAMILY: 'Comic Sans MS'; FONT-SIZE: 10pt; mso-no-proof: yes">73   Princeton Street<SPAN
  style="COLOR: navy; mso-no-proof: yes"> <FONT color=navy   face="Comic Sans MS" size=2><SPAN
  style="COLOR: navy; FONT-FAMILY: 'Comic Sans MS'; FONT-SIZE: 10pt; mso-no-proof: yes">North,   Chelmsford 01863<SPAN
  style="COLOR: navy; mso-no-proof: yes">     

<SPAN

  style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">-----Original   Message-----From: Yuval
  Arnon [mailto:Yuval.Arnon_at_wwfent.com] <SPAN   style="FONT-WEIGHT: bold">Sent: Thursday, October 04, 2001 2:16   PMTo: Multiple recipients of
  list ORACLE-LSubject: Max
  number of sessions
<FONT face="Times New Roman"

  size=3> 
<SPAN

  style="FONT-SIZE: 10pt">Hi, <SPAN
  style="FONT-SIZE: 10pt">I would like to find out how to compute/estimate the   maximum  number of sessions a db can handle. <FONT   size=2>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.
<P class=MsoNormal

  style="MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 0.5in; MARGIN-RIGHT: 0in; mso-margin-top-alt: 0in"><FONT   face="Times New Roman" size=3><SPAN
  style="FONT-SIZE: 12pt"> 
<SPAN

  style="FONT-SIZE: 10pt">TIA
<SPAN

  style="FONT-SIZE: 10pt">Yuval. Received on Thu Oct 04 2001 - 13:38:32 CDT