多选题

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

ADisable automatic checkpoint tuning.

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

CSet the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor. 

DDecrease the number of redo log members if there are more than one redo log members available in each redo log group.

正确答案

来源:www.examk.com

答案解析

相似试题
  • You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()

    多选题查看答案

  • Which two initialization parameters would you set to enable Automatic Shared Memory Management?()

    多选题查看答案

  • You can control instance recover performance by setting parameters to define targets for()

    单选题查看答案

  • You want to migrate your existing non/x7fASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?()

    多选题查看答案

  • Assume that you would like to clone an existing WebLogic Domain and enable some  customizations. What scenario would you choose?()

    单选题查看答案

  • You noticed that the index tablespace in your database requires a recovery. However, instead of performing a media recovery, you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes?()

    多选题查看答案

  • Which tool in the layout model could you use to create an external boiler plate object?()

    单选题查看答案

  • You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set?()

    单选题查看答案

  • You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to().

    单选题查看答案