Oracle Database Administration II — Question 6

While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is a bottleneck.
FORCE LOGGING is enabled for the database.
Which two could improve read performance? (Choose two.)

Answer options

• A. Increase the size of tape I/O buffers.
• B. Disable FORCE LOGGING for the database.
• C. Increase the size of the database buffer cache.
• D. Enable asynchronous disk I/O.
• E. Increase the level of RMAN multiplexing.

Correct answer: D, E

Explanation

Enabling asynchronous disk I/O (D) allows for overlapping of I/O operations, which can significantly enhance read performance by reducing wait times. Increasing the level of RMAN multiplexing (E) improves the efficiency of backup operations by allowing multiple backup streams to be written simultaneously, thus optimizing resource usage. The other options either do not directly address the read performance bottleneck or could potentially introduce issues.