oracle 查询 解锁表

select sess.SID,
sess.SERIAL#,
lo.ORACLE_USERNAME,
lo.OS_USER_NAME,
ao.OBJECT_NAME,
lo.LOCKED_MODE
from v$locked_object lo,
dba_objects ao,
v$session sess
where
ao.OBJECT_ID=lo.OBJECT_ID
and lo.SESSION_ID=sess.SID

--command 窗口

alter system kill session 'SID,SERIAL#'; 
alter system kill session '603,1753';