• Description: New Features for Oracle8i OCPs
• Passing Score: 0%
• Practice Test - Number of questions: 186 questions
• Simulation Test - Number of questions: 186 questions
• Simulation Test Duration: 120 minutes
• Has explanations: Yes

The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database if 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?

Answer(s)

1. Create two custom ADDM tasks.
2. Modify the AWR snapshot time interval to two hours.
3. Create a new scheduler window for a time period of two hours.
4. Modify the time interval by using the DBMS_JOB.INTERVAL procedure.
5. Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours.

Modify the AWR snapshot time interval to two hours.