查看最大进程数
SQL > show parameter processes;
NAME TYPE VALUE
aq_tm_processes integer 1
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 > select count ( * ) from v$session ;
COUNT ( * )
22
查看活动连接数/迸发数
SQL > Select count ( * ) from v$session where status = 'ACTIVE' ;
COUNT ( * )
20
修改最大进程数
SQL > alter system set processes = 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 9787547648 bytes
Fixed Size 2261568 bytes
Variable Size 1677725120 bytes
Database Buffers 8086618112 bytes
Redo Buffers 20942848 bytes
Database mounted.
Database opened.
SQL > show parameter processes;
NAME TYPE VALUE
aq_tm_processes integer 1
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 300
SQL >