Which events would you consider from the output for further investigation?

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.)

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.)

A.
log file sync

B.
rdbms ipc message

C.
SQL*Net message from client

D.
log file switch (checkpoint incomplete)



Leave a Reply 1

Your email address will not be published. Required fields are marked *


L. Zhu

L. Zhu

A is right.
B is wrong. idle event
C is wrong. idle event
D is right.