trying to interpret bind variable section in 100046 trace

  • From: anthony Sanchez <anthonycsanchez@xxxxxxxxx>
  • To: oracle-l <Oracle-L@xxxxxxxxxxxxx>
  • Date: Wed, 20 May 2015 22:36:23 +0000

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2015