Skip to Main Content

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!

v$session_event vs v$session_wait !

shipon_97Nov 4 2012 — edited Nov 5 2012
I am having trouble understanding the difference between v$session_wait and v$session_event. I read the oracle reference documentation and still don't get it.

For example , sometimes I got the "enq: TX - row lock contention" related wait event from "v$session_event" view but at that moment there is no wait event under the "v$session_wait" view . So for any wait event which view I need to consider and why ?


Anybody can explain this to me? Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 3 2012
Added on Nov 4 2012
12 comments
3,367 views