Create two custom ADDM tasks.
Modify the AWR snapshot time interval to two hours.
Create a new scheduler window for a time period of two hours.
Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours.
第1题:
Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)()
第2题:
Which three methods can you use to run an Automatic Database Diagnostic Monitor (ADDM) analysis over a specific time period?()
第3题:
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.
第4题:
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?()
第5题:
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?()
第6题:
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?()
第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?()
第8题:
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 threshold
B. Implement Database Resource Manager
C. Enable resumable timeout for user sessions
D. Add directives to Automatic Database Diagnostic Monitor (ADDM)
第9题:
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?()
第10题:
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?()