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).