2020-01-07-Oracle 数据库中，表的锁死查询与解锁

https://blog.csdn.net/lsh15846393847/article/details/79562816

SELECT
    sid,
    serial#,
    machine,
    program 
FROM
    v$session 
WHERE
    sid IN ( SELECT o.SESSION_ID FROM v$locked_object o, ALL_OBJECTS a WHERE a.OBJECT_ID = o.object_id AND a.object_name = '表名' )
    
    
    alter system kill session '26,16673'; -- sid  serial#