Prev Question
Next Question

Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:

5a4b9860a8234 - What are three possible causes for the latch-related wait events?

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

A.
The size of the shared pool is too small.

B.
Cursors are not being shared.

C.
A large number COMMITS are being performed.

D.
There are frequent logons and logoffs.

E.
The buffers are being read into the buffer cache, but some other session is changing the buffers.

Explanation:
https://logicalread.com/oracle-latch-free-wait-dr01/#.WQygk1i6zUI

Prev Question
Next Question

Leave a Reply

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