Mario
so how comes, that I am not able to find the corresponding SPID to my
NT-processes ???
I tried the following statement :
############################################################################
#####################################
select
substr(a.spid,1,5) pid,
substr(b.sid,1,5) sid,
substr(b.serial#,1,5) ser#,
machine box,
substr(b.username,1,10) username,
-- b.server,
substr(b.osuser,1,8) os_user,
substr(b.program,1,30) program
from v$session b, v$process a
where
b.paddr = a.addr
and type='USER'
order by spid;
## and I got :
PID SID SER# BOX USERNAME
OS_USER PROGRAM
----- ----- ----- ----------------------------------------------- ----------
-------- -----------------------------
00111 58 10121 networkname xx
xxxxxxx C:\myexe.exe
############################################################################
#######################################
(beware of wordwrap here)
If find the process myexe.exe on networkname in the taskmanager. It's PID is
: 478 (HEX 1DE). The database is on a separate server in the network.
None of the processes, running on the client could pointed to a SPID on the
server..... ???!!!!
> Frank <
>-----Ursprüngliche Nachricht-----
>Von: Broodbakker, Mario [mailto:[EMAIL PROTECTED]]
>Gesendet am: Montag, 20. Januar 2003 13:59
>An: Multiple recipients of list ORACLE-L
>Betreff: RE: 100% CPU utilization, urgent
>
>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)
>
>
--
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).
