Free Preparation Discussions
MENU
Oracle Exam 1Z0-076 Topic 1 Question 2 Discussion
Topic #: 1
There are currently 6 applief. and 6 pfepafef processes running and no idle applier processes on y 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.
To increase the number of applier processes on a logical standby database, the following changes can be made:
C: Increasing the value for the MAX_SERVERS SQL apply parameter would allow for more applier processes to be initiated, assuming that system resources permit.
D: Increasing the PARALLEL_MAX_SERVERS initialization parameter would allow for more parallel execution processes, which can be used by SQL apply to increase the number of applier processes.
Option A is incorrect as decreasing the number of archiver processes will not necessarily increase the number of applier processes; these are unrelated components.
Option B is incorrect because the 'FREPARER' processes do not exist, it seems to be a typographical error, and the 'REPARER' is not a valid Oracle process or parameter.
Option E is incorrect because the RECOVERY_PARALLELISM parameter controls the number of processes used for instance recovery and media recovery, not for SQL apply.
Tayna
6 months agoOretha
6 months agoSimona
6 months agoCeola
6 months agoEladia
6 months agoGlen
6 months agoMichael
7 months agoCordelia
7 months agoFreeman
7 months agoMichael
7 months agoJennie
8 months agoHerminia
7 months agoLindsey
7 months agoParis
8 months agoJoanna
8 months ago