Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Luis.

Asked: July 06, 2017 - 6:28 am UTC

Last updated: July 07, 2017 - 1:05 am UTC

Version: 11.2.0.4.0

Viewed 10K+ times! This question is

You Asked

Hi,

I have a Database with cursor mismatch for a sql_id , but I cant find information about this Bind mismatch "mismatch(21)" neither for
new_oacexl.
This is a RAC three node, the result of tannel script nonshared2.sql for this sql_id is

SQL_ID CHILD# REASON REASON_XML
----------------------------------------------------------------------------------------------------------------------------------
5jyrd2qd1wuc00 Bind mismatch(21): <ChildNode>
<ChildNumber>0</ChildNumber>
<ID>40</ID>
<reason>Bind mismatch(21)</reason>
<size>4x4</size>
<bind_position>10</bind_position>
<original_oacflg>19</original_oacflg>
<original_oacexl>128</original_oacexl>
<new_oacexl>32</new_oacexl>
</ChildNode>

5jyrd2qd1wuc02 Bind mismatch(21): <ChildNode>
<ChildNumber>2</ChildNumber>
<ID>40</ID>
<reason>Bind mismatch(21)</reason>
<size>4x4</size>
<bind_position>10</bind_position>
<original_oacflg>19</original_oacflg>
<original_oacexl>32</original_oacexl>
<new_oacexl>128</new_oacexl>
</ChildNode>

Please could you help me to understand this mismatch.

Obrigado


and Connor said...

See here

https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:9497064796920

The length of your bind variables has an impact

Is this answer out of date? If it is, please let us know via a Comment