SQL_ID GFPH31UMZHMXW is Causing AWR Report Generation to Run Long
(Doc ID 2565465.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
- Customers may report longer wait times to generate an AWR report due to the sub optimally written query GFPH31UMZHMXW
Changes
This is due to the changes in AWR generation starting in 12.2.0.1 that allows for the creation of such report at a pluggable level, vs container level report, which changed how latch information is aggregated.
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |