网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “单选题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.” 相关考题
考题
You create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode_task. To view the ADDM report, you use the following command:You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT‘s segments.What would you do to achieve this?（）A. Add a finding directive for the ADDM task.B. Add a segment directive for the ADDM task.C. Add a parameter directive for the ADDM task.D. Disable the Segment Advisor from the Automatic Maintenance Task.
考题
You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time.How would you accomplish this task?（）A. Set metric thresholdB. Implement Database Resource ManagerC. Enable resumable timeout for user sessionsD. Add directives to Automatic Database Diagnostic Monitor (ADDM)
考题
Which two statements are true about the Automatic Database Diagnostic Monitor （ADDM）（）A、The ADDM requires at least four AWR snapshots for analysis.B、The ADDM runs after each AWR snapshot is collected automatically by MMON.C、The results of the ADDM analysis are stored in the Automatic Workload Repository （AWR）.D、The ADDM analysis provides only diagnostic information but does not provide recommendations.E、The ADDM calls other advisors if required， but does not provide recommendations about the advisors.
考题
You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time. How would you accomplish this task?（）A、Set metric thresholdB、Implement Database Resource ManagerC、Enable resumable timeout for user sessionsD、Add directives to Automatic Database Diagnostic Monitor (ADDM)
考题
Which three methods can you use to run an Automatic Database Diagnostic Monitor （ADDM） analysis over a specific time period？（）A、 Enterprise Manager GUIB、 DBMS_TRACE package APIsC、 DBMS_ADVISOR package APIsD、 DBMS_MONITOR package APIsE、 $ORACLE_HOME/rdbms/admin/addmrpt.sql script
考题
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.
考题
In an Oracle 10g database， the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics？（）A、 Recovery catalogB、 Oracle Enterprise Manager RepositoryC、 Automatic Workload Repository （AWR）D、 Oracle 10g Enterprise Manager Grid ControlE、 Automatic Database Diagnostic Monitor （ADDM）
考题
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）
考题
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 AdvisorsB、Segment AdvisorsC、SQL Tuning and Access AdvisorsD、Automated Workload Repository （AWR）E、Automatic Database Diagnostic Monitor （ADDM）
考题
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）
考题
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.
考题
In an Oracle 10g database， the in/x7fmemory statistics are gathered at regular intervals and used to perform growth/x7ftrend analysis and capacity planning of the database. Which component stores these statistics？（）A、recovery catalogB、Oracle Enterprise Manager RepositoryC、Automatic Workload Repository （AWR）D、Oracle 10g Enterprise Manager Grid ControlE、Automatic Database Diagnostic Monitor （ADDM）
考题
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 AdvisorB、run SQL Tuning Advisor on top SQL statementsC、run the Automatic Workload Repository （AWR） reportD、run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements
考题
You create a new Automatic Database Diagnostic Monitor （ADDM） task： instance_analysis_mode_task. To view the ADDM report， you use the following command： SQL SELECT dbms_addm.get_report（’my_instance_analysis_mode_task’） FROM dual； You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT’s segments. What would you do to achieve this？（）A、 Add a finding directive for the ADDM task.B、 Add a segment directive for the ADDM task.C、 Add a parameter directive for the ADDM task.D、 Disable the Segment Advisor from the Automatic Maintenance Task.
考题
单选题In an Oracle 10g database， the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics？（）A
recovery catalogB
Oracle Enterprise Manager RepositoryC
Automatic Workload Repository （AWR）D
Oracle 10g Enterprise Manager Grid ControlE
Automatic Database Diagnostic Monitor （ADDM）
考题
单选题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 AdvisorB
run SQL Tuning Advisor on top SQL statementsC
run the Automatic Workload Repository （AWR） reportD
run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements
考题
单选题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）.
考题
多选题Which two statements are true about the Automatic Database Diagnostic Monitor （ADDM）（）AThe ADDM requires at least four AWR snapshots for analysis.BThe ADDM runs after each AWR snapshot is collected automatically by MMON.CThe results of the ADDM analysis are stored in the Automatic Workload Repository （AWR）.DThe ADDM analysis provides only diagnostic information but does not provide recommendations.EThe ADDM calls other advisors if required， but does not provide recommendations about the advisors.
考题
单选题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 AdvisorB
Segment AdvisorC
SQL Tuning AdvisorD
SQL Access AdvisorE
Automatic Database Diagnostic Monitor （ADDM）
考题
单选题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.
考题
单选题In an Oracle 10g database， the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics？（）A
Recovery catalogB
Oracle Enterprise Manager RepositoryC
Automatic Workload Repository （AWR）D
Oracle 10g Enterprise Manager Grid ControlE
Automatic Database Diagnostic Monitor （ADDM）
考题
单选题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）
考题
单选题You create a new Automatic Database Diagnostic Monitor （ADDM） task： instance_analysis_mode_task. To view the ADDM report， you use the following command： SQL SELECT dbms_addm.get_report（’my_instance_analysis_mode_task’） FROM dual； You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT’s segments. What would you do to achieve this？（）A
Add a finding directive for the ADDM task.B
Add a segment directive for the ADDM task.C
Add a parameter directive for the ADDM task.D
Disable the Segment Advisor from the Automatic Maintenance Task.
考题
单选题You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time. How would you accomplish this task？（）A
Set metric thresholdB
Implement Database Resource ManagerC
Enable resumable timeout for user sessionsD
Add directives to Automatic Database Diagnostic Monitor （ADDM）
考题
单选题You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time. How would you accomplish this task?（）A
Set metric thresholdB
Implement Database Resource ManagerC
Enable resumable timeout for user sessionsD
Add directives to Automatic Database Diagnostic Monitor (ADDM)
考题
单选题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）
考题
单选题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.
考题
单选题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.
热门标签
最新试卷
