AWR Hub
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. Every Oracle Database has a built-in AWR repository that stores AWR data. AWR data contains important performance statistics about the Oracle Database and can be used for Oracle Database performance, diagnostics, and tuning.
Ops Insights provides AWR Snapshot Collection for recent AWR analysis through AWR Explorer. Snapshots are stored in the Ops Insights data store and retained for 30 days by default; retention for one database can be increased to 92 days. For longer retention across multiple databases, use a Bring Your Own Warehouse. AWR Snapshot Collection supports 19c databases configured for Private Endpoint telemetry, including CDBs. A Bring Your Own Warehouse integrates with Autonomous AI Lakehouse resources to provide optional long-term AWR data retention and direct Oracle Database access through standard clients and tools.
With AWR Hub, you can:
- Analyze recent AWR data in easy-to-interpret charts, identify performance trends, and investigate issues without switching between hourly AWR reports.
- Track and analyze SQL plan changes for workloads within a single database.
- Generate AWR, SQL Health Check, and ASH reports for selected snapshots.
- Offload AWR snapshot storage with built-in 30-day retention, so you can analyze recent performance in AWR Explorer while using a lower AWR retention setting on your databases.
- Use a Bring Your Own Warehouse to retain AWR snapshots for longer-term history (up to 25 months), analyze SQL plans, compare AWR data across multiple databases, and create custom dashboards in AWR Data Explorer using data from databases that send AWR snapshots to the warehouse.
For more information, see: