Connection multiplexing is, at least how I understand it, the same thing.
Both names mean that several client sessions can simultaneously use the
same connection. Anyway, I didn't see any effect from turning POOL=ON
in MTS_DISPATCHERS parameter and I did see sharing when pooling was
activated in CMAN.ORA. Connection manager is meant to be a communication
controller. It unites firewall and load balancing functions. If pooling is
what you want, use connection manager.
--
Mladen Gogala
Oracle DBA
> -----Original Message-----
> From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] On
> Behalf Of bulbultyagi_at_now-india.net.in
> Sent: Wednesday, September 24, 2003 3:40 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: shared server connections
>
>
> Mladen, aren't you talking about connection multiplexing and
> not connection pooling ? Isn't pooling is supposed to carried
> out by the dispatchers themselves. Let me know if I should rtfm.
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, September 24, 2003 19:44
>
>
> > Well, to successfully use connection pooling, you need connection
> > manager. My information is that pooling by the instance is rather
> > buggy and slow. Here is an excerpt from the oracle documentation:
> >
> > Oracle Connection Manager, an Oracle Net Services
> component, enables
> > multiple client network sessions to be multiplexed, or funneled,
> > through a single network connection to a database.
> >
> > The session multiplexing feature reduces the demand on resources
> > needed to maintain multiple network sessions between two
> processes by
> > enabling the server to use fewer network connection endpoints for
> > incoming requests.
> This
> > enables you to increase the total number of network sessions that a
> > server can handle. With multiple Oracle Connection
> Managers, thousands
> > of concurrent users can connect to a server.
> >
> > Figure 1-12 shows how session multiplexing can be used in a Web
> > architecture. When Oracle Connection Manager is run on the same
> > computer
> as
> > an application Web server, the application Web server can route
> > multiple client sessions through Oracle Connection Manager
> to ensure
> > that those sessions have continuous access to an Oracle database
> > server. This functionality is especially useful for Web
> applications
> > where session availability and response time are major concerns.
> >
> > --
> > Mladen Gogala
> > Oracle DBA
> >
> >
> >
> > > -----Original Message-----
> > > From: ml-errors_at_fatcity.com
> [mailto:ml-errors_at_fatcity.com] On Behalf
> > > Of bulbultyagi_at_now-india.net.in
> > > Sent: Tuesday, September 23, 2003 7:25 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: shared server connections
> > >
> > >
> > > Hello list, I am using 9.2.0.1.0 enterprise edition on
> windows. I
> > > have a database in shared server mode. Every time any
> one tries to
> > > use a shared server connection , I find that after the
> execution of
> > > any query the processor usage shoots up to 95-98%.
> > >
> > > I have two dispatchers configured , and whenever I
> specify pool=on ,
> > > I see the following : As long as the shared server connection is
> > > maintained the processor usage remains high and the
> > > v$dispatcher_rate(CUR_LOOP_RATE) and v$dispatcher_rate(
> > > CUR_EVENT_RATE ) values for the concerned dispatcher go on
> > > increasing steadily even though there is only one user and he is
> > > sitting idle. If this user logs off, cpu usage falls down
> to normal.
> > > This happens with any user who tries to use a shared server
> > > connection. No such problem if a dedicated connection is used.
> > >
> > > If I restart the instance after setting pool=off then there is no
> > > such problem.
> > >
> > > Any ideas ?
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: <bulbultyagi_at_now-india.net.in
> > > INET: bulbultyagi_at_now-india.net.in
> > >
> > > Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> > > San Diego, California -- Mailing list and web
> hosting services
> > >
> --------------------------------------------------------------------
> > > -
> > > 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).
> > >
> >
> >
> >
> > Note:
> > This message is for the named person's use only. It may contain
> confidential, proprietary or legally privileged information.
> No confidentiality or privilege is waived or lost by any
> mistransmission. If you receive this message in error,
> please immediately delete it and all copies of it from your
> system, destroy any hard copies of it and notify the sender.
> You must not, directly or indirectly, use, disclose,
> distribute, print, or copy any part of this message if you
> are not the intended recipient. Wang Trading LLC and any of
> its subsidiaries each reserve the right to monitor all e-mail
> communications through its networks.
> > Any views expressed in this message are those of the individual
> > sender,
> except where the message states otherwise and the sender is
> authorized to state them to be the views of any such entity.
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Mladen Gogala
> > INET: mladen_at_wangtrading.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web
> hosting services
> >
> ---------------------------------------------------------------------
> > 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.net
> --
> Author: <bulbultyagi_at_now-india.net.in
> INET: bulbultyagi_at_now-india.net.in
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
>
Note:
This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: mladen_at_wangtrading.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Wed Sep 24 2003 - 15:04:46 CDT
