中文异常提示为: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.