Oracle Database Administration II — Question 14

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?

Answer options

• A. V$SESSION_EVENT
• B. V$SESSTAT
• C. V$SESSION_WAIT
• D. V$SESSION_WAIT_CLASS
• E. V$SESSION

Correct answer: A

Explanation

The correct answer is A, V$SESSION_EVENT, as it lists all the events a session has waited on at least once, which is essential for diagnosing performance issues. The other options, while related to session statistics and waits, do not provide a complete list of all waits experienced by the session.