Oracle
1Z0-063 · Question #75
Your database supports an OLTP workload. Examine the output of the query: SQL> SSLECT target_mttr, estimated_mttr FROM v$instance_recovery Target_mttrestimated_mttr To ensure faster instance…
The correct answer is A. Automatic checkpoint tuning is disabled. See the full explanation below for the reasoning.
Question
Your database supports an OLTP workload. Examine the output of the query: SQL> SSLECT target_mttr, estimated_mttr FROM v$instance_recovery Target_mttrestimated_mttr To ensure faster instance recovery, youset the fast_start_mttrjtargh:t initialization parameter to 30. What is the effect of this setting on the database?
Options
- AAutomatic checkpoint tuning is disabled.
- BThe frequency of log switches is increased.
- CThe overhead on database performance is increased because of frequent writes to disk.
- DThe MTTR advisor is disabled.
How the community answered
(24 responses)- A71% (17)
- B8% (2)
- C17% (4)
- D4% (1)
Community Discussion
No community discussion yet for this question.