http://www.cnblogs.com/fengyv/archive/2012/07/11/2585661.html
Oracle Listener
这个命令会列出Oracle Net Listener的进程
- [oracle@bej301441?~]$?ps?-ef?|?grep?tnslsnr??
- oracle????1999?29986??0?09:47?pts/2????00:00:00?grep?tnslsnr??
- oracle????3647?????1??0?Jul03??????????00:00:34?/u01/oracle/mc3yd213/db/tech_st/11.1.0/bin/tnslsnr?mc3yd213?-inherit??
- oracle????6431?????1??0?Jul03??????????00:00:00?/u01/oracle/mc3yd213/apps/tech_st/10.1.2/bin/tnslsnr?APPS_mc3yd213?-inherit??
- oracle???13616?????1??0?May27??????????00:00:40?/u01/oracle/mc3yd213/apps/tech_st/10.1.2/bin/tnslsnr?LISTENER?-inherit??
- [oracle@bej301441?~]$??
?
Oracle Background Process
- [oracle@bej301441?~]$?ps?-ef?|?grep?-i?"ora_"??
- oracle????1887?????1??0?09:42??????????00:00:00?ora_w000_mc3yd213??
- oracle????2159?????1??0?09:54??????????00:00:00?ora_j000_mc3yd213??
- oracle????2167?29986??0?09:55?pts/2????00:00:00?grep?-i?ora_??
- oracle????3516?????1??0?Jul03??????????00:02:00?ora_pmon_mc3yd213??
- oracle????3518?????1??0?Jul03??????????00:02:08?ora_vktm_mc3yd213??
- oracle????3522?????1??0?Jul03??????????00:00:27?ora_diag_mc3yd213??
- oracle????3524?????1??0?Jul03??????????00:00:18?ora_dbrm_mc3yd213??
- oracle????3526?????1??0?Jul03??????????00:00:35?ora_psp0_mc3yd213??
- oracle????3528?????1??0?Jul03??????????00:05:59?ora_dia0_mc3yd213??
- oracle????3530?????1??0?Jul03??????????00:00:19?ora_mman_mc3yd213??
- oracle????3532?????1??0?Jul03??????????00:01:06?ora_dbw0_mc3yd213??
- oracle????3534?????1??0?Jul03??????????00:02:53?ora_lgwr_mc3yd213??
- oracle????3536?????1??0?Jul03??????????00:02:08?ora_ckpt_mc3yd213??
- oracle????3538?????1??0?Jul03??????????00:01:36?ora_smon_mc3yd213??
- oracle????3540?????1??0?Jul03??????????00:00:06?ora_reco_mc3yd213??
- oracle????3542?????1??0?Jul03??????????00:02:01?ora_mmon_mc3yd213??
- oracle????3544?????1??0?Jul03??????????00:03:20?ora_mmnl_mc3yd213??
- oracle????3564?????1??0?Jul03??????????00:00:09?ora_fbda_mc3yd213??
- oracle????3569?????1??0?Jul03??????????00:00:16?ora_qmnc_mc3yd213??
- oracle????3584?????1??0?Jul03??????????00:00:36?ora_q000_mc3yd213??
- oracle????3586?????1??0?Jul03??????????00:00:15?ora_q001_mc3yd213??
- oracle????3690?????1??0?Jul03??????????00:02:30?ora_cjq0_mc3yd213??
- oracle????3707?????1??0?Jul03??????????00:00:28?ora_smco_mc3yd213??
- oracle????7676?????1??0?Jul03??????????00:42:49?ora_m000_mc3yd213??
- [oracle@bej301441?~]$??
eg.ora_pmon_mc3yd213 is PMON process,PMON (Process MONitor) is an Oracle background process created when you start a database instance. The PMON process will free up resources if a user process fails (eg. release database locks).
这些后台进程，从数据库里也是能查到的，可以使用下边这个SQL来查后台进程，在program列中，你就能看到SMON,MMON,CKPT,PMON,MMAN,MMNL...后台进程
- select?*?FRO
