Which three are true about monitoring waits for sessions and services? (Choose three.)

Question

Options

• AV$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred
• BV$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a
• CV$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.
• DV$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting
• EV$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once
• FV$SESSION_WAIT and V$SESSION both contain details of the event on which a session is

• A
  4% (1)
• B
  84% (21)
• C
  8% (2)
• E
  4% (1)

Explanation

A, E - False : V$SESSION_EVENT displays information on waits for an event by a session. V$SESSION_WAIT_HISTORY displays the last 10 wait events for each active session. B - V$SERVICE_EVENT displays aggregated wait counts and wait times for each wait statistic. C - False : V$SESSION_WAIT_CLASS displays the time spent in various wait event operations on a per-session basis. D, F - True : V$SESSION_WAIT displays the current or last wait for each session. V$SESSION.EVENT If the session is currently waiting, then the resource or event for which the session is waiting. If the session is not in a wait, then the resource or event for which the session most recently waited. https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/V- SESSION_EVENT.html#GUID-5723D404-83F7-4C8D-8BF2-031B3FFEAAA8

No community discussion yet for this question.