Message-ID: <F001.00476F89.20020606152157@fatcity.com>
Date: Thu, 06 Jun 2002 15:21:57 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: "Reardon, Bruce (CALBBAY)" <Bruce.Reardon@comalco.riotinto.com.au>
Subject: RE: runaway oracle.exe thread on NT / W2K
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

Jeffrey,

As an idea - does orakill let you kill the thread off?
This may let you "workaround" the issue without restarting the service.

Bruce Reardon
-----Original Message-----
Sent: Friday, 7 June 2002 6:05

This has now happened on 3 separeate boxes.  This has happened while putting on an Oracle Applications patch or in the last case, after starting the concurrent managers for 11i with a lot of requests scheduled to compile all of the flex fields.  In every instance, the thread id does not match anything in oracle.

We notice that box is using 50-100% cpu even though nothing is running.  Stop concurrent managers.  Terminate web sessions.  Exit all sqlplus sessions.  

Use pslist from sysinternals.com and it shows a running thread of oracle.exe using lots of user and kernal time.  This thread id is not shown in v$session/process!!!!

Oracle has not been of much help to date.

Even after doing a shutdown immediate, cpu is still high and thread is running.  Have to stop the service to get rid of it all.

We had been on 8.1.7.1.5 but upgraded to 8.1.7.3.2 since minimum for our Oracle Apps patches was 8.1.7.2.x just went to the latest and greatest since know eventually would be required.

Has anyone else seen anything like this.

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
(216) 781-4204
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: Bruce.Reardon@comalco.riotinto.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@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).