Home » RDBMS Server » Performance Tuning » Wait events (10g,linux)
Wait events [message #359554] Mon, 17 November 2008 04:39 Go to next message
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
Michel Cadot
Messages: 64139
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
Previous Topic: Error in Materialized view refresh
Next Topic: Query optimization
Goto Forum:
  


Current Time: Thu Dec 08 22:02:42 CST 2016

Total time taken to generate the page: 0.13060 seconds