在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