Friday, January 13, 2012

How to identify the wait events for a Session in oracle database

select p1, p2, p3, event
from   v$session_wait
where sid=&session_id;

Also check the following:

select count(*), event
from    v$session_wait
group   by event;

2 comments:

  1. I appreciate you sharing this article. Really thank you! Much obliged.
    This is one awesome blog article. Much thanks again.

    sap online training
    software online training
    sap sd online training
    hadoop online training
    sap-crm-online-training

    ReplyDelete
  2. I really enjoy the blog.Much thanks again. Really Great.
    Very informative article post. Really looking forward to read more. Will read on…


    oracle online training
    sap fico online training
    dotnet online training
    qa-qtp-software-testing-training-tutorial

    ReplyDelete