查看被锁的表:
select p.spid,c.object_name,b.session_id,b.oracle_username,b.os_user_name from v$process p,v$session a, v$locked_object b,all_objects c where p.addr=a.paddr and a.process=b.process and c.object_id=b.object_id
解锁:
alter system kill session '146';(其中146为锁住的进程号)
select t.object_id,t.OBJECT_ID,t2.SID,t2.SERIAL# from v$locked_object t,v$session t2
where t2.OSUSER='xiong_xyu' and t.SESSION_ID=t2.SID;
select * from dba_objects t where t.object_id='163794';
select object_name as 对象名称, s.sid, s.serial#, p.spid as 系统进程号
from v$locked_object l, dba_objects o, v$session s, v$process p
where l.object_id = o.object_id
and l.session_id = s.sid
and s.paddr = p.addr;
alter system kill session '141,18683';