Kill locked session

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