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';
