Oracle Cloud Infrastructure Documentation

Database Management Feature Support Matrix for Oracle Databases

This section provides the Database 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.

Database Management Features Supported Deployment Types Supported Database Versions Supported Platforms Available for Standby Databases (Yes/No)
  • 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*
 No
  • 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
  • External Databases – 11.2.0.4 and later
  • Oracle Cloud Databases – 11.2.0.4 and later
  • Linux
  • IBM AIX*
 No
Managed Database – SQL plan management
  • External Databases
  • Oracle Cloud Databases (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
Note:
  • 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*
 No
Managed Database – Alert logs
  • External Databases
  • Oracle Cloud Databases (Full Management option only)
    • Base Database Service
    • ExaDB-D
    • ExaDB-C@C
  • 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)
  • Linux
  • IBM AIX*
 No
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*
 No
  • 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
  • External Databases – 12.2 and later (Enterprise Edition only)
  • Oracle Cloud Databases – 12.2 and later (Enterprise Edition only)

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.

  • Linux
  • IBM AIX*
 No
  • 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*
 No
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*
 No
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*
 No
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*
 No
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*
 No
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*
 No
Performance Hub – ASH report
  • External Databases
  • Oracle Cloud Databases
    • 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*
 No

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