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).
Received on Wed Sep 24 2003 - 14:39:45 CDT
