Kill locked session


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



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.