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就是源头
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就是源头