多項選擇題

You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue（）

A.Disable automatic checkpoint tuning.
B.Check the size of the redo log file size and increase the size if it is small.
C.Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.
D.Decrease the number of redo log members if there are more than one redo log members available in each redo log group.

你可能感興趣的試題

多項選擇題

Which two statements are true about checkpointing（）

A.The checkpoint frequency decreases with the smaller redo log file size.
B.It ensures that all committed data is written to the data files during normal shutdown.
C.The frequent full checkpoint in a database can cause the overall degradation of the database performance.
D.It prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the online redo log files.

多項選擇題

Which two statements are true about setting the FAST_START_MTTR_TARGET initializationparameter to a nonzero value（）

A.The MTTR advisor will be disabled.
B.Automatic checkpoint tuning will be enabled.
C.The value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value forFAST_START_MTTR_TARGET.
D.The time taken to recover the instance after the crash is always exactly the same as the value given forthe FAST_START_MTTR_TARGET initialization parameter.

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue（）

你可能感興趣的試題

Which two statements are true about checkpointing（）

Which two statements are true about setting the FAST_START_MTTR_TARGET initializationparameter to a nonzero value（）

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精