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

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

相似考题

1.Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.()A. Change in the Oracle Database versionB. Change in your network infrastructureC. Change in the hardware configuration of the database serverD. Migration of database storage from non-ASM to ASM storageE. Database and operating system upgrade

2.You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.Which method or feature should you use?()A. Compare Period ADDM reportB. AWR Compare Period reportC. Active Session History (ASH) reportD. Taking a new snapshot and comparing it with a preserved snapshot

3.You find today’s performance of your production database to be the best ever. Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（）A、create baseline metrics for today’s performanceB、write the current database metrics to a database table and create a trigger to compare with future database statisticsC、write the current database metrics to a flat file and create an operating script to compare with future database statisticsD、write the current database metrics to a database table and create a procedure to compare with future database statisticsE、write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics

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

更多“多选题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. Whi”相关问题

  • 第1题：

    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）

    正确答案:A

  • 第2题：

    You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?（）

    • A、Compare Period ADDM report
    • B、AWR Compare Period report
    • C、Active Session History (ASH) report
    • D、Taking a new snapshot and comparing it with a preserved snapshot

    正确答案: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题：

    The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile， and statistics to diagnose the possible causes of the performance degradation？（）

    • A、by using the SQL access advisor
    • B、by using the Automatic Workload Repository report
    • C、by running the Automatic Database Diagnostic Monitor （ADDM）
    • D、by using the Automatic Workload Repository Compare Period report
    • E、by analyzing the output of the V$ACTIVE_SESSION_HISTORY view

    正确答案:D

  • 第5题：

    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

  • 第6题：

    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

  • 第7题：

    单选题
    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
    解析： 暂无解析

  • 第8题：

    单选题
    You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?（）
    A

    Compare Period ADDM report

    B

    AWR Compare Period report

    C

    Active Session History (ASH) report

    D

    Taking a new snapshot and comparing it with a preserved snapshot


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

  • 第9题：

    单选题
    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
    解析： 暂无解析

  • 第10题：

    多选题
    Which three methods can you use to run an Automatic Database Diagnostic Monitor （ADDM） analysis over a specific time period？（）
    A

    Enterprise Manager GUI

    B

    DBMS_TRACE package APIs

    C

    DBMS_ADVISOR package APIs

    D

    DBMS_MONITOR package APIs

    E

    $ORACLE_HOME/rdbms/admin/addmrpt.sql script


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

  • 第11题：

    单选题
    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
    解析： 暂无解析

  • 第12题：

    单选题
    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
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database12c. Your database supports a mixed workload. During the day, lots of insert, update, and deleteoperations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions.After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause ofperformance degradation, you want to collect basic statistics such as the level of parallelism, totaldatabase time, and the number of I/O requests for the ETL jobs. How do you accomplish this?（）

    • A、Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.
    • B、Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.
    • C、Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view.
    • D、Enable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required information.

    正确答案:D

  • 第15题：

    You notice that the performance of your production 24/7 Oracle database significantly degraded.Sometimes you are not able to connect to the instance because it hangs. You do not want to restart thedatabase instance.How can you detect the cause of the degraded performance?（）

    • A、Enable Memory Access Mode, which reads performance data from SGA.
    • B、Use emergency monitoring to fetch data directly from SGA analysis.
    • C、Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
    • D、Use Active Session History (ASH) data and hang analysis in regular performance monitoring.
    • E、Run ADDM in diagnostic mode.

    正确答案:B

  • 第16题：

    You are maintaining your database in Oracle10g. While performing an incremental backup of the database， you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database？（）

    • A、 redo log files
    • B、 password file
    • C、 control file
    • D、 change tracking file

    正确答案:D

  • 第17题：

    Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.（）

    • A、Change in the Oracle Database version
    • B、Change in your network infrastructure
    • C、Change in the hardware configuration of the database server
    • D、Migration of database storage from non-ASM to ASM storage
    • E、Database and operating system upgrade

    正确答案:A,C,E

  • 第18题：

    单选题
    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
    解析： 暂无解析

  • 第19题：

    单选题
    The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile， and statistics to diagnose the possible causes of the performance degradation？（）
    A

    by using the SQL access advisor

    B

    by using the Automatic Workload Repository report

    C

    by running the Automatic Database Diagnostic Monitor （ADDM）

    D

    by using the Automatic Workload Repository Compare Period report

    E

    by analyzing the output of the V$ACTIVE_SESSION_HISTORY view


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

  • 第20题：

    单选题
    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
    解析： 暂无解析

  • 第21题：

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


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

  • 第22题：

    单选题
    You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?（）
    A

    Compare Period ADDM report

    B

    AWR Compare Period report

    C

    Active Session History (ASH) report

    D

    Taking a new snapshot and comparing it with a preserved snapshot


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

  • 第23题：

    单选题
    You are maintaining your database in Oracle10g. While performing an incremental backup of the database， you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database？（）
    A

     redo log files

    B

     password file

    C

     control file

    D

     change tracking file


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

  • 第24题：

    多选题
    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
    解析： 暂无解析

相关内容