Oracle-L: shared server connections

From: <bulbultyagi_at_now-india.net.in>
Date: Tue, 23 Sep 2003 15:24:41 -0800
Message-ID: <F001.005D0DBF.20030923152441@fatcity.com>

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). Received on Tue Sep 23 2003 - 18:24:41 CDT