ASH report - Wait event
I have a DB running on 11.2.0.2, recently there is performance problem reported on one of the application job, during the job run time, I can see lots of time the job's session has wait SQL*Net message from client, looks like lots of time the DB is doing nothing while waiting for the application server next instruction to proceed, when i tried to review the ASH report, generating past report for this session, I can't see this wait event reported.
Anyway I can check if the session has SQL*Net message from client in the past, I used ASH report but this wait event is not reported but I'm pretty sure this is the cause why the job is slow.