clearing SNIPED status sessions
922028Apr 23 2012 — edited Apr 23 2012when profile idle time is exceded, session status will change to "SNIPED", even for "SNIPED" status session, system will consume the session space, In our system there is a limited number of sessions available,
in our system, once the session status changes to sniped then after 2 hours then it will be cleared from V$SESION, as per my understanding, this will be controled by DBA Parameter,
Could any one advice me, whats the parameter.
( OR )
Is there is a way to clean up the sniped sessions so that new users can be allowed to login without
hitting the max. number of sessions problem?
Thank you.