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)- A82% (53)
- B8% (5)
- C11% (7)
Community Discussion
No community discussion yet for this question.