SQL_ID GFPH31UMZHMXW is Causing AWR Report Generation to Run Long
(Doc ID 2565465.1)
Last updated on JANUARY 15, 2021
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
- Customers may report longer wait times to generate an AWR report due to the sub optimally written query GFPH31UMZHMXW
This is due to the changes in AWR generation starting in 188.8.131.52 that allows for the creation of such report at a pluggable level, vs container level report, which changed how latch information is aggregated.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document