AWR Snapshot Collection and Bring Your Own Warehouse

Ops Insights now provides AWR Snapshot Collection to collect and analyze recent database performance data through AWR Explorer. The feature supports eligible Oracle Database 19c and later databases configured for Private Endpoint telemetry, including CDBs. Snapshots are retained for 30 days by default, with retention for an individual database configurable up to 92 days.

For longer retention, you can use Bring Your Own Warehouse to retain snapshots from selected databases for up to 25 months. Bring Your Own Warehouse integrates with Autonomous AI Lakehouse resources and supports analysis through AWR Explorer and AWR Data Explorer, along with direct Oracle Database access through standard clients and tools.

For more information, see Analyze AWR Performance Data.