RE: Max number of sessions

[Christopher Spence]

Title: 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.