1Z0-064 · Question #82
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…
The correct answer is A. The database buffer cache is inadequately sized. B. DBWR is not writing the dirty buffers fast enough. 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. See the full explanation below for the reasoning.
Question
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.)
Exhibit
Options
- AThe database buffer cache is inadequately sized.
- BDBWR is not writing the dirty buffers fast enough.
- CA large number of blocks are fetched from disks frequently.
- DSeveral full table scans are performed by transactions.
- EBlocks are aging out of the buffer cache frequently.
- FMany sessions are waiting for buffers that are currently being read into the buffer cache by other
How the community answered
(39 responses)- A77% (30)
- C8% (3)
- D15% (6)
Community Discussion
No community discussion yet for this question.