Which of the following capabilities does the performance management feature of Database Management Services offer to a managed database?

Database Management Service in Oracle Cloud Infrastructure (OCI) provides robust performance management capabilities for registered Oracle databases. A key capability is AWR Explorer, an interactive graphical tool that extracts, visualizes, and analyzes Automatic Workload Repository (AWR) performance data. It allows database administrators to perform historical trend analysis, compare database performance across different time windows, and identify performance anomalies or workload spikes without manually creating and interpreting text-based AWR reports.

A. Database Management provides monitoring and diagnostic capabilities, but it does not automatically invoke full object statistics gathering to resolve regressed SQL queries.
C. Although administrators can view and manually adjust initialization parameters via Database Management, the service does not autonomously or dynamically modify parameters to optimize performance.

1. Oracle Cloud Infrastructure Documentation, "Use AWR Explorer to Analyze Database Performance," OCI Observability and Management - Database Management.

2. Oracle Cloud Infrastructure Documentation, "Database Management Concepts and Features," Section: Database Performance Management.

3. Oracle Cloud Infrastructure Documentation, "Analyze Real-Time and Historical Performance with Database Management."