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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
