Document directory
- Oracle listener
- Oracle management agent
In Linux, you can run the ps command to view Oracle-related processes.
Oracle listener
This command will list the processes of Oracle Net Listener
- [Oracle @ bej301441 ~] $ PS-Ef | grep tnslsnr
- Oracle 1999 29986 0 00:00:00 pts/2 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 pai_mc3yd213-inherit
- Oracle 13616 1 0 May27? 00:00:40/u01/Oracle/mc3yd213/apps/tech_st/10.1.2/bin/tnslsnr listener-inherit
- [Oracle @ bej301441 ~] $
Oracle background process
- [Oracle @ bej301441 ~] $ PS-Ef | grep-I "ora _"
- Oracle 1887 1 0? 00:00:00 ora_w000_mc3yd213
- Oracle 2159 1 0? 00:00:00 ora_j000_mc3yd213
- Oracle 2167 29986 0 00:00:00 pts/2 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_q0020.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 @ 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
User process fails (eg. Release Database locks ).
These background processes can also be found in the database. You can use the following SQL to query background processes. In the program column, you can see SMON, mmon, ckpt, pmon, mman, mmnl... background Process
- Select * from V $ session where type = 'background ';
For background processes, see Oracle background processes
Oracle management agent
- [Oracle @ bej301441 ~] $ PS-Ef | grep emagent
- Oracle 2097 29986 0 00:00:00 pts/2 grep emagent
- Oracle 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 @ bej301441 ~] $
Reprinted please indicate the source: http://blog.csdn.net/pan_tian/article/details/7734892
======= EOF ======