The Oracle Database Automatic Workload Repository (AWR) collects, processes, and maintains performance statistics for the database that can later be displayed in both reports and views. A built-in AWR repository, that exists in every Oracle Database, stores this data. AWR data contains important performance statistics about the Oracle Database and can be used for Oracle Database performance, diagnostics, and tuning.

To handle AWR data from multiple databases, Ops Insights provides AWR Hub, a cloud-based repository that collects and consolidates AWR snapshots from multiple databases in your OCI tenancy.

With AWR Hub, you can:

• Track and analyze SQL plan changes for workloads within a single database
• Track and analyze SQL plan changes for workloads across multiple databases
• Understand past and present workload (SQL) performance over a period of two years or above.
• Build custom dashboards to plot SQL performance statistics, database waits, CPU usage history, connections established, etc.

For more information see: Analyze Automatic Workload Repository (AWR) Performance Data.