中文异常提示为：ORA-00020 超出最大进程数(s%)
英文异常提示为：ORA-00020 maximum number of processes num exceeded
出现该异常的时候，可按如下步骤检查数据库：
（1）首先检查进程设置，看看是否由于允许进程数设置过低造成：
SQL> show parameter process;
NAME TYPE VALUE
———————————— ———– ——————————
aq_tm_processes integer 0
db_writer_processes integer 4
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 3000
（2）如果进程数足够，那么很可能是应用未释放连接造成：
select * from v$session
检查未释放的连接，将其结束掉。
===============================
Cause:
An operation requested a resource that was unavailable. The maximum number of processes is specified by the initialization parameter PROCESSES. When this maximum is reached, no more requests are processed.
Action:
Try the operation again in a few minutes. If this message occurs often, shut down Oracle, increase the PROCESSES parameter in the initialization parameter file, and restart Oracle.
Sorry, the comment form is closed at this time.
No comments yet.