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 integer 272
transactions_per_rollback_segment integer 5
根据公式：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
-------------------