Oracle
1Z0-064 · Question #82
1Z0-064 Question #82: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #82. The question stem and answer options stay visible for context.
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
Unlock 1Z0-064 to see the answer
You've previewed enough free 1Z0-064 questions. Unlock 1Z0-064 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.