RE: MTS_DISPATCHERS

From: Singla, Sanjeev <SSingla_at_oxhp.com>
Date: Fri, 23 Jun 2000 09:42:01 -0400
Message-Id: <10537.110258@fatcity.com>

SESSIONS is max number of users that can connect to the dispatcher CONNECTIONS is used for connection pooling, It defines the number of requests that
can be serviced by temporarily disabling the inactive sessions. EG.
CONN=100 SESS=200
Once 100 connections are reached, the 101th connection will be serviced by the dispacher
after temporarily disabling any of the inactive session. It selects the session based on
LRU.Whichever connection is inactive for the longest period will be temporarily disabled.
Oracle maintains this inactive session and once this becomes active Oracle will look for
some other inactive session and do the same thing. So virtually 200 sessions can be connected
but effectively only 100 will be served at any time. This basically help u to maximise the usage of available resources without denying request to
new connections.
This is actually good when u have internet based applications or less interactive applications
like customer service or help desk where u open the screen fetch the data and then
spend most of the time in talking to the customer. It is an extension to MTS. Cheers

-----Original Message-----
From: Jonathan Gennick [mailto:jonathan_at_gennick.com] Sent: Thursday, June 22, 2000 6:31 PM
To: Multiple recipients of list ORACLE-L Subject: MTS_DISPATCHERS

MTS_DISPATCHERS has the following two attributes: CONNECTIONS and SESSIONS. I'm not clear on the difference. They both seem to limit the number of network connections that a dispatcher can handle. Are they indeed indentical?

Jonathan

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are

-- 
Author: Jonathan Gennick
  INET: jonathan_at_gennick.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Jun 23 2000 - 08:42:01 CDT