1Z0-083 practice question 29 of 35
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?
Full set: 286 questionsThe V$SESSIONEVENT view provides cumulative statistics on waits for each event, for each session. It contains one row for every event that a session has waited for since it was started, showing the total number of waits and the total time waited. This directly answers the need to see all types of I/O (and other) waits a session has encountered at least once. Other views show either the current wait (V$SESSIONWAIT, V$SESSION) or statistics aggregated differently (V$SESSTAT, V$SESSIONWAITCLASS).
B. V$SESSTAT displays cumulative session statistics like 'CPU used by this session', not wait events.
C. V$SESSIONWAIT shows only the single event that a session is currently waiting for, not its history of waits.
D. V$SESSIONWAITCLASS aggregates wait data by class (e.g., 'User I/O'), not by individual event name.
E. V$SESSION provides general session information and shows only the current wait event, similar to V$SESSIONWAIT.
- Oracle Database Reference, 19c, Chapter 2, "Dynamic Performance (V$) Views".
- Description of V$SESSIONEVENT: "This view lists the total waits for an event by a session."
- Description of V$SESSIONWAIT: "This view displays the raw wait statistics for the event or resource that a session is currently waiting for."
- Description of V$SESSTAT: "This view displays detailed statistics for each current session on the statistic numbers."
Keep practicing
Take the free 1Z0-083 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-083 practice questions
- Question 1Which two are true about flashback features in Oracle Database 19c and later releases? (C…
- Question 2Which two statements are true about Resource Manager plans for individual pluggable datab…
- Question 3Choose three. Which are the three steps in the SQL tuning process for Oracle Database env…
- Question 4Choose three. Which three are true about using Database Upgrade Assistant (DBUA) to upgra…
- Question 5Choose three. Which three capabilities require the use of the RMAN recovery catalog?
- Question 6Choose two. In which two situations can you use Database Upgrade Assistant?
