Deepak Pushkarna wrote:If the session is reported to have some slowness, it's going to be reported in the v$session_wait . Other than, a very good tool from Tanel Poder is there for the same thing, Session Snapper which can tell you a lot what the session is doing . You should be able to find it by Googling "tanel poder snapper" .
Need a small help, do anybody have some query to find out the wait event for running oracle session, if I have Oracle SID for the same.
and some reference doc for resolving the various wait events which is causing delay in the sql statement.I am not sure that for a running query, much can be said but if you are on 11g(I believe 11.2) , run time sql monitoring may give some clue?