transactions integer 1674
transactions_per_rollback_segment integer 5
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 integer 5
SQL>
-------------------------------------------------------------------------------------------------------
Weibo: http://weibo.com/tianlesoftware
Email: tianlesoftware@gmail.com