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