Best way to monitor a concurrent request in production
Greetings all,
We have a concurrent request that hangs in production once in a while. We end up cancelling the request and resubmitting it and it runs to successful completion.
I cannot recreate the issue in my test environment. I have a small window in which to troubleshoot / monitor the problem concurrent request, and I would appreciate your
suggestions on how I should go about with the troubleshooting / monitoring the next time the issue arises. My plan so far is to get the Oracle SID and AIX PID for the request.
Generate the AWR report; in AIX see if the PID is looping;