I created one application where requests in XML format come to my application, my application runs some select and update SQLs and then responds to the other system. Total TAT for this whole process is 1.2 seconds max, but 2 requests took more than 3 seconds to respond.
So I asked for the ASH report from the DBA team to find out why this delay happened and I can see one blocking session during both of these requests. Now in the ASH report, I have the data like the following:
But to be sure I want to find out when this blocking session started and when it ended, if it coincides with request entry time to my application, I can be sure.
So is there a way to do so? I tried to find from Google but could not find any substantial answer.