Oracle Database 12c: RAC and Grid Infrastructure Administration — Question 57

There are currently 6 APPLIER and 6 PREPARER processes running and no idle APPLIER processes on your logical standby database.
The MAX_SERVERS SQL apply parameter and number of archiver processes are both set to 12.
Identify two changes, each of which would allow you to increase the number of APPLIER processes.

Answer options

• A. Increase the PROCESSES initialization parameter
• B. Increase the value for the MAX_SERVERS SQL apply parameter.
• C. Decrease the number of archiver processes on the standby database.
• D. Increase the PARALLEL_MAX_SERVER initialization parameter
• E. Decrease the number of PREPARER processes
• F. Increase the RECOVERY_PARALLELISM initialization parameter

Correct answer: B, E

Explanation

Increasing the MAX_SERVERS SQL apply parameter (Option B) allows for more APPLIER processes to run concurrently, while decreasing the number of PREPARER processes (Option E) frees up resources that can be reallocated to APPLIER processes. The other options do not directly address the limitation on the number of APPLIER processes or would not contribute to increasing their count.