Global AWR Report Is Showing 'Foreground Wait Classes' Details Incorrectly
(Doc ID 2186826.1)
Last updated on MARCH 03, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterOracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
- When generating a Global AWR report for RAC, the details for the Network Class, Concurrency Class and Configuration Class are mixed up in the Foreground Wait Classes section of the report:
Running the following sql shows the columns are incorrect:
The values under the Network Class column are actually the Concurrency class waits.
The values under the Concurrency Class column are actually the Configuration class waits.
The values under the Configuration Class column are actually the Network Class waits.
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 |
Cause |
Solution |
References |