Runaway threads in 8.1.7.3.2 on NT/W2K

We are running Oracle 8.1.7.3.2 on W2K/NT.

We have experienced a problem while applying Oracle Apps patches that CPU shot to 100% for 4 threads. The weird part is that the patch had aborted so nothing was running in the database. Bouncing database cleared the problem.

Continued with more patches and noticed CPU running at 25% with nothing running. Again bounced database and back to normal.

Latest item we noticed today is that CPU is normal (less than 5%) with no users but we have 40 threads showing in task manager. Did shutdown immediate and count only went down to 30.

Bounced database and now have 12 threads. If connect / disconnect, I see the count go up and then down again.

Looks like Oracle is missing some threads - possibly why during our patching of the Oracle Apps we see CPU out of control.

We have a TAR on this but so far Oracle is lost regarding the high CPU. Especially given that don't have it right now. Hoping the extra threads will point to something.

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