;LINE

1 ;*******************************************

2 ;* SAP HANA STATEMENT HASH DATA COLLECTION *

3 ;*******************************************

4 ;

5 ;Generated with: SQL: \"HANA_SQL_StatementHash_DataCollector\" (SAP

Note 1969700)

6 ;Start time: 2023/10/20 [Link]

7 ;End time: 2023/11/21 [Link]

8 ;System ID / database name: TS4 / TS4

9 ;Revision level: [Link].1690304772

10 ;Statement hash: 6f76b8099b6d0c0f5f8fd63426a4a094

11 ;

12 ;***************

13 ;* KEY FIGURES *

14 ;***************

15 ;

16 ;STAT_NAME VALUE VALUE_PER_EXEC

VALUE_PER_ROW

17 ;======================== ================================ ===============

==============

18 ;Statement hash 6f76b8099b6d0c0f5f8fd63426a4a094

19 ;Plan ID various (31)

20 ;Table type / dist. COLUMN / local

21 ;Application source ZCL_BW_TD_SAPI_BADI===========CP:1810

22 ;Database user name SAPHANADB

23 ;Last connection ID 343981

24 ;

25 ;Executions 35

26 ;Records 1857055 53058.71

27 ;Preparations 26 0.74
28 ;

29 ;Elapsed time 0.26 h 27048.76 ms

0.50 ms

30 ;Execution time 0.26 h 27038.01 ms

0.50 ms

31 ;Preparation time 0.00 h 10.75 ms

0.00 ms

32 ;Lock wait time 0.00 h 0.00 ms

0.00 ms

33 ;

34 ;******************

35 ;* STATEMENT TEXT *

36 ;******************

37 ;

38 ;SELECT /* FDA WRITE */

DISTINCT \"VBFA\" . \"VBELV\" , \"VBFA\" . \"POSNV\" , \"VBFA\" .

39 ;\"VBTYP_N\" , \"VBFA\" . \"ERDAT\" , \"VBFA\" . \"ERZET\" FROM \"VBFA\" , ?

AS \"t_00\" (\"C_0\"

40 ;NVARCHAR(10), \"C_1\" NVARCHAR(6)) WHERE \"VBFA\" . \"MANDT\" = ? AND

( \"VBFA\" . \"VBELV\"

41 ;= \"t_00\" . \"C_0\" AND \"VBFA\" . \"POSNV\" = \"t_00\" . \"C_1\" AND \"VBFA\"

. \"VBTYP_N\"

42 ;= N'M' OR \"VBFA\" . \"VBTYP_N\" = N'O' )

43 ;

44 ;*************

45 ;* SQL CACHE *

46 ;*************

47 ;

48 ;SNAPSHOT_TIME HOST PLAN_ID ENG

EXECUTIONS RECORDS REC_PER_EXEC ELAPSED_MS ELA_PER_EXEC_MS
ELA_PER_REC_MS PREPARES PREPARE_MS LOCK
49 ;=================== ============================= ============= ===
============== ============== ============== ================= ===============
============== =========== ============== ===========
50 ;2023/11/20 [Link] [Link] 990990003 CE
2 0 0.00 278199 139099.38 0.00
0 0
51 ;2023/11/20 [Link] [Link] 990990003 CE
1 58802 58802.00 424 423.83 0.00
0 0
52 ;2023/11/20 [Link] [Link] 990990003 CE
1 0 0.00 141126 141125.72 0.00
1 12
53 ;2023/11/15 [Link] [Link] 555910003 CE
1 58758 58758.00 22853 22852.65 0.38
1 12
54 ;2023/11/09 [Link] [Link] 6428500003 CE
1 58591 58591.00 16263 16263.20 0.27
1 14
55 ;2023/11/08 [Link] [Link] 4604960003 CE
1 58577 58577.00 17059 17058.66 0.29
1 14
56 ;2023/11/07 [Link] [Link] 3346530003 CE
1 58558 58558.00 24029 24029.41 0.41
1 14
57 ;2023/11/06 [Link] [Link] 1157980003 CE
1 58557 58557.00 21184 21184.04 0.36
1 19
58 ;2023/11/06 [Link] [Link] 976920003 CE
1 58557 58557.00 17424 17424.13 0.29
1 15
59 ;2023/11/04 [Link] [Link] 17716280003 CE
1 58557 58557.00 15458 15458.09 0.26
0 0
60 ;2023/11/03 [Link] [Link] 16851560003 CE
1 58553 58553.00 17869 17869.10 0.30
1 15
61 ;2023/11/02 [Link] [Link] 15423250003 CE
1 58515 58515.00 23473 23472.87 0.40
1 13
62 ;2023/11/02 [Link] [Link] 15016730003 CE
1 58515 58515.00 18696 18696.30 0.31
1 12
63 ;2023/11/01 [Link] [Link] 13482620003 CE
1 58514 58514.00 20452 20452.01 0.34
1 15
64 ;2023/11/01 [Link] [Link] 12978670003 CE
1 58514 58514.00 26666 26665.95 0.45
1 19
65 ;2023/11/01 [Link] [Link] 12336770003 CE
1 58514 58514.00 187 186.91 0.00
0 0
66 ;2023/10/31 [Link] [Link] 11682240003 CE
1 58467 58467.00 18664 18663.52 0.31
1 15
67 ;2023/10/31 [Link] [Link] 11530760003 CE
1 58467 58467.00 18116 18115.54 0.30
1 13
68 ;2023/10/31 [Link] [Link] 11186390003 CE
1 58467 58467.00 18347 18347.40 0.31
1 13
69 ;2023/10/27 [Link] [Link] 8375890003 CE
1 58467 58467.00 15613 15613.03 0.26
0 0
70 ;

71 ;SNP_TIME HOST PLAN_ID ENG EXECUTIONS

RECORDS REC_PER_EXEC ELAPSED_MS ELA_PER_EXEC_MS ELA_PER_REC_MS PREPARES
PREPARE_MS LOCK_MS
72 ;========== ============================= ============= === ==============
============== ============== ================= =============== ==============
=========== ============== ==============
73 ;2023/11/20 [Link] 990990003 CE 4
58802 14700.50 419748 104937.08 7.13 1
12 0
74 ;2023/11/15 [Link] 555910003 CE 1
58758 58758.00 22853 22852.65 0.38 1
12 0
75 ;2023/11/09 [Link] 6428500003 CE 1
58591 58591.00 16263 16263.20 0.27 1
14 0
76 ;2023/11/08 [Link] 4604960003 CE 1
58577 58577.00 17059 17058.66 0.29 1
14 0
77 ;2023/11/07 [Link] 3346530003 CE 1
58558 58558.00 24029 24029.41 0.41 1
14 0
78 ;2023/11/06 [Link] 1157980003 CE 1
58557 58557.00 21184 21184.04 0.36 1
19 0
79 ;2023/11/06 [Link] 976920003 CE 1
58557 58557.00 17424 17424.13 0.29 1
15 0
80 ;2023/11/04 [Link] 17716280003 CE 1
58557 58557.00 15458 15458.09 0.26 0
0 0
81 ;2023/11/03 [Link] 16851560003 CE 1
58553 58553.00 17869 17869.10 0.30 1
15 0
82 ;2023/11/02 [Link] 15423250003 CE 1
58515 58515.00 23473 23472.87 0.40 1
13 0
83 ;2023/11/02 [Link] 15016730003 CE 1
58515 58515.00 18696 18696.30 0.31 1
12 0
84 ;2023/11/01 [Link] 13482620003 CE 1
58514 58514.00 20452 20452.01 0.34 1
15 0
85 ;2023/11/01 [Link] 12978670003 CE 1
58514 58514.00 26666 26665.95 0.45 1
19 0
86 ;2023/11/01 [Link] 12336770003 CE 1
58514 58514.00 187 186.91 0.00 0
0 0
87 ;2023/10/31 [Link] 11682240003 CE 1
58467 58467.00 18664 18663.52 0.31 1
15 0
88 ;2023/10/31 [Link] 11530760003 CE 1
58467 58467.00 18116 18115.54 0.30 1
13 0
89 ;2023/10/31 [Link] 11186390003 CE 1
58467 58467.00 18347 18347.40 0.31 1
13 0
90 ;2023/10/27 [Link] 8375890003 CE 1
58467 58467.00 15613 15613.03 0.26 0
0 0
91 ;2023/10/27 [Link] 8258410003 CE 1
58467 58467.00 20239 20238.63 0.34 1
13 0
92 ;2023/10/27 [Link] 7723840003 CE 1
58467 58467.00 19455 19454.78 0.33 0
0 0
93 ;2023/10/26 [Link] 7090050003 CE 1
58446 58446.00 19033 19032.80 0.32 1
14 0
94 ;2023/10/26 [Link] 6818770003 CE 1
58446 58446.00 17413 17413.36 0.29 1
16 0
95 ;2023/10/26 [Link] 6720930003 CE 1
58446 58446.00 15921 15921.22 0.27 1
15 0
96 ;2023/10/25 [Link] 5152100003 CE 1
57958 57958.00 20717 20717.14 0.35 1
15 0
97 ;2023/10/25 [Link] 4635790003 CE 1
57958 57958.00 18067 18066.60 0.31 1
14 0
98 ;2023/10/24 [Link] 2864750003 CE 1
57099 57099.00 15585 15585.19 0.27 1
13 0
99 ;2023/10/23 [Link] 1468830003 CE 1
56303 56303.00 24723 24723.23 0.43 1
14 0
100;2023/10/23 [Link] 1090020003 CE 2
112606 56303.00 22528 11264.22 0.20 1
14 0
101;2023/10/23 [Link] 940840003 CE 1
56303 56303.00 7086 7085.87 0.12 1
13 0
102;2023/10/23 [Link] 704060003 CE 1
56303 56303.00 3851 3851.10 0.06 1
19 0
103;2023/10/23 [Link] 585690003 CE 1
56303 56303.00 9987 9987.25 0.17 0
0 0
104;

105;*********************

106;* TABLE INFORMATION *

107;*********************

108;

109;SCHEMA_NAME TABLE_NAME TYPE PARTS RECORDS MEM_TOTAL_GB MEM_DELTA_GB

CURR_DISK_GB MIN_DISK_GB MAX_DISK_GB LOAD_UNIT HOST
TABLE_SCANS_PER_S
110;=========== ========== ====== ====== =========== ============ ============
============ =========== =========== ========= =============================
=================
111;SAPHANADB VBFA COLUMN 1 11767668 0.45 0.00
0.48 0.45 0.48 DEFAULT [Link]
0.00
112;

113;*********************

114;* INDEX INFORMATION *

115;*********************

116;

117;SCHEMA_NAME TABLE_NAME INDEX_NAME COLUMN_NAME INDEX_TYPE CONSTRAINT_NAME

118;=========== ========== ========== =========== ==============

===================

119;SAPHANADB VBFA VBFA~0 MANDT INVERTED VALUE PRIMARY KEY

120; RUUID

121;SAPHANADB VBFA VBFA~1HD VBELV INVERTED VALUE

122;

123;SCHEMA_NAME TABLE_NAME INDEX_NAME COLUMN_NAME INDEX_TYPE

124;=========== ========== ========== =========== ======================

125;SAPHANADB VBFA implicit BWART INVERTED VALUE (BLOCK)

126; implicit MANDT INVERTED VALUE (BLOCK)

127; implicit PLMIN INVERTED VALUE (BLOCK)

128; implicit RFMNG INVERTED VALUE (BLOCK)

129; implicit RFMNG_FLO INVERTED VALUE (BLOCK)

130; implicit RFMNG_FLT INVERTED VALUE (BLOCK)

131; implicit RUUID INVERTED VALUE (FULL)

132; implicit STUFE INVERTED VALUE (BLOCK)

133; implicit VBTYP_V INVERTED VALUE (BLOCK)

134;

135;**********************

136;* COLUMN INFORMATION *

137;**********************

138;

139;SCHEMA_NAME TABLE_NAME COLUMN_NAME NUM_DISTINCT SIZE_MB LENGTH

DATA_TYPE COMPRESSION INDEX_TYPE LOAD_UNIT SCANNED_RECS_PER_S
INDEX_LOOKUPS_PER_S
140;=========== ========== ================= ============ ============ =======
============== =========== ========== ========= ==================
===================
141;SAPHANADB VBFA $rowid$ 11767668 38.31
internal DEFAULT FULL COLUMN 0
0
142; $trex_udiv$ -1 0.05
internal DEFAULT NONE COLUMN 0
0
143; $trexexternalkey$ 11767668 139.65
internal DEFAULT FULL COLUMN 0
0
144; ABGES 1 0.01 15
DOUBLE PREFIXED NONE COLUMN 0
0
145; AEDAT 365 0.24 8
NVARCHAR RLE NONE COLUMN 0
0
146; BDART 4 0.20 2
NVARCHAR RLE NONE COLUMN 0
0
147; BRGEW 1 0.01 15
DECIMAL PREFIXED NONE COLUMN 0
0
148; BWART 50 2.89 3
NVARCHAR INDIRECT BLOCK COLUMN 0
0
149; CMETH 1 0.01 1
NVARCHAR PREFIXED NONE COLUMN 0
0
150; ERDAT 384 0.71 8
NVARCHAR RLE NONE COLUMN 0
0
151; ERZET 72645 12.02 6
NVARCHAR RLE NONE COLUMN 0
0
152; FKTYP 5 0.07 1
NVARCHAR RLE NONE COLUMN 0
0
153; FPLNR 1 0.01 10
NVARCHAR PREFIXED NONE COLUMN 0
0
154; FPLTR 1 0.01 6
NVARCHAR PREFIXED NONE COLUMN 0
0
155; GEWEI 2 0.01 3
NVARCHAR RLE NONE COLUMN 0
0
156; KZBEF 1 0.01 1
NVARCHAR PREFIXED NONE COLUMN 0
0
157; LGNUM 1 0.01 3
NVARCHAR PREFIXED NONE COLUMN 0
0
158; LOGSYS 1 0.01 10
NVARCHAR PREFIXED NONE COLUMN 0
0
159; MANDT 1 0.04 3
NVARCHAR RLE BLOCK COLUMN 0
0
160; MATNR 8117 7.15 40
NVARCHAR INDIRECT NONE COLUMN 0
0
161; MEINS 15 0.07 3
NVARCHAR RLE NONE COLUMN 0
0
162; MJAHR 3 2.26 4
NVARCHAR RLE NONE COLUMN 0
0
163; NTGEW 1 0.01 13
DECIMAL PREFIXED NONE COLUMN 0
0
164; PLART 3 0.19 1
NVARCHAR RLE NONE COLUMN 0
0
165; PLMIN 4 2.27 1
NVARCHAR INDIRECT BLOCK COLUMN 0
0
166; POSNN 44088 12.27 6
NVARCHAR INDIRECT NONE COLUMN 0
0
167; POSNV 7729 12.10 6
NVARCHAR INDIRECT NONE COLUMN 1042
0
168; RFMNG 3922 4.75 15
DECIMAL INDIRECT BLOCK COLUMN 0
0
169; RFMNG_FLO 3999 4.46 15
DOUBLE INDIRECT BLOCK COLUMN 0
0
170; RFMNG_FLT 3976 4.71 15
DOUBLE INDIRECT BLOCK COLUMN 0
0
171; RFWRT 48026 8.97 15
DECIMAL INDIRECT NONE COLUMN 0
0
172; RUUID 11767668 121.92 16
VARBINARY DEFAULT FULL COLUMN 0
0
173; SOBKZ 2 0.02 1
NVARCHAR RLE NONE COLUMN 0
0
174; SONUM 1 0.01 16
NVARCHAR PREFIXED NONE COLUMN 0
0
175; STUFE 6 2.00 2
NVARCHAR INDIRECT BLOCK COLUMN 0
0
176; TAQUI 2 0.02 1
NVARCHAR RLE NONE COLUMN 0
0
177; VBELN 2147072 29.77 10
NVARCHAR RLE NONE COLUMN 0
0
178; VBELV 574173 46.34 10
NVARCHAR INDIRECT FULL COLUMN 0
0
179; VBTYP_N 23 2.54 4
NVARCHAR RLE NONE COLUMN 1429
0
180; VBTYP_V 18 2.66 4
NVARCHAR INDIRECT BLOCK COLUMN 0
0
181; VOLEH 3 0.01 3
NVARCHAR RLE NONE COLUMN 0
0
182; VOLUM 1 0.01 15
DECIMAL PREFIXED NONE COLUMN 0
0
183; VRKME 18 1.54 3
NVARCHAR RLE NONE COLUMN 0
0
184; WAERS 3 2.15 5
NVARCHAR RLE NONE COLUMN 0
0
185; WBSTA 2 0.52 1
NVARCHAR CLUSTERED NONE COLUMN 0
0
186; _DATAAGING 1 0.01 8
NVARCHAR PREFIXED NONE COLUMN 0
0
187;

188;************

189;* TRIGGERS *

190;************

191;

192;SCHEMA_NAME TABLE_NAME TRIGGER_NAME ACTION_TIME EVENT ACTION_LEVEL

IS_VALID IS_ENABLED CREATE_TIME

193;=========== ========== ================== =========== ====== ============

======== ========== ===================

194;SAPHANADB VBFA /1DH/000000018DEL AFTER DELETE ROW TRUE

TRUE 2022-09-27 [Link]

195;SAPHANADB VBFA /1DH/000000018INS AFTER INSERT ROW TRUE

TRUE 2022-09-27 [Link]

196;SAPHANADB VBFA /1DH/000000018UPD1 AFTER UPDATE ROW TRUE

TRUE 2022-09-27 [Link]

197;SAPHANADB VBFA /1DH/000000018UPD2 AFTER UPDATE ROW TRUE

TRUE 2022-09-27 [Link]

198;

199;***********************

200;* TABLE OPTIMIZATIONS *

201;***********************

202;

203;OPTIMIZATION_TIME SCHEMA_NAME TABLE_NAME HOST TYPE

MOTIVATION MERGED_ROWS RUNTIME_S LAST_ERROR

204;=========== =================== ========== =============================

============== ========== =========== =========
======================================================================

205;2023/11/14 [Link] SAPHANADB VBFA [Link] MERGE

AUTO 90384 3.57 0

206;

207;*********************

208;* UNLOADS AND LOADS *

209;*********************

210;

211;ACTION_TIME TYPE SCHEMA_NAME TABLE_NAME COLUMN_NAME HOST

DURATION_MS REASON_OR_HASH ERROR

212;=========== ====== =================== ========== =================

============================= =========== ================================
=========================================================
213;2023/11/21 [Link] LOAD SAPHANADB VBFA PLMIN
[Link] 438 0

214;2023/11/21 [Link] LOAD SAPHANADB VBFA STUFE

[Link] 405 0

215;2023/11/21 [Link] LOAD SAPHANADB VBFA PLART

[Link] 394 0

216;2023/11/21 [Link] LOAD SAPHANADB VBFA POSNN

[Link] 439 0

217;2023/11/21 [Link] LOAD SAPHANADB VBFA VOLEH

[Link] 154 0

218;2023/11/21 [Link] LOAD SAPHANADB VBFA RFWRT

[Link] 432 0

219;2023/11/21 [Link] LOAD SAPHANADB VBFA RFMNG_FLT

[Link] 425 0

220;2023/11/21 [Link] LOAD SAPHANADB VBFA VRKME

[Link] 404 0

221;2023/11/21 [Link] LOAD SAPHANADB VBFA MJAHR

[Link] 402 0

222;2023/11/21 [Link] LOAD SAPHANADB VBFA FPLTR

[Link] 155 0
223;2023/11/21 [Link] LOAD SAPHANADB VBFA BWART
[Link] 404 0

224;2023/11/21 [Link] LOAD SAPHANADB VBFA GEWEI

[Link] 155 0

225;2023/11/21 [Link] LOAD SAPHANADB VBFA RUUID

[Link] 449 0

226;2023/11/21 [Link] LOAD SAPHANADB VBFA NTGEW

[Link] 188 0

227;2023/11/21 [Link] LOAD SAPHANADB VBFA LOGSYS

[Link] 188 0

228;2023/11/21 [Link] LOAD SAPHANADB VBFA POSNV

[Link] 428 0

229;2023/11/21 [Link] LOAD SAPHANADB VBFA VBELN

[Link] 381 0

230;2023/11/21 [Link] LOAD SAPHANADB VBFA LGNUM

[Link] 148 0

231;2023/11/21 [Link] LOAD SAPHANADB VBFA TAQUI

[Link] 395 0

232;2023/11/21 [Link] LOAD SAPHANADB VBFA VBTYP_N

[Link] 400 0

233;

234;******************

235;* THREAD SAMPLES *

236;******************

237;

238;SAMPLES PERCENT HOST PORT THREAD_TYPE

239;======= ======= ============================= =====

==============================

240; 62 86.11 [Link] 30003 JobWorker

241; 10 13.88 [Link] 30003 SqlExecutor

242;

243;SAMPLES PERCENT THREAD_TYPE THREAD_STATE Q LOCK_NAME

244;======= ======= =========== ================ =

======================================================================

245; 62 86.11 JobWorker Running ?

246; 10 13.88 SqlExecutor Job Exec Waiting JobBarrier Wait for Jobs

247;

248;SAMPLES PERCENT THREAD_TYPE THREAD_METHOD

249;======= ======= =========== ==================================================

250; 48 66.66 JobWorker ESX::ParallelFetchJob

251; 14 19.44 JobWorker ESX::ParallelPartialGroupingJob

252; 10 13.88 SqlExecutor ExecutePrepared

253;

254;SAMPLES PERCENT THREAD_TYPE THREAD_METHOD THREAD_DETAIL

255;======= ======= =========== ===============================

================================================================================

256; 48 66.66 JobWorker ESX::ParallelFetchJob ?

257; 14 19.44 JobWorker ESX::ParallelPartialGroupingJob ?

258; 10 13.88 SqlExecutor ExecutePrepared SELECT /* FDA WRITE

*/ DISTINCT \"VBFA\" . \"VBELV\" , \"VBFA\" . \"POSNV\" , \"VBFA\" . \"VBTYP_N\" ,
\"VBFA\" . \"ERDAT\" , \"VBFA\" . \"ERZET\" FROM \"VBFA\"
259;

260;SAMPLES PERCENT DB_USER APP_USER APP_NAME APP_SOURCE

261;======= ======= ========= ============ ========

==================================================

262; 72 100.00 SAPHANADB SYS_B4REMOTE ABAP:TS4 not reliable

263;

264;SAMPLES PERCENT PASSPORT_COMPONENT PASSPORT_ACTION

265;======= ======= ================== =============================

266; 26 36.11 TB4/tb4hana_TB4_00 BIDTPR_20231120073510000000_1

267; 23 31.94 TB4/tb4hana_TB4_00 BIDTPR_20231120113336000002_1

268; 23 31.94 TB4/tb4hana_TB4_00 BIDTPR_20231120115052000002_1

269;

270;SAMPLES PERCENT PASSPORT_ACTION APP_COMP_NAME

271;======= ======= ============================= =============

272; 26 36.11 BIDTPR_20231120073510000000_1

273; 23 31.94 BIDTPR_20231120113336000002_1

274; 23 31.94 BIDTPR_20231120115052000002_1

275;

276;SAMPLES PERCENT CLIENT_IP CLIENT_PID

277;======= ======= =============== ==========

278; 26 36.11 [Link] 858004

279; 23 31.94 [Link] 2350517

280; 23 31.94 [Link] 858012

281;

282;SAMPLES PERCENT ROOT_STATEMENT_HASH STATEMENT_STRING

283;======= ======= ================================

==================================================

284; 72 100.00 6f76b8099b6d0c0f5f8fd63426a4a094 SELECT /* FDA WRITE */

DISTINCT \"VBFA\" . \"VBELV\" , \"VBFA\" . \"POSNV\" , \"VBFA\" . \"VBTYP_N\" , \"
VBFA\" . \"ERDAT\" , \"VBFA\" . \"ERZET\" FROM \"VBFA\" , ? AS \"t_0
285;

286;SAMPLES PERCENT CHILD_STATEMENT_HASH STATEMENT_STRING

287;======= ======= ================================

==================================================

288; 72 100.00 6f76b8099b6d0c0f5f8fd63426a4a094 SELECT /* FDA WRITE */

DISTINCT \"VBFA\" . \"VBELV\" , \"VBFA\" . \"POSNV\" , \"VBFA\" . \"VBTYP_N\" , \"
VBFA\" . \"ERDAT\" , \"VBFA\" . \"ERZET\" FROM \"VBFA\" , ? AS \"t_0
289;

290;AVG_PARALLELISM MAX_PARALLELISM MAX_TOTAL_THREADS

MAX_TOTAL_RUNNING_THREADS

291;=============== =============== ==============================

==============================

292; 6.20 8 9
8

293;

294;*******************

295;* STATEMENT HINTS *

296;*******************

297;

298;ENABLE_TIME ENABLED HINT_STRING

299;=================== =========
==================================================
300;2023/08/31 [Link] TRUE NO_USE_OLAP_PLAN

301;

302;*****************

303;* TRACE ENTRIES *

304;*****************

305;

306;TIMESTAMP COMPONENT TRACE_ENTRIES

307;=================== ================
==================================================

308;2023/11/20 [Link] OOM_Notification oom exception occurred at

'[Link]': conn_id=309706, stmt_id=1330179382060046,
stmt_hash=6f76b8099b6d0c0f5f8fd63426a4a094, sql=SELECT /
309;2023/11/20 [Link] ESX_parallel \n240213245[thr=19145]: SqlExecutor at \n
0: 0x00007fd0f108bf59 in ESX::executeJobs(ESX::RuntimeData&, unsigned int, unsigned
int, unsigned int, TRexUtils::Paralle
310;2023/11/20 [Link] TraceContext UserName=SAPHANADB,
ApplicationUserName=SYS_B4REMOTE, ApplicationName=ABAP:TS4,
ApplicationSource=ZCL_BW_TD_SAPI_BADI===========CP:1810, Client=100, StatementHash=

311;2023/11/20 [Link] TraceContext UserName=SAPHANADB,

ApplicationUserName=SYS_B4REMOTE, ApplicationName=ABAP:TS4,
ApplicationSource=ZCL_BW_TD_SAPI_BADI===========CP:1810, Client=100, StatementHash=

312;2023/11/20 [Link] Memory 12: 0x00007fd0fcb62530 in

Execution::JobObjectImpl::run(Execution::JobWorker*)+0x15b0 at
Basis/Execution/impl/[Link] ([Link])

313;2023/11/20 [Link] TraceContext UserName=SAPHANADB,

ApplicationUserName=SYS_B4REMOTE, ApplicationName=ABAP:TS4,
ApplicationSource=ZCL_BW_TD_SAPI_BADI===========CP:1810, Client=100, StatementHash=

314;2023/11/20 [Link] Memory 8: 0x00007fd0f102e218 in

ESX::GroupBy::GroupByThreadData::prepare(unsigned int, unsigned long, unsigned int,
bool)+0x6c4 at ltt/[Link] ([Link])
315;2023/11/20 [Link] Memory 12: 0x00007fd0fcb62530 in
Execution::JobObjectImpl::run(Execution::JobWorker*)+0x15b0 at
Basis/Execution/impl/[Link] ([Link])

316;2023/11/20 [Link] TraceContext UserName=SAPHANADB,

ApplicationUserName=SYS_B4REMOTE, ApplicationName=ABAP:TS4,
ApplicationSource=ZCL_BW_TD_SAPI_BADI===========CP:1810, Client=100, StatementHash=

317;2023/11/20 [Link] TraceContext UserName=SAPHANADB,

ApplicationUserName=SYS_B4REMOTE, ApplicationName=ABAP:TS4,
ApplicationSource=ZCL_BW_TD_SAPI_BADI===========CP:1810, Client=100, StatementHash=

318;2023/11/20 [Link] Memory 11: 0x00007fd100e0c050 in

TRexUtils::Parallel::JobBase::run(Execution::Context&, Execution::JobObject&)+0x40
at Basis/[Link] ([Link])
319;2023/11/20 [Link] OOM_Notification oom exception occurred at
'[Link]': conn_id=309683, stmt_id=1330080258111695,
stmt_hash=6f76b8099b6d0c0f5f8fd63426a4a094, sql=SELECT /
320;2023/11/20 [Link] ESX_parallel \n1986753[thr=24629]: SqlExecutor at \n
0: 0x00007fd0f108bf59 in ESX::executeJobs(ESX::RuntimeData&, unsigned int, unsigned
int, unsigned int, TRexUtils::Parallel:
321;2023/11/20 [Link] TraceContext UserName=SAPHANADB,
ApplicationUserName=SYS_B4REMOTE, ApplicationName=ABAP:TS4,
ApplicationSource=ZCL_BW_TD_SAPI_BADI===========CP:1810, Client=100, StatementHash=

322;2023/11/20 [Link] TraceContext UserName=SAPHANADB,

ApplicationUserName=SYS_B4REMOTE, ApplicationName=ABAP:TS4,
ApplicationSource=ZCL_BW_TD_SAPI_BADI===========CP:1810, Client=100, StatementHash=

323;2023/11/20 [Link] Memory Composite limit violation (OUT OF MEMORY)

occurred.\nComposite limit=50gb (53687091200b)\nRoot allocator
name=Connection/309683/Statement/1330080258111695\nHost: sapt
324;2023/11/20 [Link] Memory 11: 0x00007fd100e0c050 in
TRexUtils::Parallel::JobBase::run(Execution::Context&, Execution::JobObject&)+0x40
at Basis/[Link] ([Link])\n 12: 0x00
325;2023/11/20 [Link] TraceContext UserName=SAPHANADB,
ApplicationUserName=SYS_B4REMOTE, ApplicationName=ABAP:TS4,
ApplicationSource=ZCL_BW_TD_SAPI_BADI===========CP:1810, Client=100, StatementHash=

326;?

327;?

328;

329;****************************

330;* DATABASE VERSION HISTORY *

331;****************************

332;

333;INSTALL_TIME VERSION

334;=================== ======================

335;2023/11/21 [Link] [Link].1690304772

336;2022/04/22 [Link] [Link].1644229038

337;2021/09/24 [Link] [Link].1599235305

338;

339;**********************

340;* PARAMETER SETTINGS *

341;**********************

342;

343;FILE_NAME SECTION PARAMETER_NAME VALUE

344;=============== ============= =================================== =====

345;[Link] execution default_statement_concurrency_limit 16

346;[Link] execution max_concurrency 0

347;[Link] execution max_concurrency_hint 0

348;[Link] memorymanager statement_memory_limit 50

349;[Link] lobhandling garbage_collect_interval_s 43200

350;

351;*********************

352;* PARAMETER CHANGES *

353;*********************

354;

355;TIMESTAMP FILE_NAME SECTION PARAMETER_NAME VALUE

PREV_VALUE

356;=================== ========== =================== ======================

======= ==========

357;2023/11/20 [Link] [Link] expensive_statement enable

false

358;2023/11/20 [Link] [Link] expensive_statement threshold_duration

1000000

359;2023/11/20 [Link] [Link] expensive_statement enable false

true

360;2023/11/20 [Link] [Link] expensive_statement threshold_duration

1000000 1000

361;2023/11/20 [Link] [Link] expensive_statement enable true

362;2023/11/20 [Link] [Link] expensive_statement threshold_duration 1000

363;2023/11/16 [Link] [Link] memorymanager statement_memory_limit 50

364;2023/11/16 [Link] [Link] memorymanager statement_memory_limit

50