Oracle
1Z0-083 · Question #60
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…
The correct answer is A. V$SESSION_EVENT. The V$SESSION_EVENT view provides summary of all the events the session has waited for since it started.
Monitoring and Tuning
Question
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?
Options
- AV$SESSION_EVENT
- BV$SESSTAT
- CV$SESSION_WAIT
- DV$SESSION_WAIT_CLASS
- EV$SESSION
How the community answered
(25 responses)- A72% (18)
- C4% (1)
- D16% (4)
- E8% (2)
Explanation
The V$SESSION_EVENT view provides summary of all the events the session has waited for since it started.
Topics
#V$SESSION_EVENT#wait events#I/O waits#session performance
Community Discussion
No community discussion yet for this question.