What can be the three possible causes for the latch-related wait events?

View the Exhibit and examine the details of the Top 5 Timed Events from an Automatic Workload Repository (AWR) report.What can be the three possible causes for the latch-related wait events? (Choose three.)
Exhibit:

View the Exhibit and examine the details of the Top 5 Timed Events from an Automatic Workload Repository (AWR) report.

What can be the three possible causes for the latch-related wait events? (Choose three.)

A.
Shared pool size is too small.

B.
Cursors are not being shared.

C.
There are frequent logons/logoffs.

D.
A large number of COMMITs are being performed.

E.
A large number of data definition language (DDL) and query statements are being executed simultaneously by different sessions.



Leave a Reply 0

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