Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Max number of sessions
<span style='font-size:
10.0pt;font-family:Arial;color:navy'>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.
<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: George Schlossnagle
[mailto:george_at_omniti.com]
Sent<span
style='font-weight:bold'>: Thursday, October 04, 2001 3:56 PM
To: Multiple recipients of list
ORACLE-L
Subject: Re: Max number of
sessions
<span
style='font-size:12.0pt'>
<span
style='font-size:10.0pt;font-family:Arial'>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).
<span
style='font-size:12.0pt'>
<span style='font-size:10.0pt;font-family:
Arial'>George
<span
style='font-size:12.0pt'>
<blockquote style='border:none;border-left:solid black 1.5pt;padding:0in 0in 0in 4.0pt;
margin-left:3.75pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'>
<span
style='font-size:10.0pt;font-family:Arial'>----- Original Message -----
<font size=2
face=Arial>From:<font size=2 face=Arial> <a href="mailto:cspence_at_FuelSpot.com" title="cspence_at_FuelSpot.com">ChristopherSpence
<span
style='font-size:10.0pt;font-family:Arial;font-weight:bold'>To:<font
size=2 face=Arial> <a
href="mailto:ORACLE-L_at_fatcity.com" title="ORACLE-L_at_fatcity.com">Multiple
recipients of list ORACLE-L
<span
style='font-size:10.0pt;font-family:Arial;font-weight:bold'>Sent:<font
size=2 face=Arial> Thursday,
October 04, 2001 2:50 PM
<span
style='font-size:10.0pt;font-family:Arial;font-weight:bold'>Subject:<font
size=2 face=Arial> RE: Max
number of sessions
<span
style='font-size:12.0pt'>
<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<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'>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<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'>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:1.0in'><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 - 15:26:13 CDT
![]() |
![]() |