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 Exascale Infrastructure (ExaDB-XS) provides a cloud service experience similar to ExaDB-D, but without requiring you to subscribe to dedicated infrastructure.
  • 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, ExaDB-D, and ExaDB-XS 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 AI Databases: Easy-to-use, fully autonomous (self-governing) databases that scale elastically, deliver fast query performance, require no database administration, and are available for serverless, dedicated, or Exadata Cloud@Customer (ExaDB-C@C) deployments.
  Note
  
  In the Database Management documentation, separate "more information" links to Autonomous AI Database on ExaDB-C@C documentation are not provided. It's recommended that you see the links provided to the Oracle Autonomous AI Database on Dedicated Exadata Infrastructure documentation, which also serves as the authoritative source for the most current guidance on Autonomous AI Database 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 with Oracle Database@Azure using a Database Management private endpoint and then enable Diagnostics & Management. For information, see Video: Enable Diagnostics & Management for databases on Oracle Database@Azure - Part 1 and Video: Enable Diagnostics & Management for databases on Oracle Database@Azure - Part 2.

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.