Analyze AWR Performance Data

Ops Insights provides Automatic Workload Repository (AWR) Snapshot Collection for recent AWR analysis through AWR Explorer. The service stores these snapshots in the Ops Insights data store.

For longer-term retention across multiple databases, use a Bring Your Own Warehouse. Associate selected databases with the warehouse to retain their AWR snapshots for up to 25 months. AWR Explorer is available for snapshots stored in the Ops Insights data store and in a Bring Your Own Warehouse. AWR Data Explorer is available only for data in a Bring Your Own Warehouse. 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.

If you use an existing AWR Hub Warehouse and need transition instructions, see Migrate Ops Insights Warehouse and AWR Hub to Improved Architecture (Article ID: KB935822).