RE: 100% CPU utilization, urgent

...and this:

SQL> select sid,process from v$session;

       SID PROCESS
---------- ---------

         1 892
         2 896
         3 1044
         4 528
         5 616
         6 792
         7 1676:932

(my sqlplus sid=7) the 1676:932 pair appears to be the 'process_id:thread_id' from the sqlplus.exe client program:

pid:68c pri: 8 Hnd: 78 Pf: 58549 Ws: 2068K sqlplus.exe  tid pri Ctx Swtch StrtAddr User Time Kernel Time State  3a4 8 55171 77E99264 0:00:14.350 0:00:15.302 Wait:LpcReply

regards,
Mario Broodbakker

-----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:Mario.Broodbakker_at_hp.com]
>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: Foelz.Frank_at_Scheidt-Bachmann.de

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.net
-- 
Author: Broodbakker, Mario
  INET: Mario.Broodbakker_at_hp.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).