⑴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相关进程的方法了,常常需要查找这些进程的友友们,就赶紧收藏本教程吧,定能大大提高你的操作速度。