Missing binds in trace analyzer

Toad for Oracle
1

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

missing_binds_in_trace_analyzer.png
missing_binds_in_trace_analyzer.png1457×985 62.3 KB

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='SQLNet message to client' ela= 8 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=20333784802197,lif=69448
WAIT #11529215045667076728: nam='SQLNet message from client' ela= 433 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=20333784808690,lif=69449
WAIT #11529215045667076728: nam='SQLNet message to client' ela= 6 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=20334169479965,lif=121118
WAIT #11529215045667076728: nam='SQLNet message from client' ela= 372 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=20334169492776,lif=121119
WAIT #11529215045667076728: nam='SQLNet message to client' ela= 6 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=20334325595652,lif=139641
WAIT #11529215045667076728: nam='SQLNet message from client' ela= 273 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=20334325601103,lif=139642
WAIT #11529215045667076728: nam='SQLNet message to client' ela= 5 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=20334390260688,lif=148129
WAIT #11529215045667076728: nam='SQLNet message from client' ela= 269 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=20334390275053,lif=148130
WAIT #11529215045667076728: nam='SQLNet message to client' ela= 5 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=20334460112542,lif=157682
WAIT #11529215045667076728: nam='SQLNet message from client' ela= 305 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=20334460117335,lif=157683
WAIT #11529215045667076728: nam='SQLNet message to client' ela= 5 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=20334516106113,lif=166200
WAIT #11529215045667076728: nam='SQLNet 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

2

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.

3

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
missing_binds_in_trace_analyzer2.png1191×563 25.8 KB

4

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.

5

trace file is attached...

Brg,**
________________________**

Damir Vadas
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 wrote:

RE: Missing binds in trace analyzer

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 on this subject.

Or Unsubscribe from Toad for Oracle Forum notifications altogether.

Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.

6

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

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

Brg
Damir

7

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.