Oracle Database 12c: Performance Management and Tuning — Question 2

You want to capture AWR data to monitor performance variation every Monday between 9:00 AM and 12:00 PM for three months and automatically remove the older AWR data every fortnight.
How would you achieve this? (Choose the best answer.)

Answer options

• A. Create AWR baselines.
• B. Create SQL plan baselines.
• C. Create repeating baseline templates.
• D. Create database services and make sure that user connections use them to connect to the database instance.
• E. Create a single baseline template.

Correct answer: D

Explanation

The correct answer is D because creating database services allows for the management of user connections and can help automate the monitoring of AWR data during specified times. The other options do not address the requirement for capturing AWR data at specific intervals or managing data retention effectively.