[Error] ORA-00020: maximum number of processes (500) exceeded

ORA-00020: maximum number of processes (500) 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.

 

 

1. 프로세스 수 증가

ALTER SYSTEM SET processes = 1000 SCOPE=SPFILE;

 

2. 현재 세션 kill

select 'alter system kill session ' || ''''|| sid || '' ||  ',' || ''|| serial# || '''' ||';'  from v$session;

-- 특정 sid만 삭제 할 경우

select 'ALTER SYSTEM KILL SESSION'''||SID||','||SERIAL#||''';'
from v$session
where sid='&1';