Oracle执行存储过程死循环问题解决

select sess.sid,
sess.serial#,
lo.oracle_username,
lo.os_user_name,
ao.object_name,
lo.locked_mode
from v$locked_object lo,
dba_objects ao,
v$session sess
where ao.object_id = lo.object_id and lo.session_id = sess.sid;

SELECT Saddr, Sid, Serial#, Paddr, Username, Status
FROM V$session t
WHERE t.SID in (97,9115,9050);

ALTER system kill session '9043,38437'; -- --sid,serial


select addr, pid, spid, username from v$process where addr ='00000000EDDC8820'