多选题You notice that the performance of the database has degraded because of frequent checkpoints.  Which twoactions 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 

题目
多选题
You notice that the performance of the database has degraded because of frequent checkpoints.  Which twoactions 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 eachredo log group.

相似考题

1.WhichthreeinitializationparametersarenolongerneededwhenFAST_START_MTTR_TARGETisdefined?()A.TARGET_REDO_BLKSB.FAST_START_IO_TARGETC.LOG_CHECKPOINT_TIMEOUTD.RECOVERY_ESTIMATED_IOSE.LOG_FILE_SIZE_REDO_BLKSF.LOG_CHECKPOINT_INTERVAL

2. You observe that database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks.  Which advisory component would you refer to， in order to determine the required size of the database buffer cache？（） A、Memory AdvisorB、Segment AdvisorC、SQL Tuning AdvisorD、SQL Access AdvisorE、Automatic Database Diagnostic Monitor （ADDM）

3. A user receives the following error while executing a query： ORA/x7f01555：snapshot too old Which two options can be the solutions to avoid such errors in future？（）A、increase the size of redo log filesB、increase the size of the undo tablespaceC、increase the size of the Database Buffer CacheD、increase the size of the default temporary tablespaceE、enable the retention guarantee for the undo tablespace

4.Which  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 onlineredo log files

参考答案和解析
正确答案： D,A
解析： 暂无解析
更多“多选题You notice that the performance of the database has degraded because of frequent checkpoints.  Which twoactions 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 ”相关问题

  • 第1题：

    You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer.Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation.  Which two actions would you take to gain performance？（）

    • A、Increase the size of redo log files
    • B、Increase the size of redo log buffer
    • C、Increase the number of redo log files
    • D、Place the redo log files on a separate disk
    • E、Decrease the number of redo log groups to two
    • F、Increate the number Log Writer （LGWR） process

    正确答案:B,D

  • 第2题：

    You are maintaining your OLTP database in Oracle10g. While observing the performance of the database， you find that the log switch occurs more than once for every 20 minutes， affecting the database performance. Which factor is responsible for frequent log switches？（）  

    • A、the value of the UNDO_RETENTION initialization parameter
    • B、the value of the optimal redo log file size provided by the Redo Logfile Size Advisor
    • C、the online redo log files size
    • D、the number of redo log members in a group

    正确答案:C

  • 第3题：

    You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the log file size that should equal the minimum size of all the online redo log files. Which column will enable you to perform the desired task？（）

    • A、 the WRITES_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view
    • B、 the column of the V$INSTANCE_RECOVERY view
    • C、 the OPTIMAL_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view
    • D、 the LOG_FILE_SIZE_REDO_BLKS column of the V$INSTANCE_RECOVERY view

    正确答案:C

  • 第4题：

    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.

    正确答案:B,C

  • 第5题：

    In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members.  Which two actions would you take to improve the performance of the database server？ （）

    • A、increase the size of the redo log buffer
    • B、increase the number of redo log groups
    • C、increase the number of log writer processes
    • D、increase the number of ARCn processes
    • E、change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location

    正确答案:B,E

  • 第6题：

    Your database performance has degraded due to frequent checkpointing. What would you do in this scenario？（）

    • A、make redo log files smaller
    • B、increase the size of the checkpoint file
    • C、make the changes as per the advice given by MTTR Advisor
    • D、make the changes as per the advice given by Checkpoint Advisor

    正确答案:C

  • 第7题：

    多选题
    In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members.  Which two actions would you take to improve the performance of the database server？ （）
    A

    increase the size of the redo log buffer

    B

    increase the number of redo log groups

    C

    increase the number of log writer processes

    D

    increase the number of ARCn processes

    E

    change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location


    正确答案： B,E
    解析： 暂无解析

  • 第8题：

    单选题
    You observe that a database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine that required size of the database buffer cache？ （）
    A

     Memory Advisor

    B

     Segment Advisor

    C

     SQL Tuning Advisor

    D

     SQL Access Advisor

    E

     Automatic Database Diagnostic Monitor （ADDM）


    正确答案： A
    解析： 暂无解析

  • 第9题：

    多选题
    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.


    正确答案： B,D
    解析： 暂无解析

  • 第10题：

    单选题
    Your database performance has degraded due to frequent checkpointing. What would you do in this scenario？（）
    A

    make redo log files smaller

    B

    increase the size of the checkpoint file

    C

    make the changes as per the advice given by MTTR Advisor

    D

    make the changes as per the advice given by Checkpoint Advisor


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    You are maintaining your OLTP database in Oracle10g. While observing the performance of the database， you find that the log switch occurs more than once for every 20 minutes， affecting the database performance. Which factor is responsible for frequent log switches？（）
    A

    the value of the UNDO_RETENTION initialization parameter

    B

    the value of the optimal redo log file size provided by the Redo Logfile Size Advisor

    C

    the online redo log files size

    D

    the number of redo log members in a group


    正确答案： A
    解析： 暂无解析

  • 第12题：

    多选题
    Which three pieces of information are considered while deciding the size of the undo tablespace in your database？（）
    A

    the size of an undo block

    B

    the size of the redo log files

    C

    undo blocks generated per second

    D

    the size of the database buffer cache

    E

    the value of the UNDO_RETENTION parameter


    正确答案： C,B
    解析： 暂无解析

  • 第13题：

    Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance？（）

    • A、Data blocks have to be written more frequently by DBWR. 
    • B、Redo blocks have to be written more frequently by LGWR. 
    • C、You need to substantially increase the size of your database buffer cache to hold the additional checkpoint records. 
    • D、You need to substantially increase the size of your redo buffer cache to hold the additional checkpoint records.

    正确答案:A

  • 第14题：

    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.

    正确答案:B,C

  • 第15题：

    You notice that the performance of the database has degraded because of frequent checkpoints.  Which twoactions 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 eachredo log group.

    正确答案:B,C

  • 第16题：

    Which three initialization parameters are no longer needed when FAST_START_MTTR_TARGET is defined？（）

    • A、TARGET_REDO_BLKS
    • B、FAST_START_IO_TARGET
    • C、LOG_CHECKPOINT_TIMEOUT
    • D、RECOVERY_ESTIMATED_IOS
    • E、LOG_FILE_SIZE_REDO_BLKS
    • F、LOG_CHECKPOINT_INTERVAL

    正确答案:B,C,F

  • 第17题：

    You are attempting to increase the checkpoint interval on your database. Each of the following choices will affect the duration and/or frequency of checkpoints, except one.  Which is it?（）

    • A、Size of redo logs 
    • B、Number of datafiles 
    • C、LOG_CHECKPOINT_INTERVAL 
    • D、LOG_CHECKPOINT_TIMEOUT

    正确答案:B

  • 第18题：

    You need to improve the performance of the tempdb database on SQL1.Which two actions should you perform？（）

    • A、Move tempdb onto a faster disk volume.
    • B、Increase the initial size of tempdb to 1.5 GB
    • C、Increase the size of the data files in the Tracking database.
    • D、Decrease the file growth increment for tempdb to 25 MB
    • E、Use more local temporary tables and fewer global temporary tables in the Tracking database.

    正确答案:A,B

  • 第19题：

    多选题
    You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer.Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation.  Which two actions would you take to gain performance？（）
    A

    Increase the size of redo log files

    B

    Increase the size of redo log buffer

    C

    Increase the number of redo log files

    D

    Place the redo log files on a separate disk

    E

    Decrease the number of redo log groups to two

    F

    Increate the number Log Writer （LGWR） process


    正确答案： C,A
    解析： 暂无解析

  • 第20题：

    多选题
    Which  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 onlineredo log files


    正确答案： C,B
    解析： 暂无解析

  • 第21题：

    单选题
    You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the optimal size of the online redo log files. Which tool enables you to determine the optimal size of the online redo log files？（）
    A

     Oracle Enterprise Manager

    B

     The V$LOG view

    C

     The V$LOGFILE view

    D

     The V$FLASHBACK_DATABASE_LOGS view


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    You observe that database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks.  Which advisory component would you refer to， in order to determine the required size of the database buffer cache？（）
    A

    Memory Advisor

    B

    Segment Advisor

    C

    SQL Tuning Advisor

    D

    SQL Access Advisor

    E

    Automatic Database Diagnostic Monitor （ADDM）


    正确答案： C
    解析： 暂无解析

  • 第23题：

    多选题
    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.


    正确答案： A,B
    解析： 暂无解析

相关内容