RE: Max number of sessions

From: Koivu, Lisa <lisa.koivu_at_efairfield.com>
Date: Thu, 04 Oct 2001 11:53:39 -0700
Message-ID: <F001.003A241D.20011004115031@fatcity.com>

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.

Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117

-----Original Message-----

From:   Christopher Spence [SMTP:cspence_at_FuelSpot.com]
Sent:   Thursday, October 04, 2001 2:50 PM
To:     Multiple recipients of list ORACLE-L

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: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,
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. Received on Thu Oct 04 2001 - 13:53:39 CDT