Blocking session

Some time ago, I wrote a post on how to show a chain of blocked sessions. In this days Kaley Crum wrote a new version of my original script.

I modified a little him script. You can find the final result it in this post.

This is an example of the output: as you can see the session 2443 on instance 1 (these are separated by an "at" on the PATH_EVENT column) is blocking the session 1703 on the second instnce.

I also show the "locker" and the "last blocked" session on separated columns. In this way is more simple to understand read the the PATH_EVENT column

The picture of this post come from here.