日期:2014-05-16  浏览次数:20817 次

linux查看oracle进程

http://www.cnblogs.com/fengyv/archive/2012/07/11/2585661.html

Oracle Listener

这个命令会列出Oracle Net Listener的进程

  1. [oracle@bej301441?~]$?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@bej301441?~]$??

?

Oracle Background Process

  1. [oracle@bej301441?~]$?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@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...后台进程

  1. select?*?FRO