Oracle Database Discussions

Hi

We have user profiles defined in which IDLE_TIME is set at 45mins
At the same time SESSIONS_PER_USER is set to 1

If any user session remains idle for beyond 45 mins the session status changes to 'SNIPED'.
At this point when the user tries to open a new session, they cannot do so and get the message
'Max sessions per user limit exceeded'

AT this point, we go in to kill the session manually by using:
ALTER SYSTEM KILL SESSION 'sid,serial#';

This changes the session for the user to 'KILLED', but the user still cannot log-on.
We cannot increase the SESSIONS_PER_USER limit, so what would be the way around it?

Is cleaning at unix level the only alternative? Please advice

Regards
Gurvinder
rekhi@essex.edu