RE: runaway oracle.exe thread on NT / W2K

If you cannot tie that thread to v$process then it is likely a problem with a background thread.  

If you are using sqlnet expire time it creates 2 threads for each connection, the timer thread will not show up in v$process. There are also a few other threads that will not show up related to process management.  

One approach:
Once you have a database instance with this problem that you are willing to crash you can attach to it with a debugger to get a look at what is up. The simple way to do this with little expertise is to use: drwtsn32 -p <oracle.exe_pid#>
This will generate a dump file (given that you haven't reconfigured dr watson) that support can review (well, the BDE group can) for content. They'll need to know the EXACT version of the database you have as well as the OS version (including service packs and hot fixes) to get the right dbg symbols in place.

Regards,

Michael Sale
Author: Oracle9i for Windows(R) 2000 Tips & Techniques http://www.amazon.com/exec/obidos/ASIN/0072194626

-----Original Message-----
Beckstrom
Sent: Thursday, June 06, 2002 2:05 PM
To: Multiple recipients of list ORACLE-L

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: Michael P Sale
  INET: Michael.Sale_at_oracle.com

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