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
    • Exadata Cloud Infrastructure
  • 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 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
    • Exadata Cloud Infrastructure
  • External Databases – 11.2.0.4 and later
  • Oracle Cloud Databases – 11.2.0.4 and later
Linux No
Managed Database – SQL plan management
  • External Databases
  • Oracle Cloud Databases (Full Management option only)
    • Base Database Service
    • Exadata Cloud Infrastructure
  • 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 No
Managed Database – Alert logs
  • External Databases
  • Oracle Cloud Databases (Full Management option only)
    • Base Database Service
    • Exadata Cloud 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)
Linux 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
    • Exadata Cloud Infrastructure
  • External Databases – 11.2.0.4 and later
  • Oracle Cloud Databases – 11.2.0.4 and later
Linux 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
    • Exadata Cloud Infrastructure
  • 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 No
  • Performance Hub – ASH Analytics
  • Performance Hub – SQL Monitoring
  • Performance Hub – AWR report
  • External Databases
  • Oracle Cloud Databases
    • Base Database Service
    • Exadata Cloud Infrastructure
  • 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 No
Performance Hub – Blocking Sessions
  • External Databases
  • Oracle Cloud Databases (Full Management option only)
    • Base Database Service
    • Exadata Cloud Infrastructure
  • 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 No
Performance Hub – ADDM
  • External Databases
  • Oracle Cloud Databases (Full Management option only)
    • Base Database Service
    • Exadata Cloud Infrastructure
  • 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)

Note: Requires ASH version 44 or later.

Linux No
Performance Hub – Workload
  • External Databases
  • Oracle Cloud Databases (Full Management option only)
    • Base Database Service
    • Exadata Cloud Infrastructure
  • 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 No
Performance Hub – Exadata
  • External Databases (Full Management option only)
    • Exadata Infrastructure, CDB root only
  • Oracle Cloud Databases (Full Management option only)
    • Exadata Cloud Infrastructure, 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 No
Performance Hub – Performance Hub report
  • External Databases
  • Oracle Cloud Databases (Full Management option only)
    • Base Database Service
    • Exadata Cloud Infrastructure
  • External Databases – 19c and later (Enterprise Edition only)
  • Oracle Cloud Databases – 19c and later (Enterprise Edition only)
Linux No
Performance Hub – ASH report
  • External Databases
  • Oracle Cloud Databases
    • Base Database Service
    • Exadata Cloud Infrastructure
  • External Databases – 12.2 and later (Enterprise Edition only)
  • Oracle Cloud Databases – 12.2 and later (Enterprise Edition only)
Linux No