Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: runaway oracle.exe thread on NT / W2K

RE: runaway oracle.exe thread on NT / W2K

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Fri, 07 Jun 2002 05:18:26 -0800
Message-ID: <F001.004775D2.20020607051826@fatcity.com>


Problem is that can not reproduce on demand. Yesterday, we were doing the wrap up for PO G patches, i.e. generate messagess, flexfields, etc. Experienced the problem, tried redoing the same tasks and worked.

Then after bringin up concurrent manager, lots of compile flexfield requests started (we had upped number of standard managers from 6 to 30). Since CPU at 100%, kept lowering number of standard managers from 30 to 20 and eventually back to 6. When requests done noticed cpu at 50%. Stopped everything and still at 50% due to a thread.

Have been running 8.1.7.3.2 on another dev database for about a month with no problems, but there also had the problem but don't recall when since at the time thought it was a fluke. Did not get concerned until happened again (couple times) on another server and that's when openned the TAR.

Therefore, don't know how to reproduce but getting leary of moving it to production.

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113
(216) 781-4204

>>> Michael.Sale_at_oracle.com 6/6/02 7:31:32 PM >>>

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
p

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeffrey Beckstrom
  INET: JBECKSTROM_at_gcrta.org

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).
Received on Fri Jun 07 2002 - 08:18:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US