Oracle
1Z0-082 · Question #71
A user complains about poor database performance. You suspect that the user's session is waiting for an event to complete. You want to verify this. Which two views may reveal for what the user's…
The correct answer is B. V$SESSION_EVENT D. V$SESSION_WAIT. See the full explanation below for the reasoning.
Manage Performance
Question
A user complains about poor database performance. You suspect that the user's session is waiting for an event to complete. You want to verify this. Which two views may reveal for what the user's session is currently waiting? (Choose two.)
Options
- AV$SYSTEM_EVENT
- BV$SESSION_EVENT
- CV$SESSION_WAIT_CLASS
- DV$SESSION_WAIT
- EV$SESSION
How the community answered
(22 responses)- A9% (2)
- B73% (16)
- C14% (3)
- E5% (1)
Topics
#V$SESSION_WAIT#wait events#performance views#session monitoring
Community Discussion
No community discussion yet for this question.