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?
The most correct answer is A. V$SESSION_EVENT, but C. V$SESSION_WAIT can displays the current or last wait for each session.
https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/V-SESSION_EVENT.html#GUID-5723D404-83F7-4C8D-8BF2-031B3FFEAAA8
https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/V-SESSION_WAIT.html#GUID-4EDAB293-F3FC-40FE-BC75-4FEE6A4D7705
V$SESSION_EVENT
This view lists information on waits for an event by a session
upvoted 4 times
...
This section is not available anymore. Please use the main Exam Page.1z0-083 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
janw
Highly Voted 3 years, 5 months agojanw
Highly Voted 3 years, 5 months ago_gio_
Most Recent 7 months agoErikJanssen
1 year agoPatrick9230
1 year, 4 months agoDhanushbh
2 years, 4 months agonavingupta52
2 years, 5 months agoflaviogcmelo
2 years, 7 months agocerebro2000x
3 years, 3 months ago