Oracle 数据库死锁查询

SELECT L.SESSION_ID      SID,
       S.SERIAL#,
       L.LOCKED_MODE     锁模式,
       L.ORACLE_USERNAME 登录用户,
       L.OS_USER_NAME    登录机器用户名,
       S.MACHINE         机器名,
       S.TERMINAL        终端用户名,
       O.OBJECT_NAME     被锁对象名,
       S.LOGON_TIME      登录数据库时间,
       'alter system kill session '''||L.SESSION_ID||','||S.SERIAL#||'''; '
  FROM V$LOCKED_OBJECT L, ALL_OBJECTS O, V$SESSION S
 WHERE L.OBJECT_ID = O.OBJECT_ID
   AND L.SESSION_ID = S.SID