Oracle
1Z0-054 · Question #131
You issued the following query on the V$INSTANCE_RECOVERY dynamic performance view: SELECT target_mttr, estimated_mttr FROM v$instance_recovery; You noticed that the value for the ESTIMATED_MTTR…
The correct answer is E. DBWn is requested to write enough dirty buffers to allow the ESTIMATED_MTTR to fall back. See the full explanation below for the reasoning.
Question
You issued the following query on the V$INSTANCE_RECOVERY dynamic performance view:
SELECT target_mttr, estimated_mttr FROM v$instance_recovery; You noticed that the value for the ESTIMATED_MTTR column is greater than the value for the TARGET_MTTR. What would happen in this scenario?
Options
- AA checkpoint is initiated.
- BA warning is written in the alert log file.
- CThe number of archiver processes is increased.
- DThe control file is updated to mark another checkpoint record.
- EDBWn is requested to write enough dirty buffers to allow the ESTIMATED_MTTR to fall back
How the community answered
(52 responses)- A2% (1)
- B4% (2)
- C6% (3)
- D15% (8)
- E73% (38)
Community Discussion
No community discussion yet for this question.