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 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

Here are some notes pertaining to the availability of the Diagnostics & Monitoring features for Autonomous Databases:
  • If you enabled Diagnostics & Management for Autonomous Databases in Database Management prior to the availability of the advanced monitoring support or on the Autonomous Database details page, some of the Diagnostics & Management features listed in the following table may not be available for Autonomous Databases. To enable and use these features for Autonomous Databases, you must provide the connection information in the Edit Database Management panel. For more information, see Enable Diagnostics & Management for Autonomous Databases.
  • It's recommended that you set the Advanced diagnostics preferred credential to use the ADMIN user, or set the session credential to use the ADMIN user. This is because some of the advanced monitoring and management features like Performance Hub require additional privileges, which the ADBSNMP user does not have.
  • Performance Hub for Autonomous Databases can also be accessed from the Autonomous Database details page, however, the following advanced features are only available when Performance Hub is accessed from the Managed database details page in Database Management:
    • Top Activity Lite
    • Activity Session History (ASH) report
    • Instance-level AWR report
    • On-demand Automatic Database Diagnostic Monitor (ADDM) task runs
    • SQL tuning
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, a part of the functionality in 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 are not available.
  • 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*
  • Performance Hub – ASH Analytics
  • Performance Hub – SQL Monitoring
  • Performance Hub – AWR report
  • 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 (Full Management option only)
    • 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
    • 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*

* 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.