External databases use services including Database Management, Operations
Insights, and Application Performance Monitoring for analysis, management, and application
monitoring.
As a database administrator, you can use the Oracle Cloud Infrastructure Database Management service to monitor and manage your Oracle Databases. Database Management supports Oracle Database versions 11.2.0.4 and later. Using Database Management you can:
Monitor the key performance and configuration metrics of your fleet of Oracle Databases. You can also compare and analyze database metrics over a selected period of time.
Group your critical Oracle Databases, which reside across compartments into a Database Group, and monitor them.
Create SQL jobs to perform administrative operations on a single Oracle Database or a Database Group.
Use Performance Hub to monitor database performance and diagnose performance issues such as determining the causes of wait time, performance degradation, and changes in database performance.
Operations Insights provides 360-degree insight into the resource usage and capacity of databases and hosts. You can easily analyze CPU and storage resources, forecast capacity issues, and proactively identify SQL performance issues across your database fleet. Operations Insights can be enabled for external pluggable database and non-container database resources.
By enabling Stack Monitoring for your external database, you can get
real-time information about the performance of your applications. This enables you
to diagnose issues quickly across your software stack. You can set up dashboards to
visualize, explore, and analyze application data in charts. The service also enables
you to collect and upload key application metrics for use in creating notifications
and alarms.