My Oracle Support Banner

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 to 21.1 [Release 10.1 to 21.0]
Information in this document applies to any platform.


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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.