Oracle死锁解锁

  select db.object_name,sess.sid,sess.serial#,sess.module,sess.action  , 
'alter system kill session '''|| sess.sid ||','||sess.serial#||'''',sess.OSUSER from 
v$locked_object obj, 
dba_objects     db, 
v$session       sess 
where obj.object_id=db.object_id 
and obj.session_id=sess.sid;