Oracle: How would you determine what sessions are connected and what resources they are waiting for?

+4 votes

509 views

posted Mar 30, 2015 by Archana

Share this question

Your comment on this post:

Email me at this address if a comment is added after mine:Email me if a comment is added after mine

Privacy: Your email address will only be used for sending these notifications.

Anti-spam verification:

To avoid this verification in future, please log in or register.

+1 vote

Best answer

Use of V$SESSION and V$SESSION_WAIT

answer Mar 30, 2015 by Shivaranjini

Email me at this address if a comment is added after mine:Email me if a comment is added after mine

Privacy: Your email address will only be used for sending these notifications.

Anti-spam verification:

To avoid this verification in future, please log in or register.

Email me at this address if my answer is selected or commented on:Email me if my answer is selected or commented on

Privacy: Your email address will only be used for sending these notifications.

Anti-spam verification:

To avoid this verification in future, please log in or register.