Different Plan Hash Value due to Migration from Solaris to Linux Causing SQL Performance Analyzer to Report Incorrect Plan Changes
(Doc ID 2065831.1)
Last updated on SEPTEMBER 14, 2023
Applies to:Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 10.2.0.5 and later
Information in this document applies to any platform.
- The SQL ID and explain plan remains the same but the plan hash value changes when changing the platform
- This can cause SQL Performance Analyzer (SPA) to report incorrect plan changes due to wrong plan hash value calculation
- Here is a following example after migrating from Sun Soloris to Linux showing different hash value:
Moved from one platform to another.
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