Users complain about increased response time for queries in your production database that supports an OLTP
workload. On investigation, you notice a large number of db file scattered read, latch: cache
buffers lru chain, and latch: cache buffers chains wait events:
Identify three possible reasons for the increased response time. (Choose three.)
A.
too many sort operations being performed
B.
repeated simultaneous access to a block or small number of blocks
C.
the shared pool is inadequately sized
D.
queries not using indexes and performing full table scans
E.
queries repeatedly fetching blocks that are not in the database buffer cache
F.
cursors are closed explicitly after each execution