Re: [Q] how to check ORACLE thread and kill it on NT????

you can use the "oracle administration assistant for windows nt" in the "database administration". It allows you to see the thread ids and their cpu usage.
open it up and navigate down to databases and right click on the database and there's an option for Process Information.

for 9i, the mmc file is C:\Program Files\Oracle\MMC Snap-Ins\Administration Assistant\orammcadm9us.msc

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, October 30, 2002 12:34 PM

>
>
> We have problem on ORACLE on NT (Oracle 8.1.7). The oracle.exe show it
> use 100% CPU usage, but their is NO user inside ORACL (select usrname from
> v$session).
> I used to remember NT resource kit have tool can check which thread under
> ORACLE.exe use most CPU time and have tool can kill it.
>
> Can anyone give me a hint?
>
>
> Thanks.
>
>
>
>
>
>
> _________________________________________________________________
> Broadband? Dial-up? Get reliable MSN Internet Access.
> http://resourcecenter.msn.com/access/plans/default.asp
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: dist cash
> INET: mccdba_at_hotmail.com
>
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve Perry
  INET: sperry_at_sprynet.com

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