Which four can be possible reasons for the increased re…

You are administering a database that supports an OLTP workload. An application performs a large number of
small transactions. Users complain about increased response times for transactions. On investigation, you find
that the cache hit ratio is 69%. Examine a partial output from V$SYSTEM_EVENT:

Which four can be possible reasons for the increased response time? (Choose four.)

You are administering a database that supports an OLTP workload. An application performs a large number of
small transactions. Users complain about increased response times for transactions. On investigation, you find
that the cache hit ratio is 69%. Examine a partial output from V$SYSTEM_EVENT:

Which four can be possible reasons for the increased response time? (Choose four.)

A.
The database buffer cache is inadequately sized.

B.
DBWR is not writing the dirty buffers fast enough.

C.
A large number of blocks are fetched from disks frequently.

D.
Several full table scans are performed by transactions.

E.
Blocks are aging out of the buffer cache frequently.

F.
Many sessions are waiting for buffers that are currently being read into the buffer cache by other sessions.



Leave a Reply 0

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