Posted By

tenkyu on 05/14/09


Tagged

session Oracle kill locked


Versions (?)

Kill locked session


 / Published in: PL/SQL
 

  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  

You need to login to post a comment.