Hello,
In the sql below , the blocking_session is the BLOCKED or BLOCKER session ?
Select blocking_session, blocking_instance,wait_class, sid, serial#,
inst_id,
seconds_in_wait, program, module, s.LOGON_TIME
From gv$session s
where blocking_session is not NULL
order by blocking_session;
Regards
Eriovaldo