Linux下使用ps命令來查看Oracle相關的進程

Linux下可以使用ps命令來查看Oracle相關的進程

Oracle Listener

這個命令會列出Oracle Net Listener的進程

1. [oracle@ www.linuxidc.com ~]$ ps -ef | grep tnslsnr
2. oracle 1999 29986 0 09:47 pts/2 00:00:00 grep tnslsnr
3. oracle 3647 1 0 Jul03 ? 00:00:34 /u01/oracle/mc3yd213/db/tech_st/11.1.0/bin/tnslsnr mc3yd213 -inherit
4. oracle 6431 1 0 Jul03 ? 00:00:00 /u01/oracle/mc3yd213/apps/tech_st/10.1.2/bin/tnslsnr APPS_mc3yd213 -inherit
5. oracle 13616 1 0 May27 ? 00:00:40 /u01/oracle/mc3yd213/apps/tech_st/10.1.2/bin/tnslsnr LISTENER -inherit
6. [oracle@ www.linuxidc.com ~]$

[oracle@ www.linuxidc.com ~]$ 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@ www.linuxidc.com ~]$

Oracle Background Process

1. [oracle@ www.linuxidc.com ~]$ ps -ef | grep -i "ora_"
2. oracle 1887 1 0 09:42 ? 00:00:00 ora_w000_mc3yd213
3. oracle 2159 1 0 09:54 ? 00:00:00 ora_j000_mc3yd213
4. oracle 2167 29986 0 09:55 pts/2 00:00:00 grep -i ora_
5. oracle 3516 1 0 Jul03 ? 00:02:00 ora_pmon_mc3yd213
6. oracle 3518 1 0 Jul03 ? 00:02:08 ora_vktm_mc3yd213
7. oracle 3522 1 0 Jul03 ? 00:00:27 ora_diag_mc3yd213
8. oracle 3524 1 0 Jul03 ? 00:00:18 ora_dbrm_mc3yd213
9. oracle 3526 1 0 Jul03 ? 00:00:35 ora_psp0_mc3yd213
10. oracle 3528 1 0 Jul03 ? 00:05:59 ora_dia0_mc3yd213
11. oracle 3530 1 0 Jul03 ? 00:00:19 ora_mman_mc3yd213
12. oracle 3532 1 0 Jul03 ? 00:01:06 ora_dbw0_mc3yd213
13. oracle 3534 1 0 Jul03 ? 00:02:53 ora_lgwr_mc3yd213
14. oracle 3536 1 0 Jul03 ? 00:02:08 ora_ckpt_mc3yd213
15. oracle 3538 1 0 Jul03 ? 00:01:36 ora_smon_mc3yd213
16. oracle 3540 1 0 Jul03 ? 00:00:06 ora_reco_mc3yd213
17. oracle 3542 1 0 Jul03 ? 00:02:01 ora_mmon_mc3yd213
18. oracle 3544 1 0 Jul03 ? 00:03:20 ora_mmnl_mc3yd213
19. oracle 3564 1 0 Jul03 ? 00:00:09 ora_fbda_mc3yd213
20. oracle 3569 1 0 Jul03 ? 00:00:16 ora_qmnc_mc3yd213
21. oracle 3584 1 0 Jul03 ? 00:00:36 ora_q000_mc3yd213
22. oracle 3586 1 0 Jul03 ? 00:00:15 ora_q001_mc3yd213
23. oracle 3690 1 0 Jul03 ? 00:02:30 ora_cjq0_mc3yd213
24. oracle 3707 1 0 Jul03 ? 00:00:28 ora_smco_mc3yd213
25. oracle 7676 1 0 Jul03 ? 00:42:49 ora_m000_mc3yd213
26. [oracle@ www.linuxidc.com ~]$

[oracle@ www.linuxidc.com ~]$ 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@ www.linuxidc.com ~]$

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...後台進程

1. select * FROM v$session WHERE type ='BACKGROUND';

select * FROM v$session WHERE type ='BACKGROUND';

關於後台進程，可以參見Oracle Background processes

Oracle Management Agent

1. [oracle@ www.linuxidc.com ~]$ ps -ef | grep emagent
2. oracle 2097 29986 0 09:51 pts/2 00:00:00 grep emagent
3. oraem 3130 1 0 May24 ? 00:08:57 /opt/oracle/oraem/agent10g/perl/bin/perl /opt/oracle/oraem/agent10g/bin/emwd.pl agent /opt/oracle/oraem/agent10g/sysman/log/emagent.nohup
4. oraem 3150 3130 0 May24 ? 00:25:56 /opt/oracle/oraem/agent10g/bin/emagent
5. [oracle@ www.linuxidc.com ~]$

[oracle@ www.linuxidc.com ~]$ ps -ef | grep emagent
oracle    2097 29986  0 09:51 pts/2    00:00:00 grep emagent
oraem     3130     1  0 May24 ?        00:08:57 /opt/oracle/oraem/agent10g/perl/bin/perl /opt/oracle/oraem/agent10g/bin/emwd.pl agent /opt/oracle/oraem/agent10g/sysman/log/emagent.nohup
oraem     3150  3130  0 May24 ?        00:25:56 /opt/oracle/oraem/agent10g/bin/emagent
[oracle@ www.linuxidc.com ~]$