当ORACLE以DEDICATED SERVER连接到服务器时：ORACLE对于每个会话都会生成新的专用服务器，会话与专用服务器间是一对一的关系
测试：
会话1：
启动数据库以后没有用户连接上来的进程情况
[oracle@oraclelinux ~]$ ps -ef|grep oracle
root 6318 6286 0 10:08 pts/1 00:00:00 su - oracle
oracle 6319 6318 0 10:08 pts/1 00:00:00 -bash
oracle 24668 1 0 12:53 ? 00:00:01 ora_pmon_TESTENV01
oracle 24670 1 0 12:53 ? 00:00:01 ora_psp0_TESTENV01
oracle 24672 1 0 12:53 ? 00:00:01 ora_mman_TESTENV01
oracle 24674 1 0 12:53 ? 00:00:01 ora_dbw0_TESTENV01
oracle 24676 1 0 12:53 ? 00:00:01 ora_lgwr_TESTENV01
oracle 24678 1 0 12:53 ? 00:00:07 ora_ckpt_TESTENV01
oracle 24680 1 0 12:53 ? 00:00:01 ora_smon_TESTENV01
oracle 24682 1 0 12:53 ? 00:00:00 ora_reco_TESTENV01
oracle 24684 1 0 12:53 ? 00:00:01 ora_cjq0_TESTENV01
oracle 24690 1 0 12:53 ? 00:00:00 ora_d000_TESTENV01
oracle 24692 1 0 12:53 ? 00:00:00 ora_s000_TESTENV01
oracle 24696 1 0 12:53 ? 00:00:03 ora_mmon_TESTENV01
oracle 24698 1 0 12:53 ? 00:00:00 ora_mmnl_TESTENV01
oracle 24700 1 0 12:54 ? 00:00:00 ora_arc0_TESTENV01
oracle 24702 1 0 12:54 ? 00:00:00 ora_arc1_TESTENV01
oracle 24819 6319 0 15:10 pts/1 00:00:00 ps -ef
oracle 24820 6319 0 15:10 pts/1 00:00:00 grep oracle
会话1:当一个用户登录SQLPLUS,但是没连接到数据库的进程情况
[oracle@oraclelinux ~]$ ps -ef|grep oracle
root 6318 6286 0 10:08 pts/1 00:00:00 su - oracle
oracle 6319 6318 0 10:08 pts/1 00:00:00 -bash
oracle 24668 1 0 12:53 ? 00:00:01 ora_pmon_TESTENV01
oracle 24670 1 0 12:53 ? 00:00:01 ora_psp0_TESTENV01
oracle 24672 1 0 12:53 ? 00:00:01 ora_mman_TESTENV01
oracle 24674 1 0 12:53 ? 00:00:01 ora_dbw0_TESTENV01
oracle 24676 1 0 12:53 ? 00:00:01 ora_lgwr_TESTENV01
oracle 24678 1 0 12:53 ? 00:00:07 ora_ckpt_TESTENV01
oracle 24680 1 0 12:53 ? 00:00:01 ora_smon_TESTENV01
oracle 24682 1 0 12:53 ? 00:00:00 ora_reco_TESTENV01
oracle 24684 1 0 12:53 ? 00:00:01 ora_cjq0_TESTENV01
oracle 24690 1 0 12:53 ? 00:00:00 ora_d000_TESTENV01
oracle 24692 1 0 12:53 ? 00:00:00 ora_s000_TESTENV01
oracle 24696 1 0 12:53 ? 00:00:03 ora_mmon_TESTENV01
oracle 24698 1 0 12:53 ? 00:00:01 ora_mmnl_TESTENV01
oracle 24700 1 0 12:54 ? 00:00:00 ora_arc0_TESTENV01
oracle 24702 1 0 12:54 ? 00:00:00 ora_arc1_TESTENV01
root 24822 24765 0 15:11 pts/2 00:00:00 su - oracle
oracle 24823 24822 0 15:11 pts/2 00:00:00 -bash
oracle 24850 24823 0 15:11 pts/2 00:00:00 sqlplus ---这里多了一个SQLPLUS进程
oracle 24851 6319 0 15:11 pts/1 00:00:00 ps -ef
oracle 24852 6319 0 15:11 pts/1 00:00:00 grep oracle
会话1：当有一个用户通过SQLPLUS连接到数据库，进程情况
[oracle@oraclelinux ~]$ ps -ef|grep oracle
root 6318 6286 0 10:08 pts/1 00:00:00 su - oracle
oracle 6319 6318 0 10:08 pts/1 00:00:00 -bash
oracle 24668 1 0 12:53 ? 00:00:01 ora_pmon_TESTENV01
oracle 24670 1 0 12:53 ? 00:00:01 ora_psp0_TESTENV01
oracle 24672 1 0 12:53 ? 00:00:01 ora_mman_TESTENV01
oracle 24674 1 0 12:53 ? 00:00:01 ora_dbw0_TESTENV01
oracle 24676 1 0 12:53 ? 00:00:01 ora_lgwr_TESTENV01
oracle 24678 1 0 12:53 ? 00:00:07 ora_ckpt_TESTENV01
oracle 24680 1 0 12:53 ? 00:00:01 ora_smon_TESTENV01
oracle 24682 1 0 12:53 ? 00:00:00 ora_reco_TESTENV01
oracle 24684 1 0 12:53 ? 00:00:01 ora_cjq0_TESTENV01
oracle 24690 1 0 12:53 ? 00:00:00 ora_d000_TESTENV01
oracle 24692 1 0 12:53 ? 00:00:00 ora_s000_TESTENV01
oracle 24696 1 0 12:53 ? 00:00:03 ora_mmon_TESTENV01
oracle 24698 1 0 12:53 ? 00:00:01 ora_mmnl_TESTENV01
oracle 24700 1 0 12:54 ? 00:00:00 ora_arc0_TESTENV01
oracle 24702 1 0 12:54 ? 00:00:00 ora_arc1_TESTENV01
root 24822 24765 0 15:11 pts/2 00:00:00 su - oracle
oracle 24823 24822 0 15:11 pts/2 00:00:00 -bash
oracle 24850 24823 0 15:11 pts/2 00:00:00 sqlplus
oracle 24853 24850 2 15:11 ? 00:00:00 oracleTESTENV01 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 24854 6319 0 15:12 pts/1 00:00:00 ps -ef
oracle 24855 6319 0 15:12 pts/1 00:00:00 grep oracle
会话1：当有两个用户用SQLPLUS连接到数据库，进程情况
[oracle@oraclelinux ~]$ ps -ef|grep oracle
root 6318 6286 0 10:08 pts/1 00:00:00 su - oracle
oracle 6319 6318 0 10:08 pts/1 00:00:00 -bash
oracle 24668 1 0 12:53 ? 00:00:01 ora_pmon_TESTENV01
oracle 24670 1 0 12:53 ? 00:00:01 ora_psp0_TESTENV01
oracle 24672 1 0 12:53 ? 00:00:01 ora_mman_TESTENV01
oracle 24674 1 0 12:53 ? 00:00:01 ora_dbw0_TESTENV01
oracle 24676 1 0 12:53 ? 00:00:01 ora_lgwr_TESTENV01
oracle 24678 1 0 12:53 ? 00:00:07 ora_ckpt_TESTENV01
oracle 24680 1 0 12:53 ? 00:00:01 ora_smon_TESTENV01
oracle 24682 1 0 12:53 ? 00:00:00 ora_reco_TESTENV01
oracle 24684 1 0 12:53 ? 00:00:01 ora_cjq0_TESTENV01
oracle 24690 1 0 12:53 ? 00:00:00 ora_d000_TESTENV01
oracle 24692 1 0 12:53 ? 00:00:00 ora_s000_TESTENV01
oracle 24696 1 0 12:53 ? 00:00:03 ora_mmon_TESTENV01
oracle 24698 1 0 12:53 ? 00:00:01 ora_mmnl_TESTENV01
oracle 24700 1 0 12:54 ? 00:00:00 ora_arc0_TESTENV01
oracle 24702 1 0 12:54 ? 00:00:00 ora_arc1_TESTENV01
root 24822 24765 0 15:11 pts/2 00:00:00 su - oracle
oracle 24823 24822 0 15:11 pts/2 00:00:00 -bash
oracle 24850 24823 0 15:11 pts/2 00:00:00 sqlplus
oracle 24853 24850 0 15:11 ? 00:00:00 oracleTESTENV01 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
root 24888 24856 0 15:13 pts/3 00:00:00 su - oracle
oracle 24889 24888 0 15:13 pts/3 00:00:00 -bash
oracle 24916 24889 1 15:13 pts/3 00:00:00 sqlplus
oracle 24917 24916 2 15:13 ? 00:00:00 oracleTESTENV01 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 24918 6319 0 15:13 pts/1 00:00:00 ps -ef
oracle 24919 6319 0 15:13 pts/1 00:00:00 -bash
[oracle@oraclelinux ~]$
新加了两个进程为相应会话进行服务
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15720542/viewspace-729923/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/15720542/viewspace-729923/
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
