This content has been marked as final. Show 3 replies
A - Contact the DBA and ask them to kill the blocking session
B - Contact the System Administrator and ask them to kill the Oracle session background process at the OS level
For A you can get all the information you need from v$session, For B I would join v$session to v$process.
HTH -- Mark D Powell --
i am not a DBA. so i could not able to kill the session as the session is hanged. please tell me how to kill an user session.I wonder how you decide session is hanged or not if you are not dba? For your issue please contact wiht your dba and request info about session from him
Also see below which is mention how you can kill session(You can try Man kill command to see options)
i am not a DBA. so i could not able to kill the session as the session is hanged. please tell me how to kill an user session.Hi,
Do you know which user session you have to kill?
Do you have permission to kill the session? - Normally these permissions will have by an DBA.
Why you want to kill the session? Causing any block/lock?
You have to get sid & serial of that perticular session and then kill that particular session.
Check sample link