RE: Max number of sessions

<span style='font-size:

10.0pt;font-family:Arial;color:navy'>If you don't modify the SESSSIONS parameter.

<span style='font-size:

10.0pt;font-family:Arial;color:navy'>
If you look at v$parameter you will notice Oracle sets the parameter for "Sessions" to be 10% over the processes + <span class=GramE>5.

<span style='font-size:

10.0pt;font-family:Arial;color:navy'> 

<span

style='font-size:10.0pt;font-family:Arial;color:navy'>But<font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial; color:navy'> it will only be able to create the number of processes that is specified for processes parameter.

<span style='font-size:

10.0pt;font-family:Arial;color:navy'>For MTS this isn't a problem.

<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: Koivu, Lisa
[mailto:lisa.koivu_at_efairfield.com]
Sent<span
style='font-weight:bold'>: Thursday, October 04, 2001 2:58 PM To: '<font
 size=2 face=Tahoma>ORACLE-L_at_fatcity.com<font size=2 face=Tahoma>'<span
class=GramE>; 'cspence_at_FuelSpot.com'
Subject: RE: Max number of
sessions

<span

style='font-size:12.0pt'> 

<span

style='font-size:12.0pt;font-family:Georgia;color:blue'>Really Christopher?  I have seen databases crap out at exactly the number of sessions allowed by the processes parameter, including the background processes.  That was on Solaris and on HP/UX.  Looked like there was no wiggle room, period.

<span style='font-size:

12.0pt;font-family:Georgia'>Lisa Koivu
Oracle Database
Administrator
Fairfield Resorts, Inc.

954-935-4117

<span

style='font-size:12.0pt'> 

<span style='font-size:

7.5pt;font-family:Arial'>-----Original Message-----
<span style='font-size:7.5pt;font-family:Arial;
font-weight:bold'>From:   <span
style='font-size:7.5pt;font-family:Arial'>Christopher Spence [SMTP:cspence_at_FuelSpot.com]
<span style='font-size:7.5pt;font-family:Arial;
font-weight:bold'>Sent:   <span
style='font-size:7.5pt;font-family:Arial'>Thursday, October 04, 2001 2:50 PM

<span style='font-size:7.5pt;font-family:Arial;
font-weight:bold'>To:     <font size=1
face=Arial>Multiple recipients
of list ORACLE-L
<span style='font-size:7.5pt;font-family:Arial;
font-weight:bold'>Subject:       
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. "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'>Christopher R. Spence<span style='font-family:Arial;
color:navy'>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy'>Oracle DBA<font color=navy face=Arial>
<span

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

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

font-family:"Comic Sans MS";color:navy'>Fuelspot<font color=navy face=Arial>
<span

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

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy'>North, Chelmsford 01863<span
style='font-family:Arial;color:navy'>
 
-----Original
Message-----
From: Yuval Arnon [<a
href="mailto:Yuval.Arnon_at_wwfent.com">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

 
Hi,<span
style='font-family:Arial'>
<span style='font-size:10.0pt;font-family:
Arial'>I would like to find out how to compute/estimate the maximum  number of sessions a db can handle.<span style='font-family:Arial'>
<span style='font-size:10.0pt;font-family:
Arial'>Preferably based on the init.ora params sessions and processes, size of sga, size of ram, the /etc/system params etc.<span style='font-family:Arial'>
<span style='font-size:10.0pt;font-family:
Arial'>This is for a db running using MTS.  
TIA<span
style='font-family:Arial'>
Yuval.<font
face=Arial> Received on Thu Oct 04 2001 - 14:39:19 CDT