In a multi-user environments session locks and waits are very common.
So when my session is waiting for a resource (for example, trying to update a table row that someone else is updating and haven't yet commited), I wanna know ASAP which session is blocking me.
(Maybe it is my own session previously not killed properly because of when SQLnav crashed :) :P)
Anyway this info is available right here:
SELECT s.blocking_session blocking_session_id
,s.blocking_session_status
FROM v$session s
WHERE sid = 8297; -- My Session
May this kind of info be included somewhere in the Session Browser?
It would be very helpful.