1、锁表查询
select t2.username,
t2.sid,
t2.serial#,
t3.object_name,
t2.OSUSER,
t2.MACHINE,
t2.PROGRAM,
t2.LOGON_TIME,
t2.COMMAND
from v$locked_object t1, v$session t2, dba_objects t3
where t1.session_id = t2.sid
--AND t3.OBJECT_NAME='XXXXX' (查询指定表是否被锁)
and t1.object_id = t3.object_id;
2、释放被锁表,kill session
alter system kill session 'sid,serial#'; --该表对应sid与serial#
3、提示session已被kill,但表仍然被锁
alter system kill session 'sid,serial#' IMMEDIATE ;