1Z0-064 · Question #68
Examine the initialization parameters set for a database instance: The database supports an OLTP workload. Applications connect to the instance using shared server connections and perform small…
The correct answer is B. Configure the database instance to make asynchronous I/O available to DBWR. See the full explanation below for the reasoning.
Question
Examine the initialization parameters set for a database instance:
The database supports an OLTP workload. Applications connect to the instance using shared server connections and perform small, random I/Os. All the data files are on the same disk. You notice free buffer wait events for sessions in the database instance. To solve the problem, you increase the size of the buffer cache. But after some time, you notice sessions waiting again on free buffer waits. What will you recommend to alleviate the issue? (Choose the best answer.)
Exhibit
Options
- ARun the I/O calibration tool.
- BConfigure the database instance to make asynchronous I/O available to DBWR.
- CSpread the data files over multiple disks, controllers, and I/O buses to ensure that there are no
- DConfigure dedicated server connections for the applications.
How the community answered
(40 responses)- A3% (1)
- B83% (33)
- C5% (2)
- D10% (4)
Community Discussion
No community discussion yet for this question.
