一.官网说明
1.1 processes
11gR2 的文档:
Property | Description |
Parameter type | Integer |
Default value | 100 |
Modifiable | No |
Range of values | 6 to operating system dependent |
Basic | Yes |
Oracle RAC | Multiple instances can have different values. |
PROCESSESspecifies the maximum numberof operating system user processes that can simultaneously connect to Oracle.Its value should allow for all background processes such as locks, job queueprocesses, and parallel execution processes.
The defaultvalues of theSESSIONSandTRANSACTIONSparameters arederived from this parameter. Therefore, if you change the valueofPROCESSES, you should evaluate whether to adjust the values of thosederived parameters.
http://download.oracle.com/docs/cd/E11882_01/server.112/e25513/initparams198.htm#REFRN10175
1.2 sessions
11gR1:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28320/initparams220.htm#REFRN10197
Property | Description |
Parameter type | Integer |
Default value | Derived: (1.1 *PROCESSES ) + 5 |
Modifiable | No |
Range of values | 1 to 231 |
Basic | Yes |
11gR2
Property | Description |
Parameter type | Integer |
Default value | Derived: (1.5 *PROCESSES) + 22 |
Modifiable | No |
Range of values | 1 to 231 |
Basic | Yes |
这里要注意的是到了11gR2里,sessions 的默认值计算方式变了。 该值的计算是针对 dedicate 模式的。
SESSIONSspecifies the maximum number of sessions that can becreated in the system. Because every login requires a session, this parametereffectively determines the maximum number of concurrent users in the system.You should always set this parameter explicitly to a value equivalent to yourestimate of the maximum number of concurrent users, plus the number ofbackground processes, plus approximately 10% for recursive sessions.
Oracle uses thedefault value of this parameter as its minimum. Values between 1 and thedefault do not trigger errors, but Oracle ignores them and uses the defaultinstead.
The defaultvalues of theENQUEUE_RESOURCESandTRANSACTIONSparametersare derived fromSESSIONS. Therefore, if you increase the valueofSESSIONS, you should consider whether to adjust the valuesofENQUEUE_RESOURCESandTRANSACTIONSas well. (NotethatENQUEUE_RESOURCESis obsolete as of Oracle Database 10g release2 (10.2).)
In a shared server environment, the value ofPROCESSEScanbe quite small. Therefore, Oracle recommends that youadjust the value ofSESSIONSto approximately 1.1 * total numberofconnections.
1.3 transactions
11gR2
http://download.oracle.com/docs/cd/E11882_01/server.112/e25513/initparams258.htm#REFRN10222
Property | Description |
Parameter type | Integer |
Default value | Derived: (1.1 *SESSIONS) |
Modifiable | No |
Range of values | 4 to 232 |
Oracle RAC | Multiple instances can have different values. |
TRANSACTIONSspecifieshow many rollback segments to onlinewhenUNDO_MANAGEMENT=MANUAL. The maximum number of concurrenttransactions is now restricted by undo tablespace size(UNDO_MANAGEMENT=AUTO) or the number of online rollback segments(UNDO_MANAGEMENT=MANUAL).
二. 测试
2.1 测试DB版本
SQL> select * from v$version;
BANNER
-----------------------------------------------------------------------
Oracle Database 11g Enterprise EditionRelease 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE11.2.0.1.0 Production
TNS for 32-bit Windows: Version 11.2.0.1.0- Production
NLSRTL Version 11.2.0.1.0 - Production
SQL> show parameter processes
NAME TYPE VALUE
----------------------------------------------- -----------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 1000
log_archive_max_processes integer 4
processes integer 150
SQL> show parameter sessions
NAME TYPE VALUE
----------------------------------------------- -----------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
sessions integer 248
shared_server_sessions integer
按照11gR2的中的计算方法:SESSIONS=(1.5*PROCESSES) + 22
SESSIONS=1.5*150+22=247
SQL> show parameter transaction
NAME TYPE VALUE
----------------------------------------------- -------
transactions integer272
transactions_per_rollback_segment integer5
根据公式:transaction= (1.1 *SESSIONS)
1.1*248==272.8
2.2 只增加processes到1000,观察sessions 和 transactions 参数
SQL> create pfile from spfile;
File created.
然后修改init 文件,将processes 修改成1000。
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> create spfile frompfile='D:\app\Administrator\product\11.2.0\dbhome_1\database\INITnewccs.ORA';
File created.
SQL> startup
ORACLE instance started.
Total System Global Area 1071333376 bytes
Fixed Size 1375792 bytes
Variable Size 595591632 bytes
Database Buffers 469762048 bytes
Redo Buffers 4603904 bytes
Database mounted.
Database opened.
SQL> show parameter processes
NAME TYPE VALUE
----------------------------------------------- ------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 1000
log_archive_max_processes integer 4
processes integer 1000
SQL> show parameter sessions
NAME TYPE VALUE
----------------------------------------------- ------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
sessions integer 1522
shared_server_sessions integer
SQL> show parameter transaction
NAME TYPE VALUE
----------------------------------------------- ------------------
transactions integer 1674
transactions_per_rollback_segment integer5
SQL>
当我们修改processes 之后,如果sessions 和transactions 小于由公式计算出来的值,就会自动进行修改。为了验证这个观点,我们在做一个测试,修改processes 值,同时修改sessions和transactions的值,使其大于公式计算出来的值。
2.3 同时修改processes,sessions和transactions 值
Processes 设为500
根据公式:sessions=1.5*500+22=772
Transactions=1.1*sessions=850
我们将sessions 设置为900,transactions 设置为1000
*.processes=500
*.sessions=900
*.transactions=1000
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> create spfile frompfile='D:\app\Administrator\product\11.2.0\dbhome_1\database\INITnewccs.ORA';
File created.
SQL> startup
ORACLE instance started.
Total System Global Area 1071333376 bytes
Fixed Size 1375792 bytes
Variable Size 595591632 bytes
Database Buffers 469762048 bytes
Redo Buffers 4603904 bytes
Database mounted.
Database opened.
SQL>
SQL>show parameter processes
NAME TYPE VALUE
----------------------------------------------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 1000
log_archive_max_processes integer 4
processes integer 500
SQL> show parameter sessions
NAME TYPE VALUE
----------------------------------------------- ------------------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
sessions integer 900
shared_server_sessions integer
SQL> show parameter transactions
NAME TYPE VALUE
----------------------------------------------- ------------------------------
transactions integer 1000
transactions_per_rollback_segment integer5
SQL>
-------------------------------------------------------------------------------------------------------
版权所有. 文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.
Blog: http://blog.csdn.net/tianlesoftware
Weibo: http://weibo.com/tianlesoftware
Email: tianlesoftware@gmail.com
DBA1 群:62697716(满); DBA2 群:62697977(满)DBA3 群:62697850(满)
DBA 超级群:63306533(满); DBA4 群:83829929(满) DBA5群: 142216823(满)
DBA6 群:158654907(满) DBA7 群:69087192(满)DBA8 群:172855474
DBA 超级群2:151508914 DBA9群:102954821 聊天 群:40132017(满)
--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请
分享到:
相关推荐
BLOG_Oracle_lhr_【sessions】Oracle中sessions和processes的大小关系(10g和11g不同).pdf
查看processes和sessions参数 第一步,在cmd命令行,输入sqlplus 第二步,根据提示输入用户名与密码
Oracle9i初始化参数中文说明 Blank_trimming: 说明: 如果值为TRUE, 即使源长度比目标长度 (SQL92 兼容) 更长, 也允许分配数据。 值范围: TRUE | FALSE 默认值: FALSE serializable: 说明: 确定查询是否获取表级...
如果文件中有两个相同的参数名则以最后出现的为准,以下例子说明了这个问题。 如有一个spfile文件(myspfile.ora),包括两个参数: sessions=150 processes=200 另外有一个pfile文件(mypfile.ora),里面包括三个参数,...
hibernate_org - Sessions and transactions
如果设置为 N 表示不通过 dbstart 和 dbshut 启动和关闭实例数据库 CAMS 系统要求在 安装完 ORACLE 后要求将该参数修改为 Y 以保证 ORACLE 数据库自启动 和关闭 1.2.3 数据库实例初始化...
第一步,在cmd命令行,... 查看processes和sessions参数 SQL> show parameter processes NAME TYPE VALUE db_writer_processes integer 1 gcs_server_processes integer 0 job_queue_processes integ
§7.1 应用系统环境规划和Oracle系统安装考虑 91 §7.1.1 操作系统安装考虑 91 §7.1.2 Oracle系统安装考虑 92 §7.2 关于创建多个Oracle实例问题 93 §7.3 Oracle系统安装后的优化基础工作 94 §7.3.1 Oracle系统...
目录 1 前言 7 1.1 编写目的 7 1.2 预期读者 8 2 数据库部署模式及选择建议 8 2.1 数据库部署模式 8 2.2 单机模式 8 2.3 HA热备模式 9 2.4 RAC模式 10 ...8.1 Oracle参数说明 57 8.2 合规性检查 58
******** active sessions count ************** ssion count" from v$session where status='ACTIVE ******** total sessions count *************** sion count" from v$session; ******** top 30 big objects ...
一、ORACLE的启动和关闭 1、在单机环境下 要想启动或关闭ORACLE系统必须首先切换到ORACLE用户,如下 su - oracle a、启动ORACLE系统 oracle>svrmgrl SVRMGR>connect internal SVRMGR>startup SVRMGR>quit b、关闭...
SQL Monitor for Oracle,MySQL and DB2 是款免费的数据库跟踪工具,专门用来分析CPU使用率高的问题。 软件功能: 1. 监控SQL Server的进程和Job,查看当前执行的SQL/命令,并终止之。 2. 对象浏览器,跟 SQL Server...
virtual-art-sessions, "Virtual Art Sessions" Chrome 实验的源 虚拟艺术课程这个库镜像了活动的虚拟艺术会话站点( 代码 NAME 项目 Udon ),并已经打开了Apache许可 2.0,让任何感兴趣的人都可以发现它,看看它是...
4 常用参数说明 3 4.1 BUFFER_POOL_KEEP 4 4.2 CPU_COUNT 4 4.3 DB_BLOCK_BUFFERS 4 4.4 DB_BLOCK_SIZE 5 4.5 DB_FILE_MULTIBLOCK_READ_COUNT 5 4.6 GLOBAL_NAMES 5 4.7 INSTANCE_NAME 5 4.8 LICENSE_MAX_SESSIONS 5...
基于 Silverlight +ASP.Net实现的Sessions参数访问程序例子代码。
超出最大会话数和Ora-00020超出最大进程数错误的解决方法 Ora-00018 Maximum number of sessions exceeded超出最大会话数
Based on OOW sessions• Based on OOW demogrounds• Based on MLC• Nothing is guaranteed to be included in Oracle 12c production• RMAN - Recovery manager• Application continuity• Data Guard –...
# Usage Instructions # ~~~~~~~~~~~~~~~~~~ # Usage: [n]awk -f ass.awk fname.trc (But read ...# seqinfo...............1 = Output sequence number for WAITING processes # 0 = Do not dump seq# information.
在Web Services中管理Sessions 在Web service中通常采用两种公认技术来管理session,一种是借助HTTP和HTTP cookies,另一种是用SOAP headers。Axis能帮你实现这两种技术。
Sessions 用于http服务器的简单,高性能,高度可定制的用户会话