SESSIONS, PROCESSES, TRANSACTIONS
1. SESSIONS, PROCESSES, TRANSACTIONS
SESSIONS
Default value : (1.5 * PROCESSES) + 22 (ORACLE 11G) / (1.1 * PROCESSES) + 5 (ORACLE 10G)
Range of values: 1 to 231
http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams231.htm#REFRN10197
PROCESSES
Default value: 100
Range of values: 6 to operating system dependent
http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams199.htm#REFRN10175
TRANSACTIONS
Default value:1.1* SEESSIONS
Range of values: 4 to 232
http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams259.htm
transactions=1.1*sessions(defalt)
sessions=1.5*processes+22(default)
2.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26764973/viewspace-750485/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- mysql 5.7 新特性中在线in-place 修改字段的大小
- ORACLE 11G 静默安装soft db listener
- vsphere 虚拟机在线添加磁盘linux
- linux 缩减LV大小
- ORA-600:[kcbzwfcro_2] Reported in Alert.log (文档 ID 2085507.1)
- WRH$_ACTIVE_SESSION_HISTORY
- 索引重建的必要性与影响 (Doc ID 1525787.1)
- ORACLE 11g R2 RAC 11.2.0.2.12 PSU 安装升级
- List of Oracle Database Patch Set Updates (PSU)
- ORA-00245: control file backup operation failed
