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: |
6015.27 |
4194 |
1082748 |
2017-03-29 08:24 |
2017-03-29 11:24 |
customer order: creation |
450.41 |
565 |
81074 |
2017-03-29 08:24 |
2017-03-29 11:24 |
customer order: refuse |
37.11 |
296 |
6680 |
2017-03-29 08:24 |
2017-03-29 11:24 |
order to supplier: creation |
116.74 |
2455 |
21013 |
2017-03-29 08:24 |
2017-03-29 11:24 |
order to supplier: removal |
2.92 |
27981 |
522 |
2017-03-29 08:24 |
2017-03-29 11:24 |
invoice (draft): creation |
116.25 |
3489 |
20925 |
2017-03-29 08:24 |
2017-03-29 11:24 |
invoice (draft): removal |
39.83 |
585 |
7170 |
2017-03-29 08:24 |
2017-03-29 11:24 |
invoice accept: apply |
68.30 |
15662 |
12294 |
2017-03-29 08:24 |
2017-03-29 11:24 |
invoice accept: cancel |
18.89 |
3420 |
3382 |
2017-03-29 08:24 |
2017-03-29 11:24 |
customer reserve: creation |
3513.31 |
258 |
632395 |
2017-03-29 08:24 |
2017-03-29 11:24 |
customer reserve: removal |
1035.07 |
90 |
185277 |
2017-03-29 08:24 |
2017-03-29 11:24 |
realization accept: apply |
210.04 |
588 |
37808 |
2017-03-29 08:24 |
2017-03-29 11:24 |
realization accept: cancel |
82.45 |
205 |
14758 |
2017-03-29 08:24 |
2017-03-29 11:24 |
payment from customer: creation |
152.22 |
1064 |
27399 |
2017-03-29 08:24 |
2017-03-29 11:24 |
payment from customer: removal |
14.74 |
149 |
2638 |
2017-03-29 08:24 |
2017-03-29 11:24 |
payment to supplier: creation |
125.53 |
764 |
22596 |
2017-03-29 08:24 |
2017-03-29 11:24 |
payment to supplier: removal |
8.99 |
149 |
1610 |
2017-03-29 08:24 |
2017-03-29 11:24 |
service: total inventory turnovers |
7.77 |
4685 |
1398 |
2017-03-29 08:24 |
2017-03-29 11:24 |
service: total monetary turnovers |
21.21 |
63 |
3797 |
2017-03-29 08:24 |
2017-03-29 11:24 |
service: refresh index statistics |
0.07 |
17217 |
12 |
2017-03-29 08:24 |
2017-03-29 11:24 |
Done for 136520 ms, from 11:29:59.81 to 11:32:16.33.
ACTION |
ITRV_NO |
CNT_OK_PER_MINUTE |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
ITRV_BEG |
ITRV_END |
interval # 1, overall |
1 |
4034 |
85142 |
72610 |
12532 |
14.72 |
08:24:01 |
08:42:01 |
interval # 2, overall |
2 |
5139 |
102402 |
92498 |
9904 |
9.67 |
08:42:02 |
09:00:02 |
interval # 3, overall |
3 |
5539 |
110447 |
99701 |
10746 |
9.73 |
09:00:03 |
09:18:03 |
interval # 4, overall |
4 |
7149 |
138908 |
128688 |
10220 |
7.36 |
09:18:04 |
09:36:04 |
interval # 5, overall |
5 |
6081 |
122707 |
109452 |
13255 |
10.80 |
09:36:05 |
09:54:05 |
interval # 6, overall |
6 |
6298 |
129717 |
113355 |
16362 |
12.61 |
09:54:06 |
10:12:06 |
interval # 7, overall |
7 |
6569 |
133596 |
118239 |
15357 |
11.50 |
10:12:07 |
10:30:07 |
interval # 8, overall |
8 |
6820 |
137432 |
122757 |
14675 |
10.68 |
10:30:08 |
10:48:08 |
interval # 9, overall |
9 |
6550 |
131224 |
117907 |
13317 |
10.15 |
10:48:09 |
11:06:09 |
interval # 10, overall |
10 |
5975 |
116801 |
107541 |
9260 |
7.93 |
11:06:10 |
11:24:10 |
Done for 234690 ms, from 11:36:10.34 to 11:40:05.03.
TEST_PHASE |
MINUTE_SINCE_TEST_START |
AVG_ESTIMATED |
MIN_TO_AVG_RATIO |
MAX_TO_AVG_RATIO |
ROWS_AGGREGATED |
DISTINCT_ATTACHMENTS |
TEST_TIME |
1 |
5872.99 |
0.5555 |
1.3434 |
2030 |
65 |
TEST_TIME |
2 |
4819.92 |
0.8185 |
1.1195 |
780 |
75 |
TEST_TIME |
3 |
4320.30 |
0.8333 |
1.1562 |
1352 |
100 |
TEST_TIME |
4 |
4347.95 |
0.8616 |
1.1217 |
1725 |
100 |
TEST_TIME |
5 |
4308.61 |
0.9056 |
1.0675 |
2078 |
100 |
TEST_TIME |
6 |
4139.35 |
0.9260 |
1.0912 |
1529 |
98 |
TEST_TIME |
7 |
4192.64 |
0.9256 |
1.0684 |
2264 |
100 |
TEST_TIME |
8 |
4151.51 |
0.9441 |
1.0490 |
1815 |
98 |
TEST_TIME |
9 |
4242.40 |
0.9125 |
1.0375 |
1661 |
98 |
TEST_TIME |
10 |
4185.10 |
0.9466 |
1.0630 |
1973 |
98 |
TEST_TIME |
11 |
4220.90 |
0.9582 |
1.0686 |
1469 |
99 |
TEST_TIME |
12 |
4229.49 |
0.9776 |
1.0240 |
1646 |
91 |
TEST_TIME |
13 |
4163.99 |
0.9602 |
1.0354 |
1444 |
94 |
TEST_TIME |
14 |
4153.52 |
0.9639 |
1.0295 |
1734 |
98 |
TEST_TIME |
15 |
4079.20 |
0.9784 |
1.0265 |
1661 |
88 |
TEST_TIME |
16 |
4043.34 |
0.9709 |
1.0316 |
1590 |
91 |
TEST_TIME |
17 |
4089.06 |
0.9600 |
1.0320 |
1797 |
100 |
TEST_TIME |
18 |
4106.14 |
0.9706 |
1.0414 |
1917 |
91 |
TEST_TIME |
19 |
4224.26 |
0.9590 |
1.0313 |
1845 |
94 |
TEST_TIME |
20 |
4271.86 |
0.9688 |
1.0243 |
2051 |
90 |
TEST_TIME |
21 |
4293.00 |
0.9707 |
1.0370 |
1543 |
92 |
TEST_TIME |
22 |
4330.26 |
0.9813 |
1.0291 |
1710 |
94 |
TEST_TIME |
23 |
4368.89 |
0.9757 |
1.0262 |
1825 |
92 |
TEST_TIME |
24 |
4388.93 |
0.9790 |
1.0333 |
1804 |
90 |
TEST_TIME |
25 |
4427.18 |
0.9834 |
1.0119 |
1815 |
91 |
TEST_TIME |
26 |
4432.34 |
0.9718 |
1.0133 |
1521 |
97 |
TEST_TIME |
27 |
4414.38 |
0.9797 |
1.0211 |
1743 |
93 |
TEST_TIME |
28 |
4438.05 |
0.9805 |
1.0069 |
1328 |
97 |
TEST_TIME |
29 |
4355.04 |
0.9907 |
1.0122 |
1312 |
85 |
TEST_TIME |
30 |
4360.13 |
0.9773 |
1.0194 |
1403 |
93 |
TEST_TIME |
31 |
4373.05 |
0.9836 |
1.0205 |
1346 |
96 |
TEST_TIME |
32 |
4399.55 |
0.9827 |
1.0164 |
2127 |
94 |
TEST_TIME |
33 |
4465.60 |
0.9710 |
1.0308 |
2078 |
92 |
TEST_TIME |
34 |
4539.24 |
0.9842 |
1.0192 |
1939 |
90 |
TEST_TIME |
35 |
4579.34 |
0.9814 |
1.0269 |
2034 |
84 |
TEST_TIME |
36 |
4659.28 |
0.9823 |
1.0202 |
2066 |
89 |
TEST_TIME |
37 |
4702.93 |
0.9834 |
1.0153 |
1631 |
98 |
TEST_TIME |
38 |
4677.64 |
0.9939 |
1.0089 |
1657 |
85 |
TEST_TIME |
39 |
4684.15 |
0.9816 |
1.0185 |
1542 |
89 |
TEST_TIME |
40 |
4713.28 |
0.9869 |
1.0127 |
1783 |
90 |
TEST_TIME |
41 |
4737.54 |
0.9829 |
1.0103 |
1690 |
88 |
TEST_TIME |
42 |
4718.07 |
0.9903 |
1.0117 |
1497 |
81 |
TEST_TIME |
43 |
4731.85 |
0.9853 |
1.0162 |
1588 |
85 |
TEST_TIME |
44 |
4740.90 |
0.9913 |
1.0103 |
1403 |
78 |
TEST_TIME |
45 |
4781.98 |
0.9842 |
1.0108 |
1308 |
81 |
TEST_TIME |
46 |
4775.82 |
0.9902 |
1.0075 |
1448 |
82 |
TEST_TIME |
47 |
4778.16 |
0.9856 |
1.0210 |
1697 |
92 |
TEST_TIME |
48 |
4854.52 |
0.9842 |
1.0097 |
1660 |
91 |
TEST_TIME |
49 |
4888.83 |
0.9824 |
1.0146 |
2080 |
87 |
TEST_TIME |
50 |
4919.31 |
0.9882 |
1.0140 |
2107 |
80 |
TEST_TIME |
51 |
4959.03 |
0.9862 |
1.0188 |
1744 |
80 |
TEST_TIME |
52 |
4984.77 |
0.9952 |
1.0107 |
779 |
87 |
TEST_TIME |
53 |
4966.86 |
0.9953 |
1.0036 |
633 |
80 |
TEST_TIME |
54 |
4949.65 |
0.9885 |
1.0133 |
2092 |
74 |
TEST_TIME |
55 |
4994.74 |
0.9859 |
1.0128 |
1681 |
84 |
TEST_TIME |
56 |
5026.79 |
0.9884 |
1.0138 |
1643 |
77 |
TEST_TIME |
57 |
5050.66 |
0.9914 |
1.0097 |
1589 |
75 |
TEST_TIME |
58 |
5054.43 |
0.9915 |
1.0060 |
1043 |
71 |
TEST_TIME |
59 |
5049.49 |
0.9899 |
1.0135 |
1423 |
87 |
TEST_TIME |
60 |
5081.01 |
0.9905 |
1.0067 |
1328 |
83 |
TEST_TIME |
61 |
5085.12 |
0.9894 |
1.0116 |
1348 |
86 |
TEST_TIME |
62 |
5157.40 |
0.9814 |
1.0152 |
1890 |
78 |
TEST_TIME |
63 |
5221.61 |
0.9868 |
1.0110 |
2121 |
72 |
TEST_TIME |
64 |
5269.55 |
0.9861 |
1.0162 |
1916 |
78 |
TEST_TIME |
65 |
5317.89 |
0.9914 |
1.0091 |
951 |
74 |
TEST_TIME |
66 |
5335.90 |
0.9905 |
1.0105 |
1943 |
69 |
TEST_TIME |
67 |
5375.59 |
0.9903 |
1.0105 |
1580 |
65 |
TEST_TIME |
68 |
5398.48 |
0.9914 |
1.0137 |
1329 |
54 |
TEST_TIME |
69 |
5424.78 |
0.9946 |
1.0077 |
1195 |
68 |
TEST_TIME |
70 |
5447.64 |
0.9891 |
1.0092 |
1411 |
66 |
TEST_TIME |
71 |
5473.86 |
0.9902 |
1.0095 |
1438 |
69 |
TEST_TIME |
72 |
5492.69 |
0.9921 |
1.0047 |
1380 |
68 |
TEST_TIME |
73 |
5481.08 |
0.9930 |
1.0055 |
631 |
63 |
TEST_TIME |
74 |
5457.31 |
0.9963 |
1.0053 |
1462 |
59 |
TEST_TIME |
75 |
5461.25 |
0.9912 |
1.0071 |
1157 |
73 |
TEST_TIME |
76 |
5470.17 |
0.9940 |
1.0036 |
1279 |
81 |
TEST_TIME |
77 |
5456.19 |
0.9931 |
1.0090 |
1149 |
87 |
TEST_TIME |
78 |
5479.96 |
0.9917 |
1.0054 |
1494 |
83 |
TEST_TIME |
79 |
5511.16 |
0.9870 |
1.0084 |
1885 |
80 |
TEST_TIME |
80 |
5539.89 |
0.9906 |
1.0069 |
1660 |
77 |
TEST_TIME |
81 |
5546.16 |
0.9934 |
1.0073 |
1391 |
75 |
TEST_TIME |
82 |
5569.15 |
0.9911 |
1.0094 |
1300 |
74 |
TEST_TIME |
83 |
5589.56 |
0.9936 |
1.0060 |
1454 |
86 |
TEST_TIME |
84 |
5592.45 |
0.9935 |
1.0051 |
1395 |
84 |
TEST_TIME |
85 |
5586.20 |
0.9944 |
1.0067 |
1315 |
79 |
TEST_TIME |
86 |
5597.28 |
0.9930 |
1.0067 |
1369 |
73 |
TEST_TIME |
87 |
5603.87 |
0.9940 |
1.0070 |
1006 |
86 |
TEST_TIME |
88 |
5605.74 |
0.9953 |
1.0072 |
1161 |
84 |
TEST_TIME |
89 |
5601.79 |
0.9966 |
1.0050 |
1450 |
82 |
TEST_TIME |
90 |
5605.98 |
0.9931 |
1.0039 |
1215 |
93 |
TEST_TIME |
91 |
5585.85 |
0.9965 |
1.0036 |
1338 |
86 |
TEST_TIME |
92 |
5577.91 |
0.9941 |
1.0044 |
1411 |
86 |
TEST_TIME |
93 |
5593.49 |
0.9908 |
1.0061 |
1201 |
85 |
TEST_TIME |
94 |
5588.55 |
0.9963 |
1.0089 |
1418 |
81 |
TEST_TIME |
95 |
5633.06 |
0.9904 |
1.0067 |
1415 |
77 |
TEST_TIME |
96 |
5646.29 |
0.9939 |
1.0070 |
1729 |
72 |
TEST_TIME |
97 |
5675.51 |
0.9917 |
1.0080 |
1366 |
75 |
TEST_TIME |
98 |
5710.38 |
0.9916 |
1.0069 |
1441 |
74 |
TEST_TIME |
99 |
5735.36 |
0.9924 |
1.0072 |
1530 |
69 |
TEST_TIME |
100 |
5748.34 |
0.9950 |
1.0025 |
1295 |
66 |
TEST_TIME |
101 |
5735.18 |
0.9948 |
1.0041 |
1226 |
74 |
TEST_TIME |
102 |
5723.44 |
0.9963 |
1.0039 |
1109 |
65 |
TEST_TIME |
103 |
5730.67 |
0.9929 |
1.0025 |
1118 |
69 |
TEST_TIME |
104 |
5717.11 |
0.9952 |
1.0045 |
1054 |
81 |
TEST_TIME |
105 |
5706.17 |
0.9969 |
1.0050 |
1269 |
79 |
TEST_TIME |
106 |
5706.55 |
0.9955 |
1.0043 |
1258 |
74 |
TEST_TIME |
107 |
5705.77 |
0.9950 |
1.0054 |
1334 |
84 |
TEST_TIME |
108 |
5724.50 |
0.9932 |
1.0053 |
1740 |
82 |
TEST_TIME |
109 |
5755.34 |
0.9907 |
1.0053 |
1796 |
77 |
TEST_TIME |
110 |
5766.85 |
0.9942 |
1.0056 |
1661 |
75 |
TEST_TIME |
111 |
5783.99 |
0.9936 |
1.0055 |
1654 |
78 |
TEST_TIME |
112 |
5790.93 |
0.9954 |
1.0042 |
1698 |
74 |
TEST_TIME |
113 |
5796.75 |
0.9943 |
1.0055 |
1476 |
71 |
TEST_TIME |
114 |
5804.77 |
0.9953 |
1.0061 |
1439 |
64 |
TEST_TIME |
115 |
5805.92 |
0.9976 |
1.0031 |
1396 |
76 |
TEST_TIME |
116 |
5799.87 |
0.9955 |
1.0046 |
1290 |
70 |
TEST_TIME |
117 |
5802.38 |
0.9956 |
1.0079 |
1351 |
65 |
TEST_TIME |
118 |
5813.55 |
0.9974 |
1.0035 |
1233 |
76 |
TEST_TIME |
119 |
5825.35 |
0.9931 |
1.0051 |
997 |
89 |
TEST_TIME |
120 |
5824.35 |
0.9969 |
1.0018 |
1270 |
94 |
TEST_TIME |
121 |
5812.67 |
0.9955 |
1.0036 |
1198 |
97 |
TEST_TIME |
122 |
5810.08 |
0.9958 |
1.0034 |
1729 |
98 |
TEST_TIME |
123 |
5816.70 |
0.9941 |
1.0057 |
1682 |
97 |
TEST_TIME |
124 |
5828.90 |
0.9955 |
1.0049 |
1596 |
96 |
TEST_TIME |
125 |
5828.97 |
0.9968 |
1.0038 |
1166 |
93 |
TEST_TIME |
126 |
5851.47 |
0.9940 |
1.0028 |
1543 |
99 |
TEST_TIME |
127 |
5851.47 |
0.9965 |
1.0025 |
1586 |
100 |
TEST_TIME |
128 |
5838.61 |
0.9968 |
1.0038 |
1385 |
91 |
TEST_TIME |
129 |
5849.11 |
0.9942 |
1.0078 |
1102 |
100 |
TEST_TIME |
130 |
5872.37 |
0.9960 |
1.0051 |
1046 |
100 |
TEST_TIME |
131 |
5875.51 |
0.9969 |
1.0042 |
1403 |
100 |
TEST_TIME |
132 |
5890.07 |
0.9941 |
1.0019 |
1519 |
100 |
TEST_TIME |
133 |
5879.65 |
0.9961 |
1.0044 |
1245 |
100 |
TEST_TIME |
134 |
5892.77 |
0.9947 |
1.0029 |
1399 |
100 |
TEST_TIME |
135 |
5881.28 |
0.9974 |
1.0058 |
1228 |
99 |
TEST_TIME |
136 |
5900.73 |
0.9952 |
1.0048 |
1219 |
100 |
TEST_TIME |
137 |
5916.25 |
0.9948 |
1.0025 |
1812 |
99 |
TEST_TIME |
138 |
5915.17 |
0.9954 |
1.0060 |
1590 |
98 |
TEST_TIME |
139 |
5936.09 |
0.9952 |
1.0035 |
1536 |
100 |
TEST_TIME |
140 |
5945.45 |
0.9948 |
1.0056 |
1485 |
98 |
TEST_TIME |
141 |
5948.59 |
0.9979 |
1.0061 |
1595 |
98 |
TEST_TIME |
142 |
5956.16 |
0.9977 |
1.0058 |
1485 |
95 |
TEST_TIME |
143 |
5964.57 |
0.9973 |
1.0028 |
1427 |
98 |
TEST_TIME |
144 |
5960.08 |
0.9966 |
1.0053 |
1285 |
100 |
TEST_TIME |
145 |
5973.64 |
0.9961 |
1.0021 |
1469 |
99 |
TEST_TIME |
146 |
5958.90 |
0.9977 |
1.0028 |
1569 |
94 |
TEST_TIME |
147 |
5958.80 |
0.9960 |
1.0030 |
1377 |
94 |
TEST_TIME |
148 |
5958.60 |
0.9963 |
1.0037 |
1343 |
98 |
TEST_TIME |
149 |
5969.55 |
0.9951 |
1.0025 |
1328 |
98 |
TEST_TIME |
150 |
5977.91 |
0.9975 |
1.0020 |
1277 |
99 |
TEST_TIME |
151 |
5976.06 |
0.9957 |
1.0032 |
1277 |
100 |
TEST_TIME |
152 |
5998.87 |
0.9928 |
1.0043 |
1876 |
100 |
TEST_TIME |
153 |
6001.06 |
0.9974 |
1.0033 |
1932 |
95 |
TEST_TIME |
154 |
6011.39 |
0.9951 |
1.0030 |
2023 |
91 |
TEST_TIME |
155 |
6022.70 |
0.9947 |
1.0052 |
1608 |
94 |
TEST_TIME |
156 |
6030.57 |
0.9974 |
1.0018 |
1696 |
99 |
TEST_TIME |
157 |
6019.73 |
0.9973 |
1.0034 |
1706 |
89 |
TEST_TIME |
158 |
6027.56 |
0.9958 |
1.0037 |
1258 |
94 |
TEST_TIME |
159 |
6025.02 |
0.9978 |
1.0028 |
1282 |
93 |
TEST_TIME |
160 |
6022.77 |
0.9969 |
1.0051 |
1260 |
97 |
TEST_TIME |
161 |
6023.98 |
0.9987 |
1.0018 |
1418 |
95 |
TEST_TIME |
162 |
6019.19 |
0.9964 |
1.0056 |
1256 |
96 |
TEST_TIME |
163 |
6021.41 |
0.9990 |
1.0008 |
1298 |
95 |
TEST_TIME |
164 |
5995.75 |
0.9990 |
1.0011 |
1173 |
69 |
TEST_TIME |
165 |
5983.99 |
0.9970 |
1.0048 |
814 |
96 |
TEST_TIME |
166 |
5999.98 |
0.9961 |
1.0040 |
1165 |
100 |
TEST_TIME |
167 |
6005.17 |
0.9971 |
1.0024 |
1749 |
100 |
TEST_TIME |
168 |
6003.48 |
0.9967 |
1.0033 |
2150 |
95 |
TEST_TIME |
169 |
6008.00 |
0.9966 |
1.0032 |
1805 |
90 |
TEST_TIME |
170 |
6021.17 |
0.9951 |
1.0048 |
1541 |
99 |
TEST_TIME |
171 |
6035.65 |
0.9965 |
1.0027 |
1718 |
100 |
TEST_TIME |
172 |
6032.54 |
0.9974 |
1.0018 |
1622 |
98 |
TEST_TIME |
173 |
6027.03 |
0.9969 |
1.0054 |
1683 |
96 |
TEST_TIME |
174 |
6033.43 |
0.9986 |
1.0020 |
1627 |
96 |
TEST_TIME |
175 |
6027.71 |
0.9972 |
1.0028 |
1638 |
94 |
TEST_TIME |
176 |
6025.98 |
0.9974 |
1.0022 |
1448 |
96 |
TEST_TIME |
177 |
6021.33 |
0.9974 |
1.0026 |
1334 |
88 |
TEST_TIME |
178 |
6021.26 |
0.9969 |
1.0025 |
1315 |
83 |
TEST_TIME |
179 |
6029.83 |
0.9954 |
1.0022 |
1140 |
86 |
TEST_TIME |
180 |
6010.39 |
0.9999 |
1.0008 |
72 |
72 |
Done for 10650 ms, from 11:40:06.86 to 11:40:17.51.
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 |
21783 |
10676 |
23422 |
<null> |
22295 |
<null> |
22029 |
10506 |
14447 |
3426 |
25191 |
15930 |
35456 |
1351 |
34080 |
27307 |
32216 |
43534 |
<null> |
08:24:01 |
08:42:01 |
fetches per second |
2 |
2743 |
3023 |
4510 |
<null> |
19329 |
6429 |
8947 |
<null> |
3899 |
4137 |
3198 |
<null> |
6776 |
6646 |
7076 |
2216 |
<null> |
62920 |
<null> |
08:42:02 |
09:00:02 |
fetches per second |
3 |
6098 |
4260 |
11088 |
<null> |
12516 |
4800 |
13306 |
30020 |
4656 |
8794 |
14589 |
6634 |
21308 |
26314 |
10364 |
<null> |
<null> |
93109 |
<null> |
09:00:03 |
09:18:03 |
fetches per second |
4 |
15985 |
17240 |
13113 |
<null> |
14127 |
64147 |
17553 |
44329 |
18769 |
<null> |
16825 |
4061 |
10355 |
24381 |
24314 |
1411 |
26589 |
13680 |
<null> |
09:18:04 |
09:36:04 |
fetches per second |
5 |
7056 |
24768 |
5416 |
<null> |
4590 |
<null> |
8126 |
11974 |
10768 |
39948 |
6473 |
3090 |
10874 |
7292 |
14537 |
<null> |
<null> |
73949 |
<null> |
09:36:05 |
09:54:05 |
fetches per second |
6 |
19203 |
34186 |
12502 |
<null> |
17917 |
<null> |
29502 |
8579 |
51344 |
5162 |
39468 |
8814 |
28537 |
128875 |
30155 |
117375 |
24170 |
112046 |
<null> |
09:54:06 |
10:12:06 |
fetches per second |
7 |
9101 |
2956 |
11620 |
<null> |
5073 |
<null> |
14753 |
3710 |
148235 |
4160 |
4004 |
<null> |
10869 |
3799 |
21001 |
1215 |
<null> |
73722 |
<null> |
10:12:07 |
10:30:07 |
fetches per second |
8 |
17302 |
15568 |
7562 |
<null> |
22719 |
2820 |
24574 |
3487 |
73300 |
3108 |
15579 |
2643 |
19719 |
5285 |
32854 |
16812 |
38710 |
109478 |
<null> |
10:30:08 |
10:48:08 |
fetches per second |
9 |
12508 |
10825 |
25152 |
<null> |
9817 |
3694 |
39360 |
6795 |
4896 |
4078 |
9778 |
2316 |
19990 |
12007 |
20614 |
<null> |
233122 |
62805 |
<null> |
10:48:09 |
11:06:09 |
fetches per second |
10 |
5719 |
6283 |
5103 |
<null> |
5967 |
2526 |
4588 |
5885 |
787 |
41153 |
7009 |
8444 |
10528 |
3990 |
6233 |
<null> |
<null> |
129972 |
<null> |
11:06:10 |
11:24:10 |
marks per second |
1 |
4870 |
1389 |
4841 |
<null> |
4736 |
<null> |
2758 |
2165 |
1726 |
629 |
4050 |
2745 |
3929 |
197 |
1320 |
4173 |
1321 |
538 |
<null> |
08:24:01 |
08:42:01 |
marks per second |
2 |
588 |
370 |
816 |
<null> |
3693 |
1633 |
1451 |
<null> |
642 |
862 |
630 |
<null> |
527 |
1143 |
636 |
409 |
<null> |
1761 |
<null> |
08:42:02 |
09:00:02 |
marks per second |
3 |
1303 |
516 |
1823 |
<null> |
2611 |
1166 |
1741 |
5023 |
556 |
1652 |
2491 |
1331 |
808 |
4032 |
581 |
<null> |
<null> |
1072 |
<null> |
09:00:03 |
09:18:03 |
marks per second |
4 |
3514 |
2419 |
2812 |
<null> |
2885 |
13482 |
2821 |
7588 |
2141 |
<null> |
3264 |
646 |
490 |
3604 |
1808 |
250 |
849 |
608 |
<null> |
09:18:04 |
09:36:04 |
marks per second |
5 |
1513 |
3017 |
881 |
<null> |
835 |
<null> |
1138 |
1957 |
1540 |
6378 |
964 |
502 |
473 |
1199 |
1540 |
<null> |
<null> |
1622 |
<null> |
09:36:05 |
09:54:05 |
marks per second |
6 |
4153 |
4202 |
2261 |
<null> |
3700 |
<null> |
4456 |
1397 |
9170 |
827 |
4421 |
1460 |
1254 |
23204 |
3544 |
23875 |
973 |
4015 |
<null> |
09:54:06 |
10:12:06 |
marks per second |
7 |
2016 |
428 |
2089 |
<null> |
795 |
<null> |
1813 |
619 |
24235 |
916 |
595 |
<null> |
616 |
679 |
2658 |
183 |
<null> |
3141 |
<null> |
10:12:07 |
10:30:07 |
marks per second |
8 |
3683 |
2262 |
1401 |
<null> |
4372 |
748 |
3409 |
702 |
13300 |
691 |
1560 |
446 |
884 |
800 |
3665 |
2724 |
6442 |
18251 |
<null> |
10:30:08 |
10:48:08 |
marks per second |
9 |
2492 |
1552 |
3486 |
<null> |
1349 |
876 |
5006 |
1119 |
661 |
730 |
2044 |
368 |
884 |
1481 |
1429 |
<null> |
2603 |
728 |
<null> |
10:48:09 |
11:06:09 |
marks per second |
10 |
1205 |
877 |
649 |
<null> |
880 |
582 |
617 |
965 |
110 |
7541 |
647 |
992 |
374 |
701 |
810 |
<null> |
<null> |
791 |
<null> |
11:06:10 |
11:24:10 |
reads/fetches*100 |
1 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
08:24:01 |
08:42:01 |
reads/fetches*100 |
2 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
08:42:02 |
09:00:02 |
reads/fetches*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
0 |
<null> |
09:00:03 |
09:18:03 |
reads/fetches*100 |
4 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
09:18:04 |
09:36:04 |
reads/fetches*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
0 |
<null> |
09:36:05 |
09:54:05 |
reads/fetches*100 |
6 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
09:54:06 |
10:12:06 |
reads/fetches*100 |
7 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
10:12:07 |
10:30:07 |
reads/fetches*100 |
8 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
10:30:08 |
10:48:08 |
reads/fetches*100 |
9 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
10:48:09 |
11:06:09 |
reads/fetches*100 |
10 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
0 |
<null> |
11:06:10 |
11:24:10 |
writes/marks*100 |
1 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
4 |
0 |
<null> |
08:24:01 |
08:42:01 |
writes/marks*100 |
2 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
08:42:02 |
09:00:02 |
writes/marks*100 |
3 |
0 |
0 |
1 |
<null> |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
0 |
<null> |
09:00:03 |
09:18:03 |
writes/marks*100 |
4 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
<null> |
09:18:04 |
09:36:04 |
writes/marks*100 |
5 |
1 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
0 |
<null> |
09:36:05 |
09:54:05 |
writes/marks*100 |
6 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0 |
<null> |
09:54:06 |
10:12:06 |
writes/marks*100 |
7 |
0 |
1 |
1 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
10:12:07 |
10:30:07 |
writes/marks*100 |
8 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0 |
<null> |
10:30:08 |
10:48:08 |
writes/marks*100 |
9 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
5 |
0 |
<null> |
10:48:09 |
11:06:09 |
writes/marks*100 |
10 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
0 |
<null> |
11:06:10 |
11:24:10 |
Done for 9530 ms, from 11:40:18.71 to 11:40:28.24.
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 |
1873668 |
1758920 |
114748 |
6.12 |
0 |
20733 |
59 |
114748 |
2017-03-29 08:24 |
2017-03-29 11:24 |
doc_list_biud |
1874069 |
1758920 |
115149 |
6.14 |
0 |
17893 |
21 |
115149 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_add_invoice_to_stock |
19936 |
12294 |
7642 |
38.33 |
15 |
168917 |
15662 |
7642 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_cancel_adding_invoice |
4270 |
3382 |
888 |
20.79 |
0 |
87329 |
3420 |
888 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_cancel_client_order |
6838 |
6680 |
158 |
2.31 |
0 |
3760 |
296 |
158 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_cancel_customer_reserve |
290453 |
185277 |
105176 |
36.21 |
0 |
17893 |
90 |
105176 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_cancel_pay_from_customer |
2645 |
2638 |
7 |
0.26 |
0 |
2231 |
149 |
7 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_cancel_pay_to_supplier |
1615 |
1610 |
5 |
0.30 |
0 |
3307 |
149 |
5 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_cancel_supplier_invoice |
9051 |
7170 |
1881 |
20.78 |
0 |
11326 |
585 |
1881 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_cancel_supplier_order |
1585 |
522 |
1063 |
67.06 |
47 |
439234 |
27981 |
1063 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_cancel_write_off |
22651 |
14758 |
7893 |
34.84 |
0 |
5117 |
205 |
7893 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_client_order |
81074 |
81074 |
0 |
0.00 |
0 |
16380 |
565 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_customer_reserve |
632395 |
632395 |
0 |
0.00 |
0 |
18657 |
258 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_fill_shopping_cart |
123261 |
123012 |
249 |
0.20 |
0 |
7005 |
113 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_fill_shopping_cart_clo_res |
632395 |
632395 |
0 |
0.00 |
0 |
16989 |
19 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_get_clo_for_invoice |
12294 |
12294 |
0 |
0.00 |
0 |
4789 |
387 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_kill_cost_storno |
30779 |
22388 |
8391 |
27.26 |
0 |
2824 |
22 |
8391 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_kill_qstorno_ret_qs2qd |
612276 |
393004 |
219272 |
35.81 |
0 |
17877 |
34 |
219272 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_kill_qty_storno |
382947 |
267891 |
115056 |
30.04 |
0 |
17893 |
99 |
115056 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_lock_selected_doc |
80589 |
70077 |
10512 |
13.04 |
0 |
2091 |
8 |
10512 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_make_cost_storno |
100097 |
100097 |
0 |
0.00 |
0 |
19968 |
477 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_multiply_rows_for_pdistr |
100097 |
100097 |
0 |
0.00 |
0 |
19890 |
63 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_multiply_rows_for_qdistr |
81074 |
81074 |
0 |
0.00 |
0 |
15912 |
190 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_pay_from_customer |
27399 |
27399 |
0 |
0.00 |
15 |
20077 |
1064 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_pay_to_supplier |
22596 |
22596 |
0 |
0.00 |
0 |
18501 |
764 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_payment_common |
49995 |
49995 |
0 |
0.00 |
0 |
17768 |
67 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_qd_handle_on_cancel_clo |
6832 |
6680 |
152 |
2.22 |
0 |
3416 |
133 |
152 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_qd_handle_on_invoice_upd_sts |
16359 |
15676 |
683 |
4.17 |
0 |
17301 |
421 |
683 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_qd_handle_on_reserve_upd_sts |
37808 |
37808 |
0 |
0.00 |
0 |
4695 |
66 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_reserve_write_off |
38474 |
37808 |
666 |
1.73 |
0 |
20826 |
588 |
666 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_supplier_invoice |
21024 |
20925 |
99 |
0.47 |
0 |
25491 |
3489 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
sp_supplier_order |
21163 |
21013 |
150 |
0.70 |
0 |
20608 |
2455 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
srv_find_qd_qs_mism |
1101034 |
986284 |
114750 |
10.42 |
0 |
17488 |
34 |
114750 |
2017-03-29 08:24 |
2017-03-29 11:24 |
srv_make_invnt_saldo |
1398 |
1398 |
0 |
0.00 |
0 |
24024 |
4685 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
srv_make_money_saldo |
3797 |
3797 |
0 |
0.00 |
0 |
3463 |
63 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
2371 |
34351 |
17217 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-abend:sp_add_invoice_to_stock |
7642 |
7642 |
0 |
0.00 |
0 |
2309 |
101 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-abend:sp_cancel_adding_invoice |
792 |
792 |
0 |
0.00 |
0 |
1747 |
223 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-abend:sp_cancel_client_order |
158 |
158 |
0 |
0.00 |
0 |
1389 |
111 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-abend:sp_cancel_customer_reserve |
49 |
49 |
0 |
0.00 |
0 |
748 |
75 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-abend:sp_cancel_pay_from_customer |
7 |
7 |
0 |
0.00 |
0 |
172 |
73 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-abend:sp_cancel_pay_to_supplier |
5 |
5 |
0 |
0.00 |
32 |
265 |
99 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-abend:sp_cancel_supplier_invoice |
603 |
603 |
0 |
0.00 |
0 |
1030 |
82 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-abend:sp_cancel_supplier_order |
13227 |
13227 |
0 |
0.00 |
0 |
17753 |
163 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-abend:sp_cancel_write_off |
36 |
36 |
0 |
0.00 |
0 |
562 |
87 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-abend:sp_reserve_write_off |
666 |
666 |
0 |
0.00 |
0 |
1966 |
85 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-abend:sp_supplier_invoice |
99 |
99 |
0 |
0.00 |
0 |
655 |
87 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-abend:sp_supplier_order |
150 |
150 |
0 |
0.00 |
0 |
3760 |
150 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-norm:sp_add_invoice_to_stock |
12294 |
12294 |
0 |
0.00 |
0 |
11700 |
759 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-norm:sp_cancel_adding_invoice |
1365 |
1365 |
0 |
0.00 |
0 |
8658 |
846 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-norm:sp_cancel_client_order |
6680 |
6680 |
0 |
0.00 |
0 |
2075 |
69 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-norm:sp_cancel_customer_reserve |
2525 |
2525 |
0 |
0.00 |
0 |
2372 |
62 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-norm:sp_cancel_pay_from_customer |
2638 |
2638 |
0 |
0.00 |
0 |
2168 |
56 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-norm:sp_cancel_pay_to_supplier |
1610 |
1610 |
0 |
0.00 |
0 |
1638 |
51 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-norm:sp_cancel_supplier_invoice |
957 |
957 |
0 |
0.00 |
0 |
2184 |
91 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-norm:sp_cancel_supplier_order |
522 |
522 |
0 |
0.00 |
0 |
30997 |
2257 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-norm:sp_cancel_write_off |
3678 |
3678 |
0 |
0.00 |
0 |
2168 |
78 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-norm:sp_client_order |
81074 |
81074 |
0 |
0.00 |
0 |
3104 |
85 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-norm:sp_customer_reserve |
3744 |
3744 |
0 |
0.00 |
0 |
2106 |
62 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-norm:sp_pay_from_customer |
27399 |
27399 |
0 |
0.00 |
0 |
11700 |
77 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-norm:sp_pay_to_supplier |
22596 |
22596 |
0 |
0.00 |
0 |
2730 |
67 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-norm:sp_reserve_write_off |
37808 |
37808 |
0 |
0.00 |
0 |
6287 |
77 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-norm:sp_supplier_invoice |
20925 |
20925 |
0 |
0.00 |
0 |
13275 |
81 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-norm:sp_supplier_order |
21013 |
21013 |
0 |
0.00 |
0 |
2512 |
87 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-norm:srv_make_invnt_saldo |
1398 |
1398 |
0 |
0.00 |
0 |
1295 |
34 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-norm:srv_make_money_saldo |
3797 |
3797 |
0 |
0.00 |
0 |
1107 |
25 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
t$perf-norm:srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
0 |
795 |
166 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
v_add_invoice_to_stock |
39872 |
24588 |
15284 |
38.33 |
0 |
6739 |
47 |
15284 |
2017-03-29 08:24 |
2017-03-29 11:24 |
v_all_customers |
121762 |
121762 |
0 |
0.00 |
0 |
1560 |
6 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
v_all_suppliers |
84646 |
84148 |
498 |
0.58 |
0 |
999 |
6 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
v_all_wares |
162148 |
162148 |
0 |
0.00 |
0 |
4930 |
5 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
v_cancel_adding_invoice |
3296 |
2730 |
566 |
17.17 |
0 |
2168 |
165 |
566 |
2017-03-29 08:24 |
2017-03-29 11:24 |
v_cancel_client_order |
13676 |
13360 |
316 |
2.31 |
0 |
842 |
7 |
316 |
2017-03-29 08:24 |
2017-03-29 11:24 |
v_cancel_customer_prepayment |
5290 |
5276 |
14 |
0.26 |
0 |
655 |
9 |
14 |
2017-03-29 08:24 |
2017-03-29 11:24 |
v_cancel_customer_reserve |
5148 |
5050 |
98 |
1.90 |
0 |
749 |
9 |
98 |
2017-03-29 08:24 |
2017-03-29 11:24 |
v_cancel_payment_to_supplier |
3230 |
3220 |
10 |
0.30 |
0 |
375 |
9 |
10 |
2017-03-29 08:24 |
2017-03-29 11:24 |
v_cancel_supplier_invoice |
3120 |
1914 |
1206 |
38.65 |
0 |
1154 |
45 |
1206 |
2017-03-29 08:24 |
2017-03-29 11:24 |
v_cancel_supplier_order |
3170 |
1044 |
2126 |
67.06 |
0 |
374 |
11 |
2126 |
2017-03-29 08:24 |
2017-03-29 11:24 |
v_cancel_write_off |
7428 |
7356 |
72 |
0.96 |
0 |
3323 |
100 |
72 |
2017-03-29 08:24 |
2017-03-29 11:24 |
v_max_id_clo_ord |
21163 |
21013 |
150 |
0.70 |
0 |
889 |
6 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
v_max_id_clo_res |
3744 |
3744 |
0 |
0.00 |
0 |
967 |
19 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
v_max_id_ord_sup |
21024 |
20925 |
99 |
0.47 |
0 |
873 |
6 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
v_max_non_paid_invoice |
22460 |
22460 |
0 |
0.00 |
0 |
17753 |
7 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
v_max_non_paid_realizn |
27399 |
27399 |
0 |
0.00 |
0 |
1076 |
6 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
v_min_id_clo_ord |
21163 |
21013 |
150 |
0.70 |
0 |
1497 |
8 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
v_min_id_clo_res |
3744 |
3744 |
0 |
0.00 |
0 |
1138 |
11 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
v_min_id_ord_sup |
21024 |
20925 |
99 |
0.47 |
0 |
1248 |
8 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
v_min_non_paid_invoice |
22596 |
22596 |
0 |
0.00 |
0 |
3759 |
8 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
v_min_non_paid_realizn |
27399 |
27399 |
0 |
0.00 |
0 |
3322 |
7 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
v_our_firm |
40386 |
40386 |
0 |
0.00 |
0 |
1607 |
7 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
v_reserve_write_off |
76948 |
75616 |
1332 |
1.73 |
0 |
16817 |
9 |
1332 |
2017-03-29 08:24 |
2017-03-29 11:24 |
x_lock_depdocs_on_canc_invoice |
17295 |
9595 |
7700 |
44.52 |
0 |
1779 |
41 |
7700 |
2017-03-29 08:24 |
2017-03-29 11:24 |
x_lock_depdocs_on_canc_sup_ord |
1582 |
522 |
1060 |
67.00 |
0 |
1280 |
81 |
1060 |
2017-03-29 08:24 |
2017-03-29 11:24 |
x_make_qstorno_1000_1200 |
21163 |
21013 |
150 |
0.70 |
0 |
20421 |
2205 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
x_make_qstorno_1200_2000 |
21024 |
20925 |
99 |
0.47 |
0 |
25272 |
3240 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
x_make_qstorno_2100_3300 |
632395 |
632395 |
0 |
0.00 |
0 |
18610 |
218 |
0 |
2017-03-29 08:24 |
2017-03-29 11:24 |
Done for 458660 ms, from 11:47:47.99 to 11:55:26.65.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
DTS_BEG |
DTS_END |
deadlock |
106 |
sp_kill_cost_storno |
335544336 |
2017-03-29 08:24 |
2017-03-29 11:23 |
deadlock |
73 |
sp_kill_qstorno_ret_qs2qd |
335544336 |
2017-03-29 08:28 |
2017-03-29 11:22 |
deadlock |
1272 |
sp_lock_selected_doc |
335544336 |
2017-03-29 08:24 |
2017-03-29 11:23 |
deadlock |
152 |
sp_qd_handle_on_cancel_clo |
335544336 |
2017-03-29 08:24 |
2017-03-29 11:23 |
deadlock |
145 |
sp_qd_handle_on_invoice_upd_sts |
335544336 |
2017-03-29 08:24 |
2017-03-29 11:22 |
deadlock |
29 |
x_lock_depdocs_on_canc_invoice |
335544336 |
2017-03-29 08:24 |
2017-03-29 10:55 |
deadlock |
7 |
x_lock_depdocs_on_canc_sup_ord |
335544336 |
2017-03-29 09:12 |
2017-03-29 10:34 |
user_exc |
150 |
x_make_qstorno_1000_1200 |
335544517 |
2017-03-29 08:24 |
2017-03-29 11:23 |
user_exc |
99 |
x_make_qstorno_1200_2000 |
335544517 |
2017-03-29 08:24 |
2017-03-29 11:23 |
concurrent_transaction |
7749 |
sp_lock_selected_doc |
335544878 |
2017-03-29 08:24 |
2017-03-29 11:24 |
concurrent_transaction |
649 |
x_lock_depdocs_on_canc_invoice |
335544878 |
2017-03-29 08:24 |
2017-03-29 11:24 |
concurrent_transaction |
326 |
x_lock_depdocs_on_canc_sup_ord |
335544878 |
2017-03-29 08:28 |
2017-03-29 11:23 |
Done for 12900 ms, from 11:55:36.99 to 11:55:49.89.
MON$DATABASE_NAME D:\OLTP-EMUL\OLTP40-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 13
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 431134
MON$OLDEST_ACTIVE 431135
MON$OLDEST_SNAPSHOT 431135
MON$NEXT_TRANSACTION 431135
MON$PAGE_BUFFERS 786432
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 2017-01-11 15:15:54.2050
MON$PAGES 852672
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-T4.0.0.578 Firebird 4.0 Unstable
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.578 Firebird 4.0 Unstable"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T4.0.0.578 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P16"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T4.0.0.578 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P16"
on disk structure version 13.0
Database "D:\OLTP-EMUL\OLTP40-SMALL.FDB"
Database header page information:
Flags 0
Generation 431210
System Change Number 0
Page size 8192
ODS version 13.0
Oldest transaction 431136
Oldest active 431137
Oldest snapshot 431137
Next transaction 431138
Sequence number 0
Next attachment ID 9360
Implementation HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jan 11, 2017 15:15:54
Attributes force write
Variable header data:
Sweep interval: 0
*END*
Database file sequence:
File D:\OLTP-EMUL\OLTP40-SMALL.FDB is the only file
Analyzing database pages ...
AGENTS (154)
Primary pointer page: 314, Index root page: 315
Total formats: 1, used formats: 1
Average record length: 33.50, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 344.00, compression ratio: 10.27
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_ID_DESC (2)
Root page: 325, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_OUR_FIRM (4)
Root page: 327, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 48
Average key length: 2.04, compression ratio: 0.50
Average prefix length: 0.96, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_SUPPLIER (3)
Root page: 326, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 43
Average key length: 2.04, compression ratio: 0.55
Average prefix length: 1.06, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_NAME_UNQ (1)
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.32, total dup: 0, max dup: 0
Average key length: 15.94, compression ratio: 0.91
Average prefix length: 1.20, average data length: 13.32
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_AGENTS (0)
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BUSINESS_OPS (158)
Primary pointer page: 335, Index root page: 336
Total formats: 1, used formats: 1
Average record length: 107.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1236.00, compression ratio: 11.55
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 29%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BO_UNIT_UNQ (1)
Root page: 339, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 18.00, total dup: 0, max dup: 0
Average key length: 16.95, compression ratio: 1.25
Average prefix length: 7.21, average data length: 14.00
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BUSINESS_OPS_RND_WGTH (2)
Root page: 340, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 4.05, total dup: 7, max dup: 3
Average key length: 3.00, compression ratio: 0.75
Average prefix length: 1.42, average data length: 0.84
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$1 (0)
Root page: 338, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 5.26, total dup: 0, max dup: 0
Average key length: 4.21, compression ratio: 0.64
Average prefix length: 1.05, average data length: 1.63
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DOC_DATA (141)
Primary pointer page: 254, Index root page: 255
Total formats: 1, used formats: 1
Average record length: 47.12, total records: 2156606
Average version length: 47.73, total versions: 2615, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.36
Pointer pages: 15, data page slots: 23480
Data pages: 23480, average fill: 72%
Primary pages: 23480, secondary pages: 0, swept pages: 15410
Empty pages: 5, full pages: 18142
Fill distribution:
0 - 19% = 6
20 - 39% = 5
40 - 59% = 126
60 - 79% = 23340
80 - 99% = 3
Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26714, depth: 3, leaf buckets: 10538, nodes: 2156606
Average node length: 19.43, total dup: 0, max dup: 0
Average key length: 16.47, compression ratio: 1.64
Average prefix length: 13.52, average data length: 13.48
Clustering factor: 513103, ratio: 0.24
Fill distribution:
0 - 19% = 592
20 - 39% = 2255
40 - 59% = 5445
60 - 79% = 907
80 - 99% = 1339
Index DOC_DATA_ID_DESC (2)
Root page: 46473, depth: 3, leaf buckets: 7729, nodes: 2156606
Average node length: 11.64, total dup: 0, max dup: 0
Average key length: 8.69, compression ratio: 1.04
Average prefix length: 3.31, average data length: 5.69
Clustering factor: 474610, ratio: 0.22
Fill distribution:
0 - 19% = 0
20 - 39% = 3644
40 - 59% = 4046
60 - 79% = 35
80 - 99% = 4
Index FK_DOC_DATA_DOC_LIST (3)
Root page: 175220, depth: 3, leaf buckets: 3936, nodes: 2156606
Average node length: 6.88, total dup: 1550464, max dup: 49
Average key length: 3.93, compression ratio: 2.29
Average prefix length: 7.35, average data length: 1.65
Clustering factor: 474836, ratio: 0.22
Fill distribution:
0 - 19% = 141
20 - 39% = 1417
40 - 59% = 1751
60 - 79% = 114
80 - 99% = 513
DOC_LIST (140)
Primary pointer page: 249, Index root page: 250
Total formats: 1, used formats: 1
Average record length: 60.35, total records: 671418
Average version length: 61.31, total versions: 241, max versions: 2
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 6, data page slots: 8552
Data pages: 8552, average fill: 75%
Primary pages: 8551, secondary pages: 1, swept pages: 8240
Empty pages: 7, full pages: 7251
Fill distribution:
0 - 19% = 10
20 - 39% = 6
40 - 59% = 39
60 - 79% = 8484
80 - 99% = 13
Index DOC_LIST_ID_DESC (1)
Root page: 259256, depth: 3, leaf buckets: 2509, nodes: 671418
Average node length: 11.68, total dup: 0, max dup: 0
Average key length: 8.81, compression ratio: 1.02
Average prefix length: 3.18, average data length: 5.82
Clustering factor: 170182, ratio: 0.25
Fill distribution:
0 - 19% = 0
20 - 39% = 1485
40 - 59% = 1007
60 - 79% = 16
80 - 99% = 1
Index FK_DOC_LIST_AGENTS (2)
Root page: 2940, depth: 2, leaf buckets: 714, nodes: 671418
Average node length: 4.88, total dup: 671368, max dup: 34555
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 304850, ratio: 0.45
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 615
60 - 79% = 81
80 - 99% = 17
Index PK_DOC_LIST (0)
Root page: 308341, depth: 3, leaf buckets: 2206, nodes: 671418
Average node length: 11.68, total dup: 0, max dup: 0
Average key length: 8.81, compression ratio: 1.02
Average prefix length: 3.19, average data length: 5.81
Clustering factor: 170182, ratio: 0.25
Fill distribution:
0 - 19% = 158
20 - 39% = 905
40 - 59% = 785
60 - 79% = 133
80 - 99% = 225
DOC_STATES (153)
Primary pointer page: 312, Index root page: 313
Total formats: 1, used formats: 1
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 650.00, compression ratio: 9.63
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_MCODE_UNQ (1)
Root page: 321, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 17.75, total dup: 0, max dup: 0
Average key length: 16.50, compression ratio: 1.08
Average prefix length: 4.00, average data length: 13.75
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_NAME_UNQ (2)
Root page: 322, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 33.25, total dup: 0, max dup: 0
Average key length: 32.00, compression ratio: 0.99
Average prefix length: 2.50, average data length: 29.25
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_DOC_STATES (0)
Root page: 320, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 4.75, total dup: 0, max dup: 0
Average key length: 3.50, compression ratio: 0.86
Average prefix length: 1.50, average data length: 1.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
FB_ERRORS (159)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 148.00, compression ratio: 1.86
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 56%
Primary pages: 16, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 11
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7
Index FB_ERRORS_GDS_CODE (0)
Root page: 343, depth: 1, leaf buckets: 1, nodes: 758
Average node length: 4.24, total dup: 0, max dup: 0
Average key length: 3.04, compression ratio: 1.64
Average prefix length: 3.97, average data length: 1.03
Clustering factor: 353, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
INVNT_SALDO (147)
Primary pointer page: 273, Index root page: 274
Total formats: 1, used formats: 1
Average record length: 65.83, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 18.25, total fragments: 377, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.58
Pointer pages: 1, data page slots: 696
Data pages: 20, average fill: 32%
Primary pages: 5, secondary pages: 15, swept pages: 4
Empty pages: 7, full pages: 3
Fill distribution:
0 - 19% = 10
20 - 39% = 3
40 - 59% = 3
60 - 79% = 1
80 - 99% = 3
Index PK_INVNT_SALDO (0)
Root page: 285, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 303, ratio: 0.76
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
INVNT_TURNOVER_LOG (157)
Primary pointer page: 333, Index root page: 334
Total formats: 1, used formats: 1
Average record length: 41.27, total records: 6514
Average version length: 71.25, total versions: 2742, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 2.33
Pointer pages: 2, data page slots: 1840
Data pages: 592, average fill: 15%
Primary pages: 592, secondary pages: 0, swept pages: 476
Empty pages: 88, full pages: 25
Fill distribution:
0 - 19% = 446
20 - 39% = 74
40 - 59% = 33
60 - 79% = 29
80 - 99% = 10
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1481, depth: 2, leaf buckets: 33, nodes: 6514
Average node length: 15.45, total dup: 279, max dup: 1
Average key length: 12.52, compression ratio: 2.16
Average prefix length: 17.44, average data length: 9.56
Clustering factor: 5276, ratio: 0.81
Fill distribution:
0 - 19% = 1
20 - 39% = 20
40 - 59% = 11
60 - 79% = 1
80 - 99% = 0
MONEY_SALDO (143)
Primary pointer page: 265, Index root page: 266
Total formats: 1, used formats: 1
Average record length: 15.04, total records: 49
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 2.13
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 20%
Primary pages: 1, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MONEY_SALDO (0)
Root page: 276, depth: 1, leaf buckets: 1, nodes: 49
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MONEY_TURNOVER_LOG (142)
Primary pointer page: 263, Index root page: 264
Total formats: 1, used formats: 1
Average record length: 46.29, total records: 38
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.38
Pointer pages: 1, data page slots: 64
Data pages: 24, average fill: 2%
Primary pages: 24, secondary pages: 0, swept pages: 18
Empty pages: 20, full pages: 0
Fill distribution:
0 - 19% = 23
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 214941, depth: 2, leaf buckets: 1, nodes: 38
Average node length: 12.61, total dup: 19, max dup: 6
Average key length: 10.58, compression ratio: 1.80
Average prefix length: 10.89, average data length: 8.11
Clustering factor: 12, ratio: 0.32
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG (165)
Primary pointer page: 356, Index root page: 357
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_DTS (4)
Root page: 367, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_GDSCODE (2)
Root page: 365, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_ROWSET_DESC (1)
Root page: 364, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_UNIT (3)
Root page: 366, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG (0)
Root page: 363, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG_TABLE_STATS (166)
Primary pointer page: 369, Index root page: 370
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 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)
Root page: 376, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_GDSCODE (2)
Root page: 374, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_ROWSET (1)
Root page: 373, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
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)
Root page: 375, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG_TABLE_STATS (0)
Root page: 372, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
OPTYPES (138)
Primary pointer page: 241, Index root page: 242
Total formats: 1, used formats: 1
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 5.54
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 9%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OPTYPES_MCODE_UNQ (1)
Root page: 244, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 8.56, total dup: 0, max dup: 0
Average key length: 6.89, compression ratio: 0.73
Average prefix length: 0.44, average data length: 4.56
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_OPTYPES (0)
Root page: 243, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 6.11, total dup: 0, max dup: 0
Average key length: 5.00, compression ratio: 0.60
Average prefix length: 0.89, average data length: 2.11
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PDISTR (150)
Primary pointer page: 296, Index root page: 297
Total formats: 1, used formats: 1
Average record length: 18.78, total records: 812568
Average version length: 42.71, total versions: 1083, max versions: 6
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 3.41
Pointer pages: 4, data page slots: 4944
Data pages: 4944, average fill: 73%
Primary pages: 4938, secondary pages: 6, swept pages: 4552
Empty pages: 5, full pages: 3792
Fill distribution:
0 - 19% = 12
20 - 39% = 58
40 - 59% = 179
60 - 79% = 4356
80 - 99% = 339
Index PDISTR_AGENT_ID (4)
Root page: 3976, depth: 2, leaf buckets: 255, nodes: 238491
Average node length: 4.88, total dup: 238442, max dup: 14947
Average key length: 2.01, compression ratio: 4.47
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 34209, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 29
40 - 59% = 140
60 - 79% = 70
80 - 99% = 15
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 3600, depth: 2, leaf buckets: 297, nodes: 238491
Average node length: 5.82, total dup: 215187, max dup: 30
Average key length: 2.95, compression ratio: 7.45
Average prefix length: 21.14, average data length: 0.86
Clustering factor: 38319, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 45
40 - 59% = 127
60 - 79% = 78
80 - 99% = 46
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3602, depth: 2, leaf buckets: 292, nodes: 238491
Average node length: 5.82, total dup: 215187, max dup: 30
Average key length: 2.95, compression ratio: 7.45
Average prefix length: 21.14, average data length: 0.86
Clustering factor: 38363, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 39
40 - 59% = 123
60 - 79% = 92
80 - 99% = 38
Index PDISTR_SND_ID (1)
Root page: 3001, depth: 2, leaf buckets: 296, nodes: 238491
Average node length: 5.61, total dup: 215187, max dup: 30
Average key length: 2.74, compression ratio: 3.28
Average prefix length: 8.36, average data length: 0.64
Clustering factor: 38381, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 48
40 - 59% = 140
60 - 79% = 71
80 - 99% = 37
PERF_ESTIMATED (160)
Primary pointer page: 344, Index root page: 345
Total formats: 1, used formats: 1
Average record length: 27.90, total records: 271624
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 1.15
Pointer pages: 2, data page slots: 2320
Data pages: 2320, average fill: 64%
Primary pages: 2320, secondary pages: 0, swept pages: 0
Empty pages: 2, full pages: 2317
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 0
60 - 79% = 2317
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 65315, depth: 2, leaf buckets: 217, nodes: 271624
Average node length: 4.53, total dup: 271443, max dup: 2326
Average key length: 2.00, compression ratio: 1.28
Average prefix length: 2.56, average data length: 0.00
Clustering factor: 51392, ratio: 0.19
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 87
60 - 79% = 65
80 - 99% = 65
PERF_ISQL_STAT (161)
Primary pointer page: 347, Index root page: 348
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PERF_ISQL_STAT_TRN (0)
Root page: 349, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PERF_LOG (163)
Primary pointer page: 352, Index root page: 353
Total formats: 1, used formats: 1
Average record length: 151.84, total records: 11443787
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.17
Pointer pages: 167, data page slots: 271600
Data pages: 271600, average fill: 87%
Primary pages: 271600, secondary pages: 0, swept pages: 3
Empty pages: 0, full pages: 271599
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 271599
Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 61748, depth: 3, leaf buckets: 12540, nodes: 11443787
Average node length: 5.67, total dup: 10564555, max dup: 156
Average key length: 2.19, compression ratio: 3.65
Average prefix length: 7.86, average data length: 0.14
Clustering factor: 5264718, ratio: 0.46
Fill distribution:
0 - 19% = 14
20 - 39% = 0
40 - 59% = 6234
60 - 79% = 4095
80 - 99% = 2197
Index PERF_LOG_GDSCODE (3)
Root page: 163282, depth: 3, leaf buckets: 11272, nodes: 11443787
Average node length: 4.55, total dup: 11443782, max dup: 10588121
Average key length: 1.08, compression ratio: 0.35
Average prefix length: 0.37, average data length: 0.00
Clustering factor: 343668, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 11243
60 - 79% = 1
80 - 99% = 28
Index PERF_LOG_TRN_DESC (2)
Root page: 42827, depth: 3, leaf buckets: 13619, nodes: 11443787
Average node length: 5.71, total dup: 11078148, max dup: 22023
Average key length: 2.24, compression ratio: 4.02
Average prefix length: 8.80, average data length: 0.20
Clustering factor: 1062746, ratio: 0.09
Fill distribution:
0 - 19% = 6
20 - 39% = 1
40 - 59% = 9568
60 - 79% = 2173
80 - 99% = 1871
Index PERF_LOG_UNIT (1)
Root page: 77433, depth: 3, leaf buckets: 13863, nodes: 11443787
Average node length: 5.55, total dup: 11415117, max dup: 1391645
Average key length: 2.07, compression ratio: 18.23
Average prefix length: 37.69, average data length: 0.07
Clustering factor: 7049326, ratio: 0.62
Fill distribution:
0 - 19% = 19
20 - 39% = 2
40 - 59% = 11845
60 - 79% = 639
80 - 99% = 1358
PHRASES (145)
Primary pointer page: 269, Index root page: 270
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_ID_DESC (3)
Root page: 283, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_NAME (2)
Root page: 282, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_UNQ (1)
Root page: 281, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_PHRASES (0)
Root page: 280, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PSTORNED (151)
Primary pointer page: 303, Index root page: 304
Total formats: 1, used formats: 1
Average record length: 54.98, total records: 429949
Average version length: 55.44, total versions: 999, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.46
Pointer pages: 4, data page slots: 5144
Data pages: 5144, average fill: 74%
Primary pages: 5144, secondary pages: 0, swept pages: 3649
Empty pages: 3, full pages: 4506
Fill distribution:
0 - 19% = 6
20 - 39% = 9
40 - 59% = 29
60 - 79% = 5096
80 - 99% = 4
Index PSTORNED_RCV_ID (2)
Root page: 667592, depth: 3, leaf buckets: 596, nodes: 429949
Average node length: 5.94, total dup: 361123, max dup: 356
Average key length: 3.16, compression ratio: 2.84
Average prefix length: 7.99, average data length: 1.01
Clustering factor: 53899, ratio: 0.13
Fill distribution:
0 - 19% = 14
20 - 39% = 27
40 - 59% = 420
60 - 79% = 100
80 - 99% = 35
Index PSTORNED_SND_ID (1)
Root page: 2643, depth: 2, leaf buckets: 460, nodes: 429949
Average node length: 5.61, total dup: 382075, max dup: 574
Average key length: 2.83, compression ratio: 3.17
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 102010, ratio: 0.24
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 188
60 - 79% = 189
80 - 99% = 80
RULES_FOR_PDISTR (152)
Primary pointer page: 305, Index root page: 306
Total formats: 1, used formats: 1
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 336.00, compression ratio: 18.67
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 2%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_PDISTR_UNQ (0)
Root page: 310, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 11.50, total dup: 0, max dup: 0
Average key length: 10.25, compression ratio: 0.88
Average prefix length: 1.50, average data length: 7.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RULES_FOR_QDISTR (139)
Primary pointer page: 245, Index root page: 246
Total formats: 1, used formats: 1
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 332.00, compression ratio: 10.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_RCVOP (1)
Root page: 248, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 5.29, total dup: 2, max dup: 2
Average key length: 4.14, compression ratio: 0.72
Average prefix length: 1.43, average data length: 1.57
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_UNQ (0)
Root page: 247, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 10.14, total dup: 0, max dup: 0
Average key length: 8.86, compression ratio: 0.94
Average prefix length: 2.14, average data length: 6.14
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SEMAPHORES (156)
Primary pointer page: 318, Index root page: 319
Total formats: 1, used formats: 1
Average record length: 34.25, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 338.00, compression ratio: 9.87
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 3%
Primary pages: 1, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_SEMAPHORES (0)
Root page: 330, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 12.50, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.50, average data length: 8.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SEMAPHORES_TASK_UNQ (1)
Root page: 331, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 22.50, total dup: 0, max dup: 0
Average key length: 21.00, compression ratio: 1.07
Average prefix length: 4.00, average data length: 18.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SETTINGS (137)
Primary pointer page: 238, Index root page: 239
Total formats: 1, used formats: 1
Average record length: 98.31, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1347.00, compression ratio: 13.70
Pointer pages: 1, data page slots: 2
Data pages: 2, average fill: 80%
Primary pages: 2, secondary pages: 0, swept pages: 2
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1
Index SETTINGS_MODE_CODE (0)
Root page: 240, depth: 1, leaf buckets: 1, nodes: 114
Average node length: 27.11, total dup: 0, max dup: 0
Average key length: 26.10, compression ratio: 1.70
Average prefix length: 21.18, average data length: 23.11
Clustering factor: 6, ratio: 0.05
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: 236, Index root page: 237
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 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: 234, Index root page: 235
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 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: 216, Index root page: 217
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_DEP_DOCS_UNQ (0)
Root page: 218, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$IDX_RECALC (132)
Primary pointer page: 226, Index root page: 227
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 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)
Root page: 229, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG (133)
Primary pointer page: 230, Index root page: 231
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 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: 232, Index root page: 233
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_LOG (164)
Primary pointer page: 354, Index root page: 355
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 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)
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_MON (131)
Primary pointer page: 224, Index root page: 225
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 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: 219, Index root page: 220
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_DOC (1)
Root page: 222, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_WARE_DOC (0)
Root page: 221, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$SHOPPING_CART (128)
Primary pointer page: 211, Index root page: 212
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_SHOPCART_UNQ (0)
Root page: 215, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRACE_STAT (162)
Primary pointer page: 350, Index root page: 351
Total formats: 1, used formats: 1
Average record length: 57.90, total records: 2378
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 6.49
Pointer pages: 1, data page slots: 32
Data pages: 32, average fill: 68%
Primary pages: 32, secondary pages: 0, swept pages: 0
Empty pages: 3, full pages: 28
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 1
60 - 79% = 28
80 - 99% = 0
WARES (144)
Primary pointer page: 267, Index root page: 268
Total formats: 1, used formats: 1
Average record length: 77.71, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 448.00, compression ratio: 5.77
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 77%
Primary pages: 6, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2
Index FK_WARES_WARE_GROUPS (3)
Root page: 380, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 65
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 47, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARES (0)
Root page: 277, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 333, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_ID_DESC (2)
Root page: 279, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 333, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_NUMB_UNQ (1)
Root page: 585, depth: 2, leaf buckets: 4, nodes: 400
Average node length: 52.81, total dup: 0, max dup: 0
Average key length: 51.79, compression ratio: 1.00
Average prefix length: 2.72, average data length: 48.81
Clustering factor: 342, ratio: 0.85
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3
80 - 99% = 0
WARE_GROUPS (155)
Primary pointer page: 316, Index root page: 317
Total formats: 1, used formats: 1
Average record length: 32.13, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 352.00, compression ratio: 10.96
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 5%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARE_GROUPS (0)
Root page: 328, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 11.25, total dup: 0, max dup: 0
Average key length: 10.13, compression ratio: 0.89
Average prefix length: 1.75, average data length: 7.25
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index WARE_GROUPS_NAME_UNQ (1)
Root page: 329, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 19.88, total dup: 0, max dup: 0
Average key length: 18.13, compression ratio: 0.89
Average prefix length: 0.25, average data length: 15.88
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQD_1000_1200 (260)
Primary pointer page: 298, Index root page: 307
Total formats: 1, used formats: 1
Average record length: 56.84, total records: 6579
Average version length: 72.23, total versions: 1398, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.39
Pointer pages: 2, data page slots: 2392
Data pages: 464, average fill: 18%
Primary pages: 463, secondary pages: 1, swept pages: 365
Empty pages: 210, full pages: 47
Fill distribution:
0 - 19% = 329
20 - 39% = 59
40 - 59% = 22
60 - 79% = 49
80 - 99% = 5
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1583, depth: 2, leaf buckets: 18, nodes: 6579
Average node length: 7.70, total dup: 5658, max dup: 14
Average key length: 4.71, compression ratio: 7.85
Average prefix length: 34.43, average data length: 2.57
Clustering factor: 1103, ratio: 0.17
Fill distribution:
0 - 19% = 2
20 - 39% = 9
40 - 59% = 5
60 - 79% = 2
80 - 99% = 0
XQD_1000_3300 (262)
Primary pointer page: 782, Index root page: 783
Total formats: 1, used formats: 1
Average record length: 71.84, total records: 1168652
Average version length: 71.84, total versions: 5506, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.89
Pointer pages: 12, data page slots: 18192
Data pages: 18184, average fill: 71%
Primary pages: 18184, secondary pages: 0, swept pages: 13755
Empty pages: 60, full pages: 11401
Fill distribution:
0 - 19% = 178
20 - 39% = 312
40 - 59% = 1667
60 - 79% = 15916
80 - 99% = 111
Index XQD_1000_3300_DOC (1)
Root page: 311766, depth: 3, leaf buckets: 1349, nodes: 1168652
Average node length: 5.13, total dup: 1138541, max dup: 122
Average key length: 2.19, compression ratio: 4.11
Average prefix length: 8.84, average data length: 0.16
Clustering factor: 133925, ratio: 0.11
Fill distribution:
0 - 19% = 17
20 - 39% = 85
40 - 59% = 1002
60 - 79% = 63
80 - 99% = 182
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 226729, depth: 3, leaf buckets: 1729, nodes: 1168652
Average node length: 6.25, total dup: 1021035, max dup: 25
Average key length: 3.31, compression ratio: 11.16
Average prefix length: 35.81, average data length: 1.19
Clustering factor: 225436, ratio: 0.19
Fill distribution:
0 - 19% = 18
20 - 39% = 196
40 - 59% = 1281
60 - 79% = 161
80 - 99% = 73
XQD_1200_2000 (261)
Primary pointer page: 777, Index root page: 778
Total formats: 1, used formats: 1
Average record length: 30.96, total records: 111902
Average version length: 72.10, total versions: 4084, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 4.39
Pointer pages: 3, data page slots: 4632
Data pages: 4352, average fill: 18%
Primary pages: 4350, secondary pages: 2, swept pages: 4069
Empty pages: 657, full pages: 329
Fill distribution:
0 - 19% = 3229
20 - 39% = 529
40 - 59% = 162
60 - 79% = 348
80 - 99% = 84
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1052, depth: 2, leaf buckets: 94, nodes: 43630
Average node length: 6.63, total dup: 37915, max dup: 48
Average key length: 3.63, compression ratio: 10.19
Average prefix length: 35.50, average data length: 1.50
Clustering factor: 5072, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 56
40 - 59% = 26
60 - 79% = 9
80 - 99% = 2
XQD_2000_3300 (263)
Primary pointer page: 786, Index root page: 787
Total formats: 1, used formats: 1
Average record length: 52.04, total records: 2161523
Average version length: 71.75, total versions: 38495, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.61
Pointer pages: 18, data page slots: 28792
Data pages: 28792, average fill: 65%
Primary pages: 28792, secondary pages: 0, swept pages: 17078
Empty pages: 186, full pages: 18883
Fill distribution:
0 - 19% = 586
20 - 39% = 3152
40 - 59% = 4123
60 - 79% = 18196
80 - 99% = 2735
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 197044, depth: 3, leaf buckets: 2454, nodes: 1515970
Average node length: 5.65, total dup: 1421689, max dup: 49
Average key length: 2.68, compression ratio: 13.80
Average prefix length: 36.38, average data length: 0.62
Clustering factor: 207270, ratio: 0.14
Fill distribution:
0 - 19% = 18
20 - 39% = 1116
40 - 59% = 984
60 - 79% = 224
80 - 99% = 112
XQD_2100_3300 (264)
Primary pointer page: 789, Index root page: 790
Total formats: 1, used formats: 1
Average record length: 9.01, total records: 3919423
Average version length: 70.54, total versions: 699, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 15.09
Pointer pages: 16, data page slots: 25264
Data pages: 25264, average fill: 50%
Primary pages: 25264, secondary pages: 0, swept pages: 8928
Empty pages: 20, full pages: 23518
Fill distribution:
0 - 19% = 407
20 - 39% = 8286
40 - 59% = 6464
60 - 79% = 10092
80 - 99% = 15
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1684, depth: 2, leaf buckets: 9, nodes: 1723
Average node length: 11.66, total dup: 1189, max dup: 18
Average key length: 8.66, compression ratio: 4.27
Average prefix length: 30.65, average data length: 6.35
Clustering factor: 445, ratio: 0.26
Fill distribution:
0 - 19% = 1
20 - 39% = 7
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
XQD_3300_3400 (265)
Primary pointer page: 801, Index root page: 802
Total formats: 1, used formats: 1
Average record length: 63.65, total records: 3153477
Average version length: 71.07, total versions: 14875, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.14
Pointer pages: 26, data page slots: 41808
Data pages: 41808, average fill: 75%
Primary pages: 41808, secondary pages: 0, swept pages: 32085
Empty pages: 23, full pages: 35742
Fill distribution:
0 - 19% = 62
20 - 39% = 224
40 - 59% = 1106
60 - 79% = 38422
80 - 99% = 1994
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 37222, depth: 3, leaf buckets: 5751, nodes: 2769680
Average node length: 6.89, total dup: 2241738, max dup: 15
Average key length: 3.91, compression ratio: 9.46
Average prefix length: 35.28, average data length: 1.72
Clustering factor: 553064, ratio: 0.20
Fill distribution:
0 - 19% = 9
20 - 39% = 3074
40 - 59% = 2308
60 - 79% = 213
80 - 99% = 147
XQS_1000_1200 (266)
Primary pointer page: 805, Index root page: 806
Total formats: 1, used formats: 1
Average record length: 83.67, total records: 4676067
Average version length: 84.14, total versions: 2586, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 45, data page slots: 71960
Data pages: 71960, average fill: 80%
Primary pages: 71960, secondary pages: 0, swept pages: 28981
Empty pages: 11, full pages: 70891
Fill distribution:
0 - 19% = 16
20 - 39% = 11
40 - 59% = 58
60 - 79% = 21933
80 - 99% = 49942
Index XQS_1000_1200_DOC_ID (0)
Root page: 55157, depth: 3, leaf buckets: 4772, nodes: 4676067
Average node length: 5.15, total dup: 4569685, max dup: 126
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 758405, ratio: 0.16
Fill distribution:
0 - 19% = 18
20 - 39% = 62
40 - 59% = 2130
60 - 79% = 2028
80 - 99% = 534
Index XQS_1000_1200_RCV_ID (2)
Root page: 83992, depth: 3, leaf buckets: 5553, nodes: 4676067
Average node length: 5.70, total dup: 4184186, max dup: 49
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 277675, ratio: 0.06
Fill distribution:
0 - 19% = 74
20 - 39% = 254
40 - 59% = 3642
60 - 79% = 224
80 - 99% = 1359
Index XQS_1000_1200_SND_ID (1)
Root page: 48960, depth: 3, leaf buckets: 5315, nodes: 4676067
Average node length: 5.81, total dup: 4091466, max dup: 27
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 814489, ratio: 0.17
Fill distribution:
0 - 19% = 33
20 - 39% = 81
40 - 59% = 2325
60 - 79% = 2097
80 - 99% = 779
XQS_1000_3300 (268)
Primary pointer page: 815, Index root page: 816
Total formats: 1, used formats: 1
Average record length: 82.77, total records: 2364256
Average version length: 83.07, total versions: 14791, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.64
Pointer pages: 23, data page slots: 37256
Data pages: 37256, average fill: 78%
Primary pages: 37256, secondary pages: 0, swept pages: 27544
Empty pages: 25, full pages: 34296
Fill distribution:
0 - 19% = 52
20 - 39% = 109
40 - 59% = 503
60 - 79% = 17605
80 - 99% = 18987
Index XQS_1000_3300_DOC_ID (0)
Root page: 76716, depth: 3, leaf buckets: 2546, nodes: 2364256
Average node length: 5.15, total dup: 2309019, max dup: 227
Average key length: 2.18, compression ratio: 4.13
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 378555, ratio: 0.16
Fill distribution:
0 - 19% = 2
20 - 39% = 45
40 - 59% = 1519
60 - 79% = 734
80 - 99% = 246
Index XQS_1000_3300_RCV_ID (2)
Root page: 110552, depth: 3, leaf buckets: 4198, nodes: 2364256
Average node length: 6.23, total dup: 1940463, max dup: 14
Average key length: 3.25, compression ratio: 2.77
Average prefix length: 7.92, average data length: 1.08
Clustering factor: 258708, ratio: 0.11
Fill distribution:
0 - 19% = 118
20 - 39% = 1887
40 - 59% = 1572
60 - 79% = 439
80 - 99% = 182
Index XQS_1000_3300_SND_ID (1)
Root page: 66178, depth: 3, leaf buckets: 2896, nodes: 2364256
Average node length: 5.81, total dup: 2068806, max dup: 37
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 445990, ratio: 0.19
Fill distribution:
0 - 19% = 21
20 - 39% = 32
40 - 59% = 1791
60 - 79% = 797
80 - 99% = 255
XQS_1200_2000 (267)
Primary pointer page: 810, Index root page: 811
Total formats: 1, used formats: 1
Average record length: 83.56, total records: 4937317
Average version length: 85.57, total versions: 16777, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 48, data page slots: 77424
Data pages: 77408, average fill: 79%
Primary pages: 77408, secondary pages: 0, swept pages: 24293
Empty pages: 91, full pages: 71961
Fill distribution:
0 - 19% = 225
20 - 39% = 479
40 - 59% = 1617
60 - 79% = 19907
80 - 99% = 55180
Index XQS_1200_2000_DOC_ID (0)
Root page: 58219, depth: 3, leaf buckets: 5303, nodes: 4937317
Average node length: 5.04, total dup: 4908038, max dup: 708
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 754651, ratio: 0.15
Fill distribution:
0 - 19% = 6
20 - 39% = 317
40 - 59% = 3027
60 - 79% = 1460
80 - 99% = 493
Index XQS_1200_2000_RCV_ID (2)
Root page: 84200, depth: 3, leaf buckets: 6232, nodes: 4937317
Average node length: 5.54, total dup: 4540123, max dup: 49
Average key length: 2.55, compression ratio: 3.53
Average prefix length: 8.53, average data length: 0.47
Clustering factor: 314280, ratio: 0.06
Fill distribution:
0 - 19% = 69
20 - 39% = 1780
40 - 59% = 2652
60 - 79% = 550
80 - 99% = 1181
Index XQS_1200_2000_SND_ID (1)
Root page: 50796, depth: 3, leaf buckets: 5959, nodes: 4937317
Average node length: 5.69, total dup: 4426842, max dup: 74
Average key length: 2.70, compression ratio: 3.33
Average prefix length: 8.40, average data length: 0.60
Clustering factor: 836156, ratio: 0.17
Fill distribution:
0 - 19% = 6
20 - 39% = 286
40 - 59% = 3451
60 - 79% = 1649
80 - 99% = 567
XQS_2000_3300 (269)
Primary pointer page: 821, Index root page: 822
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 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)
Root page: 823, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_RCV_ID (2)
Root page: 825, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_SND_ID (1)
Root page: 824, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQS_2100_3300 (270)
Primary pointer page: 826, Index root page: 827
Total formats: 1, used formats: 1
Average record length: 83.34, total records: 3455885
Average version length: 83.39, total versions: 13844, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 34, data page slots: 54552
Data pages: 54552, average fill: 78%
Primary pages: 54552, secondary pages: 0, swept pages: 40340
Empty pages: 17, full pages: 50091
Fill distribution:
0 - 19% = 47
20 - 39% = 113
40 - 59% = 621
60 - 79% = 25458
80 - 99% = 28313
Index XQS_2100_3300_DOC_ID (0)
Root page: 92352, depth: 3, leaf buckets: 3734, nodes: 3455885
Average node length: 5.03, total dup: 3438560, max dup: 1188
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 754345, ratio: 0.22
Fill distribution:
0 - 19% = 13
20 - 39% = 345
40 - 59% = 2030
60 - 79% = 912
80 - 99% = 434
Index XQS_2100_3300_RCV_ID (2)
Root page: 110525, depth: 3, leaf buckets: 6336, nodes: 3455885
Average node length: 6.25, total dup: 2829103, max dup: 14
Average key length: 3.27, compression ratio: 2.75
Average prefix length: 7.91, average data length: 1.09
Clustering factor: 440171, ratio: 0.13
Fill distribution:
0 - 19% = 228
20 - 39% = 3025
40 - 59% = 2221
60 - 79% = 579
80 - 99% = 283
Index XQS_2100_3300_SND_ID (1)
Root page: 77842, depth: 3, leaf buckets: 4113, nodes: 3455885
Average node length: 5.59, total dup: 3150092, max dup: 83
Average key length: 2.61, compression ratio: 3.44
Average prefix length: 8.47, average data length: 0.53
Clustering factor: 793115, ratio: 0.23
Fill distribution:
0 - 19% = 17
20 - 39% = 377
40 - 59% = 2077
60 - 79% = 1150
80 - 99% = 492
XQS_3300_3400 (271)
Primary pointer page: 831, Index root page: 832
Total formats: 1, used formats: 1
Average record length: 69.12, total records: 690301
Average version length: 69.39, total versions: 3065, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.97
Pointer pages: 6, data page slots: 9512
Data pages: 9512, average fill: 77%
Primary pages: 9512, secondary pages: 0, swept pages: 6981
Empty pages: 1, full pages: 9134
Fill distribution:
0 - 19% = 10
20 - 39% = 24
40 - 59% = 65
60 - 79% = 9336
80 - 99% = 77
Index XQS_3300_3400_DOC_ID (0)
Root page: 208484, depth: 3, leaf buckets: 812, nodes: 690301
Average node length: 5.31, total dup: 651678, max dup: 119
Average key length: 2.43, compression ratio: 3.71
Average prefix length: 8.63, average data length: 0.37
Clustering factor: 57242, ratio: 0.08
Fill distribution:
0 - 19% = 2
20 - 39% = 158
40 - 59% = 340
60 - 79% = 235
80 - 99% = 77
Index XQS_3300_3400_SND_ID (1)
Root page: 163039, depth: 3, leaf buckets: 922, nodes: 690301
Average node length: 5.93, total dup: 590666, max dup: 14
Average key length: 3.04, compression ratio: 2.96
Average prefix length: 8.10, average data length: 0.90
Clustering factor: 62873, ratio: 0.09
Fill distribution:
0 - 19% = 4
20 - 39% = 187
40 - 59% = 390
60 - 79% = 247
80 - 99% = 94
ZDOC_DATA (230)
Primary pointer page: 674, Index root page: 675
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZDOC_LIST (229)
Primary pointer page: 672, Index root page: 673
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZINVNT_TURNOVER_LOG (231)
Primary pointer page: 676, Index root page: 677
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPDISTR (234)
Primary pointer page: 682, Index root page: 683
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPDISTR_ID (0)
Root page: 692, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPSTORNED (235)
Primary pointer page: 684, Index root page: 685
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPSTORNED_ID (0)
Root page: 693, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQDISTR (232)
Primary pointer page: 678, Index root page: 679
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_ID (0)
Root page: 686, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Root page: 687, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQSTORNED (233)
Primary pointer page: 680, Index root page: 681
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_DOC_ID (1)
Root page: 689, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_ID (0)
Root page: 688, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_RCV_ID (3)
Root page: 691, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_SND_ID (2)
Root page: 690, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_DEP_DOCS (228)
Primary pointer page: 622, Index root page: 623
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_SHOPPING_CART (227)
Primary pointer page: 620, Index root page: 621
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 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: 271, Index root page: 272
Total formats: 1, used formats: 1
Average record length: 29.38, total records: 29
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 99.00, compression ratio: 3.37
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 16%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index Z_USED_VIEWS_UNQ (0)
Root page: 284, depth: 1, leaf buckets: 1, nodes: 29
Average node length: 15.17, total dup: 0, max dup: 0
Average key length: 14.14, compression ratio: 1.44
Average prefix length: 9.17, average data length: 11.17
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Done for 83650 ms, from 11:55:50.42 to 11:57:14.07.
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
VERS_PERCENT |
AGENTS |
50 |
0 |
0.0000 |
BUSINESS_OPS |
19 |
0 |
0.0000 |
DOC_DATA |
2156606 |
2615 |
0.1212 |
DOC_LIST |
671418 |
241 |
0.0358 |
DOC_STATES |
4 |
0 |
0.0000 |
FB_ERRORS |
758 |
0 |
0.0000 |
INVNT_SALDO |
400 |
0 |
0.0000 |
INVNT_TURNOVER_LOG |
6514 |
2742 |
42.0939 |
MONEY_SALDO |
49 |
0 |
0.0000 |
MONEY_TURNOVER_LOG |
38 |
0 |
0.0000 |
OPTYPES |
9 |
0 |
0.0000 |
PDISTR |
812568 |
1083 |
0.1332 |
PERF_ESTIMATED |
271624 |
0 |
0.0000 |
PERF_LOG |
11443787 |
0 |
0.0000 |
PSTORNED |
429949 |
999 |
0.2323 |
RULES_FOR_PDISTR |
4 |
0 |
0.0000 |
RULES_FOR_QDISTR |
7 |
0 |
0.0000 |
SEMAPHORES |
4 |
0 |
0.0000 |
SETTINGS |
114 |
0 |
0.0000 |
TRACE_STAT |
2378 |
0 |
0.0000 |
WARES |
400 |
0 |
0.0000 |
WARE_GROUPS |
8 |
0 |
0.0000 |
XQD_1000_1200 |
6579 |
1398 |
21.2494 |
XQD_1000_3300 |
1168652 |
5506 |
0.4711 |
XQD_1200_2000 |
111902 |
4084 |
3.6496 |
XQD_2000_3300 |
2161523 |
38495 |
1.7809 |
XQD_2100_3300 |
3919423 |
699 |
0.0178 |
XQD_3300_3400 |
3153477 |
14875 |
0.4717 |
XQS_1000_1200 |
4676067 |
2586 |
0.0553 |
XQS_1000_3300 |
2364256 |
14791 |
0.6256 |
XQS_1200_2000 |
4937317 |
16777 |
0.3397 |
XQS_2100_3300 |
3455885 |
13844 |
0.4005 |
XQS_3300_3400 |
690301 |
3065 |
0.4440 |
Z_USED_VIEWS |
29 |
0 |
0.0000 |
Done for 2640 ms, from 11:57:28.53 to 11:57:31.17.
11:57:31.34 Validation started
11:57:31.36 Relation 140 (DOC_LIST)
11:57:31.36 process pointer page 0 of 6
11:57:31.46 process pointer page 1 of 6
11:57:31.57 process pointer page 2 of 6
11:57:31.70 process pointer page 3 of 6
11:57:31.81 process pointer page 4 of 6
11:57:31.92 process pointer page 5 of 6
11:57:31.95 Index 1 (PK_DOC_LIST)
11:57:32.23 Index 2 (DOC_LIST_ID_DESC)
11:57:32.45 Index 3 (FK_DOC_LIST_AGENTS)
11:57:32.54 Relation 140 (DOC_LIST) is ok
11:57:32.54 Relation 141 (DOC_DATA)
11:57:32.56 process pointer page 0 of 15
11:57:32.59 process pointer page 1 of 15
11:57:32.70 process pointer page 2 of 15
11:57:32.82 process pointer page 3 of 15
11:57:32.93 process pointer page 4 of 15
11:57:33.04 process pointer page 5 of 15
11:57:33.15 process pointer page 6 of 15
11:57:33.27 process pointer page 7 of 15
11:57:33.38 process pointer page 8 of 15
11:57:33.49 process pointer page 9 of 15
11:57:33.60 process pointer page 10 of 15
11:57:33.71 process pointer page 11 of 15
11:57:33.84 process pointer page 12 of 15
11:57:33.95 process pointer page 13 of 15
11:57:34.05 process pointer page 14 of 15
11:57:34.10 Index 2 (DOC_DATA_DOC_WARE_UNQ)
11:57:35.21 Index 3 (DOC_DATA_ID_DESC)
11:57:35.99 Index 4 (FK_DOC_DATA_DOC_LIST)
11:57:36.68 Relation 141 (DOC_DATA) is ok
11:57:36.68 Relation 147 (INVNT_SALDO)
11:57:36.68 process pointer page 0 of 1
11:57:36.68 Index 1 (PK_INVNT_SALDO)
11:57:36.68 Relation 147 (INVNT_SALDO) is ok
11:57:36.68 Relation 150 (PDISTR)
11:57:36.68 process pointer page 0 of 4
11:57:36.77 process pointer page 1 of 4
11:57:36.86 process pointer page 2 of 4
11:57:36.97 process pointer page 3 of 4
11:57:36.97 Index 2 (PDISTR_SND_ID)
11:57:37.07 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
11:57:37.16 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
11:57:37.25 Index 5 (PDISTR_AGENT_ID)
11:57:37.33 Relation 150 (PDISTR) is ok
11:57:37.33 Relation 151 (PSTORNED)
11:57:37.33 process pointer page 0 of 4
11:57:37.44 process pointer page 1 of 4
11:57:37.55 process pointer page 2 of 4
11:57:37.66 process pointer page 3 of 4
11:57:37.67 Index 2 (PSTORNED_SND_ID)
11:57:37.81 Index 3 (PSTORNED_RCV_ID)
11:57:37.95 Relation 151 (PSTORNED) is ok
11:57:37.95 Relation 156 (SEMAPHORES)
11:57:37.95 process pointer page 0 of 1
11:57:37.95 Index 1 (PK_SEMAPHORES)
11:57:37.95 Index 2 (SEMAPHORES_TASK_UNQ)
11:57:37.95 Relation 156 (SEMAPHORES) is ok
11:57:37.95 Relation 157 (INVNT_TURNOVER_LOG)
11:57:37.95 process pointer page 0 of 2
11:57:37.97 process pointer page 1 of 2
11:57:37.97 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
11:57:37.99 Relation 157 (INVNT_TURNOVER_LOG) is ok
11:57:37.99 Relation 160 (PERF_ESTIMATED)
11:57:37.99 process pointer page 0 of 2
11:57:38.09 process pointer page 1 of 2
11:57:38.16 Index 1 (PERF_EST_MINUTE_SINCE_START)
11:57:38.24 Relation 160 (PERF_ESTIMATED) is ok
11:57:38.24 Relation 161 (PERF_ISQL_STAT)
11:57:38.24 process pointer page 0 of 1
11:57:38.24 Index 1 (PERF_ISQL_STAT_TRN)
11:57:38.24 Relation 161 (PERF_ISQL_STAT) is ok
11:57:38.24 Relation 162 (TRACE_STAT)
11:57:38.24 process pointer page 0 of 1
11:57:38.24 Relation 162 (TRACE_STAT) is ok
11:57:38.24 Relation 163 (PERF_LOG)
11:57:38.24 process pointer page 0 of 167
11:57:38.33 process pointer page 1 of 167
11:57:38.42 process pointer page 2 of 167
11:57:38.52 process pointer page 3 of 167
11:57:38.59 process pointer page 4 of 167
11:57:38.69 process pointer page 5 of 167
11:57:38.78 process pointer page 6 of 167
11:57:38.87 process pointer page 7 of 167
11:57:38.97 process pointer page 8 of 167
11:57:39.06 process pointer page 9 of 167
11:57:39.16 process pointer page 10 of 167
11:57:39.25 process pointer page 11 of 167
11:57:39.33 process pointer page 12 of 167
11:57:39.42 process pointer page 13 of 167
11:57:39.51 process pointer page 14 of 167
11:57:39.61 process pointer page 15 of 167
11:57:39.70 process pointer page 16 of 167
11:57:39.80 process pointer page 17 of 167
11:57:39.89 process pointer page 18 of 167
11:57:39.98 process pointer page 19 of 167
11:57:40.06 process pointer page 20 of 167
11:57:40.15 process pointer page 21 of 167
11:57:40.25 process pointer page 22 of 167
11:57:40.34 process pointer page 23 of 167
11:57:40.43 process pointer page 24 of 167
11:57:40.51 process pointer page 25 of 167
11:57:40.61 process pointer page 26 of 167
11:57:40.67 process pointer page 27 of 167
11:57:40.72 process pointer page 28 of 167
11:57:40.81 process pointer page 29 of 167
11:57:40.90 process pointer page 30 of 167
11:57:41.00 process pointer page 31 of 167
11:57:41.09 process pointer page 32 of 167
11:57:41.17 process pointer page 33 of 167
11:57:41.26 process pointer page 34 of 167
11:57:41.36 process pointer page 35 of 167
11:57:41.45 process pointer page 36 of 167
11:57:41.54 process pointer page 37 of 167
11:57:41.64 process pointer page 38 of 167
11:57:41.71 process pointer page 39 of 167
11:57:41.81 process pointer page 40 of 167
11:57:41.90 process pointer page 41 of 167
11:57:41.99 process pointer page 42 of 167
11:57:42.09 process pointer page 43 of 167
11:57:42.17 process pointer page 44 of 167
11:57:42.26 process pointer page 45 of 167
11:57:42.35 process pointer page 46 of 167
11:57:42.45 process pointer page 47 of 167
11:57:42.54 process pointer page 48 of 167
11:57:42.63 process pointer page 49 of 167
11:57:42.71 process pointer page 50 of 167
11:57:42.81 process pointer page 51 of 167
11:57:42.90 process pointer page 52 of 167
11:57:42.99 process pointer page 53 of 167
11:57:43.07 process pointer page 54 of 167
11:57:43.16 process pointer page 55 of 167
11:57:43.26 process pointer page 56 of 167
11:57:43.35 process pointer page 57 of 167
11:57:43.45 process pointer page 58 of 167
11:57:43.52 process pointer page 59 of 167
11:57:43.62 process pointer page 60 of 167
11:57:43.71 process pointer page 61 of 167
11:57:43.80 process pointer page 62 of 167
11:57:43.88 process pointer page 63 of 167
11:57:43.98 process pointer page 64 of 167
11:57:44.07 process pointer page 65 of 167
11:57:44.16 process pointer page 66 of 167
11:57:44.24 process pointer page 67 of 167
11:57:44.33 process pointer page 68 of 167
11:57:44.43 process pointer page 69 of 167
11:57:44.52 process pointer page 70 of 167
11:57:44.60 process pointer page 71 of 167
11:57:44.69 process pointer page 72 of 167
11:57:44.79 process pointer page 73 of 167
11:57:44.87 process pointer page 74 of 167
11:57:44.96 process pointer page 75 of 167
11:57:45.05 process pointer page 76 of 167
11:57:45.15 process pointer page 77 of 167
11:57:45.24 process pointer page 78 of 167
11:57:45.32 process pointer page 79 of 167
11:57:45.41 process pointer page 80 of 167
11:57:45.50 process pointer page 81 of 167
11:57:45.60 process pointer page 82 of 167
11:57:45.68 process pointer page 83 of 167
11:57:45.77 process pointer page 84 of 167
11:57:45.86 process pointer page 85 of 167
11:57:45.96 process pointer page 86 of 167
11:57:46.05 process pointer page 87 of 167
11:57:46.13 process pointer page 88 of 167
11:57:46.22 process pointer page 89 of 167
11:57:46.32 process pointer page 90 of 167
11:57:46.41 process pointer page 91 of 167
11:57:46.49 process pointer page 92 of 167
11:57:46.58 process pointer page 93 of 167
11:57:46.67 process pointer page 94 of 167
11:57:46.75 process pointer page 95 of 167
11:57:46.85 process pointer page 96 of 167
11:57:46.94 process pointer page 97 of 167
11:57:47.03 process pointer page 98 of 167
11:57:47.11 process pointer page 99 of 167
11:57:47.21 process pointer page 100 of 167
11:57:47.30 process pointer page 101 of 167
11:57:47.39 process pointer page 102 of 167
11:57:47.47 process pointer page 103 of 167
11:57:47.56 process pointer page 104 of 167
11:57:47.66 process pointer page 105 of 167
11:57:47.75 process pointer page 106 of 167
11:57:47.83 process pointer page 107 of 167
11:57:47.92 process pointer page 108 of 167
11:57:48.02 process pointer page 109 of 167
11:57:48.11 process pointer page 110 of 167
11:57:48.19 process pointer page 111 of 167
11:57:48.28 process pointer page 112 of 167
11:57:48.38 process pointer page 113 of 167
11:57:48.47 process pointer page 114 of 167
11:57:48.56 process pointer page 115 of 167
11:57:48.64 process pointer page 116 of 167
11:57:48.73 process pointer page 117 of 167
11:57:48.83 process pointer page 118 of 167
11:57:48.92 process pointer page 119 of 167
11:57:49.00 process pointer page 120 of 167
11:57:49.09 process pointer page 121 of 167
11:57:49.19 process pointer page 122 of 167
11:57:49.28 process pointer page 123 of 167
11:57:49.37 process pointer page 124 of 167
11:57:49.42 process pointer page 125 of 167
11:57:49.48 process pointer page 126 of 167
11:57:49.56 process pointer page 127 of 167
11:57:49.65 process pointer page 128 of 167
11:57:49.75 process pointer page 129 of 167
11:57:49.84 process pointer page 130 of 167
11:57:49.92 process pointer page 131 of 167
11:57:50.01 process pointer page 132 of 167
11:57:50.11 process pointer page 133 of 167
11:57:50.20 process pointer page 134 of 167
11:57:50.29 process pointer page 135 of 167
11:57:50.37 process pointer page 136 of 167
11:57:50.47 process pointer page 137 of 167
11:57:50.56 process pointer page 138 of 167
11:57:50.65 process pointer page 139 of 167
11:57:50.73 process pointer page 140 of 167
11:57:50.82 process pointer page 141 of 167
11:57:50.92 process pointer page 142 of 167
11:57:51.01 process pointer page 143 of 167
11:57:51.11 process pointer page 144 of 167
11:57:51.18 process pointer page 145 of 167
11:57:51.28 process pointer page 146 of 167
11:57:51.37 process pointer page 147 of 167
11:57:51.46 process pointer page 148 of 167
11:57:51.56 process pointer page 149 of 167
11:57:51.65 process pointer page 150 of 167
11:57:51.73 process pointer page 151 of 167
11:57:51.82 process pointer page 152 of 167
11:57:51.92 process pointer page 153 of 167
11:57:52.01 process pointer page 154 of 167
11:57:52.10 process pointer page 155 of 167
11:57:52.18 process pointer page 156 of 167
11:57:52.28 process pointer page 157 of 167
11:57:52.37 process pointer page 158 of 167
11:57:52.46 process pointer page 159 of 167
11:57:52.56 process pointer page 160 of 167
11:57:52.65 process pointer page 161 of 167
11:57:52.73 process pointer page 162 of 167
11:57:52.82 process pointer page 163 of 167
11:57:52.91 process pointer page 164 of 167
11:57:53.01 process pointer page 165 of 167
11:57:53.10 process pointer page 166 of 167
11:57:53.13 Index 1 (PERF_LOG_DTS_BEG_DESC)
11:57:57.80 Index 2 (PERF_LOG_UNIT)
11:58:04.38 Index 3 (PERF_LOG_TRN_DESC)
11:58:07.69 Index 4 (PERF_LOG_GDSCODE)
11:58:10.37 Relation 163 (PERF_LOG) is ok
11:58:10.37 Relation 167 (V_STOPTEST)
11:58:10.37 Relation 167 (V_STOPTEST) is ok
11:58:10.37 Relation 184 (V_QDISTR_SOURCE)
11:58:10.37 Relation 184 (V_QDISTR_SOURCE) is ok
11:58:10.37 Relation 185 (V_QSTORNED_SOURCE)
11:58:10.37 Relation 185 (V_QSTORNED_SOURCE) is ok
11:58:10.37 Relation 260 (XQD_1000_1200)
11:58:10.39 process pointer page 0 of 2
11:58:10.39 process pointer page 1 of 2
11:58:10.40 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
11:58:10.42 Relation 260 (XQD_1000_1200) is ok
11:58:10.42 Relation 261 (XQD_1200_2000)
11:58:10.42 process pointer page 0 of 3
11:58:10.46 process pointer page 1 of 3
11:58:10.53 process pointer page 2 of 3
11:58:10.57 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
11:58:10.59 Relation 261 (XQD_1200_2000) is ok
11:58:10.59 Relation 262 (XQD_1000_3300)
11:58:10.59 process pointer page 0 of 12
11:58:10.70 process pointer page 1 of 12
11:58:10.79 process pointer page 2 of 12
11:58:10.90 process pointer page 3 of 12
11:58:11.00 process pointer page 4 of 12
11:58:11.10 process pointer page 5 of 12
11:58:11.20 process pointer page 6 of 12
11:58:11.31 process pointer page 7 of 12
11:58:11.40 process pointer page 8 of 12
11:58:11.51 process pointer page 9 of 12
11:58:11.62 process pointer page 10 of 12
11:58:11.71 process pointer page 11 of 12
11:58:11.73 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
11:58:12.18 Index 2 (XQD_1000_3300_DOC)
11:58:12.52 Relation 262 (XQD_1000_3300) is ok
11:58:12.52 Relation 263 (XQD_2000_3300)
11:58:12.52 process pointer page 0 of 18
11:58:12.57 process pointer page 1 of 18
11:58:12.65 process pointer page 2 of 18
11:58:12.76 process pointer page 3 of 18
11:58:12.85 process pointer page 4 of 18
11:58:12.96 process pointer page 5 of 18
11:58:13.05 process pointer page 6 of 18
11:58:13.16 process pointer page 7 of 18
11:58:13.26 process pointer page 8 of 18
11:58:13.35 process pointer page 9 of 18
11:58:13.46 process pointer page 10 of 18
11:58:13.55 process pointer page 11 of 18
11:58:13.65 process pointer page 12 of 18
11:58:13.74 process pointer page 13 of 18
11:58:13.85 process pointer page 14 of 18
11:58:13.94 process pointer page 15 of 18
11:58:14.04 process pointer page 16 of 18
11:58:14.15 process pointer page 17 of 18
11:58:14.21 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
11:58:14.77 Relation 263 (XQD_2000_3300) is ok
11:58:14.77 Relation 264 (XQD_2100_3300)
11:58:14.77 process pointer page 0 of 16
11:58:14.83 process pointer page 1 of 16
11:58:14.91 process pointer page 2 of 16
11:58:14.97 process pointer page 3 of 16
11:58:15.04 process pointer page 4 of 16
11:58:15.10 process pointer page 5 of 16
11:58:15.18 process pointer page 6 of 16
11:58:15.24 process pointer page 7 of 16
11:58:15.30 process pointer page 8 of 16
11:58:15.36 process pointer page 9 of 16
11:58:15.44 process pointer page 10 of 16
11:58:15.50 process pointer page 11 of 16
11:58:15.57 process pointer page 12 of 16
11:58:15.63 process pointer page 13 of 16
11:58:15.69 process pointer page 14 of 16
11:58:15.75 process pointer page 15 of 16
11:58:15.78 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
11:58:15.78 Relation 264 (XQD_2100_3300) is ok
11:58:15.78 Relation 265 (XQD_3300_3400)
11:58:15.78 process pointer page 0 of 26
11:58:15.89 process pointer page 1 of 26
11:58:16.00 process pointer page 2 of 26
11:58:16.10 process pointer page 3 of 26
11:58:16.21 process pointer page 4 of 26
11:58:16.31 process pointer page 5 of 26
11:58:16.42 process pointer page 6 of 26
11:58:16.52 process pointer page 7 of 26
11:58:16.63 process pointer page 8 of 26
11:58:16.74 process pointer page 9 of 26
11:58:16.83 process pointer page 10 of 26
11:58:16.94 process pointer page 11 of 26
11:58:17.05 process pointer page 12 of 26
11:58:17.17 process pointer page 13 of 26
11:58:17.28 process pointer page 14 of 26
11:58:17.41 process pointer page 15 of 26
11:58:17.52 process pointer page 16 of 26
11:58:17.64 process pointer page 17 of 26
11:58:17.77 process pointer page 18 of 26
11:58:17.87 process pointer page 19 of 26
11:58:18.00 process pointer page 20 of 26
11:58:18.12 process pointer page 21 of 26
11:58:18.25 process pointer page 22 of 26
11:58:18.36 process pointer page 23 of 26
11:58:18.48 process pointer page 24 of 26
11:58:18.59 process pointer page 25 of 26
11:58:18.67 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
11:58:19.92 Relation 265 (XQD_3300_3400) is ok
11:58:19.92 Relation 266 (XQS_1000_1200)
11:58:19.93 process pointer page 0 of 45
11:58:20.04 process pointer page 1 of 45
11:58:20.17 process pointer page 2 of 45
11:58:20.28 process pointer page 3 of 45
11:58:20.40 process pointer page 4 of 45
11:58:20.53 process pointer page 5 of 45
11:58:20.65 process pointer page 6 of 45
11:58:20.76 process pointer page 7 of 45
11:58:20.89 process pointer page 8 of 45
11:58:21.01 process pointer page 9 of 45
11:58:21.14 process pointer page 10 of 45
11:58:21.24 process pointer page 11 of 45
11:58:21.37 process pointer page 12 of 45
11:58:21.49 process pointer page 13 of 45
11:58:21.60 process pointer page 14 of 45
11:58:21.73 process pointer page 15 of 45
11:58:21.85 process pointer page 16 of 45
11:58:21.96 process pointer page 17 of 45
11:58:22.09 process pointer page 18 of 45
11:58:22.20 process pointer page 19 of 45
11:58:22.32 process pointer page 20 of 45
11:58:22.45 process pointer page 21 of 45
11:58:22.65 process pointer page 22 of 45
11:58:23.10 process pointer page 23 of 45
11:58:23.54 process pointer page 24 of 45
11:58:23.96 process pointer page 25 of 45
11:58:24.38 process pointer page 26 of 45
11:58:24.83 process pointer page 27 of 45
11:58:25.27 process pointer page 28 of 45
11:58:25.69 process pointer page 29 of 45
11:58:26.08 process pointer page 30 of 45
11:58:26.53 process pointer page 31 of 45
11:58:26.97 process pointer page 32 of 45
11:58:27.34 process pointer page 33 of 45
11:58:27.66 process pointer page 34 of 45
11:58:28.00 process pointer page 35 of 45
11:58:28.33 process pointer page 36 of 45
11:58:28.67 process pointer page 37 of 45
11:58:29.01 process pointer page 38 of 45
11:58:29.36 process pointer page 39 of 45
11:58:29.72 process pointer page 40 of 45
11:58:30.06 process pointer page 41 of 45
11:58:30.40 process pointer page 42 of 45
11:58:30.74 process pointer page 43 of 45
11:58:31.12 process pointer page 44 of 45
11:58:31.15 Index 1 (XQS_1000_1200_DOC_ID)
11:58:33.66 Index 2 (XQS_1000_1200_SND_ID)
11:58:36.31 Index 3 (XQS_1000_1200_RCV_ID)
11:58:38.79 Relation 266 (XQS_1000_1200) is ok
11:58:38.79 Relation 267 (XQS_1200_2000)
11:58:38.79 process pointer page 0 of 48
11:58:39.25 process pointer page 1 of 48
11:58:39.68 process pointer page 2 of 48
11:58:40.10 process pointer page 3 of 48
11:58:40.54 process pointer page 4 of 48
11:58:40.96 process pointer page 5 of 48
11:58:41.37 process pointer page 6 of 48
11:58:41.81 process pointer page 7 of 48
11:58:42.26 process pointer page 8 of 48
11:58:42.68 process pointer page 9 of 48
11:58:43.12 process pointer page 10 of 48
11:58:43.55 process pointer page 11 of 48
11:58:43.99 process pointer page 12 of 48
11:58:44.46 process pointer page 13 of 48
11:58:44.88 process pointer page 14 of 48
11:58:45.32 process pointer page 15 of 48
11:58:45.78 process pointer page 16 of 48
11:58:46.27 process pointer page 17 of 48
11:58:46.69 process pointer page 18 of 48
11:58:47.11 process pointer page 19 of 48
11:58:47.56 process pointer page 20 of 48
11:58:48.05 process pointer page 21 of 48
11:58:48.54 process pointer page 22 of 48
11:58:49.01 process pointer page 23 of 48
11:58:49.50 process pointer page 24 of 48
11:58:49.98 process pointer page 25 of 48
11:58:50.46 process pointer page 26 of 48
11:58:50.95 process pointer page 27 of 48
11:58:51.43 process pointer page 28 of 48
11:58:51.90 process pointer page 29 of 48
11:58:52.38 process pointer page 30 of 48
11:58:52.85 process pointer page 31 of 48
11:58:53.32 process pointer page 32 of 48
11:58:53.80 process pointer page 33 of 48
11:58:54.27 process pointer page 34 of 48
11:58:54.72 process pointer page 35 of 48
11:58:55.17 process pointer page 36 of 48
11:58:55.63 process pointer page 37 of 48
11:58:56.05 process pointer page 38 of 48
11:58:56.49 process pointer page 39 of 48
11:58:56.91 process pointer page 40 of 48
11:58:57.36 process pointer page 41 of 48
11:58:57.81 process pointer page 42 of 48
11:58:58.25 process pointer page 43 of 48
11:58:58.68 process pointer page 44 of 48
11:58:59.11 process pointer page 45 of 48
11:58:59.56 process pointer page 46 of 48
11:59:00.00 process pointer page 47 of 48
11:59:00.15 Index 1 (XQS_1200_2000_DOC_ID)
11:59:03.02 Index 2 (XQS_1200_2000_SND_ID)
11:59:06.20 Index 3 (XQS_1200_2000_RCV_ID)
11:59:09.03 Relation 267 (XQS_1200_2000) is ok
11:59:09.03 Relation 268 (XQS_1000_3300)
11:59:09.03 process pointer page 0 of 23
11:59:09.54 process pointer page 1 of 23
11:59:10.06 process pointer page 2 of 23
11:59:10.56 process pointer page 3 of 23
11:59:11.06 process pointer page 4 of 23
11:59:11.57 process pointer page 5 of 23
11:59:12.09 process pointer page 6 of 23
11:59:12.58 process pointer page 7 of 23
11:59:13.08 process pointer page 8 of 23
11:59:13.58 process pointer page 9 of 23
11:59:14.08 process pointer page 10 of 23
11:59:14.60 process pointer page 11 of 23
11:59:15.10 process pointer page 12 of 23
11:59:15.60 process pointer page 13 of 23
11:59:16.08 process pointer page 14 of 23
11:59:16.59 process pointer page 15 of 23
11:59:17.08 process pointer page 16 of 23
11:59:17.56 process pointer page 17 of 23
11:59:18.06 process pointer page 18 of 23
11:59:18.53 process pointer page 19 of 23
11:59:18.98 process pointer page 20 of 23
11:59:19.45 process pointer page 21 of 23
11:59:19.90 process pointer page 22 of 23
11:59:20.23 Index 1 (XQS_1000_3300_DOC_ID)
11:59:21.73 Index 2 (XQS_1000_3300_SND_ID)
11:59:23.35 Index 3 (XQS_1000_3300_RCV_ID)
11:59:25.11 Relation 268 (XQS_1000_3300) is ok
11:59:25.11 Relation 269 (XQS_2000_3300)
11:59:25.13 process pointer page 0 of 1
11:59:25.13 Index 1 (XQS_2000_3300_DOC_ID)
11:59:25.13 Index 2 (XQS_2000_3300_SND_ID)
11:59:25.13 Index 3 (XQS_2000_3300_RCV_ID)
11:59:25.13 Relation 269 (XQS_2000_3300) is ok
11:59:25.13 Relation 270 (XQS_2100_3300)
11:59:25.13 process pointer page 0 of 34
11:59:25.63 process pointer page 1 of 34
11:59:26.13 process pointer page 2 of 34
11:59:26.64 process pointer page 3 of 34
11:59:27.15 process pointer page 4 of 34
11:59:27.65 process pointer page 5 of 34
11:59:28.15 process pointer page 6 of 34
11:59:28.65 process pointer page 7 of 34
11:59:29.15 process pointer page 8 of 34
11:59:29.67 process pointer page 9 of 34
11:59:30.17 process pointer page 10 of 34
11:59:30.66 process pointer page 11 of 34
11:59:31.16 process pointer page 12 of 34
11:59:31.66 process pointer page 13 of 34
11:59:32.15 process pointer page 14 of 34
11:59:32.65 process pointer page 15 of 34
11:59:33.15 process pointer page 16 of 34
11:59:33.68 process pointer page 17 of 34
11:59:34.14 process pointer page 18 of 34
11:59:34.61 process pointer page 19 of 34
11:59:35.10 process pointer page 20 of 34
11:59:35.56 process pointer page 21 of 34
11:59:36.02 process pointer page 22 of 34
11:59:36.48 process pointer page 23 of 34
11:59:36.95 process pointer page 24 of 34
11:59:37.42 process pointer page 25 of 34
11:59:37.86 process pointer page 26 of 34
11:59:38.31 process pointer page 27 of 34
11:59:38.75 process pointer page 28 of 34
11:59:39.18 process pointer page 29 of 34
11:59:39.60 process pointer page 30 of 34
11:59:40.02 process pointer page 31 of 34
11:59:40.45 process pointer page 32 of 34
11:59:40.85 process pointer page 33 of 34
11:59:40.99 Index 1 (XQS_2100_3300_DOC_ID)
11:59:43.14 Index 2 (XQS_2100_3300_SND_ID)
11:59:45.45 Index 3 (XQS_2100_3300_RCV_ID)
11:59:48.00 Relation 270 (XQS_2100_3300) is ok
11:59:48.00 Relation 271 (XQS_3300_3400)
11:59:48.00 process pointer page 0 of 6
11:59:48.50 process pointer page 1 of 6
11:59:48.98 process pointer page 2 of 6
11:59:49.46 process pointer page 3 of 6
11:59:49.96 process pointer page 4 of 6
11:59:50.45 process pointer page 5 of 6
11:59:50.82 Index 1 (XQS_3300_3400_DOC_ID)
11:59:51.21 Index 2 (XQS_3300_3400_SND_ID)
11:59:51.65 Relation 271 (XQS_3300_3400) is ok
11:59:51.66 Validation finished
Done for 140570 ms, from 11:57:31.20 to 11:59:51.77.
Differences between old and current firebird.log
11:59:53.91. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2017-03-29 11:59 478 oltp40_fb_log_when_test_finished.log
End of gathering firebird.log AFTER test finish.
+++ Start of comparison +++
Comparing files E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Wed Mar 29 11:57:31 2017
7: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Wed Mar 29 11:59:51 2017
12: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++
Remove 401 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.oltp40\oltp40_*.*:
ERRORS_CHECKING_RESULT |
NO_SEVERE_ERRORS_FOUND |
ISQL logs are removed because no severe errors occured during test.
2017-03-29 12:00:05.25 - end of report, text file: e:\temp\logs.oltp40\oltp40.report.txt, html: e:\temp\logs.oltp40\oltp40.report.html