Oracle Exam 1Z0-063 Topic 3 Question 35 Discussion

Actual exam question for Oracle's 1Z0-063 exam

Question #: 35
Topic #: 3

Which two statements are true about setting the FAST_START_MTTR_TARGET parameter to a nonzero value? (Choose two.)

AThe MTTR advisor is enabled only if the value is greater than the default value.

BAutomatic checkpoint tuning is enabled.

CThe value of the LOG_CHECKPOINT_INTERVAL parameter overrides the value of the FAST_START_MTTR_TARGET parameter.

DThe time taken to recover an instance after a crash is always exactly the same as the value set for the FAST_START_MTTR_TARGET parameter.

Show Suggested Answer

Suggested Answer: A, C

The FAST_START_MTTR_TARGET initialization parameter lets you specify in seconds the expected 'mean time to recover' (MTTR), which is the expected amount of time Oracle takes to perform crash or instance recovery for a single instance.

To enable MTTR advisory, set the initialization parameter FAST_START_MTTR_TARGET to a nonzero value. If FAST_START_MTTR_TARGET is not specified, then MTTR advisory will be OFF.

When specified, FAST_START_MTTR_TARGET is overridden by LOG_CHECKPOINT_INTERVAL.

Note: The default value is 0. Range of values is 0 to 3600 seconds.

References: https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams079.htm#REFRN10058 https://docs.oracle.com/cd/A97630_01/server.920/a96533/instreco.htm

by Ammie at May 06, 2022, 10:48 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-063 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!