Troubleshooting: High Version Count Issues (Doc ID 296377.1)

Last updated on FEBRUARY 09, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 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.

Purpose

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

In this Document

Sign In

To view full details, sign in with your My Oracle Support account.

Register

Don't have a My Oracle Support account? Click to get started!

Purpose

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?

U NBOUND_CURSOR

S QL_TYPE_MISMATCH

** O PTIMIZER_MISMATCH

O UTLINE_MISMATCH

S TATS_ROW_MISMATCH

L ITERAL_MISMATCH

S EC_DEPTH_MISMATCH

E XPLAIN_PLAN_CURSOR

B UFFERED_DML_MISMATCH

P DML_ENV_MISMATCH

I NST_DRTLD_MISMATCH

S LAVE_QC_MISMATCH

T YPECHECK_MISMATCH

A UTH_CHECK_MISMATCH

** B IND_MISMATCH

D ESCRIBE_MISMATCH

L ANGUAGE_MISMATCH

T RANSLATION_MISMATCH

R OW_LEVEL_SEC_MISMATCH

I NSUFF_PRIVS

I NSUFF_PRIVS_REM

R EMOTE_TRANS_MISMATCH

L OGMINER_SESSION_MISMATCH

I NCOMP_LTRL_MISMATCH

O VERLAP_TIME_MISMATCH

S QL_REDIRECT_MISMATCH

M V_QUERY_GEN_MISMATCH

U SER_BIND_PEEK_MISMATCH

T YPCHK_DEP_MISMATCH

N O_TRIGGER_MISMATCH

F LASHBACK_CURSOR

A NYDATA_TRANSFORMATION

I NCOMPLETE_CURSOR

T OP_LEVEL_RPI_CURSOR

D IFFERENT_LONG_LENGTH

L OGICAL_STANDBY_APPLY

D IFF_CALL_DURN

B IND_UACS_DIFF

P LSQL_CMP_SWITCHS_DIFF

C URSOR_PARTS_MISMATCH

S TB_OBJECT_MISMATCH

R OW_SHIP_MISMATCH

P Q_SLAVE_MISMATCH

T OP_LEVEL_DDL_MISMATCH

M ULTI_PX_MISMATCH

B IND_PEEKED_PQ_MISMATCH

M V_REWRITE_MISMATCH

R OLL_INVALID_MISMATCH

O PTIMIZER_MODE_MISMATCH

P X_MISMATCH

M V_STALEOBJ_MISMATCH

F LASHBACK_TABLE_MISMATCH

L ITREP_COMP_MISMATCH

P LSQL_DEBUG

L OAD_OPTIMIZER_STATS

A CL_MISMATCH

F LASHBACK_ARCHIVE_MISMATCH

L OCK_USER_SCHEMA_FAILED

R EMOTE_MAPPING_MISMATCH

L OAD_RUNTIME_HEAP_FAILED

H ASH_MATCH_FAILED

P URGED_CURSOR

B IND_LENGTH_UPGRADEABLE

U SE_FEEDBACK_STATS

B IND_EQUIV_FAILURE

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?

Explanation:

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

References

---

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit oracle.com . � Oracle | Contact and Chat | Support | Communities | Connect with us | | | | Legal Notices | Terms of Use