单选题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?（）
A

Decreasing PCTUSED

B

Decreasing PCTFREE

C

Increasing the number of DBWN process

D

Using Automatic Segment Space Management (ASSM)

E

Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation

相似考题

1.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.（）A. Missing or stale histogram statisticsB. Undersized shared poolC. High clustering factor for the indexesD. High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameterE. Oversized buffer cache

2. 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 peak­load period in the database.C、Decrease the snapshot interval in the AWR to collect more number of snapshots during the peak­load period.D、Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid theautomatic purging of the snapshots.

3.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.

4.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

更多“单选题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题：

    You work as a database administrator for Certkiller .com. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation.  Which advisory component would you refer to， in order to determine the appropriate indexes？（）

    • A、Memory Advisors
    • B、Segment Advisors
    • C、SQL Tuning and Access Advisors
    • D、Automated Workload Repository （AWR）
    • E、Automatic Database Diagnostic Monitor （ADDM）

    正确答案:C

  • 第2题：

    Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）

    • A、 Backup of offline tablespaces.
    • B、 Backup of read-only tablespaces.
    • C、 Backup of system-critical tablespaces.
    • D、 Backup of online， locally managed tablespaces.
    • E、 Backup of read/write dictionary-managed tablespaces.

    正确答案:A,B

  • 第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 Advisor
    • B、 Segment Advisor
    • C、 SQL Access Advisor
    • D、 Automatic Workload Repository （AWR）
    • E、 Automatic Database Diagnostic Monitor （ADDM）

    正确答案:C

  • 第4题：

    In which two cases would you perform only consistent backup？（）

    • A、You are working on a database where downtime is not tolerated.
    • B、You are working on a database where downtime can be tolerated.
    • C、You are working on a database that operates in ARCHIVELOG mode.
    • D、You are working on a database that operates in NOARCHIVELOG mode.
    • E、You are working on a database where all the tablespaces are locally managed.
    • F、You are working on a database where control files and redo log files are multiplexed.
    • G、You are working on a database where control files and redo log files are not multiplexed.

    正确答案:B,D

  • 第5题：

    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.（）

    • A、Missing or stale histogram statistics
    • B、Undersized shared pool
    • C、High clustering factor for the indexes
    • D、High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter
    • E、Oversized buffer cache

    正确答案:A,C,D

  • 第6题：

    You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance？（）

    • A、run Segment Advisor
    • B、run SQL Tuning Advisor on top SQL statements
    • C、run the Automatic Workload Repository （AWR） report
    • D、run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements

    正确答案:B

  • 第7题：

    单选题
    You work as a database administrator for Supportcenter.cn. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation. Which advisory component would you refer to， in order to determine the appropriate indexes？（）
    A

    Memory Advisors

    B

    Segment Advisors

    C

    SQL Tuning and Access Advisors

    D

    Automated Workload Repository （AWR）

    E

    Automatic Database Diagnostic Monitor （ADDM）


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

  • 第8题：

    单选题
    You work in a data warehouse environment that involves the execution of complex queries. The current content of the SQL cache holds the ideal workload for analysis. You want to analyze only few most resource-intensive statements. What would be your suggestion to receive recommendations on the efficient use of indexes and materialized views to improve query performance？（）
    A

    Run the SQL Access Advisor.

    B

    Run the SQL Tuning Advisor （STA）.

    C

    Run the Automatic Workload Repository （AWR） report.

    D

    Run the Automatic Database Diagnostic Monitor （ADDM）.


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

  • 第9题：

    单选题
    You work with a newly created database. Presently, there is no application load on the database instance.You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.What action must you take to achieve this?（）
    A

    Run Segment Advisor

    B

    Run the SQL Tuning Advisor (STA)

    C

    Run the Automatic Workload Repository (AWR) report

    D

    Run the SQL Access Advisor with a hypothetical workload


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

  • 第10题：

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

    Missing or stale histogram statistics

    B

    Undersized shared pool

    C

    High clustering factor for the indexes

    D

    High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter

    E

    Oversized buffer cache


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

  • 第11题：

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


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

  • 第12题：

    单选题
    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 Advisor

    B

     Segment Advisor

    C

     SQL Access Advisor

    D

     Automatic Workload Repository （AWR）

    E

     Automatic Database Diagnostic Monitor （ADDM）


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

  • 第13题：

    You work with a newly created database. Presently, there is no application load on the database instance.You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.What action must you take to achieve this?（）

    • A、Run Segment Advisor
    • B、Run the SQL Tuning Advisor (STA)
    • C、Run the Automatic Workload Repository (AWR) report
    • D、Run the SQL Access Advisor with a hypothetical workload

    正确答案:D

  • 第14题：

    Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups.  Which two backups would you be able to perform when the database is being accessed by users？（）

    • A、backup of offline tablespaces
    • B、backup of read­only tablespaces
    • C、backup of system­critical tablespaces
    • D、backup of online， locally managed tablespaces
    • E、backup of read/write dictionary­managed tablespaces

    正确答案:A,B

  • 第15题：

    You work as a database administrator for Certkiller .com. You have set the retention period for Automatic Repository （AWR） statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics？（）

    • A、use enterprise manager
    • B、use DBMS_SQL package
    • C、use DBMS_AWR package
    • D、use PRVT_WORKLOAD package
    • E、query the AWR snapshot repository objects
    • F、use DBMS_WORKLOAD_REPOSITORY package

    正确答案:A,F

  • 第16题：

    In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command： RMAN> RESTORE CONTROLFILE;  Which two operations do you need to perform after restoring the control file from backup？（）

    • A、shut down and restart the instance
    • B、add new tempfiles to the temporary tablespaces after recovery
    • C、perform a media recovery and open the database with the RESETLOGS option
    • D、perform a media recovery and bring the database to NOARCHIVELOG mode

    正确答案:B,C

  • 第17题：

    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 PCTUSED
    • B、Decreasing PCTFREE
    • C、Increasing the number of DBWN process
    • D、Using Automatic Segment Space Management (ASSM)
    • E、Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation

    正确答案:D

  • 第18题：

    You notice a performance change in your production Oracle database and you want to know which change has made this performance difference. You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation. Which three findings would you get from the report?（）

    • A、It detects any configuration change that caused a performance difference in both time periods.
    • B、It identifies any workload change that caused a performance difference in both time periods.
    • C、It detects the top wait events causing performance degradation.
    • D、It shows the resource usage for CPU, memory, and I/O in both time periods.
    • E、It shows the difference in the size of memory pools in both time periods.
    • F、It gives information about statistics collection in both time periods.

    正确答案:A,B,E

  • 第19题：

    单选题
    You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance？（）
    A

    run Segment Advisor

    B

    run SQL Tuning Advisor on top SQL statements

    C

    run the Automatic Workload Repository （AWR） report

    D

    run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements


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

  • 第20题：

    单选题
    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 thedatabase 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 peak-load period in the database.

    C

    Decrease the snapshot interval in the AWR to collect more number of snapshots during the peak-load period.

    D

    Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid the automatic purging of the snapshots.


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

  • 第21题：

    单选题
    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 peak­load period in the database.

    C

    Decrease the snapshot interval in the AWR to collect more number of snapshots during the peak­load period.

    D

    Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid theautomatic purging of the snapshots.


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

  • 第22题：

    单选题
    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 Advisor

    B

    Segment Advisor

    C

    SQL Access Advisor

    D

    Automatic Workload Repository （AWR）

    E

    Automatic Database Diagnostic Monitor （ADDM）


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

  • 第23题：

    单选题
    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 PCTUSED

    B

    Decreasing PCTFREE

    C

    Increasing the number of DBWN process

    D

    Using Automatic Segment Space Management (ASSM)

    E

    Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation


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

  • 第24题：

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


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

相关内容