RE: Connection Manager

CMAN provides connection concentration which runs on a middle tier. This channels a number of clients via a single connection to a server. It is also termed as multiplexing.It works in conjunction with MTS MTS allows multiple clients to use dispatcher processes on the server thereby reducing the number of individual o/s processes on the server. A new feature of MTS is called connection pooling. This further reduces the number of physical resources required on the server end by allowing connections to be made to the dispatcher when a session becomes idle rather than when it is disconnected. Therefore queueing time is either reduced or removed depending on the workload of each session.

Connection concentration and connection pooling are mutually exclusive. Use pooling to share connections at the database server or use concentration to share connections at the middle tier.

It has been useful writing this note as I am taking my Network OCP exam in 4 hours time - I have now realised how little I know.

Regards

John

-----Original Message-----
Baumgartel
Sent: 20 February 2001 15:46
To: Multiple recipients of list ORACLE-L

Can anyone explain to me the difference between Connection Manager's connection concentration and connection pooling capabilities, and the appropriate circumstances in which to use them? Thanks.

Paul Baumgartel
InstiPro, Inc.
paul.baumgartel_at_instipro.com
212 813-0829 x103 (office)
917 549-4717 (mobile)

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
  INET: PaulB_at_instipro.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Hallas
  INET: john.hallas_at_mail.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).