Troubleshooting: Missing Automatic Workload Repository (AWR) Snapshots and Other Collection Issues
(Doc ID 1301503.1)
Last updated on MAY 10, 2023
Applies to:
Oracle Cloud Infrastructure - Database Service - Version N/A and later Oracle Database Exadata Express Cloud Service - Version N/A and later Oracle Database Backup Service - Version N/A and later Oracle Database Cloud Exadata Service - Version N/A and later Oracle Database Cloud Schema Service - Version N/A and later Information in this document applies to any platform.
Oracle RDBMS Automatic Workload Repository
Purpose
The purpose of this document is to describe the diagnostic data that can be collected and the corrective steps that can be taken when encountering issues with slow, hung or missing AWR snapshots.
AWR snapshots may fail to create for a number of reasons, the main two being: