Processes, sessions and open_cursors
来源:互联网 发布:太空地图软件 编辑:程序博客网 时间:2024/03/28 21:42
Processes, sessions and open_cursors
Hi,
when you got this error always check trace file. In my trace file was this error:
ORA-00020: maximum number of processes (2000) exceeded
So what does mean?
1) This error is related to parameter processes.
SQL> show parameter processes
NAME TYPE VALUE
————————————
processes integer 2000
–> It it max value
current value:
select count(*) from v$process;
COUNT(*)
———-
1122
==> It is ok now. Parameter processes set max value for operating system processes
Parameter Sessions set max. value for session in oracle and should be calculate from parameter processes.
Session=(processes * 1.1 ) +5
In our case (2000 * 1.1) +5 = 2205
SQL> show parameter sessions
NAME TYPE VALUE
———————————— ———– ——————————
sessions integer 2205
–> current number of sessions
select count(*) from v$session;
COUNT(*)
———-
1122
==> we are under limit and this is ok.
Other parameter could be open_cursors. This parameter set max. number of open cursors per one session.
SQL>show parameter cursors
NAME TYPE VALUE
———————————— ———– ——————————
open_cursors integer 500
–> This mean that each session could have 500 open cursor. Together it is 2205 * 500 = 1102500 cursors.
Now we have open
SQL>select count(*) from v$open_cursor;
COUNT(*)
———-
18319
What value set to parameter open_cursors?
We can calculate 18319 / 2205 = 8.3
–> we can set it to 50 which is default value
- Processes, sessions and open_cursors
- open_cursors、sessions、processes
- Oracle open_cursors、sessions、processes的理解与监控
- Creating Processes: Sessions and Integrity Levels
- threads, processes, process groups and sessions
- DIFFERENCES BETWEEN PROCESSES, SESSIONS AND CONNECTIONS", version 8.1.7.4
- Oracle数据库中Sessions and Processes的概念总结
- Oracle sessions & processes关系
- oracle修改processes与sessions
- Oracle 修改sessions和processes
- processes与sessions参数的学习
- 关于processes和sessions参数的说明
- processes与sessions参数的学习
- ORACLE修改processes和sessions参数
- Processes and Threads Sample
- Processes and Threads
- informatica - Architecture and Processes
- Processes and Threads
- ccs中一些常用的名词
- 图解VS2010下实现C#,VB,C++之间的跨语言支持
- VC中类与对应头文件
- AT收发短信命令
- 收集oracle统计信息
- Processes, sessions and open_cursors
- c标准库源代码之 memcpy/memcmp/memset
- 将数据源DataSet导出成Excel表格形式
- 针对第二层到第四层的攻击
- 利用开源ide(Code::Blocks)在windows中调试ffmpeg
- TD数据库常用表以及字段的介绍
- Android程序构成
- 修改表字段的精度大小
- SVN 客户端TortoiseSVN