oracle查询是否锁表和杀掉死锁的语句

1.oracle查询是否锁表
SELECT C.SID         AS SID,
       C.SERIAL#     AS SERIAL,
       D.NAME,
       B.OBJECT_NAME,
       C.USERNAME,
       C.PROGRAM,
       C.OSUSER
  FROM GV$LOCKED_OBJECT A, ALL_OBJECTS B, GV$SESSION C, AUDIT_ACTIONS D
 WHERE A.OBJECT_ID = B.OBJECT_ID
   AND A.INST_ID = C.INST_ID(+)
   AND A.SESSION_ID = C.SID(+)
   AND C.COMMAND = D.ACTION
  ---AND B.OBJECT_NAME =

 

 2.杀掉死锁

其中SID和SERIAL为上面语句，查询的结果中包含
   alter system kill session 'SID,SERIAL'；