1. 使用windows的tasklist工具查看进程情况

tasklist /fi "IMAGENAME eq oracle.exe"

查看帮助tasklist /?

2. 开始-->运行 wmic

输入process可以查看进程的路径

3. pslist 查看进程中线程的相关信息，但不能显示线程名称

下载解压后放到系统目录system32下

pslsit – help查看帮助信息，下载pslist包中还有chm的帮助文档

          不加参数使用PsList查看本机启动的Oracle进程相关信息
通过Thd列可以看到oracle进程中包含22个线程
C:\>pslist oracle

pslist v1.28 - Sysinternals PsList
Copyright ? 2000-2004 Mark Russinovich
Sysinternals

Process information for HOUSWLT:

Name                Pid Pri Thd Hnd   Priv        CPU Time    Elapsed Time
oracle             7408   8 22 427 259884     0:00:03.515     0:04:39.077

          使用-d参数进一步查看在XP系统中对应的线程详细信息
详细显示每个线程对应的基本信息。与在linux或UNIX上使用"ps -ef | grep oracle"命令得到的信息相比，这里不会显示出具体的线程名信息，仅仅显示出了线程的ID值（Tid列）。
C:\>pslist -d oracle

pslist v1.28 - Sysinternals PsList
Copyright ? 2000-2004 Mark Russinovich
Sysinternals

Thread detail for HOUSWLT:

oracle 7408:
Tid Pri    Cswtch            State     User Time   Kernel Time   Elapsed Time
6464   9        94   Wait:Executive 0:00:00.000   0:00:00.031    0:04:44.812
7776   9        84     Wait:UserReq 0:00:00.000   0:00:00.000    0:04:44.687
5268   9        14     Wait:UserReq 0:00:00.000   0:00:00.000    0:04:44.671
2804   8       226     Wait:UserReq 0:00:00.031   0:00:00.015    0:04:41.624
7152   8       302     Wait:UserReq 0:00:00.015   0:00:00.000    0:04:41.624
7156   8       193     Wait:UserReq 0:00:00.000   0:00:00.000    0:04:41.577
4024   8       231     Wait:UserReq 0:00:00.000   0:00:00.031    0:04:41.577
8124   9       609     Wait:UserReq 0:00:00.031   0:00:00.031    0:04:41.562
6844   9       514     Wait:UserReq 0:00:00.046   0:00:00.046    0:04:41.562
7116   8       768     Wait:UserReq 0:00:00.140   0:00:00.046    0:04:41.562
4772   8        36     Wait:UserReq 0:00:00.000   0:00:00.015    0:04:41.546
4156   9       339     Wait:UserReq 0:00:00.125   0:00:00.000    0:04:41.546
620   8      1217     Wait:UserReq 0:00:00.437   0:00:00.046    0:04:41.546
5960   8       473     Wait:UserReq 0:00:00.015   0:00:00.000    0:04:41.546
4340 10         3       Wait:Queue 0:00:00.000   0:00:00.000    0:04:41.484
5040   8       275     Wait:UserReq 0:00:00.015   0:00:00.015    0:04:36.984
5020   9       181     Wait:UserReq 0:00:00.000   0:00:00.015    0:04:36.984
6832   9        66     Wait:UserReq 0:00:00.000   0:00:00.000    0:04:34.718
4332   9        49     Wait:UserReq 0:00:00.000   0:00:00.015    0:04:31.968
6964   9        38     Wait:UserReq 0:00:00.015   0:00:00.000    0:04:21.968
8008   8        44     Wait:UserReq 0:00:00.000   0:00:00.015    0:04:16.968
160   8        80     Wait:UserReq 0:00:00.000   0:00:00.031    0:00:09.750

          使用-m参数查看oracle进程使用内存的情况
C:\>pslist -m oracle

pslist v1.28 - Sysinternals PsList
Copyright ? 2000-2004 Mark Russinovich
Sysinternals

Process memory detail for HOUSWLT:

Name                Pid      VM      WS    Priv Priv Pk   Faults   NonP Page
oracle             7408 372588 150508 254412 269920    52531     16 207

4. tlist 安装debugging tools for windows可以使用该命令

tlist /?查看帮助，下载的debugging tools包中有chm帮助文档

C:\Documents and Settings\yangluwei>tlist 6048

6048 oracle.exe

CWD: d:\oracle\ora92\DATABASE\

VirtualSize: 455256 KB PeakVirtualSize: 467916 KB

WorkingSetSize:225968 KB PeakWorkingSetSize:233860 KB

NumberOfThreads: 14

5272 Win32StartAddr:0x018e6c7c LastErr:0x00000000 State:Waiting

5076 Win32StartAddr:0x77dc3539 LastErr:0x0000007e State:Waiting

2880 Win32StartAddr:0x006f7dc0 LastErr:0x000003e5 State:Waiting

780 Win32StartAddr:0x00430360 LastErr:0x00000000 State:Waiting

3588 Win32StartAddr:0x00430360 LastErr:0x00000000 State:Waiting

3456 Win32StartAddr:0x00430360 LastErr:0x000000b7 State:Waiting

5820 Win32StartAddr:0x00430360 LastErr:0x00000000 State:Waiting

6124 Win32StartAddr:0x00430360 LastErr:0x00000000 State:Waiting

4672 Win32StartAddr:0x00430360 LastErr:0x00000000 State:Waiting

4204 Win32StartAddr:0x00430360 LastErr:0x00000000 State:Waiting

5492 Win32StartAddr:0x00430360 LastErr:0x00000000 State:Waiting

5448 Win32StartAddr:0x00430360 LastErr:0x00000000 State:Waiting

2024 Win32StartAddr:0x719cd2c6 LastErr:0x00000000 State:Waiting

5256 Win32StartAddr:0x00430360 LastErr:0x00000000 State:Waiting

oracle有14个线程

9.2.0.5 shp 0x00400000 d:\oracle\ora92\bin\ORACLE.EXE

5.1.2600.5755 shp 0x7C920000 C:\WINDOWS\system32\ntdll.dll

5.1.2600.5781 shp 0x7C800000 C:\WINDOWS\system32\kernel32.dll

9.2.0.5 shp 0x60600000 d:\oracle\ora92\bin\oraclient9.dll

9.2.0.5 shp 0x610A0000 d:\oracle\ora92\bin\oracore9.dll

0.0.0.0 shp 0x612A0000 d:\oracle\ora92\bin\oranls9.dll

0.0.0.0 shp 0x613A0000 d:\oracle\ora92\bin\oraunls9.dll

7.0.2600.5512 shp 0x77BE0000 C:\WINDOWS\system32\MSVCRT.dll

5.1.2600.5512 shp 0x71A40000 C:\WINDOWS\system32\WSOCK32.dll

5.1.2600.5512 shp 0x71A20000 C:\WINDOWS\system32\WS2_32.dll

5.1.2600.5755 shp 0x77DA0000 C:\WINDOWS\system32\ADVAPI32.dll

5.1.2600.5795 shp 0x77E50000 C:\WINDOWS\system32\RPCRT4.dll

5.1.2600.5834 shp 0x77FC0000 C:\WINDOWS\system32\Secur32.dll

5.1.2600.5512 shp 0x71A10000 C:\WINDOWS\system32\WS2HELP.dll

5.1.2600.5512 shp 0x76990000 C:\WINDOWS\system32\ole32.dll

5.1.2600.5698 shp 0x77EF0000 C:\WINDOWS\system32\GDI32.dll

5.1.2600.5512 shp 0x77D10000 C:\WINDOWS\system32\USER32.dll

5.1.2600.5512 shp 0x76B10000 C:\WINDOWS\system32\WINMM.dll

9.2.0.5 shp 0x60800000 d:\oracle\ora92\bin\oravsn9.dll

9.2.0.5 shp 0x60500000 d:\oracle\ora92\bin\oracommon9.dll

9.2.0.5 shp 0x02740000 d:\oracle\ora92\bin\orageneric9.dll

0.0.0.0 shp 0x62FC0000 d:\oracle\ora92\bin\oraxml9.dll

7.0.2600.5512 shp 0x00380000 C:\WINDOWS\system32\MSVCIRT.dll

0.0.0.0 shp 0x630F0000 d:\oracle\ora92\bin\oraxsd9.dll

0.0.0.0 shp 0x61480000 d:\oracle\ora92\bin\oran9.dll

0.0.0.0 shp 0x61400000 d:\oracle\ora92\bin\oranl9.dll

0.0.0.0 shp 0x61960000 d:\oracle\ora92\bin\oranldap9.dll

0.0.0.0 shp 0x615A0000 d:\oracle\ora92\bin\orannzsbb9.dll

9.2.0.5 shp 0x62000000 d:\oracle\ora92\bin\oraldapclnt9.dll

0.0.0.0 shp 0x616B0000 d:\oracle\ora92\bin\orancrypt9.dll

5.1.2600.5512 shp 0x770F0000 C:\WINDOWS\system32\OLEAUT32.dll

0x62300000 d:\oracle\ora92\bin\ORATRACE9.dll

0.0.0.0 shp 0x61730000 d:\oracle\ora92\bin\oranro9.dll

0.0.0.0 shp 0x617C0000 d:\oracle\ora92\bin\oranhost9.dll

0.0.0.0 shp 0x617D0000 d:\oracle\ora92\bin\oranoname9.dll

0.0.0.0 shp 0x616A0000 d:\oracle\ora92\bin\orancds9.dll

0.0.0.0 shp 0x61820000 d:\oracle\ora92\bin\orantns9.dll

9.2.0.0 shp 0x10000000 d:\oracle\ora92\bin\oranms.dll

9.2.0.0 shp 0x003A0000 d:\oracle\ora92\bin\oranmsp.dll

9.2.0.5 shp 0x60A00000 d:\oracle\ora92\bin\orapls9.dll

0.0.0.0 shp 0x62500000 d:\oracle\ora92\bin\oraslax9.dll

0.0.0.0 shp 0x61350000 d:\oracle\ora92\bin\orasnls9.dll

9.2.0.5 shp 0x60810000 d:\oracle\ora92\bin\orawtc9.dll

0.0.0.0 shp 0x62600000 d:\oracle\ora92\bin\orasql9.dll

9.2.0.5 shp 0x60820000 d:\oracle\ora92\bin\oraodm9.dll

9.2.0.5 shp 0x60E00000 d:\oracle\ora92\bin\oraplp9.dll

0x029D0000 d:\oracle\ora92\bin\orajox9.dll

0.0.0.0 shp 0x61AF0000 d:\oracle\ora92\bin\oransgr9.dll

0.0.0.0 shp 0x60000000 d:\oracle\ora92\bin\orawwg9.dll

5.1.2600.5694 shp 0x5FDD0000 C:\WINDOWS\system32\NETAPI32.dll

0x62F00000 d:\oracle\ora92\bin\ocijdbc9.dll

5.1.2600.5512 shp 0x76300000 C:\WINDOWS\system32\IMM32.DLL

5.1.2600.5512 shp 0x62C20000 C:\WINDOWS\system32\LPK.DLL

1.420.2600.5512 sh 0x73FA0000 C:\WINDOWS\system32\USP10.dll

0.0.0.0 shp 0x03240000 d:\oracle\ora92\BIN\ORAIMR9.Dll

5.1.2600.5512 shp 0x76D70000 C:\WINDOWS\system32\Apphelp.dll

0.0.0.0 shp 0x61850000 d:\oracle\ora92\bin\oranbeq9.dll

0.0.0.0 shp 0x61890000 d:\oracle\ora92\bin\orannts9.dll

5.1.2600.5512 shp 0x71F00000 C:\WINDOWS\system32\security.dll

5.1.2600.5876 shp 0x77C40000 C:\WINDOWS\system32\msv1_0.dll

5.1.2600.5512 shp 0x76760000 C:\WINDOWS\system32\cryptdll.dll

5.1.2600.5512 shp 0x76D30000 C:\WINDOWS\system32\iphlpapi.dll

0.0.0.0 shp 0x61910000 d:\oracle\ora92\bin\orantcp9.dll

5.1.2600.5625 shp 0x719C0000 C:\WINDOWS\System32\mswsock.dll

5.1.2600.5625 shp 0x76EF0000 C:\WINDOWS\system32\DNSAPI.dll

5.1.2600.5512 shp 0x76F80000 C:\WINDOWS\System32\winrnr.dll

5.1.2600.5512 shp 0x76F30000 C:\WINDOWS\system32\WLDAP32.dll

5.1.2600.5512 shp 0x76F90000 C:\WINDOWS\system32\rasadhlp.dll

6.0.2900.5512 shp 0x5ADC0000 C:\WINDOWS\system32\uxtheme.dll

0x04D10000 C:\WINDOWS\system32\Zte_Proxy.dll

5.1.2600.5512 shp 0x60FD0000 C:\WINDOWS\system32\hnetcfg.dll

5.1.2600.5512 shp 0x71A00000 C:\WINDOWS\System32\wshtcpip.dll

每通过sqlplus连上服务端，线程数+1,说明是专用服务器模式

SQL> conn /as sysdba

已连接。

NumberOfThreads: 15