oracle对象解锁操作

oracle对象解锁操作

查询被锁定对象

select * from v$locked_object;

www.2cto.com

查询被锁的表

select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object_id = a.object_id;

查询引起锁定session：

select b.username,b.sid,b.serial#,logon_time from v$locked_object a,v$session b where a.session_id = b.sid order by b.logon_time;

杀掉对应进程：

alter system kill session'1025,41';其中1025为sid,41为serial#.

另外：查询锁类型

select sid,type,id1,id2,decode(lmode,0,'None',1,'Null',2,'Row share',3,'Row Exclusive',4,'Share',5,'Share Row Exclusive',6,'Exclusive')

lock_type,request,ctime,block from v$lock where TYPE IN('TX','TM');