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.