oracle对象解锁操作

查询被锁定对象select * from v$locked_object;
查询被锁的表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');