AWR Report Generation Takes Long Time To Complete
Last updated on MAY 30, 2018
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [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 126.96.36.199.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms