关于oracle数据库解锁修改等操作

查看数据库锁：
select s.sid,s.serial#,osuser,username,machine,a.object_name,decode(locked_mode,0,'None',1,'Null',2,'Row share',
  3,'Row Exclusive',4,'Share',5,'Share Row Exclusive',6,'Exclusive') lock_type
from v$session s,v$locked_object l,all_objects a
where s.sid=l.session_id
and l.object_id=a.object_id

接触锁操作：
alter system kill session 'SID,SERIAK#';