Users complain about increased response time for queries in your production database that
supports an OLTP workload. On investigation, you notice a large number ofdb file scattered
read, latch: cache buffers lru chain, andlatch: cache buffers chainswait 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
imo B,D,E
diablo, go through first questions also.
B,D,E
BDE others are shared_pool related or direct read
Not D! — The db file scattered read waits are associated with full table scans and index fast full scans (FFS) operations.