单选题In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you find that buffe

题目内容(请给出正确答案)

单选题

In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you find that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?（）

Decreasing PCTUSED

Decreasing PCTFREE

Increasing the number of DBWN process

Using Automatic Segment Space Management (ASSM)

Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

单选题Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of the database in the future. What action would you take to achieve this task？（）A Set the STATISTICS_LEVEL initialization parameter to ALL.B Create a baseline on a pair of snapshots that have the statistics of the peakload period in the database.C Decrease the snapshot interval in the AWR to collect more number of snapshots during the peakload period.D Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid theautomatic purging of the snapshots.

点击查看答案
第2题

多选题You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed. Identify three possible reasons for this.（）AMissing or stale histogram statisticsBUndersized shared poolCHigh clustering factor for the indexesDHigh value for the DB_FILE_MULTIBLOCK_READ_COUNT parameterEOversized buffer cache

点击查看答案
第3题

单选题You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to， in order to determine the appropriate indexes？（）A Memory AdvisorB Segment AdvisorC SQL Access AdvisorD Automatic Workload Repository （AWR）E Automatic Database Diagnostic Monitor （ADDM）

点击查看答案
第4题

单选题The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?（）A Create two custom ADDM tasks.B Modify the AWR snapshot time interval to two hours.C Create a new scheduler window for a time period of two hours.D Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours.

点击查看答案
第5题

单选题In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you find that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?（）A Decreasing PCTUSEDB Decreasing PCTFREEC Increasing the number of DBWN processD Using Automatic Segment Space Management (ASSM)E Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation

点击查看答案
第6题

单选题You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to， in order to determine the appropriate indexes？（）AMemory AdvisorBSegment AdvisorCSQL Access AdvisorDAutomatic Workload Repository （AWR）EAutomatic Database Diagnostic Monitor （ADDM）

点击查看答案
第7题

单选题The Automatic Database Diagnostic Monitor （ADDM） analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do？（）ACreate two custom ADDM tasks.BModify the AWR snapshot time interval to two hours.CCreate a new scheduler window for a time period of two hours.DModify the Automatic Workload Repository （AWR） snapshot retention period to two hours.

点击查看答案

单选题In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you find that buffe

题目内容(请给出正确答案)

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容