High Version Counts For SQL Statements (>1024) Post Upgrade To 12.2 and Above Causing Database Slow Performance
(Doc ID 2431353.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database Backup Service - Version N/A and laterOracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
- Slow Database Performance post upgrade to 12.2.
- High waits for "cursor: mutex X" or "cursor: mutex S" or "cursor: pin S wait on X" found after upgrade to 12.2.
- High parse time (soft/hard) observed post upgrade.
- Version counts for the SQLs are consistently above 1024.
- Too many reloads in SQL Area due to space pressure in shared pool due to excessive child cursors created.
- AMM or ASMM shows growth trend for shared pool causing extreme memory pressure in SGA.
Changes
Upgrading the database from lower versions to 12.2 and above.
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 |