1. Get Started with Performance Tuning
  2. Reactive Database Tuning
  3. Using Automatic Workload Repository Warehouse for Generating Performance Reports
  4. Using Autonomous Database Warehouse in Automatic Workload Repository

Using Autonomous Database Warehouse in Automatic Workload Repository

Autonomous Data Warehouse (ADW) is supported in AWR Warehouse. The ADW must be discovered as an Enterprise Manager (EM) target. In addition to other AWR information, the user needs to provide for ADW:

  • A Named OCI Credential to access Object Store. This is created in EM.
  • Object Store base URI.
  • Bucket Name.

When the warehouse is ADW, these features are disabled in the AWR dashboard in EM:

  • Edit Warehouse
  • Restore Warehouse if the warehouse is on error state

If the EM does not detect when ADG switch-over has occurred for a database, you can manually restore the source database to the new ADG primary.