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.)

Question

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.)

Accepted Answer

B. repeated simultaneous access to a block or small number of blocks D. queries not using indexes and performing full table scans E. queries repeatedly fetching blocks that are not in the database buffer cache

Answer

A. too many sort operations being performed

Answer

C. the shared pool is inadequately sized

Answer

F. cursors are closed explicitly after each execution

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…

Question

Options

How the community answered

Community Discussion