AWR Report Generation Takes Long Time To Complete
(Doc ID 2404906.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 12.1]
Information in this document applies to any platform.
- AWR Report generation is encountering performance issues and the report takes a long time to complete (i.e 20 minutes or more with some use cases) in a non-CDB environment.
- Waits on "Disk file Mirror Read" and "control file sequential read" events are observed.
- Even the reports for shorter duration also take long time to finish.
- Collecting fresh statistics for the SYS schema, dictionary and fixed objects does not improve the performance or time to generate the AWR report.
Upgrading the Database to 22.214.171.124.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!