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.
Explanation:
A, B, E
A B E
ABD
refer to Domingo;
Lack of statement reuse
Statements not using bind variables
Insufficient size of application cursor cache
Cursors closed explicitly after each execution
Frequent logins and logoffs
Underlying object structure being modified (for example truncate)
Shared pool too small
ADE
A: Shared pool too small
D: Frequent logins and logoffs
E:Being read by one session while being modified by another session
docs:
http://docs.oracle.com/database/121/CNCPT/consist.htm#CNCPT1357
http://docs.oracle.com/database/121/TGDBA/pfgrf_instance_tune.htm#TGDBA94516