Oracle
1Z0-067 · Question #125
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…
The correct answer is C. The overhead on database performance is increased because of frequent writes to disk. 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, you set 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
(21 responses)- A14% (3)
- B5% (1)
- C71% (15)
- D10% (2)
Community Discussion
No community discussion yet for this question.