Re: Oracle.exe , CPU running at near 85%

Rick,

Shot in the dark =8-) If Context (a.k.a. InterMedia) is involved I've seen a CPU pegged at 90% with a web app doing a dynamic text query using CONTAINS and a '-' minus operator. They actually didn't know about the '-' query op...they ended up searching the text string input and replacing '-' with '\-' and the problem dis-appeared. This was 8.1.7.0.0 BTW on Win2K. I found the problem using v$session joined to v$sqlarea. Luckily only the suspect query was running at the time.

There are also spin problems with Net8 and many OCI multi-threaded connections.

Just guessing....I just got back from Christmas in Cuba and I'm trying to exercise my brain...it hurts =8-0

HTH
Jeff Herrick

On Fri, 27 Dec 2002 Rick_Cale_at_teamhealth.com wrote:

> Hi,
>
> Oracle 8.1.6 on NT 4.0
>
> Oracle.exe is running at about 85% CPU utilization. What can I check to
> see why that is the case?
>
> Thanks
> Rick
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: Rick_Cale_at_teamhealth.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: Jeff Herrick
  INET: jherrick_at_igs.net

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