My Oracle Support Banner

Troubleshooting: High Version Count Issues (Doc ID 296377.1)

Last updated on JULY 15, 2022

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database 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
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.

Troubleshooting Steps

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
Troubleshooting Steps
 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?
 Version_rpt script:
 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
 Known Issues
 Troubleshooting Other Issues
 Discuss High Version Count Issues

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