Database Administration (MOSC)

MOSC Banner

Allowing end users to kill their own session

edited Aug 20, 2009 4:46PM in Database Administration (MOSC) 2 commentsAnswered
I've seen a few ideas around how to do this while looking around on google, mostly involving using a PL/SQL wrapper but wanted to get the input from you guys on here too. What's the most efficient way to allow end users on a RAC cluster (particularly 11g) to kill their own session?

I know in 11g the 'alter system kill session' has changed to allow you to now specify the node in where the session resides, which is quite handy for a DBA, but still doesn't help the end user (Developer) trying to kill his/her own session. It would be nice if this is added as a feature some day but in the interim, are there any best practices or most optimal solution? I would think this would be a pretty common request for end users.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center