RE: Max number of sessions

[Christopher Spence]

Title: RE: Max number of sessions

If you don't modify the SESSSIONS parameter. If you look at v$parameter you will notice Oracle sets the parameter for "Sessions" to be 10% over the processes + 5.   But it will only be able to create the number of processes that is specified for processes parameter. For MTS this isn't a problem. "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: Koivu, Lisa [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 04, 2001 2:58 PM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: RE: Max number of sessions   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.