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 ratiois 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 ratiois 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 7

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


vasya

vasya

B – free buffer waits,
E – low cache hit ration
F – read by other session

and
D – several full table scans are performed by transactions

dmx

dmx

A,B,E,F

C is wrong. I think it says about the hot blocks, it is difficult to say how many of them

D is wrong. read by other session, and buffer busy waits events occur not only on full table scans

Fonx

Fonx

ABEF yep, others are not “prooved”