• 查找锁表语句
• 查找锁存储过程

查找锁表语句

--查询表是否被锁
SELECT distinct
    object_name,
    machine,
    s.sid,
    s.serial#,
    'alter system kill session ''' || s.sid || ',' || s.serial# ||''';' AS kill_session
FROM gv$locked_object l, dba_objects o, gv$session s
WHERE l.object_id　 = o.object_id
AND l.session_id = s.sid
-- AND object_name IN('BRANCH_INFO','POLICY','POLICY_PRINT_TASK','POLICY_PRINT_INFO');

查找锁存储过程

--存储过程被锁
select a.sid,
    a.serial#,
    a.MACHINE,
    a.status,
    a.paddr,
    'alter system kill session ''' || a.sid || ',' || a.serial# ||''';' AS kill_session,
    b.OBJECT
FROM v$session a, v$access b
WHERE a.sid = b.sid
-- AND b.OBJECT LIKE '%L_UW_%';