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 AUGUST 10, 2018
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle 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
Information in this document applies to any platform.
- 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.
Upgrading the database from lower versions to 12.2 and above.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!