hello forum,
can you suggest how to monitor blocked processes.
i Am interested to get list of pocesses which wait for execution for longer then 60 sec, the blocker, supporting info for both:
sid, sql text, user, client pc id.
its also good to know that potential suggestion was tested in practice.
thank you for your help.