nerdexam
Oracle

1Z0-054 · Question #133

You want to review a summary of all the wait events in an instance since it started over a month ago. You issued the following query: SQL>SELECT event, total_waits, time_waited, average_wait FROM…

The correct answer is A. log file sync D. log file switch (checkpoint incomplete). See the full explanation below for the reasoning.

Question

You want to review a summary of all the wait events in an instance since it started over a month ago. You issued the following query:

SQL>SELECT event, total_waits, time_waited, average_wait FROM V$SYSTEM_EVENT ORDER BY time_waited DESC; View the Exhibit and examine a portion of the output from the above query. Which events would you consider from the output for further investigation? (Choose all that apply.)

Options

  • Alog file sync
  • Brdbms ipc message
  • CSQL*Net message from client
  • Dlog file switch (checkpoint incomplete)

How the community answered

(65 responses)
  • A
    82% (53)
  • B
    8% (5)
  • C
    11% (7)

Community Discussion

No community discussion yet for this question.

Full 1Z0-054 Practice