Runaway threads in 8.1.7.3.2 on NT/W2K

[Jeffrey Beckstrom]

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