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.)
A.
Run the I/O calibration tool.
B.
Configure the database instance to make asynchronous I/O available to DBWR.
C.
Spread the data files over multiple disks, controllers, and I/O buses to ensure that there are no hotspots in
the I/O subsystem.
D.
Configure dedicated server connections for the applications.