trying to interpret bind variable section in 100046 trace

From: anthony Sanchez <anthonycsanchez_at_gmail.com>
Date: Wed, 20 May 2015 22:36:23 +0000
Message-ID: <CAEwv4fHdi=xNr07Jyd8cj9D2VewqV2VUNQFMAa3oL9gpuE0Jrw_at_mail.gmail.com>



Hi folks,

11.2.0.4 on Windows 2008R2

I'm trying to troubleshoot an issue and need help deciphering the bind variables for an update statement in my 10046 trace file.

I'm trying to figure out why some of the binds have no "value=" part at the bottom. For example:

 Bind#26
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00   oacflg=13 fl2=202001 frm=00 csi=00 siz=24 off=0   kxsbbbfp=00000000 bln=22 avl=00 flg=09

Bind#51
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00   oacflg=13 fl2=202001 frm=00 csi=00 siz=24 off=0   kxsbbbfp=0645223f bln=22 avl=01 flg=09   value=0

I did learn that oacdty=02 means its of data type number. Is it just that the bind for #26 is null?

thanks,
Anthony

--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 21 2015 - 00:36:23 CEST

Original text of this message