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
10 months agoOretha
10 months agoSimona
10 months agoCeola
10 months agoEladia
11 months agoGlen
11 months agoMichael
11 months agoCordelia
11 months agoFreeman
1 years agoMichael
1 years agoJennie
1 years agoHerminia
11 months agoLindsey
12 months agoParis
1 years agoJoanna
1 years ago