[Oracle] 如何找出鎖住表格之session 並剔除(kill session)

SQL>

select sid,serial# from v$session where sid in (select sid  from v$lock where id1 = (select object_id  from user_objects where
object_name = upper('TABLE_NAME')));
 

    SID    SERIAL#
---------- ----------
       783         13

 

SQL> alter system kill session '783,13';