1Z0-083 practice question 29 of 35

A user complains about poor database performance. You want to verify if the user’s session has waited for certain types of I/O activity. Which view displays all waits waited on by a session at least once?

Full set: 286 questions
Answer options
A: V$SESSION_EVENT Correct answer
B: V$SESSTAT
C: V$SESSION_WAIT
D: V$SESSION_WAIT_CLASS
E: V$SESSION
Correct Answer:
A. V$SESSION_EVENT
Explanation

The V$SESSIONEVENT view provides cumulative statistics on waits for each event, for each session. It contains one row for every event that a session has waited for since it was started, showing the total number of waits and the total time waited. This directly answers the need to see all types of I/O (and other) waits a session has encountered at least once. Other views show either the current wait (V$SESSIONWAIT, V$SESSION) or statistics aggregated differently (V$SESSTAT, V$SESSIONWAITCLASS).

Why Incorrect

B. V$SESSTAT displays cumulative session statistics like 'CPU used by this session', not wait events.
C. V$SESSIONWAIT shows only the single event that a session is currently waiting for, not its history of waits.
D. V$SESSIONWAITCLASS aggregates wait data by class (e.g., 'User I/O'), not by individual event name.
E. V$SESSION provides general session information and shows only the current wait event, similar to V$SESSIONWAIT.

References

- Oracle Database Reference, 19c, Chapter 2, "Dynamic Performance (V$) Views".

- Description of V$SESSIONEVENT: "This view lists the total waits for an event by a session."

- Description of V$SESSIONWAIT: "This view displays the raw wait statistics for the event or resource that a session is currently waiting for."

- Description of V$SESSTAT: "This view displays detailed statistics for each current session on the statistic numbers."

Scroll to Top