sinat_38585699的博客

原创 oracle查询死锁的源头

select a.USERNAME, a.EVENT, a.BLOCKING_SESSION, a.FINAL_BLOCKING_SESSION,a.* from gv$session a where username is not null and status <> 'INACTIVE' order by logon_time, SID;查询结果中 final_blocking_session就是源头