Database Insights provides on-demand analysis for RDS for Oracle

Amazon CloudWatch Database Insights expands the availability of its on-demand analysis experience to the RDS for Oracle database engine. This feature leverages machine learning models to help identify performance bottlenecks during the selected time period, and gives advice on what to do next.

This launch allows you to analyze database performance monitoring data for a time period of your choice. You can learn how the selected time period differs from normal, what went wrong, and get advice on corrective actions. Through simple-to-understand graphs and explanations, you can identify the chief contributors to performance issues. You will also get guidance on the next steps to act on these issues. This can reduce the mean-time-to-diagnosis for database performance issues from hours to minutes.

You can get started with this feature by enabling the Advanced mode of Database Insights on your RDS for Oracle databases using the RDS service console, AWS APIs, the AWS SDK, or AWS CloudFormation. Please refer to RDS documentation and Aurora documentation for information regarding the availability of this feature across different regions, engines and instance classes.

CloudWatch Database Insights delivers database health monitoring aggregated at the fleet level, as well as instance-level dashboards for detailed database and SQL query analysis. It is available in all AWS regions and offers vCPU-based pricing – see the pricing page for details. For further information, visit the Database Insights User Guide.