oracle proc 死锁的sql及kill

select * from v$session a ,v$locked_object b ,dba_objects c
where a.sid = b.session_id
and b.object_id = c.object_id
and a.username = 'NOVA'

alter system kill session '152,41451' immediate;