SQL>conn / as sysdba
检测processes的数量为150.
SQL> show parameter processes;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
db_writer_processes integer 1
job_queue_processes integer 10
log_archive_max_processes integer 1
processes integer 150
修改连接数到spfile
SQL> alter system set processes=300 scope = spfile;
重启库。
shutdown immediate;
startup;
再次检查一下是否更改
SQL> show parameter processes;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
db_writer_processes integer 1
job_queue_processes integer 10
log_archive_max_processes integer 1
processes integer 150
重启数据库,OK!