Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

clearing SNIPED status sessions

922028Apr 23 2012 — edited Apr 23 2012
when 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 21 2012
Added on Apr 23 2012
1 comment
2,563 views