RE: shared server connections
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of [EMAIL PROTECTED] > 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" <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > > > Of [EMAIL PROTECTED] > > > 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: <[EMAIL PROTECTED] > > > INET: [EMAIL PROTECTED] > > > > > > 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 lis
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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > Behalf Of [EMAIL PROTECTED] > > 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: <[EMAIL PROTECTED] > > INET: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a li
RE: shared server connections
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of [EMAIL PROTECTED] > 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: <[EMAIL PROTECTED] > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
