问题描述
- 查询数据库连接数设置:
SQL> show parameter processes
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 6
gcs_server_processes integer 0
job_queue_processes integer 0
log_archive_max_processes integer 2
processes integer 150
- 查询当前连接数
SQL> select count(*) from v$process;
COUNT(*)
----------
147
问题解决
SQL> alter system set processes=1000 scope=spfile;
SQL> alter system set sessions=1580 scope=spfile;