Diagnostics & Management for Oracle Databases
As a Database Administrator, you can use Diagnostics & Management in the Oracle Cloud Infrastructure Database Management service to monitor and manage Oracle Databases.
Diagnostics & Management is available for the following Oracle Databases:
- External Databases: Oracle Databases located outside of Oracle Cloud Infrastructure and connected to a resource in the External Database service.
- Oracle Cloud Databases: Oracle Databases running on the
following Oracle Database cloud solutions:
- Oracle Base Database Service offers database systems (DB systems) on virtual machines. These DB systems are available as single-node DB systems and multi-node RAC DB systems.
- Oracle Exadata Database Service on Dedicated Infrastructure (ExaDB-D or Exadata Cloud Infrastructure) enables you to run Oracle Database workloads in the cloud and leverage the power of Exadata in the cloud.
- Oracle Exadata Database Service on Cloud@Customer (ExaDB-C@C) enables you to apply the combined power of Oracle Exadata and Oracle Cloud Infrastructure inside your own data center.
Note
Diagnostics & Management features for Oracle Cloud Databases in the Base Database Service and ExaDB-D are available as part of the Full management and Basic management options. The Basic management option is not available for Oracle Cloud Databases in ExaDB-C@C. For more information on management options, see About Management Options. - Oracle Autonomous Databases: Easy-to-use, fully autonomous
database that scales elastically, delivers fast query performance, requires no
database administration, and is available for serverless or dedicated
deployments.
Note
Diagnostics & Management features are currently not available for Autonomous Databases on ExaDB-C@C. - Multicloud Databases: Multicloud adoption allows businesses to
harness the strengths of different cloud platforms while mitigating risks. However,
monitoring and managing databases in a multicloud environment introduces unique
challenges, requiring specialized approaches and solutions. You can use Diagnostics
& Management features to monitor and manage Oracle Databases running on the
following cloud platforms:
- Oracle Databases running on AWS RDS: You can discover the Oracle Databases on AWS RDS as External Databases and enable Diagnostics & Management. For information, see Set Up OCI Observability and Management for AWS RDS Databases.
- Oracle Database@Azure: You can enable communication between Database Management and Oracle Database@Azure using a private endpoint and then enable Diagnostics & Management. For information, see Create a Database Management Private Endpoint for Oracle Cloud Databases and Enable Diagnostics & Management for Oracle Cloud Databases.
For information on these Oracle Cloud Infrastructure Database services, supported Oracle Database versions and editions, see Database documentation.
Using Diagnostics & Management, you can monitor single instance and RAC databases, which include Container Databases (CDBs), Pluggable Databases (PDBs), and Non-Container Databases (Non-CDBs). This feature set is available for Oracle Database version 11.2.0.4 and later. You can also use Diagnostics & Management to monitor and manage the primary and standby databases that are a part of an Oracle Data Guard configuration. For information on Diagnostics & Management feature availability for database types and versions, see Diagnostics & Management Feature Support Matrix for Oracle Databases.
Here are some of the important tasks you can perform using Diagnostics & Management features:
- 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.
- Use Performance Hub for a single-pane-of-glass view of database performance, which enables you to quickly diagnose performance issues.
- Use AWR Explorer to visualize historical performance data from AWR snapshots in easy-to-interpret charts.
- Use the other available Diagnostics & Management features to monitor, manage, and administer a single Oracle Database.
- Use dashboards to visualize, explore and analyze database performance metrics.