nerdexam
Oracle

1Z0-072 · Question #22

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.

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

(49 responses)
  • A
    6% (3)
  • B
    73% (36)
  • C
    4% (2)
  • E
    16% (8)

Community Discussion

No community discussion yet for this question.

Full 1Z0-072 Practice