共享服务器进程对应得服务器进程是ora_s???_SID 吗?
来源:互联网 发布:笔记本支架 知乎 编辑:程序博客网 时间:2024/06/15 10:17
共享服务器进程对应得服务器进程是ora_s???_SID 吗?
SQL> show parameters shared_servers;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_shared_servers integer
shared_servers integer 5
SQL> !ps -ef | grep ora_
oracle 7774 1 0 Aug20 ? 00:00:02 ora_pmon_stone
oracle 7776 1 0 Aug20 ? 00:00:01 ora_psp0_stone
oracle 7778 1 0 Aug20 ? 00:00:00 ora_mman_stone
oracle 7780 1 0 Aug20 ? 00:00:10 ora_dbw0_stone
oracle 7782 1 0 Aug20 ? 00:00:08 ora_lgwr_stone
oracle 7784 1 0 Aug20 ? 00:00:16 ora_ckpt_stone
oracle 7786 1 0 Aug20 ? 00:00:08 ora_smon_stone
oracle 7788 1 0 Aug20 ? 00:00:00 ora_reco_stone
oracle 7790 1 0 Aug20 ? 00:00:13 ora_cjq0_stone
oracle 7792 1 0 Aug20 ? 00:00:09 ora_mmon_stone
oracle 7794 1 0 Aug20 ? 00:00:04 ora_mmnl_stone
oracle 7796 1 0 Aug20 ? 00:00:00 ora_d000_stone
oracle 7800 1 0 Aug20 ? 00:00:03 ora_arc0_stone
oracle 7802 1 0 Aug20 ? 00:00:00 ora_arc1_stone
oracle 7806 1 0 Aug20 ? 00:00:00 ora_qmnc_stone
oracle 7814 1 0 Aug20 ? 00:00:00 ora_q000_stone
oracle 7816 1 0 Aug20 ? 00:00:00 ora_q001_stone
oracle 7820 1 0 Aug20 ? 00:00:00 ora_s000_stone
oracle 7822 1 0 Aug20 ? 00:00:00 ora_s001_stone
oracle 9860 1 0 08:18 ? 00:00:00 ora_s002_stone
oracle 9862 1 0 08:18 ? 00:00:00 ora_s003_stone
oracle 9864 1 0 08:18 ? 00:00:00 ora_s004_stone
oracle 9865 9849 0 08:19 pts/2 00:00:00 /bin/bash -c ps -ef | grep ora_
oracle 9867 9865 0 08:19 pts/2 00:00:00 grep ora_
SQL> alter system set shared_servers=3;
System altered.
SQL> !ps -ef | grep ora_
oracle 7774 1 0 Aug20 ? 00:00:02 ora_pmon_stone
oracle 7776 1 0 Aug20 ? 00:00:01 ora_psp0_stone
oracle 7778 1 0 Aug20 ? 00:00:00 ora_mman_stone
oracle 7780 1 0 Aug20 ? 00:00:10 ora_dbw0_stone
oracle 7782 1 0 Aug20 ? 00:00:08 ora_lgwr_stone
oracle 7784 1 0 Aug20 ? 00:00:16 ora_ckpt_stone
oracle 7786 1 0 Aug20 ? 00:00:08 ora_smon_stone
oracle 7788 1 0 Aug20 ? 00:00:00 ora_reco_stone
oracle 7790 1 0 Aug20 ? 00:00:13 ora_cjq0_stone
oracle 7792 1 0 Aug20 ? 00:00:09 ora_mmon_stone
oracle 7794 1 0 Aug20 ? 00:00:04 ora_mmnl_stone
oracle 7796 1 0 Aug20 ? 00:00:00 ora_d000_stone
oracle 7800 1 0 Aug20 ? 00:00:03 ora_arc0_stone
oracle 7802 1 0 Aug20 ? 00:00:00 ora_arc1_stone
oracle 7806 1 0 Aug20 ? 00:00:00 ora_qmnc_stone
oracle 7814 1 0 Aug20 ? 00:00:00 ora_q000_stone
oracle 7816 1 0 Aug20 ? 00:00:00 ora_q001_stone
oracle 7820 1 0 Aug20 ? 00:00:00 ora_s000_stone
oracle 7822 1 0 Aug20 ? 00:00:00 ora_s001_stone
oracle 9860 1 0 08:18 ? 00:00:00 ora_s002_stone
oracle 9862 1 0 08:18 ? 00:00:00 ora_s003_stone
oracle 9864 1 0 08:18 ? 00:00:00 ora_s004_stone
oracle 9869 1 0 08:19 ? 00:00:00 ora_j000_stone
oracle 9870 9849 0 08:19 pts/2 00:00:00 /bin/bash -c ps -ef | grep ora_
oracle 9872 9870 0 08:19 pts/2 00:00:00 grep ora_
SQL> !ps -ef | grep ora_
oracle 7774 1 0 Aug20 ? 00:00:02 ora_pmon_stone
oracle 7776 1 0 Aug20 ? 00:00:01 ora_psp0_stone
oracle 7778 1 0 Aug20 ? 00:00:00 ora_mman_stone
oracle 7780 1 0 Aug20 ? 00:00:10 ora_dbw0_stone
oracle 7782 1 0 Aug20 ? 00:00:08 ora_lgwr_stone
oracle 7784 1 0 Aug20 ? 00:00:16 ora_ckpt_stone
oracle 7786 1 0 Aug20 ? 00:00:08 ora_smon_stone
oracle 7788 1 0 Aug20 ? 00:00:00 ora_reco_stone
oracle 7790 1 0 Aug20 ? 00:00:13 ora_cjq0_stone
oracle 7792 1 0 Aug20 ? 00:00:09 ora_mmon_stone
oracle 7794 1 0 Aug20 ? 00:00:04 ora_mmnl_stone
oracle 7796 1 0 Aug20 ? 00:00:00 ora_d000_stone
oracle 7800 1 0 Aug20 ? 00:00:03 ora_arc0_stone
oracle 7802 1 0 Aug20 ? 00:00:00 ora_arc1_stone
oracle 7806 1 0 Aug20 ? 00:00:00 ora_qmnc_stone
oracle 7814 1 0 Aug20 ? 00:00:00 ora_q000_stone
oracle 7816 1 0 Aug20 ? 00:00:00 ora_q001_stone
oracle 7820 1 0 Aug20 ? 00:00:00 ora_s000_stone
oracle 7822 1 0 Aug20 ? 00:00:00 ora_s001_stone
oracle 9860 1 0 08:18 ? 00:00:00 ora_s002_stone
oracle 9862 1 0 08:18 ? 00:00:00 ora_s003_stone
oracle 9864 1 0 08:18 ? 00:00:00 ora_s004_stone
oracle 9869 1 0 08:19 ? 00:00:00 ora_j000_stone
oracle 9873 9849 0 08:19 pts/2 00:00:00 /bin/bash -c ps -ef | grep ora_
oracle 9875 9873 0 08:19 pts/2 00:00:00 grep ora_
SQL> !ps -ef | grep ora_
oracle 7774 1 0 Aug20 ? 00:00:02 ora_pmon_stone
oracle 7776 1 0 Aug20 ? 00:00:01 ora_psp0_stone
oracle 7778 1 0 Aug20 ? 00:00:00 ora_mman_stone
oracle 7780 1 0 Aug20 ? 00:00:10 ora_dbw0_stone
oracle 7782 1 0 Aug20 ? 00:00:08 ora_lgwr_stone
oracle 7784 1 0 Aug20 ? 00:00:16 ora_ckpt_stone
oracle 7786 1 0 Aug20 ? 00:00:08 ora_smon_stone
oracle 7788 1 0 Aug20 ? 00:00:00 ora_reco_stone
oracle 7790 1 0 Aug20 ? 00:00:13 ora_cjq0_stone
oracle 7792 1 0 Aug20 ? 00:00:09 ora_mmon_stone
oracle 7794 1 0 Aug20 ? 00:00:04 ora_mmnl_stone
oracle 7796 1 0 Aug20 ? 00:00:00 ora_d000_stone
oracle 7800 1 0 Aug20 ? 00:00:03 ora_arc0_stone
oracle 7802 1 0 Aug20 ? 00:00:00 ora_arc1_stone
oracle 7806 1 0 Aug20 ? 00:00:00 ora_qmnc_stone
oracle 7814 1 0 Aug20 ? 00:00:00 ora_q000_stone
oracle 7816 1 0 Aug20 ? 00:00:00 ora_q001_stone
oracle 7820 1 0 Aug20 ? 00:00:00 ora_s000_stone
oracle 7822 1 0 Aug20 ? 00:00:00 ora_s001_stone
oracle 9860 1 0 08:18 ? 00:00:00 ora_s002_stone
oracle 9876 9849 0 08:20 pts/2 00:00:00 /bin/bash -c ps -ef | grep ora_
oracle 9878 9876 0 08:20 pts/2 00:00:00 grep ora_
- 共享服务器进程对应得服务器进程是ora_s???_SID 吗?
- Oracle的共享服务器进程
- 使用和配置共享服务器连接进程
- Oracle进程--服务器进程
- 进程与多进程服务器
- 检查服务器的pid文件,如果文件不存在或pid对应的进程已死重启服务器
- 监视服务器进程
- 监视服务器进程
- inetd启动服务器进程
- xinetd超级服务器进程
- 如何终结服务器进程
- 进程 服务器编程入门
- 服务器 进程实现
- 进程实现tcp服务器
- 多进程并发服务器
- 多进程服务器
- 多进程、多线程服务器
- 并发服务器---多进程
- 标准C++异常处理
- 完整项目所需基础技术及框架
- emacs配置--包括gdb像vs2003一样多个可拉伸窗口和快捷键
- 让C#程序run anywhere脱离.net Framework框架环境运行
- 用C的?:来实现折半查找
- 共享服务器进程对应得服务器进程是ora_s???_SID 吗?
- 换一种态度看程序员(转)
- Ajax原理
- yum 备忘
- 支付宝Payto接口的c#.net实现
- google groups 新的地址
- soso hoho!
- 拨打电话 挂断电话 发送短信 发送Email Email发送附件 设置约会
- FlowLayoutPanel控件学习