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:[EMAIL PROTECTED]]
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:[EMAIL PROTECTED]]
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.
