On investigation, you notice a large number ofdb file s…

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

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



Leave a Reply 5

Your email address will not be published. Required fields are marked *


vasya

vasya

diablo, go through first questions also.

Fonx

Fonx

BDE others are shared_pool related or direct read

Pavel

Pavel

Not D! — The db file scattered read waits are associated with full table scans and index fast full scans (FFS) operations.