Frank,
I'm pretty sure they do:
SQL> select spid,program from v$process;
SPID PROGRAM
--------- --------------------------------------------------
PSEUDO
892 ORACLE.EXE
896 ORACLE.EXE
1044 ORACLE.EXE
528 ORACLE.EXE
616 ORACLE.EXE
792 ORACLE.EXE
300 ORACLE.EXE
>From Pstat:
pid:6a8 pri: 8 Hnd: 206 Pf: 43673 Ws: 17828K oracle.exe
tid pri Ctx Swtch StrtAddr User Time Kernel Time State
424 8 937 77E99264 0:00:00.020 0:00:01.281 Wait:Executive
690 8 51 77E83775 0:00:00.000 0:00:00.020 Wait:UserRequest
6f8 8 2 77E83775 0:00:00.000 0:00:00.000 Wait:UserRequest
510 9 7 77E83775 0:00:00.000 0:00:00.000 Wait:UserRequest
558 8 4 77E83775 0:00:00.000 0:00:00.010 Wait:DelayExecution
450 9 71 77E83775 0:00:00.000 0:00:00.000 Wait:EventPairLow
37c 8 8158 77E83775 0:00:00.220 0:00:00.861 Wait:UserRequest
380 8 926 77E83775 0:00:00.020 0:00:00.090 Wait:UserRequest
414 8 1040 77E83775 0:00:00.010 0:00:00.270 Wait:UserRequest
210 9 1837 77E83775 0:00:00.040 0:00:00.080 Wait:UserRequest
268 8 237 77E83775 0:00:00.420 0:00:00.150 Wait:UserRequest
318 9 65 77E83775 0:00:00.010 0:00:00.040 Wait:UserRequest
12c 9 6347 77E83775 0:02:30.826 0:00:00.821 Wait:UserRequest
The last tid (12c hex) equals to 300: that's my thread after running Jonathans world
famous kill_cpu script.
You can checkout (after converting to dec) a few of the others too.
This was the case on NT4 and I just showed this on W2K
In perfmon you can find the thread_id in the Thread Object (don't confuse it with the
perfmon's object_id!), and off course the cpu usage of the corresponding thread.
regards,
Mario
Btw I didn't see your earlier question, since I joined the list a few days ago, please
send it to me if you want a more specific answer (or correct me if I'm wrong)
-----Original Message-----
Sent: maandag 20 januari 2003 12:39
To: Multiple recipients of list ORACLE-L
>If I remember correctly (from a previous NT-life):
>v$process.spid maps to the NT thread_id.
no, they don't !!! (at least NT4 with a SQLNet connection to a DB Server)
(see my question I posted a few days ago)
> Frank <
>Von: Broodbakker, Mario [mailto:[EMAIL PROTECTED]]
>Gesendet am: Montag, 20. Januar 2003 11:34
>An: Multiple recipients of list ORACLE-L
>Betreff: RE: 100% CPU utilization, urgent
>
>If I remember correctly (from a previous NT-life):
>v$process.spid maps to the NT thread_id. The thread(s) causing
>this can be found probably by looking at pstat or perfmon:
>here you can see the cpu consumption. Also you can probably
>deduce it from v$sesstat's 'cpu used by this session': it will
>be high compared to others (if it's just 1 runaway thread)..
>regards,
>Mario Broodbakker
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Foelz.Frank
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.net
--
Author: Broodbakker, Mario
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).
