查看当前最大连接数:
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>
修改最大连接数
SQL> alter system set processes=500 scope = spfile;
System altered.
重启数据库使修改生效:
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 4275781632 bytes
Fixed Size 2233336 bytes
Variable Size 3254782984 bytes
Database Buffers 1006632960 bytes
Redo Buffers 12132352 bytes
Database mounted.
Database opened.