select * from V$session;select * from v$LOCK;
select sid, serial# from V$sessionwhere sid in (select sid from v$LOCK where sid in ('5','12','14','16','67','71','72','73','76','77','78','132','136','137','141','144','146','194','196','197','204'));alter system kill session 'sid, serial#';
转载于:https://www.cnblogs.com/jimmyLei/p/9186406.html
