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: spurious threads

Re: spurious threads

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Thu, 18 Sep 2003 06:04:40 -0800
Message-ID: <F001.005D0600.20030918060440@fatcity.com>


Btw, if you're applying bigger patches, you have shut down Apps anyway, shutting down the database & service for a sec doesn't add much downtime...

Tane.

  Hi!

  Orakill is able to kill threads based on thread id. But since you can't find out the "runaway" thread id-s from v$process, you could find all thread id-s in oracle.exe, minus those spids which exist in v$process and kill those. But I definitely recommend to turn to support first, because killing threads that way isn't a nice thing to do in production system and might be good enough only for temporary workaround, not for continous usage.

  Tanel.

    We have had an ongoing problem for nearly 1.5 years now starting with 8.1.7.3.2. If we patch the Oracle Apps 11i, a majority of the time, the oracle.exe process gets a runaway thread. A thread exists in the oracle.exe but not in v$process/v$session. Shutting down the database does not resolve the problem. Only stopping the service will resolve it.

    Two weeks ago implemented FND G/HRMS F in dev/test with production scheduled for this weekend. Since then have noticed high thread counts. Dev has topped out at 1000+, test is currently at 809 with only 50 v$process entries!!!!

    Help.

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

Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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). Received on Thu Sep 18 2003 - 09:04:40 CDT

Original text of this message

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