Oracle Cloud Infrastructure Documentation

Diagnostics & Management Feature Support Matrix for Oracle Databases

This section provides the Database Management Diagnostics & Management feature support matrix for Oracle Databases.

For detailed information on each of these features, see Monitor and Manage a Specific Managed Database and Performance Hub Features and Reports.

Note

For Oracle Cloud Databases, Database Management only supports the monitoring and management of PDBs for Oracle Database version 19c and later.
Note

For External Databases and Oracle Cloud Databases version 11.2.0.4 and later, you can use Diagnostics & Management features in Database Management to monitor and manage the primary and standby databases that are a part of an Oracle Data Guard configuration. You can use all the features listed in the table below for primary databases, however, for standby databases, you can only perform read-only tasks if the database is in read-only mode. Also, note that Database Management currently does not support the monitoring of Data Guard per Pluggable Database (DGPDB).
Note

To use all the available Diagnostics & Monitoring features for Autonomous Databases, including advanced Performance Hub features, namely Top Activity Lite, Activity Session History and Instance-level AWR reports, On-demand ADDM task runs, and SQL tuning, you must ensure that:
  • Database Management Diagnostics & Management is enabled. If you enabled Diagnostics & Management for Autonomous Databases prior to September 2024, then you must edit Database Management and update connection information. For information, see Enable Diagnostics & Management for Autonomous Databases.
  • The Advanced diagnostics preferred credential or the session credential is set to use the ADMIN user. This is a mandatory requirement for advanced Performance Hub features and certain other advanced monitoring and management features.
Diagnostics & Management Features Supported Deployment Types Supported Database Versions Supported Platforms
  • Fleet summary
  • Managed Database – summary
  • Database groups
  • Alarm definitions
  • Dashboards
  • External Databases
  • Oracle Cloud Databases (Full Management option only)
    • Base Database Service
    • ExaDB-D
    • ExaDB-C@C
  • Autonomous Databases
    • Serverless
    • Dedicated Infrastructure
  • External Databases – 11.2.0.4 and later
  • Oracle Cloud Databases – 11.2.0.4 and later
  • Autonomous Databases – All versions
  • Linux
  • IBM AIX*
  • Managed Database – SQL tuning sets
  • Managed Database – Optimizer statistics summary
  • Managed Database – Tablespaces
  • Managed Database – Users
  • Managed Database – Database parameters
  • Managed Database – Jobs
  • Managed Database – Preferred credentials
  • Managed Database – Named credentials
  • External Databases
  • Oracle Cloud Databases (Full Management option only)
    • Base Database Service
    • ExaDB-D
    • ExaDB-C@C
  • Autonomous Databases
    • Serverless
    • Dedicated Infrastructure
  • External Databases – 11.2.0.4 and later
  • Oracle Cloud Databases – 11.2.0.4 and later
  • Autonomous Databases – 19c and later

Note: For Autonomous Databases, some part of the following features is not available:

  • Tablespaces
  • Database parameters
  • Linux
  • IBM AIX*
Managed Database – SQL plan management
  • External Databases
  • Oracle Cloud Databases (Full Management option only)
    • Base Database Service
    • ExaDB-D
    • ExaDB-C@C
  • Autonomous Databases
    • Serverless
    • Dedicated Infrastructure
  • External Databases – 11.2.0.4 and later
  • Oracle Cloud Databases – 11.2.0.4 and later
  • Autonomous Databases – 19c and later
Note:
  • For Autonomous Databases, SQL plan management configuration tasks cannot be performed.
  • Support for loading SQL plans from AWR is only available for Oracle Databases version 12.2 and later.
  • Automatic SPM Evolve Advisor task is only available for Oracle Databases version 12.2 and later.
  • Selective plan capturing (filters) is only available for Oracle Databases version 12.2 and later.
  • High-frequency Automatic SPM Evolve Advisor task is only available for Oracle Databases 19c and later running on the Oracle Exadata platform.
  • Linux
  • IBM AIX*
Managed Database – Cluster cache
  • External Databases – RAC CDBs and Non-CDBs
  • Oracle Cloud Databases – RAC CDBs and Non-CDBs (Full Management option only)
    • Base Database Service
    • ExaDB-D
    • ExaDB-C@C
  • External Databases – 11.2.0.4 and later
  • Oracle Cloud Databases – 11.2.0.4 and later
  • Linux
  • IBM AIX*
Managed Database – Metric Extensions External Databases 11.2.0.4 and later
  • Linux
  • IBM AIX*
Managed Database – Alert logs
  • External Databases
  • Oracle Cloud Databases (Full Management option only)
    • Base Database Service
    • ExaDB-D
    • ExaDB-C@C
  • Autonomous Databases
    • Serverless
    • Dedicated Infrastructure
  • External Databases – 12.2 and later for Alert Log and External Databases – 21c and later for Attention Log (Enterprise Edition only)
  • Oracle Cloud Databases – 12.2 and later for Alert Log and Oracle Cloud Databases – 21c and later for Attention Log (Enterprise Edition only)
  • Autonomous Databases – 19c and later

Note: For Autonomous Databases, Attention log is not available.

  • Linux
  • IBM AIX*
  • Managed Database – AWR Explorer
  • Managed Database – SQL Tuning Advisor
  • Managed Database – Optimizer Statistics Advisor
  • External Databases
  • Oracle Cloud Databases (Full Management option only)
    • Base Database Service
    • ExaDB-D
    • ExaDB-C@C
  • Autonomous Databases
    • Serverless
    • Dedicated Infrastructure
  • External Databases – 12.2 and later (Enterprise Edition only)
  • Oracle Cloud Databases – 12.2 and later (Enterprise Edition only)
  • Autonomous Databases – 19c and later
Note:
  • To use AWR Explorer and SQL Tuning Advisor, you must ensure that if the COMPATIBLE initialization parameter is set for the database, then it should match version 12.2.0 and later.
  • For Autonomous Databases, Optimizer Statistics Advisor is disabled by default.
  • Linux
  • IBM AIX*
Managed Database – Search sessions
  • External Databases
  • Oracle Cloud Databases (Full Management option only)
    • Base Database Service
    • ExaDB-D
    • ExaDB-C@C
  • External Databases – 12.2 and later (Enterprise Edition only)
  • Oracle Cloud Databases – 12.2 and later (Enterprise Edition only)
  • Linux
  • IBM AIX*
  • Performance Hub – ASH Analytics
  • Performance Hub – SQL Monitoring
  • External Databases
  • Oracle Cloud Databases
    • Base Database Service
    • ExaDB-D
    • ExaDB-C@C
  • Autonomous Databases
    • Serverless
    • Dedicated Infrastructure
  • External Databases – 12.1 and later (Enterprise Edition only)
  • Oracle Cloud Databases – 12.1 and later (Enterprise Edition only)
  • Autonomous Databases – 12.1 and later (Enterprise Edition only)
  • Linux
  • IBM AIX*
Performance Hub – Blocking Sessions
  • External Databases
  • Oracle Cloud Databases (Full Management option only)
    • Base Database Service
    • ExaDB-D
    • ExaDB-C@C
  • Autonomous Databases
    • Serverless
    • Dedicated Infrastructure
  • External Databases – 12.2 and later (Enterprise Edition only)
  • Oracle Cloud Databases – 12.2 and later (Enterprise Edition only)
  • Autonomous Databases – 12.2 and later (Enterprise Edition only)
  • Linux
  • IBM AIX*
Performance Hub – ADDM
  • External Databases
  • Oracle Cloud Databases (Full Management option only)
    • Base Database Service
    • ExaDB-D
    • ExaDB-C@C
  • Autonomous Databases
    • Serverless
    • Dedicated Infrastructure
  • External Databases – 19c and later (Enterprise Edition only)
  • Oracle Cloud Databases – 19c and later (Enterprise Edition only)
  • Autonomous Databases – 19c and later (Enterprise Edition only)
  • Linux
  • IBM AIX*
Performance Hub – Workload
  • External Databases
  • Oracle Cloud Databases (Full Management option only)
    • Base Database Service
    • ExaDB-D
    • ExaDB-C@C
  • Autonomous Databases
    • Serverless
    • Dedicated Infrastructure
  • External Databases – 21c and later (Enterprise Edition only)
  • Oracle Cloud Databases – 21c and later (Enterprise Edition only)
  • Autonomous Databases
    • Serverless – 18c and later (Enterprise Edition only)
    • Dedicated Infrastructure – 19.8 and later (Enterprise Edition only)
  • Linux
  • IBM AIX*
Performance Hub – Top Activity Lite
  • External Databases
  • Oracle Cloud Databases (Full Management option only)
    • Base Database Service
    • ExaDB-D
    • ExaDB-C@C
  • Autonomous Databases
    • Serverless
    • Dedicated Infrastructure
  • External Databases – 12.1 and later (Enterprise Edition only)
  • Oracle Cloud Databases – 12.1 and later (Enterprise Edition only)
  • Autonomous Databases – 12.1 and later (Enterprise Edition only)
  
Performance Hub – Exadata
  • External Databases
    • Exadata Infrastructure, CDB root only
  • Oracle Cloud Databases (Full Management option only)
    • ExaDB-D, CDB root only
    • ExaDB-C@C, CDB root only
  • External Databases – 12.1.0.2 and later (Enterprise Edition only)
  • Oracle Cloud Databases – 12.1.0.2 and later (Enterprise Edition only)
  • Linux
  • IBM AIX*
Performance Hub – Performance Hub report
  • External Databases
  • Oracle Cloud Databases (Full Management option only)
    • Base Database Service
    • ExaDB-D
    • ExaDB-C@C
  • External Databases – 19c and later (Enterprise Edition only)
  • Oracle Cloud Databases – 19c and later (Enterprise Edition only)
  • Linux
  • IBM AIX*
Performance Hub – ASH report
  • External Databases
  • Oracle Cloud Databases (Full Management option only)
    • Base Database Service
    • ExaDB-D
    • ExaDB-C@C
  • Autonomous Databases
    • Serverless
    • Dedicated Infrastructure
  • External Databases – 12.2 and later (Enterprise Edition only)
  • Oracle Cloud Databases – 12.2 and later (Enterprise Edition only)
  • Autonomous Databases – 19c and later
  • Linux
  • IBM AIX*
Performance Hub – AWR report
  • External Databases
  • Oracle Cloud Databases (Full Management option only)
    • Base Database Service
    • ExaDB-D
    • ExaDB-C@C
  • Autonomous Databases
    • Serverless
    • Dedicated Infrastructure
  • External Databases – 12.1 and later (Enterprise Edition only)
  • Oracle Cloud Databases – 12.1 and later (Enterprise Edition only)
  • Autonomous Databases – 19c and later
  • Linux
  • IBM AIX*

* IBM AIX is only supported for External Databases in Database Management. For information on the additional Management Agent-related prerequisite tasks that must be performed to monitor and manage External Databases on IBM AIX, see OCI Database Management Service: Support for Database Management on AIX (Doc ID 3015022.1) in My Oracle Support.