Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cause for session waiting

735967Mar 12 2012 — edited Mar 12 2012

Hi All,

The query "select sid,event,state from v$session_Wait where sid like 796;"

shows the output

SID EVENT STATE
796 Streams AQ: waiting for messages in the queue WAITING

Please guide me how to know what is making this session waiting

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 9 2012

Added on Mar 12 2012

#general-database-discussions, #session

13 comments

3,261 views