RE: Max number of sessions

<span style='font-size:

10.0pt;font-family:Arial;color:navy'>Oracle uses PROCESSES + 10% + 5 for setting the hard limit of the sessions parameter.

<span style='font-size:12.0pt;

color:navy;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='font-size:18.0pt;

font-family:"Comic Sans MS";color:navy;mso-no-proof:yes'>Christopher R. Spence<font color=navy>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>Oracle DBA<span style='color:navy;
mso-no-proof:yes'>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>Phone: (978) 322-5744<span
style='color:navy;mso-no-proof:yes'>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>Fax:    (707) 885-2275<span
style='color:navy;mso-no-proof:yes'>

<span style='font-size:10.0pt;

font-family:"Comic Sans MS";color:navy;mso-no-proof:yes'>Fuelspot<font color=navy>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>73 Princeton Street<span style='color:navy; mso-no-proof:yes'>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>North, Chelmsford 01863<span
style='color:navy;mso-no-proof:yes'>
 

<span

style='font-size:10.0pt;font-family:Tahoma'>-----Original Message----- From: Yuval Arnon
[mailto:Yuval.Arnon_at_wwfent.com]
Sent: Thursday, October 04, 2001
2:16 PM
To: Multiple recipients of list
ORACLE-L
Subject: Max number of sessions

<span

style='font-size:12.0pt'> 

<span

style='font-size:10.0pt'>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.

<p class=MsoNormal style='mso-margin-top-alt:0in;margin-right:0in;margin-bottom:
12.0pt;margin-left:.5in'><span
style='font-size:12.0pt'> 

<span

style='font-size:10.0pt'>TIA

<span

style='font-size:10.0pt'>Yuval. Received on Thu Oct 04 2001 - 13:07:56 CDT