一个session是一个逻辑实体存在你的数据库实例里,一个session可以标识你在实例里执行的SQL,内存分集合等信息。
而一个process 是在数据库处理session的进程。
在oracle 10g 下 sessions=(1.1*process)+5 这里的5和1.1 是因为oracle启动的要创建dbwr,lgwr,ckpt等这些进程。
默认安装session默认170 process默认150 170=1.1*150+5
这里要注意的是sessions是配置当前process当前最小直,
如果设置session 如果设置session>=(1.1*process)+5 那么数据库启动的时候会保留当前sessions值。
默认情况:
C:\Users\Administrator>sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jan 8 09:44:05 2014
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> conn / as sysdba
Connected.
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
logmnr_max_persistent_sessions integer 1
sessions integer 170
shared_server_sessions integer
SQL> show parameter process
NAME TYPE VALUE
------------------------------------ ----------- ----------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 150
当设置随意设置process时,session会自动更新。
SQL> alter system set processes=160 scope=spfile;
System altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size 2066080 bytes
Variable Size 385878368 bytes
Database Buffers 1207959552 bytes
Redo Buffers 14708736 bytes
Database mounted.
Database opened.
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
logmnr_max_persistent_sessions integer 1
sessions integer 181
shared_server_sessions integer
181=1.1*160+5
如果session< (1.1*process)+5
SQL> alter system set sessions=100 scope=spfile;
System altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size 2066080 bytes
Variable Size 385878368 bytes
Database Buffers 1207959552 bytes
Redo Buffers 14708736 bytes
Database mounted.
Database opened.
SQL> show parameter sessions
NAME TYPE VALU
------------------------------------ ----------- ----
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
logmnr_max_persistent_sessions integer 1
sessions integer 181
shared_server_sessions integer
SQL> show parameter process
NAME TYPE VALU
------------------------------------ ----------- ----
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 160
重启后 会自动恢复到最小值((1.1*process)+5)
设置sessions>=(1.1*process)+5时
SQL> alter system set sessions=300 scope =spfile;
System altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size 2066080 bytes
Variable Size 385878368 bytes
Database Buffers 1207959552 bytes
Redo Buffers 14708736 bytes
Database mounted.
Database opened.
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
logmnr_max_persistent_sessions integer 1
sessions integer 300
shared_server_sessions integer
SQL> show parameter process
NAME TYPE VALU
------------------------------------ ----------- ----
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 160
300>1.1*160+5 保留
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26575510/viewspace-1068219/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26575510/viewspace-1068219/