Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2016-03-31 23:56:33.34.
Server version: WI-V2.5.6.26991 Firebird 2.5
Server implementation: Firebird/x86-64/Windows NT
FB_ARCHITECTURE |
DB_NAME |
FORCED_WRITES |
SWEEP_INT |
PAGE_BUFFERS |
PAGE_SIZE |
Classic 2.5.6 |
D:\OLTP-EMUL\OLTP25-SMALL.FDB |
ON |
0 |
384 |
8192 |
Test configuration settings
File: E:\OLTP-EMUL\src\oltp25_config.win
PARAM_NAME |
PARAM_VALUE |
fbc |
E:\FB25.TMPINSTANCE\bin\ |
dbnm |
D:\OLTP-EMUL\oltp25-small.fdb |
host |
localhost |
port |
3255 |
usr |
SYSDBA |
pwd |
masterke |
tmpdir |
e:\temp\logs.oltp25 |
working_mode |
small_03 |
warm_time |
10 |
test_time |
180 |
idle_time |
0 |
use_mtee |
0 |
is_embed |
0 |
remove_isql_logs |
if_no_severe_errors |
no_auto_undo |
1 |
detailed_info |
0 |
mon_unit_perf |
0 |
trc_unit_perf |
1 |
init_buff |
32768 |
create_with_fw |
sync |
create_with_sweep |
0 |
wait_if_not_exists |
0 |
wait_after_create |
0 |
init_docs |
0 |
wait_for_copy |
0 |
create_with_debug_objects |
1 |
create_with_split_heavy_tabs |
1 |
create_with_separate_qdistr_idx |
0 |
create_with_compound_columns_order |
most_selective_first |
make_html |
1 |
run_db_statistics |
1 |
run_db_validation |
1 |
file_name_with_test_params |
regular |
file_name_this_host_info |
ak25 |
upload_report |
1 |
FINISH_STATE |
DTS_END |
FB_GDSCODE |
FB_MNEMONA |
STACK |
IP |
TRN_ID |
ATT_ID |
EXC_UNIT |
NORMAL: TEST_TIME EXPIRED. |
2016-03-31 23:56:13.0290 |
-1 |
<null> |
|
127.0.0.1 |
91228 |
4275 |
2 |
CATEGORY |
SETTING |
VAL |
COMMON |
TRACED_UNITS |
,, |
COMMON |
LOG_PK_VIOLATION |
0 |
COMMON |
QMISM_VERIFY_BITSET |
1 |
COMMON |
RECALC_IDX_MIN_INTERVAL |
15 |
COMMON |
ENABLE_RESERVES_WHEN_ADD_INVOICE |
1 |
COMMON |
ORDER_FOR_OUR_FIRM_PERCENT |
25 |
COMMON |
ENABLE_FILL_PHRASES |
0 |
COMMON |
RANDOM_SEEK_VIA_ROWS_LIMIT |
0 |
COMMON |
C_INVOICE_MIN_PURCHASE |
1000 |
COMMON |
C_INVOICE_MAX_PURCHASE |
2000 |
COMMON |
C_INVOICE_MIN_PROFIT_PRC |
35 |
COMMON |
C_INVOICE_MAX_PROFIT_PRC |
80 |
COMMON |
C_MIN_COST_TO_BE_SPLITTED |
1000 |
COMMON |
C_ROWS_TO_MULTIPLY |
10 |
COMMON |
C_PAYMENT_FROM_CLIENT_MIN_TOTAL |
1000 |
COMMON |
C_PAYMENT_FROM_CLIENT_MAX_TOTAL |
5000 |
COMMON |
C_PAYMENT_TO_SUPPLIER_MIN_TOTAL |
2000 |
COMMON |
C_PAYMENT_TO_SUPPLIER_MAX_TOTAL |
15000 |
COMMON |
BUILD_WITH_SPLIT_HEAVY_TABS |
1 |
COMMON |
BUILD_WITH_SEPAR_QDISTR_IDX |
0 |
COMMON |
BUILD_WITH_QD_COMPOUND_ORDR |
MOST_SELECTIVE_FIRST |
COMMON |
ENABLE_MON_QUERY |
0 |
COMMON |
HALT_TEST_ON_ERRORS |
,CK, |
SMALL_03 |
C_WARES_MAX_ID |
400 |
SMALL_03 |
C_CUSTOMER_DOC_MAX_ROWS |
10 |
SMALL_03 |
C_SUPPLIER_DOC_MAX_ROWS |
50 |
SMALL_03 |
C_CUSTOMER_DOC_MAX_QTY |
15 |
SMALL_03 |
C_SUPPLIER_DOC_MAX_QTY |
50 |
SMALL_03 |
C_NUMBER_OF_AGENTS |
50 |
TAB_NAME |
IDX_NAME |
IDX_KEY |
XQD_1000_1200 |
XQD_1000_1200_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_1000_3300 |
XQD_1000_3300_DOC |
DOC_ID |
XQD_1000_3300 |
XQD_1000_3300_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_1200_2000 |
XQD_1200_2000_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_2000_3300 |
XQD_2000_3300_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_2100_3300 |
XQD_2100_3300_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_3300_3400 |
XQD_3300_3400_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
Performance reports
ACTION |
AVG_TIMES_PER_MINUTE |
AVG_ELAPSED_MS |
SUCCESSFUL_TIMES_DONE |
JOB_BEG |
JOB_END |
*** OVERALL *** for 180 minutes: |
614.37 |
88689 |
110586 |
2016-03-31 20:56 |
2016-03-31 23:56 |
customer order: creation |
34.77 |
4492 |
6259 |
2016-03-31 20:56 |
2016-03-31 23:56 |
customer order: refuse |
2.69 |
64 |
485 |
2016-03-31 20:56 |
2016-03-31 23:56 |
order to supplier: creation |
8.92 |
22864 |
1606 |
2016-03-31 20:56 |
2016-03-31 23:56 |
order to supplier: removal |
0.19 |
44692 |
34 |
2016-03-31 20:56 |
2016-03-31 23:56 |
invoice (draft): creation |
8.60 |
1934 |
1548 |
2016-03-31 20:56 |
2016-03-31 23:56 |
invoice (draft): removal |
1.53 |
146 |
275 |
2016-03-31 20:56 |
2016-03-31 23:56 |
invoice accept: apply |
3.10 |
1515560 |
558 |
2016-03-31 20:56 |
2016-03-31 23:56 |
invoice accept: cancel |
0.68 |
77283 |
122 |
2016-03-31 20:56 |
2016-03-31 23:56 |
customer reserve: creation |
480.22 |
9571 |
86440 |
2016-03-31 20:56 |
2016-03-31 23:56 |
customer reserve: removal |
23.84 |
2597 |
4267 |
2016-03-31 20:56 |
2016-03-31 23:56 |
realization accept: apply |
16.12 |
72 |
2902 |
2016-03-31 20:56 |
2016-03-31 23:56 |
realization accept: cancel |
5.63 |
40 |
1007 |
2016-03-31 20:56 |
2016-03-31 23:56 |
payment from customer: creation |
11.89 |
163 |
2141 |
2016-03-31 20:56 |
2016-03-31 23:56 |
payment from customer: removal |
1.19 |
25 |
214 |
2016-03-31 20:56 |
2016-03-31 23:56 |
payment to supplier: creation |
9.32 |
386 |
1677 |
2016-03-31 20:56 |
2016-03-31 23:56 |
payment to supplier: removal |
0.71 |
40 |
126 |
2016-03-31 20:56 |
2016-03-31 23:56 |
service: total inventory turnovers |
2.79 |
3260 |
502 |
2016-03-31 20:56 |
2016-03-31 23:56 |
service: total monetary turnovers |
2.29 |
9 |
413 |
2016-03-31 20:56 |
2016-03-31 23:56 |
service: refresh index statistics |
0.07 |
1901 |
10 |
2016-03-31 20:56 |
2016-03-31 23:56 |
Done for 10250 ms, from 23:56:48.58 to 23:56:58.83.
ACTION |
ITRV_NO |
CNT_OK_PER_MINUTE |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
ITRV_BEG |
ITRV_END |
interval # 1, overall |
1 |
1665 |
32861 |
29970 |
2891 |
8.80 |
20:56:13 |
21:14:12 |
interval # 2, overall |
2 |
302 |
5865 |
5443 |
422 |
7.20 |
21:14:13 |
21:32:12 |
interval # 3, overall |
3 |
377 |
7006 |
6786 |
220 |
3.14 |
21:32:13 |
21:50:12 |
interval # 4, overall |
4 |
345 |
6359 |
6212 |
147 |
2.31 |
21:50:13 |
22:08:12 |
interval # 5, overall |
5 |
458 |
8690 |
8247 |
443 |
5.10 |
22:08:13 |
22:26:12 |
interval # 6, overall |
6 |
641 |
12059 |
11536 |
523 |
4.34 |
22:26:13 |
22:44:12 |
interval # 7, overall |
7 |
645 |
12067 |
11616 |
451 |
3.74 |
22:44:13 |
23:02:12 |
interval # 8, overall |
8 |
696 |
14443 |
12536 |
1907 |
13.20 |
23:02:13 |
23:20:12 |
interval # 9, overall |
9 |
620 |
12248 |
11154 |
1094 |
8.93 |
23:20:13 |
23:38:12 |
interval # 10, overall |
10 |
394 |
7171 |
7086 |
85 |
1.19 |
23:38:13 |
23:56:12 |
Done for 14770 ms, from 23:57:11.28 to 23:57:26.05.
TEST_PHASE |
MINUTE_SINCE_TEST_START |
AVG_ESTIMATED |
MIN_TO_AVG_RATIO |
MAX_TO_AVG_RATIO |
ROWS_AGGREGATED |
DISTINCT_ATTACHMENTS |
WARM_TIME |
1 |
1816.94 |
0.6758 |
1.2961 |
999 |
92 |
WARM_TIME |
2 |
1342.49 |
0.8774 |
1.1586 |
564 |
74 |
WARM_TIME |
3 |
1241.56 |
0.8355 |
1.1737 |
312 |
67 |
WARM_TIME |
4 |
1220.93 |
0.8954 |
1.0997 |
431 |
71 |
WARM_TIME |
5 |
1125.21 |
0.9559 |
1.0559 |
342 |
62 |
WARM_TIME |
6 |
1090.65 |
0.9080 |
1.0739 |
188 |
53 |
WARM_TIME |
7 |
1112.35 |
0.9027 |
1.1360 |
383 |
69 |
WARM_TIME |
8 |
1210.34 |
0.9136 |
1.0868 |
398 |
72 |
WARM_TIME |
9 |
1241.22 |
0.9421 |
1.0949 |
584 |
78 |
WARM_TIME |
10 |
1354.17 |
0.9033 |
1.0579 |
487 |
80 |
TEST_TIME |
11 |
1450.77 |
0.8978 |
1.0541 |
497 |
80 |
TEST_TIME |
12 |
1522.65 |
0.9209 |
1.0757 |
347 |
71 |
TEST_TIME |
13 |
1618.04 |
0.9361 |
1.0582 |
540 |
83 |
TEST_TIME |
14 |
1671.07 |
0.9515 |
1.0310 |
208 |
59 |
TEST_TIME |
15 |
1720.74 |
0.9345 |
1.1088 |
503 |
77 |
TEST_TIME |
16 |
1872.37 |
0.9553 |
1.0415 |
490 |
69 |
TEST_TIME |
17 |
1954.87 |
0.9389 |
1.0284 |
380 |
70 |
TEST_TIME |
18 |
1934.83 |
0.9813 |
1.0082 |
436 |
78 |
TEST_TIME |
19 |
1858.21 |
0.9945 |
1.0047 |
280 |
66 |
TEST_TIME |
20 |
1785.16 |
0.9936 |
1.0061 |
486 |
68 |
TEST_TIME |
21 |
1725.32 |
0.9915 |
1.0085 |
539 |
67 |
TEST_TIME |
22 |
1677.85 |
0.9900 |
1.0108 |
590 |
58 |
TEST_TIME |
23 |
1644.49 |
0.9865 |
1.0148 |
949 |
52 |
TEST_TIME |
24 |
1617.82 |
0.9886 |
1.0107 |
852 |
28 |
TEST_TIME |
25 |
1571.81 |
0.9987 |
1.0013 |
105 |
4 |
TEST_TIME |
26 |
1517.78 |
0.9970 |
1.0030 |
189 |
5 |
TEST_TIME |
27 |
1467.11 |
0.9992 |
1.0007 |
71 |
2 |
TEST_TIME |
28 |
1418.76 |
0.9996 |
1.0003 |
28 |
1 |
TEST_TIME |
29 |
1370.90 |
0.9998 |
1.0001 |
12 |
1 |
TEST_TIME |
30 |
1327.13 |
0.9991 |
1.0009 |
11 |
3 |
TEST_TIME |
31 |
1285.80 |
0.9997 |
1.0002 |
17 |
1 |
TEST_TIME |
32 |
1248.90 |
0.9975 |
1.0027 |
97 |
3 |
TEST_TIME |
33 |
1215.93 |
0.9987 |
1.0006 |
57 |
4 |
TEST_TIME |
34 |
1182.78 |
0.9984 |
1.0015 |
137 |
2 |
TEST_TIME |
35 |
1151.01 |
0.9998 |
1.0001 |
14 |
1 |
TEST_TIME |
37 |
1090.65 |
0.9993 |
1.0004 |
15 |
2 |
TEST_TIME |
38 |
1064.14 |
0.9983 |
1.0013 |
124 |
3 |
TEST_TIME |
39 |
1042.51 |
0.9959 |
1.0006 |
38 |
2 |
TEST_TIME |
40 |
1018.38 |
0.9998 |
1.0001 |
11 |
1 |
TEST_TIME |
41 |
996.91 |
0.9967 |
1.0031 |
97 |
4 |
TEST_TIME |
42 |
976.84 |
0.9994 |
1.0006 |
55 |
1 |
TEST_TIME |
43 |
954.89 |
0.9998 |
1.0001 |
12 |
1 |
TEST_TIME |
44 |
936.59 |
0.9968 |
1.0066 |
27 |
5 |
TEST_TIME |
45 |
923.83 |
0.9979 |
1.0010 |
71 |
4 |
TEST_TIME |
46 |
907.23 |
0.9991 |
1.0008 |
81 |
2 |
TEST_TIME |
47 |
889.83 |
0.9987 |
1.0024 |
108 |
3 |
TEST_TIME |
49 |
857.98 |
0.9989 |
1.0031 |
92 |
2 |
TEST_TIME |
50 |
857.53 |
0.9840 |
1.0113 |
315 |
10 |
TEST_TIME |
51 |
853.39 |
0.9963 |
1.0041 |
182 |
8 |
TEST_TIME |
52 |
846.00 |
0.9949 |
1.0030 |
107 |
5 |
TEST_TIME |
53 |
838.62 |
0.9928 |
1.0036 |
93 |
6 |
TEST_TIME |
54 |
828.35 |
0.9995 |
1.0009 |
24 |
3 |
TEST_TIME |
55 |
816.06 |
0.9998 |
1.0001 |
15 |
1 |
TEST_TIME |
56 |
804.73 |
0.9961 |
1.0015 |
104 |
4 |
TEST_TIME |
57 |
792.78 |
0.9988 |
1.0029 |
70 |
3 |
TEST_TIME |
58 |
782.92 |
0.9981 |
1.0045 |
84 |
5 |
TEST_TIME |
59 |
775.37 |
0.9973 |
1.0019 |
64 |
3 |
TEST_TIME |
60 |
765.32 |
0.9999 |
1.0000 |
2 |
1 |
TEST_TIME |
61 |
752.92 |
0.9998 |
1.0001 |
19 |
1 |
TEST_TIME |
62 |
741.23 |
0.9995 |
1.0004 |
39 |
1 |
TEST_TIME |
63 |
730.27 |
0.9997 |
1.0002 |
26 |
1 |
TEST_TIME |
64 |
719.18 |
0.9999 |
1.0000 |
9 |
1 |
TEST_TIME |
65 |
710.75 |
0.9989 |
1.0013 |
52 |
2 |
TEST_TIME |
66 |
701.92 |
0.9986 |
1.0013 |
136 |
3 |
TEST_TIME |
67 |
694.45 |
0.9970 |
1.0037 |
9 |
2 |
TEST_TIME |
68 |
691.89 |
0.9926 |
1.0076 |
143 |
4 |
TEST_TIME |
69 |
687.73 |
0.9990 |
1.0009 |
98 |
3 |
TEST_TIME |
70 |
680.46 |
0.9985 |
1.0025 |
72 |
2 |
TEST_TIME |
71 |
675.90 |
0.9970 |
1.0040 |
57 |
5 |
TEST_TIME |
72 |
670.09 |
0.9987 |
1.0018 |
36 |
3 |
TEST_TIME |
73 |
662.17 |
0.9999 |
1.0000 |
8 |
1 |
TEST_TIME |
74 |
653.81 |
0.9993 |
1.0007 |
20 |
2 |
TEST_TIME |
77 |
629.65 |
0.9998 |
1.0001 |
19 |
1 |
TEST_TIME |
78 |
624.06 |
0.9997 |
1.0002 |
24 |
1 |
TEST_TIME |
79 |
618.61 |
0.9962 |
1.0010 |
80 |
2 |
TEST_TIME |
81 |
605.27 |
0.9999 |
1.0000 |
6 |
1 |
TEST_TIME |
82 |
600.56 |
0.9956 |
1.0076 |
138 |
4 |
TEST_TIME |
83 |
598.88 |
0.9983 |
1.0026 |
27 |
3 |
TEST_TIME |
85 |
586.52 |
0.9998 |
1.0001 |
14 |
1 |
TEST_TIME |
86 |
580.86 |
0.9981 |
1.0023 |
37 |
2 |
TEST_TIME |
87 |
579.36 |
0.9959 |
1.0015 |
45 |
3 |
TEST_TIME |
88 |
576.08 |
0.9957 |
1.0079 |
110 |
5 |
TEST_TIME |
89 |
575.77 |
0.9971 |
1.0010 |
105 |
4 |
TEST_TIME |
90 |
573.69 |
0.9973 |
1.0032 |
75 |
4 |
TEST_TIME |
91 |
569.26 |
0.9999 |
1.0000 |
11 |
2 |
TEST_TIME |
92 |
563.84 |
0.9998 |
1.0001 |
15 |
1 |
TEST_TIME |
93 |
563.03 |
0.9939 |
1.0031 |
140 |
6 |
TEST_TIME |
94 |
561.48 |
0.9952 |
1.0054 |
137 |
6 |
TEST_TIME |
95 |
559.04 |
0.9992 |
1.0007 |
88 |
2 |
TEST_TIME |
96 |
558.02 |
0.9955 |
1.0040 |
59 |
4 |
TEST_TIME |
97 |
555.15 |
0.9988 |
1.0034 |
27 |
3 |
TEST_TIME |
98 |
552.66 |
0.9977 |
1.0010 |
109 |
5 |
TEST_TIME |
99 |
549.28 |
0.9970 |
1.0035 |
90 |
4 |
TEST_TIME |
100 |
550.58 |
0.9950 |
1.0034 |
38 |
3 |
TEST_TIME |
101 |
549.75 |
0.9991 |
1.0018 |
53 |
3 |
TEST_TIME |
102 |
546.04 |
0.9987 |
1.0036 |
44 |
3 |
TEST_TIME |
103 |
545.10 |
0.9956 |
1.0037 |
131 |
4 |
TEST_TIME |
104 |
544.65 |
0.9999 |
1.0000 |
9 |
1 |
TEST_TIME |
105 |
544.59 |
0.9906 |
1.0070 |
48 |
5 |
TEST_TIME |
106 |
543.92 |
0.9988 |
1.0054 |
102 |
6 |
TEST_TIME |
110 |
532.14 |
0.9948 |
1.0005 |
35 |
4 |
TEST_TIME |
111 |
532.84 |
0.9902 |
1.0068 |
198 |
6 |
TEST_TIME |
112 |
534.50 |
0.9947 |
1.0096 |
93 |
8 |
TEST_TIME |
113 |
537.60 |
0.9950 |
1.0029 |
212 |
6 |
TEST_TIME |
114 |
538.95 |
0.9961 |
1.0033 |
104 |
4 |
TEST_TIME |
115 |
540.01 |
0.9927 |
1.0026 |
90 |
4 |
TEST_TIME |
116 |
541.18 |
0.9991 |
1.0010 |
62 |
4 |
TEST_TIME |
117 |
542.10 |
0.9950 |
1.0052 |
47 |
7 |
TEST_TIME |
118 |
542.42 |
0.9961 |
1.0048 |
99 |
6 |
TEST_TIME |
119 |
545.22 |
0.9964 |
1.0084 |
77 |
6 |
TEST_TIME |
120 |
555.27 |
0.9820 |
1.0096 |
236 |
7 |
TEST_TIME |
121 |
557.68 |
0.9969 |
1.0034 |
105 |
4 |
TEST_TIME |
122 |
555.15 |
0.9998 |
1.0002 |
19 |
2 |
TEST_TIME |
123 |
551.00 |
0.9995 |
1.0003 |
19 |
3 |
TEST_TIME |
124 |
547.85 |
0.9980 |
1.0018 |
44 |
4 |
TEST_TIME |
125 |
548.57 |
0.9953 |
1.0026 |
169 |
5 |
TEST_TIME |
126 |
551.07 |
0.9901 |
1.0040 |
263 |
6 |
TEST_TIME |
127 |
553.43 |
0.9955 |
1.0053 |
61 |
6 |
TEST_TIME |
128 |
555.59 |
0.9936 |
1.0039 |
172 |
6 |
TEST_TIME |
129 |
558.62 |
0.9908 |
1.0030 |
103 |
4 |
TEST_TIME |
130 |
565.39 |
0.9937 |
1.0061 |
132 |
6 |
TEST_TIME |
131 |
566.95 |
0.9957 |
1.0021 |
108 |
4 |
TEST_TIME |
132 |
569.06 |
0.9999 |
1.0000 |
10 |
2 |
TEST_TIME |
133 |
567.10 |
0.9959 |
1.0011 |
97 |
3 |
TEST_TIME |
134 |
567.10 |
0.9953 |
1.0020 |
108 |
4 |
TEST_TIME |
135 |
565.14 |
0.9998 |
1.0001 |
26 |
1 |
TEST_TIME |
136 |
569.46 |
0.9954 |
1.0007 |
62 |
4 |
TEST_TIME |
137 |
568.30 |
0.9955 |
1.0097 |
157 |
8 |
TEST_TIME |
138 |
574.35 |
0.9918 |
1.0103 |
207 |
11 |
TEST_TIME |
139 |
581.13 |
0.9913 |
1.0022 |
229 |
8 |
TEST_TIME |
140 |
580.02 |
0.9977 |
1.0024 |
77 |
3 |
TEST_TIME |
141 |
582.59 |
0.9919 |
1.0036 |
77 |
5 |
TEST_TIME |
142 |
583.30 |
0.9954 |
1.0055 |
191 |
6 |
TEST_TIME |
143 |
584.65 |
0.9961 |
1.0061 |
78 |
6 |
TEST_TIME |
144 |
587.51 |
0.9943 |
1.0066 |
104 |
9 |
TEST_TIME |
145 |
587.64 |
0.9995 |
1.0006 |
30 |
2 |
TEST_TIME |
146 |
588.56 |
0.9938 |
1.0045 |
135 |
8 |
TEST_TIME |
147 |
589.21 |
0.9966 |
1.0016 |
15 |
2 |
TEST_TIME |
148 |
586.69 |
0.9991 |
1.0035 |
88 |
4 |
TEST_TIME |
149 |
591.77 |
0.9898 |
1.0042 |
120 |
6 |
TEST_TIME |
150 |
593.44 |
0.9958 |
1.0027 |
110 |
7 |
TEST_TIME |
151 |
592.05 |
0.9984 |
1.0010 |
10 |
3 |
TEST_TIME |
152 |
590.92 |
0.9969 |
1.0027 |
191 |
9 |
TEST_TIME |
153 |
595.85 |
0.9947 |
1.0036 |
188 |
8 |
TEST_TIME |
154 |
595.24 |
0.9981 |
1.0052 |
67 |
5 |
TEST_TIME |
155 |
596.10 |
0.9972 |
1.0040 |
94 |
5 |
TEST_TIME |
156 |
597.15 |
0.9995 |
1.0019 |
12 |
2 |
TEST_TIME |
157 |
597.34 |
0.9952 |
1.0037 |
40 |
4 |
TEST_TIME |
158 |
600.08 |
0.9928 |
1.0039 |
246 |
7 |
TEST_TIME |
159 |
603.24 |
0.9924 |
1.0040 |
72 |
6 |
TEST_TIME |
160 |
604.92 |
0.9950 |
1.0045 |
120 |
6 |
TEST_TIME |
161 |
604.23 |
0.9995 |
1.0005 |
104 |
3 |
TEST_TIME |
162 |
606.24 |
0.9942 |
1.0082 |
153 |
8 |
TEST_TIME |
163 |
613.33 |
0.9904 |
1.0020 |
222 |
6 |
TEST_TIME |
164 |
612.71 |
0.9969 |
1.0016 |
34 |
3 |
TEST_TIME |
165 |
613.27 |
0.9946 |
1.0049 |
87 |
5 |
TEST_TIME |
166 |
615.62 |
0.9951 |
1.0019 |
103 |
7 |
TEST_TIME |
167 |
613.94 |
0.9986 |
1.0029 |
61 |
4 |
TEST_TIME |
168 |
616.06 |
0.9946 |
1.0022 |
132 |
7 |
TEST_TIME |
169 |
614.84 |
0.9982 |
1.0010 |
13 |
2 |
TEST_TIME |
170 |
614.85 |
0.9965 |
1.0027 |
35 |
3 |
TEST_TIME |
171 |
614.81 |
0.9976 |
1.0012 |
49 |
3 |
TEST_TIME |
172 |
614.34 |
0.9976 |
1.0012 |
59 |
2 |
TEST_TIME |
173 |
614.93 |
0.9958 |
1.0054 |
117 |
5 |
TEST_TIME |
174 |
619.99 |
0.9943 |
1.0101 |
86 |
7 |
TEST_TIME |
175 |
624.68 |
0.9968 |
1.0043 |
101 |
7 |
TEST_TIME |
176 |
626.46 |
0.9957 |
1.0035 |
126 |
8 |
TEST_TIME |
177 |
628.68 |
0.9975 |
1.0013 |
85 |
5 |
TEST_TIME |
178 |
628.88 |
0.9984 |
1.0032 |
63 |
4 |
TEST_TIME |
179 |
629.36 |
0.9996 |
1.0002 |
13 |
2 |
TEST_TIME |
180 |
628.92 |
0.9954 |
1.0023 |
53 |
6 |
TEST_TIME |
181 |
628.50 |
0.9974 |
1.0055 |
178 |
6 |
TEST_TIME |
182 |
629.54 |
0.9983 |
1.0036 |
52 |
5 |
TEST_TIME |
183 |
629.47 |
0.9992 |
1.0020 |
42 |
3 |
TEST_TIME |
184 |
631.30 |
0.9970 |
1.0024 |
91 |
5 |
TEST_TIME |
185 |
632.11 |
0.9957 |
1.0019 |
133 |
4 |
TEST_TIME |
186 |
635.12 |
0.9976 |
1.0048 |
42 |
4 |
TEST_TIME |
187 |
636.46 |
0.9987 |
1.0021 |
206 |
5 |
TEST_TIME |
188 |
642.81 |
0.9886 |
1.0092 |
202 |
9 |
TEST_TIME |
189 |
647.15 |
0.9972 |
1.0012 |
107 |
4 |
TEST_TIME |
190 |
649.20 |
0.9964 |
1.0004 |
244 |
100 |
Done for 9800 ms, from 23:57:26.31 to 23:57:36.11.
TRACED_DATA |
ITRV_NO |
SP_CLIENT_ORDER |
SP_CANCEL_CLIENT_ORDER |
SP_SUPPLIER_ORDER |
SP_CANCEL_SUPPLIER_ORDER |
SP_SUPPLIER_INVOICE |
SP_CANCEL_SUPPLIER_INVOICE |
SP_ADD_INVOICE_TO_STOCK |
SP_CANCEL_ADDING_INVOICE |
SP_CUSTOMER_RESERVE |
SP_CANCEL_CUSTOMER_RESERVE |
SP_RESERVE_WRITE_OFF |
SP_CANCEL_WRITE_OFF |
SP_PAY_FROM_CUSTOMER |
SP_CANCEL_PAY_FROM_CUSTOMER |
SP_PAY_TO_SUPPLIER |
SP_CANCEL_PAY_TO_SUPPLIER |
SRV_MAKE_INVNT_SALDO |
SRV_MAKE_MONEY_SALDO |
SRV_RECALC_IDX_STAT |
ITRV_BEG |
ITRV_END |
fetches per second |
1 |
2845 |
39933 |
426 |
<null> |
33325 |
<null> |
65796 |
<null> |
19013 |
<null> |
18803 |
16528 |
36859 |
12953 |
112501 |
<null> |
287662 |
263059 |
<null> |
20:56:13 |
21:14:12 |
fetches per second |
6 |
38833 |
<null> |
28062 |
<null> |
57077 |
<null> |
640 |
<null> |
2365 |
23369 |
39531 |
<null> |
160379 |
<null> |
290822 |
<null> |
<null> |
<null> |
<null> |
22:26:13 |
22:44:12 |
fetches per second |
7 |
57935 |
104897 |
38870 |
82653 |
74745 |
<null> |
1023 |
<null> |
<null> |
272 |
64040 |
42493 |
243841 |
<null> |
341368 |
100636 |
89900 |
2362666 |
<null> |
22:44:13 |
23:02:12 |
fetches per second |
8 |
49309 |
51407 |
42049 |
128371 |
53695 |
75285 |
1279 |
18318 |
844 |
<null> |
57572 |
31824 |
153529 |
69825 |
277260 |
<null> |
68660 |
<null> |
<null> |
23:02:13 |
23:20:12 |
marks per second |
1 |
538 |
3670 |
64 |
<null> |
4585 |
<null> |
3165 |
<null> |
1381 |
<null> |
2954 |
2615 |
1523 |
1878 |
1912 |
<null> |
5401 |
1500 |
<null> |
20:56:13 |
21:14:12 |
marks per second |
6 |
7471 |
<null> |
1722 |
<null> |
3585 |
<null> |
44 |
<null> |
208 |
2205 |
6562 |
<null> |
1827 |
<null> |
5377 |
<null> |
<null> |
<null> |
<null> |
22:26:13 |
22:44:12 |
marks per second |
7 |
9856 |
10377 |
2532 |
12689 |
4599 |
<null> |
73 |
<null> |
<null> |
82 |
11518 |
7000 |
2768 |
<null> |
5182 |
8909 |
714 |
8444 |
<null> |
22:44:13 |
23:02:12 |
marks per second |
8 |
8596 |
4543 |
2627 |
17780 |
2885 |
9969 |
84 |
1654 |
73 |
<null> |
8650 |
4684 |
1886 |
6625 |
3235 |
<null> |
485 |
<null> |
<null> |
23:02:13 |
23:20:12 |
reads/fetches*100 |
1 |
28 |
7 |
29 |
<null> |
8 |
<null> |
5 |
<null> |
11 |
<null> |
10 |
6 |
9 |
6 |
4 |
<null> |
7 |
1 |
<null> |
20:56:13 |
21:14:12 |
reads/fetches*100 |
6 |
6 |
<null> |
9 |
<null> |
7 |
<null> |
13 |
<null> |
16 |
3 |
6 |
<null> |
5 |
<null> |
4 |
<null> |
<null> |
<null> |
<null> |
22:26:13 |
22:44:12 |
reads/fetches*100 |
7 |
5 |
4 |
8 |
2 |
6 |
<null> |
14 |
<null> |
<null> |
38 |
6 |
6 |
5 |
<null> |
3 |
4 |
28 |
0 |
<null> |
22:44:13 |
23:02:12 |
reads/fetches*100 |
8 |
4 |
4 |
8 |
3 |
7 |
4 |
13 |
3 |
15 |
<null> |
7 |
7 |
5 |
4 |
4 |
<null> |
27 |
<null> |
<null> |
23:02:13 |
23:20:12 |
writes/marks*100 |
1 |
5 |
15 |
1 |
<null> |
7 |
<null> |
4 |
<null> |
11 |
<null> |
7 |
6 |
3 |
0 |
3 |
<null> |
29 |
0 |
<null> |
20:56:13 |
21:14:12 |
writes/marks*100 |
6 |
13 |
<null> |
10 |
<null> |
7 |
<null> |
1 |
<null> |
14 |
7 |
8 |
<null> |
9 |
<null> |
4 |
<null> |
<null> |
<null> |
<null> |
22:26:13 |
22:44:12 |
writes/marks*100 |
7 |
13 |
13 |
12 |
5 |
7 |
<null> |
1 |
<null> |
<null> |
1 |
7 |
6 |
11 |
<null> |
4 |
0 |
51 |
0 |
<null> |
22:44:13 |
23:02:12 |
writes/marks*100 |
8 |
13 |
14 |
8 |
6 |
10 |
3 |
3 |
5 |
20 |
<null> |
8 |
7 |
11 |
0 |
6 |
<null> |
50 |
<null> |
<null> |
23:02:13 |
23:20:12 |
Done for 5640 ms, from 23:57:36.33 to 23:57:41.97.
UNIT |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
OK_MIN_MS |
OK_MAX_MS |
OK_AVG_MS |
CNT_LK_CONFL |
JOB_BEG |
JOB_END |
doc_list_aiud |
85689 |
78680 |
7009 |
8.17 |
0 |
9747 |
31 |
7009 |
2016-03-31 20:56 |
2016-03-31 23:56 |
doc_list_biud |
85778 |
78679 |
7099 |
8.27 |
0 |
418463 |
388 |
7099 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_add_invoice_to_stock |
1404 |
558 |
846 |
60.25 |
124 |
9210722 |
1515560 |
846 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_cancel_adding_invoice |
197 |
122 |
75 |
38.07 |
15 |
1139083 |
77283 |
75 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_cancel_client_order |
538 |
485 |
53 |
9.85 |
0 |
2215 |
64 |
53 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_cancel_customer_reserve |
9508 |
4267 |
5241 |
55.12 |
0 |
160044 |
2597 |
5241 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_cancel_pay_from_customer |
216 |
214 |
2 |
0.92 |
0 |
639 |
25 |
2 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_cancel_pay_to_supplier |
130 |
126 |
4 |
3.07 |
0 |
874 |
40 |
4 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_cancel_supplier_invoice |
380 |
275 |
105 |
27.63 |
0 |
2075 |
146 |
105 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_cancel_supplier_order |
119 |
34 |
85 |
71.42 |
141 |
372342 |
44692 |
85 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_cancel_write_off |
2731 |
1007 |
1724 |
63.12 |
0 |
3714 |
40 |
1724 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_client_order |
6259 |
6259 |
0 |
0.00 |
0 |
91119 |
4492 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_customer_reserve |
86440 |
86440 |
0 |
0.00 |
0 |
78204 |
9571 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_fill_shopping_cart |
9413 |
9413 |
0 |
0.00 |
0 |
58658 |
892 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_fill_shopping_cart_clo_res |
86440 |
86440 |
0 |
0.00 |
0 |
624 |
2 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_get_clo_for_invoice |
558 |
558 |
0 |
0.00 |
0 |
1124 |
103 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_kill_cost_storno |
3211 |
1469 |
1742 |
54.25 |
0 |
3634 |
11 |
1742 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_kill_qstorno_ret_qs2qd |
22054 |
9850 |
12204 |
55.33 |
0 |
159966 |
1179 |
12204 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_kill_qty_storno |
16728 |
9650 |
7078 |
42.31 |
0 |
418463 |
3159 |
7078 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_lock_selected_doc |
6079 |
4920 |
1159 |
19.06 |
0 |
63 |
0 |
1159 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_make_cost_storno |
7278 |
7278 |
0 |
0.00 |
0 |
7738 |
126 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_multiply_rows_for_pdistr |
7278 |
7278 |
0 |
0.00 |
0 |
1596 |
26 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_multiply_rows_for_qdistr |
6259 |
6259 |
0 |
0.00 |
0 |
89840 |
4356 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_pay_from_customer |
2141 |
2141 |
0 |
0.00 |
31 |
3838 |
163 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_pay_to_supplier |
1677 |
1677 |
0 |
0.00 |
31 |
9469 |
386 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_payment_common |
3818 |
3818 |
0 |
0.00 |
0 |
1030 |
28 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_qd_handle_on_cancel_clo |
538 |
485 |
53 |
9.85 |
0 |
2184 |
43 |
53 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_qd_handle_on_invoice_upd_sts |
729 |
680 |
49 |
6.72 |
0 |
418463 |
27541 |
49 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_qd_handle_on_reserve_upd_sts |
2903 |
2902 |
1 |
0.03 |
0 |
218 |
12 |
1 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_reserve_write_off |
2950 |
2902 |
48 |
1.62 |
0 |
2574 |
72 |
48 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_supplier_invoice |
1548 |
1548 |
0 |
0.00 |
15 |
58705 |
1934 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
sp_supplier_order |
1606 |
1606 |
0 |
0.00 |
15 |
254422 |
22864 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
srv_find_qd_qs_mism |
49145 |
42132 |
7013 |
14.27 |
0 |
6942 |
30 |
7013 |
2016-03-31 20:56 |
2016-03-31 23:56 |
srv_make_invnt_saldo |
502 |
502 |
0 |
0.00 |
328 |
12205 |
3260 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
srv_make_money_saldo |
413 |
413 |
0 |
0.00 |
0 |
62 |
9 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
srv_recalc_idx_stat |
10 |
10 |
0 |
0.00 |
1123 |
2808 |
1901 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-abend:sp_add_invoice_to_stock |
846 |
846 |
0 |
0.00 |
0 |
358 |
12 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-abend:sp_cancel_adding_invoice |
163 |
163 |
0 |
0.00 |
0 |
811 |
54 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-abend:sp_cancel_client_order |
53 |
53 |
0 |
0.00 |
0 |
219 |
19 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-abend:sp_cancel_customer_reserve |
4 |
4 |
0 |
0.00 |
0 |
0 |
0 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-abend:sp_cancel_pay_from_customer |
2 |
2 |
0 |
0.00 |
0 |
31 |
15 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-abend:sp_cancel_pay_to_supplier |
4 |
4 |
0 |
0.00 |
0 |
16 |
7 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-abend:sp_cancel_supplier_invoice |
72 |
72 |
0 |
0.00 |
0 |
124 |
10 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-abend:sp_cancel_supplier_order |
730 |
730 |
0 |
0.00 |
0 |
520 |
41 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-abend:sp_cancel_write_off |
2 |
2 |
0 |
0.00 |
0 |
0 |
0 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-abend:sp_reserve_write_off |
48 |
48 |
0 |
0.00 |
0 |
140 |
13 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-norm:sp_add_invoice_to_stock |
558 |
558 |
0 |
0.00 |
0 |
2309 |
296 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-norm:sp_cancel_adding_invoice |
84 |
84 |
0 |
0.00 |
0 |
1700 |
155 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-norm:sp_cancel_client_order |
485 |
485 |
0 |
0.00 |
0 |
499 |
22 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-norm:sp_cancel_customer_reserve |
179 |
179 |
0 |
0.00 |
0 |
562 |
30 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-norm:sp_cancel_pay_from_customer |
214 |
214 |
0 |
0.00 |
0 |
375 |
19 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-norm:sp_cancel_pay_to_supplier |
126 |
126 |
0 |
0.00 |
0 |
406 |
23 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-norm:sp_cancel_supplier_invoice |
47 |
47 |
0 |
0.00 |
0 |
141 |
11 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-norm:sp_cancel_supplier_order |
35 |
35 |
0 |
0.00 |
0 |
2652 |
477 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-norm:sp_cancel_write_off |
291 |
291 |
0 |
0.00 |
0 |
483 |
24 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-norm:sp_client_order |
6311 |
6311 |
0 |
0.00 |
0 |
796 |
30 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-norm:sp_customer_reserve |
289 |
289 |
0 |
0.00 |
0 |
218 |
14 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-norm:sp_pay_from_customer |
2141 |
2141 |
0 |
0.00 |
0 |
515 |
20 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-norm:sp_pay_to_supplier |
1677 |
1677 |
0 |
0.00 |
0 |
562 |
18 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-norm:sp_reserve_write_off |
2902 |
2902 |
0 |
0.00 |
0 |
843 |
25 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-norm:sp_supplier_invoice |
1548 |
1548 |
0 |
0.00 |
0 |
749 |
23 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-norm:sp_supplier_order |
1653 |
1653 |
0 |
0.00 |
0 |
655 |
30 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-norm:srv_make_invnt_saldo |
502 |
502 |
0 |
0.00 |
0 |
203 |
6 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-norm:srv_make_money_saldo |
413 |
413 |
0 |
0.00 |
0 |
109 |
5 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
t$perf-norm:srv_recalc_idx_stat |
10 |
10 |
0 |
0.00 |
0 |
93 |
19 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
v_add_invoice_to_stock |
2808 |
1116 |
1692 |
60.25 |
0 |
110 |
3 |
1692 |
2016-03-31 20:56 |
2016-03-31 23:56 |
v_all_customers |
9374 |
9374 |
0 |
0.00 |
0 |
31 |
0 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
v_all_suppliers |
6308 |
6308 |
0 |
0.00 |
0 |
16 |
0 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
v_all_wares |
12518 |
12518 |
0 |
0.00 |
0 |
16 |
0 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
v_cancel_adding_invoice |
254 |
168 |
86 |
33.85 |
0 |
63 |
7 |
86 |
2016-03-31 20:56 |
2016-03-31 23:56 |
v_cancel_client_order |
1076 |
970 |
106 |
9.85 |
0 |
32 |
0 |
106 |
2016-03-31 20:56 |
2016-03-31 23:56 |
v_cancel_customer_prepayment |
432 |
428 |
4 |
0.92 |
0 |
16 |
1 |
4 |
2016-03-31 20:56 |
2016-03-31 23:56 |
v_cancel_customer_reserve |
366 |
358 |
8 |
2.18 |
0 |
21 |
1 |
8 |
2016-03-31 20:56 |
2016-03-31 23:56 |
v_cancel_payment_to_supplier |
260 |
252 |
8 |
3.07 |
0 |
16 |
1 |
8 |
2016-03-31 20:56 |
2016-03-31 23:56 |
v_cancel_supplier_invoice |
238 |
94 |
144 |
60.50 |
0 |
16 |
3 |
144 |
2016-03-31 20:56 |
2016-03-31 23:56 |
v_cancel_supplier_order |
238 |
68 |
170 |
71.42 |
0 |
16 |
0 |
170 |
2016-03-31 20:56 |
2016-03-31 23:56 |
v_cancel_write_off |
586 |
582 |
4 |
0.68 |
0 |
32 |
2 |
4 |
2016-03-31 20:56 |
2016-03-31 23:56 |
v_max_id_clo_ord |
1606 |
1606 |
0 |
0.00 |
0 |
2792 |
36 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
v_max_id_clo_res |
289 |
289 |
0 |
0.00 |
0 |
16 |
2 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
v_max_id_ord_sup |
1548 |
1548 |
0 |
0.00 |
0 |
274 |
9 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
v_max_non_paid_invoice |
1677 |
1677 |
0 |
0.00 |
0 |
327 |
4 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
v_max_non_paid_realizn |
2141 |
2141 |
0 |
0.00 |
0 |
94 |
5 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
v_min_id_clo_ord |
1606 |
1606 |
0 |
0.00 |
0 |
1918 |
66 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
v_min_id_clo_res |
289 |
289 |
0 |
0.00 |
0 |
16 |
1 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
v_min_id_ord_sup |
1548 |
1548 |
0 |
0.00 |
0 |
3105 |
38 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
v_min_non_paid_invoice |
1677 |
1677 |
0 |
0.00 |
0 |
687 |
24 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
v_min_non_paid_realizn |
2141 |
2141 |
0 |
0.00 |
0 |
203 |
11 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
v_our_firm |
3144 |
3144 |
0 |
0.00 |
0 |
16 |
0 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
v_reserve_write_off |
5900 |
5804 |
96 |
1.62 |
0 |
60 |
1 |
96 |
2016-03-31 20:56 |
2016-03-31 23:56 |
x_lock_depdocs_on_canc_invoice |
656 |
350 |
306 |
46.64 |
0 |
47 |
3 |
306 |
2016-03-31 20:56 |
2016-03-31 23:56 |
x_lock_depdocs_on_canc_sup_ord |
119 |
34 |
85 |
71.42 |
0 |
16 |
2 |
85 |
2016-03-31 20:56 |
2016-03-31 23:56 |
x_make_qstorno_1000_1200 |
1613 |
1613 |
0 |
0.00 |
15 |
241068 |
19072 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
x_make_qstorno_1200_2000 |
1548 |
1548 |
0 |
0.00 |
0 |
15187 |
653 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
x_make_qstorno_2100_3300 |
86440 |
86440 |
0 |
0.00 |
0 |
78189 |
9558 |
0 |
2016-03-31 20:56 |
2016-03-31 23:56 |
Done for 26970 ms, from 23:58:01.46 to 23:58:28.43.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
DTS_BEG |
DTS_END |
deadlock |
7 |
sp_kill_cost_storno |
335544336 |
2016-03-31 20:57 |
2016-03-31 21:30 |
deadlock |
3 |
sp_lock_selected_doc |
335544336 |
2016-03-31 20:57 |
2016-03-31 21:03 |
deadlock |
5 |
sp_qd_handle_on_invoice_upd_sts |
335544336 |
2016-03-31 21:32 |
2016-03-31 23:12 |
lock_conflict |
6 |
sp_kill_cost_storno |
335544345 |
2016-03-31 21:02 |
2016-03-31 23:05 |
lock_conflict |
968 |
sp_lock_selected_doc |
335544345 |
2016-03-31 20:56 |
2016-03-31 23:56 |
lock_conflict |
53 |
sp_qd_handle_on_cancel_clo |
335544345 |
2016-03-31 20:57 |
2016-03-31 23:47 |
lock_conflict |
27 |
sp_qd_handle_on_invoice_upd_sts |
335544345 |
2016-03-31 20:57 |
2016-03-31 23:30 |
lock_conflict |
1 |
sp_qd_handle_on_reserve_upd_sts |
335544345 |
2016-03-31 21:09 |
2016-03-31 21:09 |
lock_conflict |
61 |
x_lock_depdocs_on_canc_invoice |
335544345 |
2016-03-31 20:57 |
2016-03-31 23:50 |
lock_conflict |
27 |
x_lock_depdocs_on_canc_sup_ord |
335544345 |
2016-03-31 21:06 |
2016-03-31 23:47 |
Done for 2570 ms, from 23:58:29.13 to 23:58:31.70.
MON$DATABASE_NAME D:\OLTP-EMUL\OLTP25-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 11
MON$ODS_MINOR 2
MON$OLDEST_TRANSACTION 95826
MON$OLDEST_ACTIVE 95827
MON$OLDEST_SNAPSHOT 95827
MON$NEXT_TRANSACTION 95827
MON$PAGE_BUFFERS 384
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2015-12-11 10:02:47.3010
MON$PAGES 184643
MON$STAT_ID 1
MON$BACKUP_STATE 0
ISQL Version: WI-V2.5.6.26991 Firebird 2.5
Server version:
Firebird/x86-64/Windows NT (access method), version "WI-V2.5.6.26991 Firebird 2.5"
Firebird/x86-64/Windows NT (remote server), version "WI-V2.5.6.26991 Firebird 2.5/tcp (WIN-2BE1UI8LGDL)/P12"
Firebird/x86-64/Windows NT (remote interface), version "WI-V2.5.6.26991 Firebird 2.5/tcp (WIN-2BE1UI8LGDL)/P12"
on disk structure version 11.2
Database "D:\OLTP-EMUL\oltp25-small.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 100313
Page size 8192
ODS version 11.2
Oldest transaction 95828
Oldest active 95829
Oldest snapshot 95829
Next transaction 95830
Bumped transaction 1
Sequence number 0
Next attachment ID 4452
Implementation ID 24
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Dec 11, 2015 10:02:47
Attributes force write
Variable header data:
Sweep interval: 0
*END*
Database file sequence:
File D:\OLTP-EMUL\oltp25-small.fdb is the only file
Analyzing database pages ...
AGENTS (154)
Primary pointer page: 259, Index root page: 260
Average record length: 34.62, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 32%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_ID_DESC (2)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_OUR_FIRM (4)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 0.06, total dup: 48, max dup: 48
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_SUPPLIER (3)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 0.06, total dup: 48, max dup: 47
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_NAME_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 13.88, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_AGENTS (0)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BUSINESS_OPS (158)
Primary pointer page: 280, Index root page: 281
Average record length: 103.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 28%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BO_UNIT_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 14.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BUSINESS_OPS_RND_WGTH (2)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 0.84, total dup: 7, max dup: 3
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$1 (0)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 1.63, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DOC_DATA (141)
Primary pointer page: 199, Index root page: 200
Average record length: 43.31, total records: 508598
Average version length: 46.13, total versions: 30272, max versions: 1
Data pages: 5409, data page slots: 5409, average fill: 74%
Fill distribution:
0 - 19% = 3
20 - 39% = 8
40 - 59% = 74
60 - 79% = 5174
80 - 99% = 150
Index DOC_DATA_DOC_WARE_UNQ (1)
Depth: 3, leaf buckets: 1740, nodes: 508598
Average data length: 11.98, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 163
20 - 39% = 44
40 - 59% = 792
60 - 79% = 95
80 - 99% = 646
Index DOC_DATA_ID_DESC (2)
Depth: 3, leaf buckets: 1488, nodes: 508598
Average data length: 5.94, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 23
40 - 59% = 1464
60 - 79% = 1
80 - 99% = 0
Index FK_DOC_DATA_DOC_LIST (3)
Depth: 3, leaf buckets: 532, nodes: 508598
Average data length: 0.99, total dup: 428632, max dup: 49
Fill distribution:
0 - 19% = 9
20 - 39% = 24
40 - 59% = 260
60 - 79% = 10
80 - 99% = 229
DOC_LIST (140)
Primary pointer page: 195, Index root page: 196
Average record length: 57.85, total records: 92791
Average version length: 45.17, total versions: 10748, max versions: 5
Data pages: 1190, data page slots: 1190, average fill: 79%
Fill distribution:
0 - 19% = 3
20 - 39% = 32
40 - 59% = 49
60 - 79% = 509
80 - 99% = 597
Index DOC_LIST_ID_DESC (1)
Depth: 2, leaf buckets: 272, nodes: 92791
Average data length: 6.24, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 16
40 - 59% = 255
60 - 79% = 1
80 - 99% = 0
Index FK_DOC_LIST_AGENTS (2)
Depth: 2, leaf buckets: 79, nodes: 92791
Average data length: 0.01, total dup: 92741, max dup: 18820
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 47
60 - 79% = 26
80 - 99% = 6
Index PK_DOC_LIST (0)
Depth: 2, leaf buckets: 210, nodes: 92791
Average data length: 6.24, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 13
20 - 39% = 15
40 - 59% = 107
60 - 79% = 1
80 - 99% = 74
DOC_STATES (153)
Primary pointer page: 257, Index root page: 258
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_MCODE_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 13.75, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_NAME_UNQ (2)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 29.75, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_DOC_STATES (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 1.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
FB_ERRORS (159)
Primary pointer page: 287, Index root page: 288
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 12, data page slots: 12, average fill: 75%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7
Index FB_ERRORS_GDS_CODE (0)
Depth: 1, leaf buckets: 1, nodes: 758
Average data length: 1.03, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
INVNT_SALDO (147)
Primary pointer page: 216, Index root page: 217
Average record length: 63.55, total records: 400
Average version length: 13.75, total versions: 110437, max versions: 323
Data pages: 439, data page slots: 439, average fill: 96%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 438
Index PK_INVNT_SALDO (0)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
INVNT_TURNOVER_LOG (157)
Primary pointer page: 278, Index root page: 279
Average record length: 0.07, total records: 146404
Average version length: 68.27, total versions: 146275, max versions: 1
Data pages: 2113, data page slots: 2113, average fill: 87%
Fill distribution:
0 - 19% = 15
20 - 39% = 38
40 - 59% = 83
60 - 79% = 181
80 - 99% = 1796
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Depth: 3, leaf buckets: 400, nodes: 146404
Average data length: 8.23, total dup: 15979, max dup: 5
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 194
60 - 79% = 182
80 - 99% = 21
MONEY_SALDO (143)
Primary pointer page: 208, Index root page: 209
Average record length: 15.82, total records: 49
Average version length: 9.00, total versions: 5388, max versions: 454
Data pages: 20, data page slots: 20, average fill: 87%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 18
Index PK_MONEY_SALDO (0)
Depth: 1, leaf buckets: 1, nodes: 49
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MONEY_TURNOVER_LOG (142)
Primary pointer page: 206, Index root page: 207
Average record length: 0.04, total records: 6915
Average version length: 44.12, total versions: 6909, max versions: 1
Data pages: 74, data page slots: 74, average fill: 90%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 1
60 - 79% = 10
80 - 99% = 62
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Depth: 2, leaf buckets: 4, nodes: 6915
Average data length: 0.13, total dup: 6829, max dup: 1472
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 3
MON_LOG (164)
Primary pointer page: 303, Index root page: 304
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_DTS (4)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_GDSCODE (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_ROWSET_DESC (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_UNIT (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG_TABLE_STATS (165)
Primary pointer page: 316, Index root page: 317
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_DTS (4)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_GDSCODE (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_ROWSET (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_TN_UNIT (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG_TABLE_STATS (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
OPTYPES (138)
Primary pointer page: 186, Index root page: 187
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 9%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OPTYPES_MCODE_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 9
Average data length: 4.56, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_OPTYPES (0)
Depth: 1, leaf buckets: 1, nodes: 9
Average data length: 2.11, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PDISTR (150)
Primary pointer page: 241, Index root page: 242
Average record length: 26.15, total records: 132558
Average version length: 33.97, total versions: 75299, max versions: 9
Data pages: 1408, data page slots: 1408, average fill: 83%
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 14
60 - 79% = 517
80 - 99% = 874
Index PDISTR_AGENT_ID (4)
Depth: 2, leaf buckets: 114, nodes: 132558
Average data length: 0.01, total dup: 132509, max dup: 30096
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 70
60 - 79% = 23
80 - 99% = 19
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Depth: 2, leaf buckets: 143, nodes: 132558
Average data length: 0.89, total dup: 119337, max dup: 52
Fill distribution:
0 - 19% = 0
20 - 39% = 4
40 - 59% = 90
60 - 79% = 29
80 - 99% = 20
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Depth: 2, leaf buckets: 147, nodes: 132558
Average data length: 0.89, total dup: 119337, max dup: 52
Fill distribution:
0 - 19% = 0
20 - 39% = 4
40 - 59% = 89
60 - 79% = 35
80 - 99% = 19
Index PDISTR_SND_ID (1)
Depth: 2, leaf buckets: 130, nodes: 132558
Average data length: 0.67, total dup: 119337, max dup: 52
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 60
60 - 79% = 50
80 - 99% = 17
PERF_ESTIMATED (160)
Primary pointer page: 289, Index root page: 290
Average record length: 27.16, total records: 26380
Average version length: 18.00, total versions: 2, max versions: 1
Data pages: 224, data page slots: 224, average fill: 64%
Fill distribution:
0 - 19% = 4
20 - 39% = 1
40 - 59% = 0
60 - 79% = 219
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Depth: 2, leaf buckets: 20, nodes: 26380
Average data length: 0.01, total dup: 26198, max dup: 1158
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 9
60 - 79% = 9
80 - 99% = 2
PERF_ISQL_STAT (161)
Primary pointer page: 296, Index root page: 297
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PERF_ISQL_STAT_TRN (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PERF_LOG (162)
Primary pointer page: 299, Index root page: 300
Average record length: 145.50, total records: 1506351
Average version length: 153.00, total versions: 1, max versions: 1
Data pages: 34617, data page slots: 34617, average fill: 87%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 34616
Index PERF_LOG_DTS_BEG_DESC (0)
Depth: 3, leaf buckets: 1821, nodes: 1506351
Average data length: 0.56, total dup: 891391, max dup: 44
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1305
60 - 79% = 346
80 - 99% = 170
Index PERF_LOG_GDSCODE (3)
Depth: 3, leaf buckets: 1498, nodes: 1506351
Average data length: 0.00, total dup: 1506346, max dup: 1433565
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1497
60 - 79% = 0
80 - 99% = 1
Index PERF_LOG_TRN_DESC (2)
Depth: 3, leaf buckets: 1813, nodes: 1506351
Average data length: 0.33, total dup: 1429042, max dup: 6373
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 1492
60 - 79% = 184
80 - 99% = 136
Index PERF_LOG_UNIT (1)
Depth: 3, leaf buckets: 1731, nodes: 1506351
Average data length: 0.46, total dup: 1435235, max dup: 166241
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 1243
60 - 79% = 242
80 - 99% = 242
PHRASES (145)
Primary pointer page: 212, Index root page: 213
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_ID_DESC (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_NAME (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_PHRASES (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PSTORNED (151)
Primary pointer page: 248, Index root page: 249
Average record length: 50.00, total records: 89430
Average version length: 54.90, total versions: 7758, max versions: 1
Data pages: 1043, data page slots: 1043, average fill: 77%
Fill distribution:
0 - 19% = 1
20 - 39% = 3
40 - 59% = 1
60 - 79% = 946
80 - 99% = 92
Index PSTORNED_RCV_ID (2)
Depth: 2, leaf buckets: 111, nodes: 89430
Average data length: 1.17, total dup: 73687, max dup: 226
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 105
60 - 79% = 5
80 - 99% = 1
Index PSTORNED_SND_ID (1)
Depth: 2, leaf buckets: 81, nodes: 89430
Average data length: 0.60, total dup: 81706, max dup: 71
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 37
60 - 79% = 36
80 - 99% = 8
RULES_FOR_PDISTR (152)
Primary pointer page: 250, Index root page: 251
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_PDISTR_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 7.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RULES_FOR_QDISTR (139)
Primary pointer page: 190, Index root page: 191
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_RCVOP (1)
Depth: 1, leaf buckets: 1, nodes: 7
Average data length: 1.57, total dup: 2, max dup: 2
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 7
Average data length: 6.14, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SEMAPHORES (156)
Primary pointer page: 263, Index root page: 264
Average record length: 34.25, total records: 4
Average version length: 9.00, total versions: 1168, max versions: 642
Data pages: 5, data page slots: 5, average fill: 75%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 4
Index PK_SEMAPHORES (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 8.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SEMAPHORES_TASK_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 18.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SETTINGS (137)
Primary pointer page: 183, Index root page: 184
Average record length: 98.32, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 2, data page slots: 2, average fill: 81%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1
Index SETTINGS_MODE_CODE (0)
Depth: 1, leaf buckets: 1, nodes: 114
Average data length: 23.07, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$RAND$CALLS (136)
Primary pointer page: 180, Index root page: 181
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$SOURCE (135)
Primary pointer page: 178, Index root page: 179
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$DEP_DOCS (129)
Primary pointer page: 159, Index root page: 160
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_DEP_DOCS_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$IDX_RECALC (132)
Primary pointer page: 169, Index root page: 170
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG (133)
Primary pointer page: 174, Index root page: 175
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG_TABLE_STATS (134)
Primary pointer page: 176, Index root page: 177
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_LOG (163)
Primary pointer page: 301, Index root page: 302
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_MON (131)
Primary pointer page: 167, Index root page: 168
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$RESULT_SET (130)
Primary pointer page: 162, Index root page: 163
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_DOC (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_WARE_DOC (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$SHOPPING_CART (128)
Primary pointer page: 155, Index root page: 156
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_SHOPCART_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRACE_STAT (276)
Primary pointer page: 513, Index root page: 95177
Average record length: 59.41, total records: 409
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 6, data page slots: 6, average fill: 64%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 5
80 - 99% = 0
WARES (144)
Primary pointer page: 210, Index root page: 211
Average record length: 78.00, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 6, data page slots: 6, average fill: 78%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2
Index FK_WARES_WARE_GROUPS (3)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 0.14, total dup: 392, max dup: 62
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARES (0)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_ID_DESC (2)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_NUMB_UNQ (1)
Depth: 2, leaf buckets: 2, nodes: 400
Average data length: 19.40, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 0
WARE_GROUPS (155)
Primary pointer page: 261, Index root page: 262
Average record length: 32.13, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 5%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARE_GROUPS (0)
Depth: 1, leaf buckets: 1, nodes: 8
Average data length: 7.25, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index WARE_GROUPS_NAME_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 8
Average data length: 15.88, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQD_1000_1200 (258)
Primary pointer page: 645, Index root page: 646
Average record length: 0.16, total records: 245458
Average version length: 69.26, total versions: 244909, max versions: 1
Data pages: 3302, data page slots: 3414, average fill: 94%
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 0
60 - 79% = 4
80 - 99% = 3296
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 301, nodes: 245458
Average data length: 1.23, total dup: 215028, max dup: 29
Fill distribution:
0 - 19% = 21
20 - 39% = 15
40 - 59% = 105
60 - 79% = 90
80 - 99% = 70
XQD_1000_3300 (260)
Primary pointer page: 653, Index root page: 654
Average record length: 52.24, total records: 251294
Average version length: 69.22, total versions: 61715, max versions: 1
Data pages: 3541, data page slots: 3621, average fill: 79%
Fill distribution:
0 - 19% = 60
20 - 39% = 86
40 - 59% = 70
60 - 79% = 1341
80 - 99% = 1984
Index XQD_1000_3300_DOC (1)
Depth: 2, leaf buckets: 230, nodes: 251294
Average data length: 0.17, total dup: 244869, max dup: 173
Fill distribution:
0 - 19% = 1
20 - 39% = 50
40 - 59% = 79
60 - 79% = 8
80 - 99% = 92
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 307, nodes: 251294
Average data length: 1.26, total dup: 220081, max dup: 42
Fill distribution:
0 - 19% = 3
20 - 39% = 1
40 - 59% = 151
60 - 79% = 105
80 - 99% = 47
XQD_1200_2000 (259)
Primary pointer page: 648, Index root page: 649
Average record length: 1.49, total records: 324222
Average version length: 69.23, total versions: 317319, max versions: 1
Data pages: 4355, data page slots: 4355, average fill: 94%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 20
80 - 99% = 4335
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 355, nodes: 324222
Average data length: 0.91, total dup: 294931, max dup: 145
Fill distribution:
0 - 19% = 9
20 - 39% = 6
40 - 59% = 120
60 - 79% = 149
80 - 99% = 71
XQD_2000_3300 (261)
Primary pointer page: 657, Index root page: 658
Average record length: 17.81, total records: 1132055
Average version length: 68.33, total versions: 840805, max versions: 1
Data pages: 15254, data page slots: 15254, average fill: 89%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3491
80 - 99% = 11762
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 1480, nodes: 1132055
Average data length: 1.09, total dup: 1005937, max dup: 95
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 1233
60 - 79% = 120
80 - 99% = 126
XQD_2100_3300 (262)
Primary pointer page: 661, Index root page: 662
Average record length: 2.56, total records: 135877
Average version length: 69.16, total versions: 130837, max versions: 1
Data pages: 3490, data page slots: 3632, average fill: 50%
Fill distribution:
0 - 19% = 1141
20 - 39% = 454
40 - 59% = 337
60 - 79% = 235
80 - 99% = 1323
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 216, nodes: 135877
Average data length: 1.38, total dup: 118059, max dup: 131
Fill distribution:
0 - 19% = 0
20 - 39% = 41
40 - 59% = 133
60 - 79% = 41
80 - 99% = 1
XQD_3300_3400 (263)
Primary pointer page: 664, Index root page: 665
Average record length: 38.71, total records: 839792
Average version length: 68.48, total versions: 367381, max versions: 1
Data pages: 11772, data page slots: 11788, average fill: 82%
Fill distribution:
0 - 19% = 123
20 - 39% = 173
40 - 59% = 307
60 - 79% = 3774
80 - 99% = 7395
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 1214, nodes: 839792
Average data length: 1.37, total dup: 721769, max dup: 29
Fill distribution:
0 - 19% = 1
20 - 39% = 15
40 - 59% = 948
60 - 79% = 156
80 - 99% = 94
XQS_1000_1200 (264)
Primary pointer page: 667, Index root page: 668
Average record length: 78.01, total records: 1051870
Average version length: 80.57, total versions: 31713, max versions: 1
Data pages: 15677, data page slots: 15677, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 6489
80 - 99% = 9187
Index XQS_1000_1200_DOC_ID (0)
Depth: 3, leaf buckets: 1154, nodes: 1051870
Average data length: 0.16, total dup: 1028158, max dup: 138
Fill distribution:
0 - 19% = 7
20 - 39% = 0
40 - 59% = 812
60 - 79% = 286
80 - 99% = 49
Index XQS_1000_1200_RCV_ID (2)
Depth: 3, leaf buckets: 860, nodes: 1051870
Average data length: 0.71, total dup: 927850, max dup: 49
Fill distribution:
0 - 19% = 7
20 - 39% = 0
40 - 59% = 175
60 - 79% = 34
80 - 99% = 644
Index XQS_1000_1200_SND_ID (1)
Depth: 3, leaf buckets: 1306, nodes: 1051870
Average data length: 0.74, total dup: 921213, max dup: 35
Fill distribution:
0 - 19% = 10
20 - 39% = 0
40 - 59% = 912
60 - 79% = 312
80 - 99% = 72
XQS_1000_3300 (266)
Primary pointer page: 678, Index root page: 679
Average record length: 64.37, total records: 725039
Average version length: 80.37, total versions: 144106, max versions: 1
Data pages: 10966, data page slots: 10979, average fill: 82%
Fill distribution:
0 - 19% = 45
20 - 39% = 95
40 - 59% = 98
60 - 79% = 4196
80 - 99% = 6532
Index XQS_1000_3300_DOC_ID (0)
Depth: 3, leaf buckets: 706, nodes: 725039
Average data length: 0.14, total dup: 710504, max dup: 348
Fill distribution:
0 - 19% = 2
20 - 39% = 4
40 - 59% = 307
60 - 79% = 297
80 - 99% = 96
Index XQS_1000_3300_RCV_ID (2)
Depth: 3, leaf buckets: 620, nodes: 725039
Average data length: 0.86, total dup: 625360, max dup: 14
Fill distribution:
0 - 19% = 11
20 - 39% = 6
40 - 59% = 136
60 - 79% = 5
80 - 99% = 462
Index XQS_1000_3300_SND_ID (1)
Depth: 3, leaf buckets: 819, nodes: 725039
Average data length: 0.66, total dup: 647766, max dup: 63
Fill distribution:
0 - 19% = 28
20 - 39% = 5
40 - 59% = 330
60 - 79% = 361
80 - 99% = 95
XQS_1200_2000 (265)
Primary pointer page: 673, Index root page: 674
Average record length: 74.18, total records: 1126968
Average version length: 81.02, total versions: 87843, max versions: 1
Data pages: 16798, data page slots: 16798, average fill: 81%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 7273
80 - 99% = 9524
Index XQS_1200_2000_DOC_ID (0)
Depth: 3, leaf buckets: 1145, nodes: 1126968
Average data length: 0.05, total dup: 1120489, max dup: 896
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 722
60 - 79% = 304
80 - 99% = 119
Index XQS_1200_2000_RCV_ID (2)
Depth: 3, leaf buckets: 848, nodes: 1126968
Average data length: 0.66, total dup: 1000418, max dup: 49
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 81
60 - 79% = 8
80 - 99% = 757
Index XQS_1200_2000_SND_ID (1)
Depth: 3, leaf buckets: 1302, nodes: 1126968
Average data length: 0.66, total dup: 1003401, max dup: 145
Fill distribution:
0 - 19% = 4
20 - 39% = 1
40 - 59% = 772
60 - 79% = 384
80 - 99% = 141
XQS_2000_3300 (267)
Primary pointer page: 683, Index root page: 684
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_DOC_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_RCV_ID (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_SND_ID (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQS_2100_3300 (268)
Primary pointer page: 691, Index root page: 692
Average record length: 66.46, total records: 899638
Average version length: 80.51, total versions: 156803, max versions: 1
Data pages: 13749, data page slots: 13777, average fill: 81%
Fill distribution:
0 - 19% = 81
20 - 39% = 194
40 - 59% = 217
60 - 79% = 4731
80 - 99% = 8526
Index XQS_2100_3300_DOC_ID (0)
Depth: 3, leaf buckets: 823, nodes: 899638
Average data length: 0.04, total dup: 894967, max dup: 771
Fill distribution:
0 - 19% = 1
20 - 39% = 8
40 - 59% = 294
60 - 79% = 349
80 - 99% = 171
Index XQS_2100_3300_RCV_ID (2)
Depth: 3, leaf buckets: 880, nodes: 899638
Average data length: 0.88, total dup: 772787, max dup: 14
Fill distribution:
0 - 19% = 24
20 - 39% = 25
40 - 59% = 334
60 - 79% = 7
80 - 99% = 490
Index XQS_2100_3300_SND_ID (1)
Depth: 3, leaf buckets: 919, nodes: 899638
Average data length: 0.63, total dup: 806849, max dup: 87
Fill distribution:
0 - 19% = 0
20 - 39% = 13
40 - 59% = 301
60 - 79% = 359
80 - 99% = 246
XQS_3300_3400 (269)
Primary pointer page: 697, Index root page: 698
Average record length: 55.83, total records: 331119
Average version length: 68.38, total versions: 60695, max versions: 1
Data pages: 4457, data page slots: 4457, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3017
80 - 99% = 1439
Index XQS_3300_3400_DOC_ID (0)
Depth: 2, leaf buckets: 303, nodes: 331119
Average data length: 0.23, total dup: 320093, max dup: 199
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 112
60 - 79% = 121
80 - 99% = 69
Index XQS_3300_3400_SND_ID (1)
Depth: 2, leaf buckets: 354, nodes: 331119
Average data length: 0.83, total dup: 287702, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 150
60 - 79% = 127
80 - 99% = 76
ZDOC_DATA (228)
Primary pointer page: 564, Index root page: 565
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZDOC_LIST (227)
Primary pointer page: 560, Index root page: 561
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZINVNT_TURNOVER_LOG (229)
Primary pointer page: 567, Index root page: 568
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPDISTR (232)
Primary pointer page: 573, Index root page: 574
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPDISTR_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPSTORNED (233)
Primary pointer page: 575, Index root page: 576
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPSTORNED_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQDISTR (230)
Primary pointer page: 569, Index root page: 570
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQSTORNED (231)
Primary pointer page: 571, Index root page: 572
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_DOC_ID (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_RCV_ID (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_SND_ID (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_DEP_DOCS (226)
Primary pointer page: 558, Index root page: 559
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_SHOPPING_CART (225)
Primary pointer page: 556, Index root page: 557
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Z_USED_VIEWS (146)
Primary pointer page: 214, Index root page: 215
Average record length: 29.19, total records: 32
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 18%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index Z_USED_VIEWS_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 32
Average data length: 10.78, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Done for 11230 ms, from 23:58:31.92 to 23:58:43.15.
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
VERS_PERCENT |
AGENTS |
50 |
0 |
0.0000 |
BUSINESS_OPS |
19 |
0 |
0.0000 |
DOC_DATA |
508598 |
30272 |
5.9520 |
DOC_LIST |
92791 |
10748 |
11.5830 |
DOC_STATES |
4 |
0 |
0.0000 |
FB_ERRORS |
758 |
0 |
0.0000 |
INVNT_SALDO |
400 |
110437 |
27609.2500 |
INVNT_TURNOVER_LOG |
146404 |
146275 |
99.9118 |
MONEY_SALDO |
49 |
5388 |
10995.9183 |
MONEY_TURNOVER_LOG |
6915 |
6909 |
99.9132 |
OPTYPES |
9 |
0 |
0.0000 |
PDISTR |
132558 |
75299 |
56.8045 |
PERF_ESTIMATED |
26380 |
2 |
0.0075 |
PERF_LOG |
1506351 |
1 |
0.0000 |
PSTORNED |
89430 |
7758 |
8.6749 |
RULES_FOR_PDISTR |
4 |
0 |
0.0000 |
RULES_FOR_QDISTR |
7 |
0 |
0.0000 |
SEMAPHORES |
4 |
1168 |
29200.0000 |
SETTINGS |
114 |
0 |
0.0000 |
TRACE_STAT |
409 |
0 |
0.0000 |
WARES |
400 |
0 |
0.0000 |
WARE_GROUPS |
8 |
0 |
0.0000 |
XQD_1000_1200 |
245458 |
244909 |
99.7763 |
XQD_1000_3300 |
251294 |
61715 |
24.5588 |
XQD_1200_2000 |
324222 |
317319 |
97.8709 |
XQD_2000_3300 |
1132055 |
840805 |
74.2724 |
XQD_2100_3300 |
135877 |
130837 |
96.2907 |
XQD_3300_3400 |
839792 |
367381 |
43.7466 |
XQS_1000_1200 |
1051870 |
31713 |
3.0149 |
XQS_1000_3300 |
725039 |
144106 |
19.8756 |
XQS_1200_2000 |
1126968 |
87843 |
7.7946 |
XQS_2100_3300 |
899638 |
156803 |
17.4295 |
XQS_3300_3400 |
331119 |
60695 |
18.3302 |
Z_USED_VIEWS |
32 |
0 |
0.0000 |
Done for 2190 ms, from 23:58:51.50 to 23:58:53.69.
23:58:53.78 Validation started
23:58:53.78 Relation 140 (DOC_LIST)
23:58:53.78 process pointer page 0 of 1
23:58:53.86 Index 1 (PK_DOC_LIST)
23:58:53.89 Index 2 (DOC_LIST_ID_DESC)
23:58:53.92 Index 3 (FK_DOC_LIST_AGENTS)
23:58:53.94 Relation 140 (DOC_LIST) is ok
23:58:53.94 Relation 141 (DOC_DATA)
23:58:53.94 process pointer page 0 of 3
23:58:54.03 process pointer page 1 of 3
23:58:54.08 process pointer page 2 of 3
23:58:54.17 Index 2 (DOC_DATA_DOC_WARE_UNQ)
23:58:54.37 Index 3 (DOC_DATA_ID_DESC)
23:58:54.45 Index 4 (FK_DOC_DATA_DOC_LIST)
23:58:54.51 Relation 141 (DOC_DATA) is ok
23:58:54.51 Relation 147 (INVNT_SALDO)
23:58:54.51 process pointer page 0 of 1
23:58:54.65 Index 1 (PK_INVNT_SALDO)
23:58:54.65 Relation 147 (INVNT_SALDO) is ok
23:58:54.65 Relation 150 (PDISTR)
23:58:54.65 process pointer page 0 of 1
23:58:54.70 Index 2 (PDISTR_SND_ID)
23:58:54.72 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
23:58:54.73 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
23:58:54.73 Index 5 (PDISTR_AGENT_ID)
23:58:54.75 Relation 150 (PDISTR) is ok
23:58:54.75 Relation 151 (PSTORNED)
23:58:54.75 process pointer page 0 of 1
23:58:54.78 Index 2 (PSTORNED_SND_ID)
23:58:54.78 Index 3 (PSTORNED_RCV_ID)
23:58:54.80 Relation 151 (PSTORNED) is ok
23:58:54.80 Relation 156 (SEMAPHORES)
23:58:54.80 process pointer page 0 of 1
23:58:54.80 Index 1 (PK_SEMAPHORES)
23:58:54.80 Index 2 (SEMAPHORES_TASK_UNQ)
23:58:54.80 Relation 156 (SEMAPHORES) is ok
23:58:54.80 Relation 157 (INVNT_TURNOVER_LOG)
23:58:54.80 process pointer page 0 of 2
23:58:54.86 process pointer page 1 of 2
23:58:54.86 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
23:58:54.89 Relation 157 (INVNT_TURNOVER_LOG) is ok
23:58:54.89 Relation 160 (PERF_ESTIMATED)
23:58:54.89 process pointer page 0 of 1
23:58:54.90 Index 1 (PERF_EST_MINUTE_SINCE_START)
23:58:54.90 Relation 160 (PERF_ESTIMATED) is ok
23:58:54.90 Relation 161 (PERF_ISQL_STAT)
23:58:54.90 process pointer page 0 of 1
23:58:54.90 Index 1 (PERF_ISQL_STAT_TRN)
23:58:54.90 Relation 161 (PERF_ISQL_STAT) is ok
23:58:54.90 Relation 162 (PERF_LOG)
23:58:54.90 process pointer page 0 of 19
23:58:54.94 process pointer page 1 of 19
23:58:54.95 process pointer page 2 of 19
23:58:54.98 process pointer page 3 of 19
23:58:55.00 process pointer page 4 of 19
23:58:55.03 process pointer page 5 of 19
23:58:55.06 process pointer page 6 of 19
23:58:55.08 process pointer page 7 of 19
23:58:55.09 process pointer page 8 of 19
23:58:55.12 process pointer page 9 of 19
23:58:55.14 process pointer page 10 of 19
23:58:55.15 process pointer page 11 of 19
23:58:55.19 process pointer page 12 of 19
23:58:55.20 process pointer page 13 of 19
23:58:55.22 process pointer page 14 of 19
23:58:55.25 process pointer page 15 of 19
23:58:55.28 process pointer page 16 of 19
23:58:55.33 process pointer page 17 of 19
23:58:55.36 process pointer page 18 of 19
23:58:55.36 Index 1 (PERF_LOG_DTS_BEG_DESC)
23:58:55.81 Index 2 (PERF_LOG_UNIT)
23:58:56.37 Index 3 (PERF_LOG_TRN_DESC)
23:58:56.60 Index 4 (PERF_LOG_GDSCODE)
23:58:56.98 Relation 162 (PERF_LOG) is ok
23:58:56.98 Relation 166 (V_STOPTEST)
23:58:56.98 Relation 166 (V_STOPTEST) is ok
23:58:56.98 Relation 183 (V_QDISTR_SOURCE)
23:58:56.98 Relation 183 (V_QDISTR_SOURCE) is ok
23:58:56.98 Relation 184 (V_QSTORNED_SOURCE)
23:58:56.98 Relation 184 (V_QSTORNED_SOURCE) is ok
23:58:56.98 Relation 258 (XQD_1000_1200)
23:58:56.98 process pointer page 0 of 2
23:58:57.09 process pointer page 1 of 2
23:58:57.17 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
23:58:57.24 Relation 258 (XQD_1000_1200) is ok
23:58:57.24 Relation 259 (XQD_1200_2000)
23:58:57.24 process pointer page 0 of 3
23:58:57.43 process pointer page 1 of 3
23:58:57.62 process pointer page 2 of 3
23:58:57.67 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
23:58:57.76 Relation 259 (XQD_1200_2000) is ok
23:58:57.76 Relation 260 (XQD_1000_3300)
23:58:57.76 process pointer page 0 of 2
23:58:57.85 process pointer page 1 of 2
23:58:57.88 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
23:58:57.92 Index 2 (XQD_1000_3300_DOC)
23:58:57.96 Relation 260 (XQD_1000_3300) is ok
23:58:57.96 Relation 261 (XQD_2000_3300)
23:58:57.96 process pointer page 0 of 8
23:58:58.07 process pointer page 1 of 8
23:58:58.23 process pointer page 2 of 8
23:58:58.35 process pointer page 3 of 8
23:58:58.52 process pointer page 4 of 8
23:58:58.70 process pointer page 5 of 8
23:58:58.84 process pointer page 6 of 8
23:58:58.96 process pointer page 7 of 8
23:58:59.01 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
23:58:59.32 Relation 261 (XQD_2000_3300) is ok
23:58:59.32 Relation 262 (XQD_2100_3300)
23:58:59.32 process pointer page 0 of 2
23:58:59.44 process pointer page 1 of 2
23:58:59.54 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
23:58:59.60 Relation 262 (XQD_2100_3300) is ok
23:58:59.60 Relation 263 (XQD_3300_3400)
23:58:59.60 process pointer page 0 of 7
23:58:59.76 process pointer page 1 of 7
23:58:59.88 process pointer page 2 of 7
23:58:59.94 process pointer page 3 of 7
23:58:59.99 process pointer page 4 of 7
23:59:00.02 process pointer page 5 of 7
23:59:00.07 process pointer page 6 of 7
23:59:00.07 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
23:59:00.21 Relation 263 (XQD_3300_3400) is ok
23:59:00.21 Relation 264 (XQS_1000_1200)
23:59:00.21 process pointer page 0 of 9
23:59:00.30 process pointer page 1 of 9
23:59:00.40 process pointer page 2 of 9
23:59:00.49 process pointer page 3 of 9
23:59:00.58 process pointer page 4 of 9
23:59:00.66 process pointer page 5 of 9
23:59:00.77 process pointer page 6 of 9
23:59:00.88 process pointer page 7 of 9
23:59:00.94 process pointer page 8 of 9
23:59:00.94 Index 1 (XQS_1000_1200_DOC_ID)
23:59:01.07 Index 2 (XQS_1000_1200_SND_ID)
23:59:01.38 Index 3 (XQS_1000_1200_RCV_ID)
23:59:01.63 Relation 264 (XQS_1000_1200) is ok
23:59:01.63 Relation 265 (XQS_1200_2000)
23:59:01.63 process pointer page 0 of 9
23:59:01.71 process pointer page 1 of 9
23:59:01.80 process pointer page 2 of 9
23:59:01.85 process pointer page 3 of 9
23:59:01.88 process pointer page 4 of 9
23:59:01.91 process pointer page 5 of 9
23:59:01.96 process pointer page 6 of 9
23:59:02.02 process pointer page 7 of 9
23:59:02.11 process pointer page 8 of 9
23:59:02.19 Index 1 (XQS_1200_2000_DOC_ID)
23:59:02.42 Index 2 (XQS_1200_2000_SND_ID)
23:59:02.66 Index 3 (XQS_1200_2000_RCV_ID)
23:59:02.92 Relation 265 (XQS_1200_2000) is ok
23:59:02.92 Relation 266 (XQS_1000_3300)
23:59:02.92 process pointer page 0 of 6
23:59:03.02 process pointer page 1 of 6
23:59:03.13 process pointer page 2 of 6
23:59:03.23 process pointer page 3 of 6
23:59:03.34 process pointer page 4 of 6
23:59:03.45 process pointer page 5 of 6
23:59:03.53 Index 1 (XQS_1000_3300_DOC_ID)
23:59:03.72 Index 2 (XQS_1000_3300_SND_ID)
23:59:03.92 Index 3 (XQS_1000_3300_RCV_ID)
23:59:04.08 Relation 266 (XQS_1000_3300) is ok
23:59:04.08 Relation 267 (XQS_2000_3300)
23:59:04.08 process pointer page 0 of 1
23:59:04.08 Index 1 (XQS_2000_3300_DOC_ID)
23:59:04.08 Index 2 (XQS_2000_3300_SND_ID)
23:59:04.08 Index 3 (XQS_2000_3300_RCV_ID)
23:59:04.08 Relation 267 (XQS_2000_3300) is ok
23:59:04.08 Relation 268 (XQS_2100_3300)
23:59:04.08 process pointer page 0 of 8
23:59:04.12 process pointer page 1 of 8
23:59:04.23 process pointer page 2 of 8
23:59:04.34 process pointer page 3 of 8
23:59:04.45 process pointer page 4 of 8
23:59:04.56 process pointer page 5 of 8
23:59:04.67 process pointer page 6 of 8
23:59:04.76 process pointer page 7 of 8
23:59:04.76 Index 1 (XQS_2100_3300_DOC_ID)
23:59:05.06 Index 2 (XQS_2100_3300_SND_ID)
23:59:05.37 Index 3 (XQS_2100_3300_RCV_ID)
23:59:05.61 Relation 268 (XQS_2100_3300) is ok
23:59:05.61 Relation 269 (XQS_3300_3400)
23:59:05.61 process pointer page 0 of 3
23:59:05.72 process pointer page 1 of 3
23:59:05.76 process pointer page 2 of 3
23:59:05.78 Index 1 (XQS_3300_3400_DOC_ID)
23:59:05.81 Index 2 (XQS_3300_3400_SND_ID)
23:59:05.84 Relation 269 (XQS_3300_3400) is ok
23:59:05.84 Relation 276 (TRACE_STAT)
23:59:05.84 process pointer page 0 of 1
23:59:05.84 Relation 276 (TRACE_STAT) is ok
23:59:05.84 Validation finished
Done for 12140 ms, from 23:58:53.70 to 23:59:05.84.
Differences between old and current firebird.log
23:59:06.18. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP25\OLTP25_FB_LOG_WHEN_TEST_FINISHED.LOG: 5 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2016-03-31 23:59 309 oltp25_fb_log_when_test_finished.log
End of gathering firebird.log AFTER test finish.
+++ Start of comparison +++
result: files match. No new messages appeared in firebird.log during test ran.
+++ End of comparison +++
Remove 302 logs of every ISQL session if there were no serious errors.
Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp25\oltp25_*.*:
ERRORS_CHECKING_RESULT |
NO_SEVERE_ERRORS_FOUND |
ISQL logs are removed because no severe errors occured during test.
2016-03-31 23:59:08.12 - end of report, text file: e:\temp\logs.oltp25\oltp25.report.txt, html: e:\temp\logs.oltp25\oltp25.report.html