API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 5th, 2020
99
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.17 KB | None | 0 0
raw download clone embed print report
  1. =====================
  2. PARSING IN CURSOR #139694257394608 len=605 dep=1 uid=115 oct=3 lid=115 tim=103081764576096 hv=2147298655 ad='7993e978' sqlid='4tw5c11zzubaz'
  3. SELECT /* DS_SVC */ /*+ dynamic_sampling(0) no_sql_tune no_monitoring optimizer_features_enable(default) no_parallel result_cache(snapshot=3600) OPT_ESTIMATE(@"innerQuery", TABLE, "TABLE_ONE", ROWS=108.30625) OPT_ESTIMATE(@"innerQuery", INDEX_SCAN, "TABLE_ONE", "PK_TABLE_ONE", ROWS=139) */ C1, C2, C3 FROM (SELECT /*+ qb_name("innerQuery") INDEX( "TABLE_ONE" "PK_TABLE_ONE") */ COUNT(*) AS C1, 4294967295 AS C2, COUNT(*) AS C3 FROM APP_USER."TABLE_ONE" "TABLE_ONE" WHERE ("TABLE_ONE"."COUNTRY_CODE"=:B1) AND ("TABLE_ONE"."STORE_NR"=7368)) innerQuery
  4. END OF STMT
  5. PARSE #139694257394608:c=608,e=294,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=1,plh=0,tim=103081764576096
  6. PARSE #139694257683880:c=0,e=6,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=2191121161,tim=103081764576176
  7. BINDS #139694257683880:
  8. Bind#0
  9. oacdty=11 mxl=16(16) mxlc=00 mal=00 scl=00 pre=00
  10. oacflg=18 fl2=0001 frm=00 csi=00 siz=16 off=0
  11. kxsbbbfp=7f0d1a9d33a8 bln=16 avl=16 flg=05
  12. value=000089D2.001D.0001
  13. EXEC #139694257683880:c=0,e=26,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=2191121161,tim=103081764576220
  14. FETCH #139694257683880:c=0,e=7,p=0,cr=2,cu=0,mis=0,r=1,dep=2,og=4,plh=2191121161,tim=103081764576235
  15. CLOSE #139694257683880:c=0,e=6,dep=2,type=3,tim=103081764576258
  16. BINDS #139694257394608:
  17. Bind#0
  18. oacdty=01 mxl=32(02) mxlc=00 mal=00 scl=00 pre=00
  19. oacflg=10 fl2=0001 frm=01 csi=873 siz=32 off=0
  20. kxsbbbfp=7f0d1a9d3398 bln=32 avl=02 flg=05
  21. value="DE"
  22. EXEC #139694257394608:c=1017,e=1039,p=0,cr=2,cu=0,mis=1,r=0,dep=1,og=1,plh=2270550773,tim=103081764577166
  23. FETCH #139694257394608:c=0,e=11,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=1,plh=2270550773,tim=103081764577185
  24. STAT #139694257394608 id=1 cnt=1 pid=0 pos=1 obj=0 op='RESULT CACHE b7hsfbtt9sjdm9a5bkpqzpurgs (cr=0 pr=0 pw=0 time=10 us)'
  25. STAT #139694257394608 id=2 cnt=0 pid=1 pos=1 obj=0 op='VIEW (cr=0 pr=0 pw=0 time=0 us cost=4 size=31 card=1)'
  26. STAT #139694257394608 id=3 cnt=0 pid=2 pos=1 obj=0 op='SORT AGGREGATE (cr=0 pr=0 pw=0 time=0 us)'
  27. STAT #139694257394608 id=4 cnt=0 pid=3 pos=1 obj=143216 op='INDEX RANGE SCAN PK_TABLE_ONE (cr=0 pr=0 pw=0 time=0 us cost=4 size=756 card=108)'
  28. CLOSE #139694257394608:c=0,e=2,dep=1,type=0,tim=103081764577237
  29. BINDS #139694257658640:
  30. Bind#0
  31. oacdty=01 mxl=32(08) mxlc=00 mal=00 scl=00 pre=00
  32. oacflg=03 fl2=1000010 frm=01 csi=873 siz=32 off=0
  33. kxsbbbfp=7f0d1a8790a8 bln=32 avl=02 flg=05
  34. value="DE"
  35. EXEC #139694257658640:c=12931,e=19206,p=0,cr=38,cu=0,mis=1,r=0,dep=0,og=1,plh=3241275704,tim=103081764578597
  36. WAIT #139694257658640: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=103081764578637
  37. FETCH #139694257658640:c=1002,e=957,p=0,cr=163,cu=0,mis=0,r=1,dep=0,og=1,plh=3241275704,tim=103081764579630
  38. STAT #139694257658640 id=1 cnt=1 pid=0 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=163 pr=0 pw=0 time=960 us cost=9216 size=58320 card=216)'
  39. STAT #139694257658640 id=2 cnt=1 pid=1 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=152 pr=0 pw=0 time=588 us cost=8783 size=27756 card=108)'
  40. STAT #139694257658640 id=3 cnt=1 pid=2 pos=1 obj=0 op='VIEW (cr=145 pr=0 pw=0 time=540 us cost=143 size=15012 card=108)'
  41. STAT #139694257658640 id=4 cnt=139 pid=3 pos=1 obj=0 op='WINDOW BUFFER (cr=145 pr=0 pw=0 time=593 us cost=143 size=6696 card=108)'
  42. STAT #139694257658640 id=5 cnt=139 pid=4 pos=1 obj=142872 op='TABLE ACCESS BY INDEX ROWID TABLE_ONE (cr=145 pr=0 pw=0 time=502 us cost=143 size=6696 card=108)'
  43. STAT #139694257658640 id=6 cnt=139 pid=5 pos=1 obj=143216 op='INDEX RANGE SCAN PK_TABLE_ONE (cr=7 pr=0 pw=0 time=12 us cost=4 size=0 card=139)'
  44. STAT #139694257658640 id=7 cnt=1 pid=2 pos=2 obj=0 op='VIEW VW_LAT_DCA94159 (cr=7 pr=0 pw=0 time=44 us cost=80 size=118 card=1)'
  45. STAT #139694257658640 id=8 cnt=1 pid=7 pos=1 obj=142873 op='TABLE ACCESS BY INDEX ROWID BATCHED TABLE_TWO (cr=7 pr=0 pw=0 time=43 us cost=4 size=84 card=1)'
  46. STAT #139694257658640 id=9 cnt=1 pid=8 pos=1 obj=143252 op='INDEX RANGE SCAN PK_TABLE_TWO (cr=6 pr=0 pw=0 time=40 us cost=3 size=0 card=1)'
  47. STAT #139694257658640 id=10 cnt=1 pid=9 pos=1 obj=0 op='SORT AGGREGATE (cr=3 pr=0 pw=0 time=11 us)'
  48. STAT #139694257658640 id=11 cnt=1 pid=10 pos=1 obj=0 op='FIRST ROW (cr=3 pr=0 pw=0 time=7 us cost=3 size=18 card=1)'
  49. STAT #139694257658640 id=12 cnt=1 pid=11 pos=1 obj=143252 op='INDEX RANGE SCAN (MIN/MAX) PK_TABLE_TWO (cr=3 pr=0 pw=0 time=7 us cost=3 size=18 card=1)'
  50. STAT #139694257658640 id=13 cnt=1 pid=1 pos=2 obj=0 op='VIEW VW_LAT_DCA94159 (cr=11 pr=0 pw=0 time=369 us cost=4 size=26 card=2)'
  51. STAT #139694257658640 id=14 cnt=1 pid=13 pos=1 obj=0 op='VIEW VW_LAT_7C006CC6 (cr=11 pr=0 pw=0 time=353 us cost=4 size=112 card=2)'
  52. STAT #139694257658640 id=15 cnt=96 pid=14 pos=1 obj=0 op='WINDOW BUFFER (cr=11 pr=0 pw=0 time=304 us cost=4 size=48 card=2)'
  53. STAT #139694257658640 id=16 cnt=96 pid=15 pos=1 obj=142873 op='TABLE ACCESS BY INDEX ROWID TABLE_TWO (cr=11 pr=0 pw=0 time=340 us cost=4 size=48 card=2)'
  54. STAT #139694257658640 id=17 cnt=96 pid=16 pos=1 obj=143252 op='INDEX RANGE SCAN PK_TABLE_TWO (cr=9 pr=0 pw=0 time=242 us cost=3 size=0 card=2)'
  55. WAIT #139694257658640: nam='SQL*Net message from client' ela= 1490 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=103081764581356
  56. CLOSE #139694257658640:c=0,e=6,dep=0,type=0,tim=103081764581409
  57. WAIT #139694257657072: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=103081764581458
  58. WAIT #139694257657072: nam='SQL*Net message from client' ela= 1246 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=103081764582715
  59. XCTEND rlbk=0, rd_only=0, tim=103081764582794
  60. WAIT #0: nam='log file sync' ela= 419 buffer#=12978 sync scn=3263508636 p3=0 obj#=-1 tim=103081764583314
  61. WAIT #0: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=103081764583355
  62. WAIT #0: nam='SQL*Net message from client' ela= 7390 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=103081764590754
  63. WAIT #0: nam='log file sync' ela= 458 buffer#=13005 sync scn=3263508647 p3=0 obj#=-1 tim=103081764591269
  64. WAIT #0: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=103081764591335
  65. WAIT #0: nam='SQL*Net message from client' ela= 5964 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=103081764597309
  66. WAIT #0: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=103081764597388
  67. WAIT #0: nam='SQL*Net message from client' ela= 485 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=103081764597882
  68. PARSE #139694257841112:c=0,e=14,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=3060718939,tim=103081764597920
  69. BINDS #139694257841112:
  70. Bind#0
  71. oacdty=180 mxl=11(11) mxlc=00 mal=00 scl=00 pre=00
  72. oacflg=03 fl2=9000000 frm=00 csi=00 siz=88 off=0
  73. kxsbbbfp=7f0d1a879070 bln=11 avl=07 flg=05
  74. value=05-OCT-20 12.00.00 AM
  75. Bind#1
  76. oacdty=180 mxl=11(11) mxlc=00 mal=00 scl=09 pre=00
  77. oacflg=03 fl2=9000000 frm=00 csi=00 siz=0 off=16
  78. kxsbbbfp=7f0d1a879080 bln=11 avl=11 flg=01
  79. value=05-OCT-20 11.00.08.337000000 AM
  80. Bind#2
  81. oacdty=01 mxl=32(08) mxlc=00 mal=00 scl=00 pre=00
  82. oacflg=03 fl2=1000010 frm=01 csi=873 siz=0 off=32
  83. kxsbbbfp=7f0d1a879090 bln=32 avl=02 flg=01
  84. value="DE"
  85. Bind#3
  86. oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  87. oacflg=03 fl2=1000000 frm=01 csi=873 siz=0 off=64
  88. kxsbbbfp=7f0d1a8790b0 bln=22 avl=03 flg=01
  89. value=7383
  90. EXEC #139694257841112:c=905,e=123,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=3060718939,tim=103081764598056
  91. WAIT #139694257841112: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=103081764598084
  92. FETCH #139694257841112:c=0,e=10,p=0,cr=3,cu=0,mis=0,r=0,dep=0,og=1,plh=3060718939,tim=103081764598128
  93. WAIT #139694257841112: nam='SQL*Net message from client' ela= 666 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=103081764598817
  94. CLOSE #139694257841112:c=0,e=3,dep=0,type=3,tim=103081764598847
  95. PARSE #139694257896936:c=0,e=10,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=0,tim=103081764598876
  96. BINDS #139694257896936:
  97. Bind#0
  98. oacdty=01 mxl=128(36) mxlc=00 mal=00 scl=00 pre=00
  99. oacflg=03 fl2=1000010 frm=01 csi=873 siz=424 off=0
  100. kxsbbbfp=7f0d1a878f20 bln=128 avl=09 flg=05
  101. value="GMT+02:00"
  102. Bind#1
  103. oacdty=01 mxl=128(36) mxlc=00 mal=00 scl=00 pre=00
  104. oacflg=03 fl2=1000010 frm=01 csi=873 siz=0 off=128
  105. kxsbbbfp=7f0d1a878fa0 bln=128 avl=09 flg=01
  106. value="GMT+02:00"
  107. Bind#2
  108. oacdty=01 mxl=32(12) mxlc=00 mal=00 scl=00 pre=00
  109. oacflg=03 fl2=1000010 frm=01 csi=873 siz=0 off=256
  110. kxsbbbfp=7f0d1a879020 bln=32 avl=03 flg=01
  111. value="EUR"
  112. Bind#3
  113. oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  114. oacflg=03 fl2=1000000 frm=01 csi=873 siz=0 off=288
  115. kxsbbbfp=7f0d1a879040 bln=22 avl=03 flg=01
  116. value=237
  117. Bind#4
  118. oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  119. oacflg=03 fl2=1000000 frm=01 csi=873 siz=0 off=312
  120. kxsbbbfp=7f0d1a879058 bln=22 avl=09 flg=01
  121. value=5680.679130018308
  122. Bind#5
  123. oacdty=180 mxl=11(11) mxlc=00 mal=00 scl=00 pre=00
  124. oacflg=03 fl2=9000000 frm=00 csi=00 siz=0 off=336
  125. kxsbbbfp=7f0d1a879070 bln=11 avl=07 flg=01
  126. value=05-OCT-20 12.00.00 AM
  127. Bind#6
  128. oacdty=180 mxl=11(11) mxlc=00 mal=00 scl=09 pre=00
  129. oacflg=03 fl2=9000000 frm=00 csi=00 siz=0 off=352
  130. kxsbbbfp=7f0d1a879080 bln=11 avl=11 flg=01
  131. value=05-OCT-20 11.00.08.337000000 AM
  132. Bind#7
  133. oacdty=01 mxl=32(08) mxlc=00 mal=00 scl=00 pre=00
  134. oacflg=03 fl2=1000010 frm=01 csi=873 siz=0 off=368
  135. kxsbbbfp=7f0d1a879090 bln=32 avl=02 flg=01
  136. value="DE"
  137. Bind#8
  138. oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  139. oacflg=03 fl2=1000000 frm=01 csi=873 siz=0 off=400
  140. kxsbbbfp=7f0d1a8790b0 bln=22 avl=03 flg=01
  141. value=7383
  142. EXEC #139694257896936:c=0,e=284,p=0,cr=1,cu=16,mis=0,r=1,dep=0,og=1,plh=0,tim=103081764599186
  143. WAIT #139694257896936: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=103081764599221
  144. WAIT #139694257896936: nam='SQL*Net message from client' ela= 7599 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=103081764606834
  145. CLOSE #139694257896936:c=0,e=3,dep=0,type=3,tim=103081764606863
  146. WAIT #139694257658640: nam='latch: row cache objects' ela= 40596 address=21532996456 number=411 tries=0 obj#=-1 tim=103081764647586
  147.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!