感谢支持
我们一直在努力
当前位置：服务器评测 > 教程资讯 > Linux运维 > 正文

Linux下使用ps命令来查看Oracle相关的进程

2012-07-11 分类：Linux运维 阅读(200) 评论(0)

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 ~]$

赞(0) 打赏
转载请注明出处：服务器评测 » Linux下使用ps命令来查看Oracle相关的进程
分享到： 更多 (0)
标签：

相关推荐

分类

听说打赏我的人，都进福布斯排行榜啦！

支付宝扫一扫打赏

微信扫一扫打赏