Oracle ORA-00020 : Maximum Number of Processes(XXX) Exceeded.

Hi,

When connecting to oracle sometimes, user may face this error:

Maximum Number of Processes(XXX) Exceeded.

The reason is the process in the server are in use.

Solution:

<![if !supportLists]>1.    <![endif]>Is to increase the value of Processes in initialization parameter.

Or

<![if !supportLists]>2.    <![endif]>Kill the long time ideal session to free the processes. From oracle and in unix if needed

--List of processes not connected to sessions (Oracle8i):

***********************************************

select 'kill -9 '|| SPID || ';'  from v$process where program!= 'PSEUDO'and addr not in (select paddr from v$session)and addr not in (select paddr from v$bgprocess)and addr not in (select paddr from v$shared_server);

Thanks & Regards

Fauzi