Three dynamic performance views of wait events:
V$SESSION_WAIT :-
It displays the events for which sessions have just completed waiting or are currently waiting.
V$SYSTEM_EVENT :_
It displays the total number of times all the sessions have waited for the events in that view.
V$SESSION_EVENT-:
It is similar to V$SYSTEM_EVENT, but displays all waits for each session.
V$SESSION_WAIT :-
It displays the events for which sessions have just completed waiting or are currently waiting.
V$SYSTEM_EVENT :_
It displays the total number of times all the sessions have waited for the events in that view.
V$SESSION_EVENT-:
It is similar to V$SYSTEM_EVENT, but displays all waits for each session.
No comments:
Post a Comment