Troubleshooting: High Version Count Issues
(Doc ID 296377.1)
Last updated on FEBRUARY 03, 2019
Applies to: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 Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
This Troubleshooting Guide is provided to assist in debugging SQL sharing issues. When possible, diagnostic tools are included in the document to assist in troubleshooting problems. This document does not contain bugs/patches as these topics are addressed in the articles referenced at the bottom of this document.
Ask Questions, Get Help, And Share Your Experiences With This Article
Would you like to explore this topic further with other Oracle Customers, Oracle Employees, and Industry Experts?
Click here to join the discussion where you can ask questions, get help from others, and share your experiences with this specific article.
Discover discussions about other articles and helpful subjects by clicking here to access the main My Oracle Support Community page for Database Tuning.
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
|Ask Questions, Get Help, And Share Your Experiences With This Article|
|What is a 'High' Version Count?|
|What is shared SQL ?|
|What is 'SQL Metadata'?|
|Why should I be concerned about 'High' Versions?|
|How do I see the versions and why they are not shared ?|
|What do the reasons given in v$SQL_SHARED_CURSOR mean?|
|What further tracing is available.|
|Are there any times when a high version count is expected even though BINDS are being used?|
|Enhancement to obsolete parent cursors if Version Count exceeds a threshold|
|High Version Count with Adaptive Cursor Sharing|
|Troubleshooting Other Issues|
|Discuss High Version Count Issues|