可以通过pslist来看oracle.exe进程下的线程:
pslist在这里下载:
http://www.sysinternals.com/ntw2k/freeware/pslist.shtml
(tom书上介绍说的)
后台进程可以通过查v$bgprocess,v$process和pslist的线程对应上,server process就不知道了。
SQL> select spid, name from v$bgprocess, v$process where v$bgprocess.paddr=v$process.addr;
SPID NAME
------------------------------------ ---------------
3152 PMON
3156 DBW0
3176 ARC0
3212 ARC1
3160 LGWR
3164 CKPT
3168 SMON
3172 RECO
8 rows selected.
C:\Documents and Settings\lilixin-\My Documents\pslist -d oracle
PsList 1.26 - Process Information Lister
Copyright (C) 1999-2004 Mark Russinovich
Sysinternals - www.sysinternals.com
Thread detail for HEWLETT-F2L0GLV:
oracle 952:
Tid Pri Cswtch State User Time Kernel Time Elapsed Time
960 8 797 Wait:Executive 0:00:00.010 0:00:00.040 1:56:19.926
1024 8 1691 Wait:UserReq 0:00:00.010 0:00:00.030 1:56:19.766
1800 8 2 Wait:UserReq 0:00:00.000 0:00:00.000 1:56:19.405
3152 8 2524 Wait:UserReq 0:00:00.110 0:00:00.010 1:56:01.239
3156 8 2557 Wait:UserReq 0:00:00.100 0:00:00.020 1:56:00.939
3160 8 2738 Wait:UserReq 0:00:00.050 0:00:00.120 1:56:00.638
3164 9 9979 Wait:UserReq 0:00:00.180 0:00:00.120 1:56:00.338
3168 8 379 Wait:UserReq 0:00:00.230 0:00:00.130 1:56:00.038
3172 8 25 Wait:UserReq 0:00:00.000 0:00:00.010 1:55:59.737
3176 8 847 Wait:UserReq 0:00:00.040 0:00:00.090 1:55:59.407
3212 8 92 Wait:UserReq 0:00:00.010 0:00:00.030 1:55:59.106