奇奇网>新事>正文

Linux下使用ps命令来查看oracle数据库相关进程的操作步骤

2019-05-01 22:50:24 IT时代网 分享

  具体的方法和详细的步骤如下;

  Oracle Listener

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

  [[email protected] 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

  [[email protected] www.linuxidc.com ~]$

  Oracle Background Process

  [[email protected] 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

  [[email protected] www.xitongzhijia.net~]$

  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...后台进程

声明:本站部分资源来源于网络,版权归原作者或者来源机构所有,如作者或来源机构不同意本站转载采用,请通知我们,我们将第一时间删除内容。本站刊载文章出于传递更多信息之目的,所刊文章观点仅代表作者本人观点,并不意味着本站赞同作者观点或证实其描述,其原创性及对文章内容的真实性、完整性、及时性本站亦不作任何保证或承诺,请读者仅作参考。
编辑:奇奇