Q:查看锁表进程，及杀死所有锁表进程sql

SELECT DISTINCT decode(s.inst_id, 1, 'DB1', 2, 'DB2') 数据库服务器,
                decode(s.BLOCKING_SESSION,
                       '',
                       S.USERNAME,
                       '--' || s.USERNAME) 登陆用户名,
                O.OWNER || '.' || O.OBJECT_NAME 锁的对象,
                S.SID,
                decode(S.BLOCKING_SESSION,
                       '',
                       '根锁为此会话',
                       '根锁会话：' || S.BLOCKING_SESSION) 阻塞SID,
                S.BLOCKING_SESSION_STATUS STATUS,
                (CASE
                  WHEN SQL_TEXT IS NULL THEN
                   '(SID:' || S.SID || ')会话 SQL已跑完'
                  ELSE
                   '(SID:' || S.SID || ')会话 正执行SQL：' || SQL_.SQL_TEXT
                END) SQL_TEXT,
                s.CLIENT_INFO,
                LO.REQUEST,
                S.STATE,
                S.EVENT,
                S.MACHINE,
                S.LOGON_TIME,
                S.INST_ID,
                S.BLOCKING_SESSION,
     
                       'ALTER SYSTEM KILL SESSION ''' || S.SID || ',' ||
                       S.SERIAL# || ''';',
                       '' KILL
  FROM GV$SESSION S
  LEFT JOIN GV$SQL SQL_
    ON SQL_.SQL_ID = S.SQL_ID
   AND SQL_.INST_ID = S.INST_ID
  JOIN GV$LOCKED_OBJECT L
    ON L.SESSION_ID = S.SID
   AND L.INST_ID = S.INST_ID
  JOIN ALL_OBJECTS O
    ON L.OBJECT_ID = O.OBJECT_ID
  JOIN GV$LOCK LO
    ON (LO.BLOCK != 0 OR LO.REQUEST != 0)
WHERE LO.SID = L.SESSION_ID
   AND LO.SID = S.SID
   AND LO.INST_ID = L.INST_ID
   AND LO.INST_ID = S.INST_ID
ORDER BY s.inst_id, S.BLOCKING_SESSION, s.SID DESC;