Which two actions resolve the issue?

You notice that the performance of the database has degraded because of frequent
checkpoints. Which two actions resolve the issue? (Choose two.)

You notice that the performance of the database has degraded because of frequent
checkpoints. Which two actions resolve the issue? (Choose two.)

A.
Check the size of the redo log file size and increase the size if it is small

B.
Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR
Advisor

C.
Decrease the number of redo log members if there are more than one redo l og members
available in each redo log group

D.
Disable automatic checkpoint tuning



Leave a Reply 4

Your email address will not be published. Required fields are marked *


Eamon

Eamon

Questions missing from this exam, in 1Z0-052 (v.3)

1. When would Datapump external tables be used instead of Datapump import direct path?

2. Is the lock from a select … FOR UPDATE compatible with a ROW SHARE table lock?

bea

bea

FAST_START_MTTR_TARGET enables you to specify the number of seconds the database takes to perform crash recovery of a single instance. When specified, FAST_START_MTTR_TARGET is overridden by LOG_CHECKPOINT_INTERVAL.

mel

mel

Are these dumps still valid for the exam? Haw anyone passed the exam with those dumps?

gee

gee

Not sure, I am wondering the same thing