Advanced Search

Kill locked session

/ Published in: PL/SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SELECT 'ALTER SYSTEM KILL SESSION ''' || SID || ',' || SERIAL# || ''';' KILL_SQL
  2.      , MACHINE
  3.      , ORACLE_USERNAME
  4.      , OS_USER_NAME
  5.      , LOCKED_MODE
  6.      , OBJECT_NAME
  7.      , OBJECT_TYPE
  8.   FROM V$LOCKED_OBJECT A
  9.      , DBA_OBJECTS B
  10.      , V$SESSION C
  11.  WHERE A.OBJECT_ID = B.OBJECT_ID
  12.    AND A.SESSION_ID = C.SID

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.