ORA-00020: No more process state objects available故障一例(二)

2015-07-16 12:08:39 · 作者: · 浏览: 3
th error = 20
?Thu May 14 15:59:30 2015
?ORA-00020: maximum number of processes (40) exceeded
? ORA-20 errors will not be written to the alert log for
? the next minute. Please look at trace files to see all
? the ORA-20 errors.
?Process m000 submission failed with error = 20
?Process m001 submission failed with error = 20
?Thu May 14 16:00:30 2015
?Process m000 submission failed with error = 20
?Thu May 14 16:01:30 2015
?ORA-00020: maximum number of processes (40) exceeded
? ORA-20 errors will not be written to the alert log for
? the next minute. Please look at trace files to see all
? the ORA-20 errors.
?Process m000 submission failed with error = 20
?Thu May 14 16:03:31 2015
?ORA-00020: maximum number of processes (40) exceeded
? ORA-20 errors will not be written to the alert log for
? the next minute. Please look at trace files to see all
? the ORA-20 errors.
?Process m000 submission failed with error = 20
?Thu May 14 16:04:31 2015
?Process m000 submission failed with error = 20
例子中我们可以清楚地了解到是因为数据库在实际运行中出现了processes进程总数达到参数设定上限从而导致问题出现,那么可以合理增加初始化参数processes或者通过修正异常频繁的程序客户端登录来解决该问题。