Performance degradation of sql due to 'row chaining' and causing more 'consitent reads'
(Doc ID 2796931.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.5 to 21.1 [Release 10.1 to 21.0]Information in this document applies to any platform.
Symptoms
SQL with same execution plan was running in 3 to 5 mins in UAT environment , whereas in PROD it was completing within 10 secs.
Data was same. Execution plan was same. However, UAT env had atleast 10x times more consistent reads compared to PROD env for the SQL.
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 |