What are three possible causes for the latch-related wa…

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

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

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

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.



Leave a Reply 0

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