High Version Count Due To BIND_MISMATCH (Doc ID 336268.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Oracle Server - Enterprise Edition - Version 8.1.7.4 and later
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 8.1.7.4


Symptoms

Performance is bad due to high version count. V$SQL_SHARED_CURSOR shows new child cursors for the parent one due to BIND_MISMATCH.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms