在windows下檢視oracle的後臺程式

在linux環境下可以使用命令直接查oracle的程式，在windows下可以使用sql語句檢視，不過沒有linux的資訊詳細。。。

SQL> select program,status from v$session where type='BACKGROUND';
PROGRAM                                                          STATUS        
---------------------------------------------------------------- --------      
ORACLE.EXE (CJQ0)                                                ACTIVE        
ORACLE.EXE (q001)                                                ACTIVE        
ORACLE.EXE (q000)                                                ACTIVE        
ORACLE.EXE (QMNC)                                                ACTIVE        
ORACLE.EXE (W000)                                                ACTIVE        
ORACLE.EXE (SMCO)                                                ACTIVE        
ORACLE.EXE (FBDA)                                                ACTIVE        
ORACLE.EXE (ARC4)                                                ACTIVE        
ORACLE.EXE (ARC3)                                                ACTIVE        
ORACLE.EXE (ARC2)                                                ACTIVE        
ORACLE.EXE (ARC1)                                                ACTIVE        
ORACLE.EXE (ARC0)                                                ACTIVE        
ORACLE.EXE (MMNL)                                                ACTIVE        
ORACLE.EXE (MMON)                                                ACTIVE        
ORACLE.EXE (RECO)                                                ACTIVE        
ORACLE.EXE (SMON)                                                ACTIVE        
ORACLE.EXE (CKPT)                                                ACTIVE        
ORACLE.EXE (LGWR)                                                ACTIVE        
ORACLE.EXE (DBW0)                                                ACTIVE        
ORACLE.EXE (MMAN)                                                ACTIVE        
ORACLE.EXE (DIA0)                                                ACTIVE        
ORACLE.EXE (PSP0)                                                ACTIVE             ORACLE.EXE (DBRM)                                                ACTIVE        
ORACLE.EXE (DIAG)                                                ACTIVE        
ORACLE.EXE (VKTM)                                                ACTIVE        
ORACLE.EXE (PMON)                                                ACTIVE        
已選擇26行。

附 linux環境下檢視程式的命令：

檢視Oracle db程式 ps –ef|grep ora_
檢視Net8 Listener程式1 ps –ef|grep lsnr
檢視Net8 Listener of the APPS RPC程式 ps –ef|grep lsnr
檢視Report serve程式 ps –ef|grep rwmts60
檢視Concurrent Manager程式 ps –ef|grep FND|grep oracle
檢視Apache程式 ps –ef|grep Apache|grep oracle
檢視Apache Servle程式 ps –ef|grep java
檢視Forms Metric Client程式 ps –ef|grep d2lc60
檢視Forms Metric Server程式 ps –ef|grep d2ls60
檢視Forms Serverr程式 ps –ef|grep f60webmx

參考資料：

http://zhulch.itpub.net/post/17395/462068