Hi Gentlemen,
Currently I have a profile set up for the user our application server logs iin as - it has an idle time of 3 minutes.

Quite often we are getting the message - maximum number of processes reached. So When I run the following:

from v$process
where pid not in (
select sid
from v$session)

I get about 100 rows - which would explain the drain on the number of processes available for session logins.

Now what I was wondering if it is possible to decrease the interval between process cleanups and if so how.

Thank you in advance for any help,