Oracle
1Z0-054 · Question #120
1Z0-054 Question #120: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #120. The question stem and answer options stay visible for context.
Question
You are working on an online transaction processing (OLTP) database that runs on a machine having multiple CPUs. The database uses normal file system storage. Examine the following initialization parameters and their respective values for the instance: NAME TYPE VALUE ------------------------------------ ---------- ---------------------- dbwr_io_slaves integer 0 db_writer_processes integer 1 filesystemio_options string NONE disk_asynch_io boolean TRUE The applications perform small, random I/Os in which each foreground process reads a data block into the buffer cache for updates and the changed blocks are written in batches by the DBWR process. You noticed free buffer waits events for your database. To solve the problem, you increased the size of the buffer cache. But after some time, you notice the same event again. Which three possible actions would you recommend? (Choose three.)
Options
- Aconfiguring multiple DBWR processes
- Bdecreasing the size of the buffer cache
- Cconfiguring I/O slaves for the DBWR process
- Dconfiguring instances to make asynchronous I/O available to DBWR
- Espread data files over multiple disks, controllers, and I/O buses to ensure that there are no
Unlock 1Z0-054 to see the answer
You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 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.