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.
For me are for sure A,B and E.
Those latch are always related to small shared pool size, not cursor sharing (hard parse) and contentions on library cache.
A is right
B is right. not shared, Latch: share pool
C is wrong.
D is wrong. commit?
E is right. concurrency
freq logon/logoff aren`t combine with dc_users in v$rowcache?
A and B are correct for sure.
D is not correct.
E is also correct: http://docs.oracle.com/cd/B28359_01/server.111/b28274/memory.htm#i45439
As we have three options to choose, my choice is: ABE