Advanced Search

Return to Snippet

Revision: 13947
at May 14, 2009 06:38 by tenkyu
Initial Code 
SELECT 'ALTER SYSTEM KILL SESSION ''' || SID || ',' || SERIAL# || ''';' KILL_SQL
     , MACHINE
     , ORACLE_USERNAME
     , OS_USER_NAME
     , LOCKED_MODE
     , OBJECT_NAME
     , OBJECT_TYPE
  FROM V$LOCKED_OBJECT A
     , DBA_OBJECTS B
     , V$SESSION C
 WHERE A.OBJECT_ID = B.OBJECT_ID
   AND A.SESSION_ID = C.SID
Initial URL 









Initial Description














Initial Title





Kill locked session









Initial Tags





Oracle









Initial Language





PL/SQL