# Missing binds in trace analyzer

**URL:** <https://forums.toadworld.com/t/missing-binds-in-trace-analyzer/39687>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [July 13, 2017, 4:15am UTC](https://forums.toadworld.com/t/missing-binds-in-trace-analyzer/39687 "2017-07-13T04:15:18Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [July 13, 2017, 4:15am UTC](https://forums.toadworld.com/t/missing-binds-in-trace-analyzer/39687/1 "2017-07-13T04:15:18Z")

</div>

Toad 12.10.0.30 x64, Oracle 11.2.0.3 x64 8server and client)

 ![missing_binds_in_trace_analyzer.png](https://global.discourse-cdn.com/quest/original/2X/e/ebeb8dcbfc7b0eb379c8ff97af33b41e723c3417.png)

Raw data from the last tab (saved in TXT file)

Data  
Header  
PARSING IN CURSOR #11529215045667076728 len=261 dep=0 uid=9 oct=6 lid=9 tim=20333783838252 hv=2590979785 ad='c0000006d5657c18' sqlid='5z8hn7fd6ydq9'  
SQL Statement  
update CHARGE set SYS\_CREATION\_DATE=SYS\_CREATION\_DATE,SYS\_UPDATE\_DATE=SYSDATE,OPERATOR\_ID=:b1:b2,APPLICATION\_ID=:b3:b4,DL\_SERVICE\_CODE=:b5:b6,DL\_UPDATE\_STAMP=:b7:b8,CHG\_APPLY\_POINTS=:b9 where (((BAN=:b10 and ENT\_SEQ\_NO=:b11) and ACTV\_SEQ\_NO=:b12) and BEN=:b13)  
Parse Information  
PARSE #11529215045667076728:c=0,e=548,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,plh=0,tim=20333783838249,lif=69276  
Bind Information  
BINDS #11529215045667076728:  
Bind#0,lif=69309  
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00  
oacflg=01 fl2=1000000 frm=00 csi=00 siz=232 off=0  
kxsbbbfp=9fffffffe8131d18 bln=22 avl=00 flg=05  
Bind#1,lif=69313  
oacdty=01 mxl=32(06) mxlc=00 mal=00 scl=00 pre=00  
oacflg=01 fl2=1000000 frm=01 csi=31 siz=0 off=24  
kxsbbbfp=9fffffffe8131d30 bln=32 avl=06 flg=01  
value="BLPREP"  
Bind#2,lif=69318  
oacdty=01 mxl=32(05) mxlc=00 mal=00 scl=00 pre=00  
oacflg=01 fl2=1000000 frm=01 csi=31 siz=0 off=56  
kxsbbbfp=9fffffffe8131d50 bln=32 avl=05 flg=01  
value="BL096"  
Bind#3,lif=69323  
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00  
oacflg=01 fl2=1000000 frm=00 csi=00 siz=0 off=88  
kxsbbbfp=9fffffffe8131d70 bln=22 avl=03 flg=01  
value=7954  
Bind#4,lif=69328  
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00  
oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=112  
kxsbbbfp=9fffffffe8131d88 bln=22 avl=04 flg=01  
value=115.64  
Bind#5,lif=69333  
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00  
oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=136  
kxsbbbfp=9fffffffe8131da0 bln=22 avl=06 flg=01  
value=102504779  
Bind#6,lif=69338  
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00  
oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=160  
kxsbbbfp=9fffffffe8131db8 bln=22 avl=06 flg=01  
value=169172849  
Bind#7,lif=69343  
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00  
oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=184  
kxsbbbfp=9fffffffe8131dd0 bln=22 avl=02 flg=01  
value=1  
Bind#8,lif=69348  
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00  
oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=208  
kxsbbbfp=9fffffffe8131de8 bln=22 avl=02 flg=01  
value=1  
BINDS #11529215045667076728:  
Bind#0,lif=69355  
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00  
oacflg=01 fl2=1000000 frm=00 csi=00 siz=232 off=0  
kxsbbbfp=9fffffffe8131d18 bln=22 avl=00 flg=05  
Bind#1,lif=69359  
oacdty=01 mxl=32(06) mxlc=00 mal=00 scl=00 pre=00  
oacflg=01 fl2=1000000 frm=01 csi=31 siz=0 off=24  
kxsbbbfp=9fffffffe8131d30 bln=32 avl=06 flg=01  
value="BLPREP"  
Bind#2,lif=69364  
oacdty=01 mxl=32(05) mxlc=00 mal=00 scl=00 pre=00  
oacflg=01 fl2=1000000 frm=01 csi=31 siz=0 off=56  
kxsbbbfp=9fffffffe8131d50 bln=32 avl=05 flg=01  
value="BL096"  
Bind#3,lif=69369  
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00  
oacflg=01 fl2=1000000 frm=00 csi=00 siz=0 off=88  
kxsbbbfp=9fffffffe8131d70 bln=22 avl=03 flg=01  
value=7954  
Bind#4,lif=69374  
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00  
oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=112  
kxsbbbfp=9fffffffe8131d88 bln=22 avl=03 flg=01  
value=7.32  
Bind#5,lif=69379  
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00  
oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=136  
kxsbbbfp=9fffffffe8131da0 bln=22 avl=06 flg=01  
value=102504779  
Bind#6,lif=69384  
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00  
oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=160  
kxsbbbfp=9fffffffe8131db8 bln=22 avl=06 flg=01  
value=169172850  
Bind#7,lif=69389  
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00  
oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=184  
kxsbbbfp=9fffffffe8131dd0 bln=22 avl=02 flg=01  
value=1  
Bind#8,lif=69394  
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00  
oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=208  
kxsbbbfp=9fffffffe8131de8 bln=22 avl=02 flg=01  
value=1  
BINDS #11529215045667076728:  
Bind#0,lif=120934  
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00  
oacflg=01 fl2=1000000 frm=00 csi=00 siz=232 off=0  
kxsbbbfp=9fffffffe82e3f30 bln=22 avl=00 flg=05  
Bind#1,lif=120938  
oacdty=01 mxl=32(06) mxlc=00 mal=00 scl=00 pre=00  
oacflg=01 fl2=1000000 frm=01 csi=31 siz=0 off=24  
kxsbbbfp=9fffffffe82e3f48 bln=32 avl=06 flg=01  
value="BLPREP"  
Bind#2,lif=120943  
oacdty=01 mxl=32(05) mxlc=00 mal=00 scl=00 pre=00  
oacflg=01 fl2=1000000 frm=01 csi=31 siz=0 off=56  
kxsbbbfp=9fffffffe82e3f68 bln=32 avl=05 flg=01  
value="BL096"  
Bind#3,lif=120948  
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00  
oacflg=01 fl2=1000000 frm=00 csi=00 siz=0 off=88  
kxsbbbfp=9fffffffe82e3f88 bln=22 avl=03 flg=01  
value=7962  
Bind#4,lif=120953

```
*** 2017-07-13 11:33:21.148
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=112
  kxsbbbfp=9fffffffe82e3fa0 bln=22 avl=03 flg=01
  value=57.8
 Bind#5,lif=120960
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=136
  kxsbbbfp=9fffffffe82e3fb8 bln=22 avl=06 flg=01
  value=327830415
 Bind#6,lif=120965
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=160
  kxsbbbfp=9fffffffe82e3fd0 bln=22 avl=06 flg=01
  value=169328394
 Bind#7,lif=120970
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=184
  kxsbbbfp=9fffffffe82e3fe8 bln=22 avl=02 flg=01
  value=1
 Bind#8,lif=120975
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=208
  kxsbbbfp=9fffffffe82e4000 bln=22 avl=02 flg=01
  value=1
BINDS #11529215045667076728:
 Bind#0,lif=139414
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=01 fl2=1000000 frm=00 csi=00 siz=232 off=0
  kxsbbbfp=9fffffffe82e4f98 bln=22 avl=00 flg=05
 Bind#1,lif=139418
  oacdty=01 mxl=32(06) mxlc=00 mal=00 scl=00 pre=00
  oacflg=01 fl2=1000000 frm=01 csi=31 siz=0 off=24
  kxsbbbfp=9fffffffe82e4fb0 bln=32 avl=06 flg=01
  value="BLPREP"
 Bind#2,lif=139423
  oacdty=01 mxl=32(05) mxlc=00 mal=00 scl=00 pre=00
  oacflg=01 fl2=1000000 frm=01 csi=31 siz=0 off=56
  kxsbbbfp=9fffffffe82e4fd0 bln=32 avl=05 flg=01
  value="BL096"
 Bind#3,lif=139428
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=01 fl2=1000000 frm=00 csi=00 siz=0 off=88
  kxsbbbfp=9fffffffe82e4ff0 bln=22 avl=03 flg=01
  value=2321
 Bind#4,lif=139433
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=112
  kxsbbbfp=9fffffffe82e5008 bln=22 avl=04 flg=01
  value=105.68
 Bind#5,lif=139438
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=136
  kxsbbbfp=9fffffffe82e5020 bln=22 avl=06 flg=01
  value=102628507
 Bind#6,lif=139443
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=160
  kxsbbbfp=9fffffffe82e5038 bln=22 avl=06 flg=01
  value=169352709
 Bind#7,lif=139448
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=184
  kxsbbbfp=9fffffffe82e5050 bln=22 avl=02 flg=01
  value=1
 Bind#8,lif=139453
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=208
  kxsbbbfp=9fffffffe82e5068 bln=22 avl=02 flg=01
  value=1
BINDS #11529215045667076728:
 Bind#0,lif=148037

*** 2017-07-13 11:37:02.436
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=01 fl2=1000000 frm=00 csi=00 siz=232 off=0
  kxsbbbfp=9fffffffe82e4f98 bln=22 avl=00 flg=05
 Bind#1,lif=148043
  oacdty=01 mxl=32(06) mxlc=00 mal=00 scl=00 pre=00
  oacflg=01 fl2=1000000 frm=01 csi=31 siz=0 off=24
  kxsbbbfp=9fffffffe82e4fb0 bln=32 avl=06 flg=01
  value="BLPREP"
 Bind#2,lif=148048
  oacdty=01 mxl=32(05) mxlc=00 mal=00 scl=00 pre=00
  oacflg=01 fl2=1000000 frm=01 csi=31 siz=0 off=56
  kxsbbbfp=9fffffffe82e4fd0 bln=32 avl=05 flg=01
  value="BL096"
 Bind#3,lif=148053
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=01 fl2=1000000 frm=00 csi=00 siz=0 off=88
  kxsbbbfp=9fffffffe82e4ff0 bln=22 avl=03 flg=01
  value=4148
 Bind#4,lif=148058
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=112
  kxsbbbfp=9fffffffe82e5008 bln=22 avl=03 flg=01
  value=95.6
 Bind#5,lif=148063
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=136
  kxsbbbfp=9fffffffe82e5020 bln=22 avl=05 flg=01
  value=338863600
 Bind#6,lif=148068
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=160
  kxsbbbfp=9fffffffe82e5038 bln=22 avl=06 flg=01
  value=169367484
 Bind#7,lif=148073
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=184
  kxsbbbfp=9fffffffe82e5050 bln=22 avl=02 flg=01
  value=1
 Bind#8,lif=148078
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=208
  kxsbbbfp=9fffffffe82e5068 bln=22 avl=02 flg=01
  value=1
BINDS #11529215045667076728:
 Bind#0,lif=157500
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=01 fl2=1000000 frm=00 csi=00 siz=232 off=0
  kxsbbbfp=9fffffffe82e4f98 bln=22 avl=00 flg=05
 Bind#1,lif=157504
  oacdty=01 mxl=32(06) mxlc=00 mal=00 scl=00 pre=00
  oacflg=01 fl2=1000000 frm=01 csi=31 siz=0 off=24
  kxsbbbfp=9fffffffe82e4fb0 bln=32 avl=06 flg=01
  value="BLPREP"
 Bind#2,lif=157509
  oacdty=01 mxl=32(05) mxlc=00 mal=00 scl=00 pre=00
  oacflg=01 fl2=1000000 frm=01 csi=31 siz=0 off=56
  kxsbbbfp=9fffffffe82e4fd0 bln=32 avl=05 flg=01
  value="BL096"
 Bind#3,lif=157514
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=01 fl2=1000000 frm=00 csi=00 siz=0 off=88
  kxsbbbfp=9fffffffe82e4ff0 bln=22 avl=03 flg=01
  value=9026
 Bind#4,lif=157519
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=112
  kxsbbbfp=9fffffffe82e5008 bln=22 avl=04 flg=01
  value=142.96
 Bind#5,lif=157524
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=136
  kxsbbbfp=9fffffffe82e5020 bln=22 avl=06 flg=01
  value=102464532
 Bind#6,lif=157529
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=160
  kxsbbbfp=9fffffffe82e5038 bln=22 avl=06 flg=01
  value=169378955
 Bind#7,lif=157534
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=184
  kxsbbbfp=9fffffffe82e5050 bln=22 avl=02 flg=01

*** 2017-07-13 11:38:12.200
  value=1
 Bind#8,lif=157541
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=208
  kxsbbbfp=9fffffffe82e5068 bln=22 avl=02 flg=01
  value=2
BINDS #11529215045667076728:
 Bind#0,lif=166018
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=01 fl2=1000000 frm=00 csi=00 siz=232 off=0
  kxsbbbfp=9fffffffe82e4f98 bln=22 avl=00 flg=05
 Bind#1,lif=166022
  oacdty=01 mxl=32(06) mxlc=00 mal=00 scl=00 pre=00
  oacflg=01 fl2=1000000 frm=01 csi=31 siz=0 off=24
  kxsbbbfp=9fffffffe82e4fb0 bln=32 avl=06 flg=01
  value="BLPREP"
 Bind#2,lif=166027
  oacdty=01 mxl=32(05) mxlc=00 mal=00 scl=00 pre=00
  oacflg=01 fl2=1000000 frm=01 csi=31 siz=0 off=56
  kxsbbbfp=9fffffffe82e4fd0 bln=32 avl=05 flg=01
  value="BL096"
 Bind#3,lif=166032
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=01 fl2=1000000 frm=00 csi=00 siz=0 off=88
  kxsbbbfp=9fffffffe82e4ff0 bln=22 avl=03 flg=01
  value=9519
 Bind#4,lif=166037
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=112
  kxsbbbfp=9fffffffe82e5008 bln=22 avl=04 flg=01
  value=116.32
 Bind#5,lif=166042
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=136
  kxsbbbfp=9fffffffe82e5020 bln=22 avl=06 flg=01
  value=102464532
 Bind#6,lif=166047
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=160
  kxsbbbfp=9fffffffe82e5038 bln=22 avl=06 flg=01
  value=169391898
 Bind#7,lif=166052
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=184
  kxsbbbfp=9fffffffe82e5050 bln=22 avl=02 flg=01
  value=1
 Bind#8,lif=166057
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=00 fl2=1000000 frm=00 csi=00 siz=0 off=208
  kxsbbbfp=9fffffffe82e5068 bln=22 avl=02 flg=01
  value=1

```

Exec Information  
EXEC #11529215045667076728:c=100000,e=921241,p=1,cr=1262,cu=4,mis=1,r=3,dep=0,og=1,plh=572047594,tim=20333784783801,lif=69444  
EXEC #11529215045667076728:c=70000,e=1634921,p=0,cr=12,cu=6,mis=0,r=4,dep=0,og=1,plh=572047594,tim=20334169462967,lif=121117  
EXEC #11529215045667076728:c=90000,e=1329847,p=0,cr=15,cu=5,mis=0,r=5,dep=0,og=1,plh=572047594,tim=20334325589807,lif=139640  
EXEC #11529215045667076728:c=20000,e=818306,p=0,cr=6,cu=5,mis=0,r=2,dep=0,og=1,plh=572047594,tim=20334390256089,lif=148128  
EXEC #11529215045667076728:c=60000,e=1181175,p=0,cr=12,cu=4,mis=0,r=4,dep=0,og=1,plh=572047594,tim=20334460107866,lif=157681  
EXEC #11529215045667076728:c=60000,e=1123284,p=0,cr=12,cu=4,mis=0,r=4,dep=0,og=1,plh=572047594,tim=20334516095117,lif=166199  
Fetch and Wait Information  
WAIT #11529215045667076728: nam='db file sequential read' ela= 7685 file#=1406 block#=357453 blocks=1 obj#=14168957 tim=20333784316057,lif=69353  
WAIT #11529215045667076728: nam='SQL_Net message to client' ela= 8 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=20333784802197,lif=69448  
WAIT #11529215045667076728: nam='SQL_Net message from client' ela= 433 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=20333784808690,lif=69449  
WAIT #11529215045667076728: nam='SQL_Net message to client' ela= 6 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=20334169479965,lif=121118  
WAIT #11529215045667076728: nam='SQL_Net message from client' ela= 372 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=20334169492776,lif=121119  
WAIT #11529215045667076728: nam='SQL_Net message to client' ela= 6 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=20334325595652,lif=139641  
WAIT #11529215045667076728: nam='SQL_Net message from client' ela= 273 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=20334325601103,lif=139642  
WAIT #11529215045667076728: nam='SQL_Net message to client' ela= 5 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=20334390260688,lif=148129  
WAIT #11529215045667076728: nam='SQL_Net message from client' ela= 269 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=20334390275053,lif=148130  
WAIT #11529215045667076728: nam='SQL_Net message to client' ela= 5 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=20334460112542,lif=157682  
WAIT #11529215045667076728: nam='SQL_Net message from client' ela= 305 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=20334460117335,lif=157683  
WAIT #11529215045667076728: nam='SQL_Net message to client' ela= 5 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=20334516106113,lif=166200  
WAIT #11529215045667076728: nam='SQL_Net message from client' ela= 266 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=20334516117864,lif=166201  
Statistics  
STAT #11529215045667076728 id=1 cnt=0 pid=0 pos=1 obj=0 op='UPDATE CHARGE (cr=11 pr=1 pw=0 time=14065 us)'  
STAT #11529215045667076728 id=2 cnt=3 pid=1 pos=1 obj=0 op='PARTITION RANGE SINGLE PARTITION: KEY KEY (cr=9 pr=1 pw=0 time=13655 us cost=1 size=56 card=1)'  
STAT #11529215045667076728 id=3 cnt=3 pid=2 pos=1 obj=12105662 op='INDEX UNIQUE SCAN CHARGE\_PK PARTITION: KEY KEY (cr=9 pr=1 pw=0 time=13623 us cost=1 size=56 card=1)'

Trace file may be sent on mail of course.

Brg  
Damir

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [July 13, 2017, 4:50am UTC](https://forums.toadworld.com/t/missing-binds-in-trace-analyzer/39687/2 "2017-07-13T04:50:28Z")

</div>

Hi Damir,

Well, it looks like those binds are not in the trace file either - at least not in the portion that you sent. The :b0 bind is the group of 4 lines that starts with Bind#0, :b1 is the group of 4 lines that starts with Bind#1, etc. I don’t see any Bind#10, Bind#11, Bind#12, or Bind#13.

---

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [July 13, 2017, 5:49am UTC](https://forums.toadworld.com/t/missing-binds-in-trace-analyzer/39687/3 "2017-07-13T05:49:47Z")

</div>

Hi John,

You are right.

Any clue (hint) why they (those binds) are missing in trace file? Trace was done with binds and waits true.

In the same trace, similar query (crazy double binds) has correct values:

 ![missing_binds_in_trace_analyzer2.png](https://global.discourse-cdn.com/quest/original/2X/1/19615e2daffccda0e14fbc93b512ca8cd4458704.png)

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [July 13, 2017, 6:02am UTC](https://forums.toadworld.com/t/missing-binds-in-trace-analyzer/39687/4 "2017-07-13T06:02:01Z")

</div>

It’s not uncommon for trace files to have data for a particular statement mixed in with data for other statements. Toad tries to watch for the StatementID’s to pull them all together, but sometimes those statement ID’s get reused for different statements, so I have to be careful to not just always combine data when the statement id matches.

So it may be that the data is in there somewhere, just in an unexpected position in the file.

Or maybe it really is missing - who knows. These files are not well documented.

try searching the file for “BINDS #11529215045667076728” and maybe you’ll find more Bind#10, 11, 12 elsewhere in the file.

If so, send me the file and I’ll see if I can piece it together.

---

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [July 13, 2017, 6:11am UTC](https://forums.toadworld.com/t/missing-binds-in-trace-analyzer/39687/5 "2017-07-13T06:11:34Z")

</div>

trace file is attached...

Brg,\*\*  
\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\*\*

**Damir Vadas**  
[http://damir-vadas.blogspot.com](http://damir-vadas.blogspot.com)

It does not matter what you have in your life, but who!

**Razmislite o čuvanju okoliša prije nego odštampate ovaj e-mail**  
**Please consider the environment before printing this email**

On Thu, Jul 13, 2017 at 3:03 PM, John Dorlon [bounce-jdorlon@toadworld.com](mailto:bounce-jdorlon@toadworld.com) wrote:

> **[RE: Missing binds in trace analyzer](http://www.toadworld.com/products/toad-for-oracle/f/10/p/32920/66632#66632)**

> Reply by John Dorlon  
> It's not uncommon for trace files to have data for a particular statement mixed in with data for other statements. Toad tries to watch for the StatementID's to pull them all together, but sometimes those statement ID's get reused for different statements, so I have to be careful to not just always combine data when the statement id matches.

> So it may be that the data is in there somewhere, just in an unexpected position in the file.

> Or maybe it really is missing - who knows. These files are not well documented.

> try searching the file for "BINDS #11529215045667076728" and maybe you'll find more Bind#10, 11, 12 elsewhere in the file.

> If so, send me the file and I'll see if I can piece it together.

> To reply, please reply-all to this email.
> 
> [Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/f/10/t/32920?subscribe=false) on this subject.
> 
> Or [Unsubscribe from Toad for Oracle Forum](http://www.toadworld.com/products/toad-for-oracle/f/10?subscribe=false) notifications altogether.
> 
> Toad for Oracle - Discussion Forum

> [Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/p/32920/66632?AbuseContentId=50d6b317-0811-4ca2-95be-4e322255f344&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse.

---

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [July 13, 2017, 6:12am UTC](https://forums.toadworld.com/t/missing-binds-in-trace-analyzer/39687/6 "2017-07-13T06:12:03Z")

</div>

there are a lot of “Bind#10” occurances.

So I sent a trace file to you if you can dig something.

Brg  
Damir

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [July 13, 2017, 6:18am UTC](https://forums.toadworld.com/t/missing-binds-in-trace-analyzer/39687/7 "2017-07-13T06:18:40Z")

</div>

Your statement is Statement ID 11529215045667076728, so the binds for that statement all start with BINDS #11529215045667076728.

The places where Bind#10 exists, if you scroll up to see the BINDS # line, you’ll see that those belong to different statements.