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…
Sign in or unlock 1Z0-083 to reveal the answer and full explanation for question #60. The question stem and answer options stay visible for context.
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
Unlock 1Z0-083 to see the answer
You've previewed enough free 1Z0-083 questions. Unlock 1Z0-083 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#V$SESSION_EVENT#wait events#I/O waits#session performance