Wait events [message #359554] |
Mon, 17 November 2008 04:39 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
vinniora
Messages: 56 Registered: October 2008 Location: Mumbai
|
Member |
|
|
hi....i would like to know what is the basic difference between
V$session_event,V$session_wait,V$system_event...so please try to give a descriptive description and also that,at what secenario these view must be used....
|
|
|
Re: Wait events [message #359557 is a reply to message #359554] |
Mon, 17 November 2008 04:51 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
v$session_events reports all waits for each sessionsince they begin.
v$session_wait reports the current wait for each session.
Regards
Michel
|
|
|