2024年10月Linux通过ps命令查看Oracle相关进程的方法

发布时间:

  ⑴Oracle是很多开发人员所使用的数据库之一,与Oracle相关的进程也非常多,我们平时就可以通过ps命令来查看这些相关的进程。

  ⑵Oracle Listener

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

  ⑷[oracle ~]$ ps -ef | grep tnslsnr

  ⑸oracle : pts/ :: grep tnslsnr

  ⑹oracle Jul ? :: /u/oracle/mcyd/db/tech_st/../bin/tnslsnr mcyd -inherit

  ⑺oracle Jul ? :: /u/oracle/mcyd/apps/tech_st/../bin/tnslsnr APPS_mcyd -inherit

  ⑻oracle May ? :: /u/oracle/mcyd/apps/tech_st/../bin/tnslsnr LISTENER -inherit

  ⑼[oracle ~]$

  ⑽Oracle Background Process

  ⑾[oracle ~]$ ps -ef | grep -i "ora_"

  ⑿oracle : ? :: ora_w_mcyd

  ⒀oracle : ? :: ora_j_mcyd

  ⒁oracle : pts/ :: grep -i ora_

  ⒂oracle Jul ? :: ora_pmon_mcyd

  ⒃oracle Jul ? :: ora_vktm_mcyd

  ⒄oracle Jul ? :: ora_diag_mcyd

  ⒅oracle Jul ? :: ora_dbrm_mcyd

  ⒆oracle Jul ? :: ora_psp_mcyd

  ⒇oracle Jul ? :: ora_dia_mcyd

  ⒈oracle Jul ? :: ora_mman_mcyd

  ⒉oracle Jul ? :: ora_dbw_mcyd

  ⒊oracle Jul ? :: ora_lgwr_mcyd

  ⒋oracle Jul ? :: ora_ckpt_mcyd

  ⒌oracle Jul ? :: ora_smon_mcyd

  ⒍oracle Jul ? :: ora_reco_mcyd

  ⒎oracle Jul ? :: ora_mmon_mcyd

  ⒏oracle Jul ? :: ora_mmnl_mcyd

  ⒐oracle Jul ? :: ora_fbda_mcyd

  ⒑oracle Jul ? :: ora_qmnc_mcyd

  ⒒oracle Jul ? :: ora_q_mcyd

  ⒓oracle Jul ? :: ora_q_mcyd

  ⒔oracle Jul ? :: ora_cjq_mcyd

  ⒕oracle Jul ? :: ora_smco_mcyd

  ⒖oracle Jul ? :: ora_m_mcyd

  ⒗[oracle

  ⒘eg.ora_pmon_mcyd 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 * FROM v$session WHERE type ='BACKGROUND';

  ⒛Oracle Management Agent

  ①[oracle ~]$ ps -ef | grep emagent

  ②oracle : pts/ :: grep emagent

  ③oraem May ? :: /opt/oracle/oraem/agentg/perl/bin/perl /opt/oracle/oraem/agentg/bin/emwd.pl agent /opt/oracle/oraem/agentg/sysman/log/emagent.nohup

  ④oraem May ? :: /opt/oracle/oraem/agentg/bin/emagent

  ⑤[oracle ~]$

  ⑥以上就是Linux通过ps命令查看Oracle相关进程的方法了,常常需要查找这些进程的友友们,就赶紧收藏本教程吧,定能大大提高你的操作速度。