ACTION |
AVG_TIMES_PER_MINUTE |
AVG_ELAPSED_MS |
SUCCESSFUL_TIMES_DONE |
JOB_BEG |
JOB_END |
*** OVERALL *** for 180 minutes: |
5488.02 |
4704 |
987844 |
2017-07-12 03:46 |
2017-07-12 06:46 |
customer order: creation |
435.94 |
623 |
78469 |
2017-07-12 03:46 |
2017-07-12 06:46 |
customer order: refuse |
36.18 |
324 |
6513 |
2017-07-12 03:46 |
2017-07-12 06:46 |
order to supplier: creation |
111.27 |
2798 |
20028 |
2017-07-12 03:46 |
2017-07-12 06:46 |
order to supplier: removal |
2.72 |
31648 |
490 |
2017-07-12 03:46 |
2017-07-12 06:46 |
invoice (draft): creation |
111.23 |
4135 |
20021 |
2017-07-12 03:46 |
2017-07-12 06:46 |
invoice (draft): removal |
38.55 |
689 |
6939 |
2017-07-12 03:46 |
2017-07-12 06:46 |
invoice accept: apply |
61.41 |
18270 |
11054 |
2017-07-12 03:46 |
2017-07-12 06:46 |
invoice accept: cancel |
17.72 |
3843 |
3190 |
2017-07-12 03:46 |
2017-07-12 06:46 |
customer reserve: creation |
3132.27 |
302 |
563808 |
2017-07-12 03:46 |
2017-07-12 06:46 |
customer reserve: removal |
950.22 |
103 |
171040 |
2017-07-12 03:46 |
2017-07-12 06:46 |
realization accept: apply |
195.76 |
731 |
35237 |
2017-07-12 03:46 |
2017-07-12 06:46 |
realization accept: cancel |
82.06 |
221 |
14770 |
2017-07-12 03:46 |
2017-07-12 06:46 |
payment from customer: creation |
143.63 |
1176 |
25853 |
2017-07-12 03:46 |
2017-07-12 06:46 |
payment from customer: removal |
13.33 |
172 |
2399 |
2017-07-12 03:46 |
2017-07-12 06:46 |
payment to supplier: creation |
121.32 |
1539 |
21838 |
2017-07-12 03:46 |
2017-07-12 06:46 |
payment to supplier: removal |
8.06 |
167 |
1451 |
2017-07-12 03:46 |
2017-07-12 06:46 |
service: total inventory turnovers |
7.21 |
5047 |
1298 |
2017-07-12 03:46 |
2017-07-12 06:46 |
service: total monetary turnovers |
19.08 |
71 |
3434 |
2017-07-12 03:46 |
2017-07-12 06:46 |
service: refresh index statistics |
0.07 |
17512 |
12 |
2017-07-12 03:46 |
2017-07-12 06:46 |
Done for 63700 ms, from 6:51:30.50 to 6:52:34.20.
ACTION |
ITRV_NO |
CNT_OK_PER_MINUTE |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
ITRV_BEG |
ITRV_END |
interval # 1, overall |
1 |
4369 |
91972 |
78644 |
13328 |
14.49 |
03:46:46 |
04:04:46 |
interval # 2, overall |
2 |
4898 |
101504 |
88165 |
13339 |
13.14 |
04:04:47 |
04:22:47 |
interval # 3, overall |
3 |
5681 |
110582 |
102256 |
8326 |
7.53 |
04:22:48 |
04:40:48 |
interval # 4, overall |
4 |
5603 |
110712 |
100860 |
9852 |
8.90 |
04:40:49 |
04:58:49 |
interval # 5, overall |
5 |
5368 |
105980 |
96617 |
9363 |
8.83 |
04:58:50 |
05:16:50 |
interval # 6, overall |
6 |
5452 |
106433 |
98138 |
8295 |
7.79 |
05:16:51 |
05:34:51 |
interval # 7, overall |
7 |
5745 |
110953 |
103408 |
7545 |
6.80 |
05:34:52 |
05:52:52 |
interval # 8, overall |
8 |
5995 |
117950 |
107909 |
10041 |
8.51 |
05:52:53 |
06:10:53 |
interval # 9, overall |
9 |
5801 |
115712 |
104426 |
11286 |
9.75 |
06:10:54 |
06:28:54 |
interval # 10, overall |
10 |
5968 |
121653 |
107421 |
14232 |
11.70 |
06:28:55 |
06:46:55 |
Done for 147110 ms, from 6:55:05.28 to 6:57:32.39.
TEST_PHASE |
MINUTE_SINCE_TEST_START |
AVG_ESTIMATED |
MIN_TO_AVG_RATIO |
MAX_TO_AVG_RATIO |
ROWS_AGGREGATED |
DISTINCT_ATTACHMENTS |
TEST_TIME |
1 |
2456.39 |
0.3680 |
1.7525 |
2237 |
49 |
TEST_TIME |
2 |
3081.28 |
0.6985 |
1.3036 |
2053 |
53 |
TEST_TIME |
3 |
3354.86 |
0.7984 |
1.2297 |
1501 |
55 |
TEST_TIME |
4 |
3519.87 |
0.8792 |
1.1298 |
1585 |
100 |
TEST_TIME |
5 |
3515.97 |
0.9048 |
1.0991 |
1484 |
100 |
TEST_TIME |
6 |
3549.23 |
0.9073 |
1.0770 |
1592 |
100 |
TEST_TIME |
7 |
3588.27 |
0.9132 |
1.0888 |
1663 |
100 |
TEST_TIME |
8 |
3721.72 |
0.9186 |
1.0861 |
1925 |
100 |
TEST_TIME |
9 |
3825.46 |
0.9394 |
1.0586 |
1874 |
100 |
TEST_TIME |
10 |
3945.83 |
0.9592 |
1.0398 |
1545 |
100 |
TEST_TIME |
11 |
3919.51 |
0.9516 |
1.0456 |
1643 |
95 |
TEST_TIME |
12 |
4021.82 |
0.9341 |
1.0437 |
1415 |
100 |
TEST_TIME |
13 |
4045.92 |
0.9577 |
1.0408 |
1465 |
100 |
TEST_TIME |
14 |
4093.24 |
0.9553 |
1.0341 |
1394 |
100 |
TEST_TIME |
15 |
4099.85 |
0.9636 |
1.0314 |
1350 |
100 |
TEST_TIME |
16 |
4181.63 |
0.9481 |
1.0324 |
2154 |
100 |
TEST_TIME |
17 |
4181.84 |
0.9717 |
1.0448 |
2181 |
99 |
TEST_TIME |
18 |
4275.21 |
0.9695 |
1.0301 |
1942 |
99 |
TEST_TIME |
19 |
4288.66 |
0.9728 |
1.0196 |
1690 |
96 |
TEST_TIME |
20 |
4269.38 |
0.9730 |
1.0262 |
1765 |
98 |
TEST_TIME |
21 |
4317.93 |
0.9664 |
1.0230 |
1541 |
100 |
TEST_TIME |
22 |
4334.12 |
0.9728 |
1.0127 |
1485 |
97 |
TEST_TIME |
23 |
4279.64 |
0.9810 |
1.0247 |
1295 |
97 |
TEST_TIME |
24 |
4247.04 |
0.9895 |
1.0103 |
1500 |
91 |
TEST_TIME |
25 |
4174.24 |
0.9869 |
1.0128 |
1283 |
77 |
TEST_TIME |
26 |
4141.59 |
0.9816 |
1.0206 |
1277 |
78 |
TEST_TIME |
27 |
4180.81 |
0.9736 |
1.0358 |
1244 |
100 |
TEST_TIME |
28 |
4271.28 |
0.9778 |
1.0257 |
1495 |
100 |
TEST_TIME |
29 |
4320.38 |
0.9796 |
1.0187 |
1556 |
100 |
TEST_TIME |
30 |
4328.42 |
0.9832 |
1.0172 |
1083 |
100 |
TEST_TIME |
31 |
4368.44 |
0.9753 |
1.0275 |
2111 |
100 |
TEST_TIME |
32 |
4439.08 |
0.9796 |
1.0191 |
2116 |
100 |
TEST_TIME |
33 |
4476.66 |
0.9799 |
1.0164 |
1763 |
97 |
TEST_TIME |
34 |
4518.97 |
0.9827 |
1.0117 |
1557 |
99 |
TEST_TIME |
35 |
4521.75 |
0.9822 |
1.0169 |
1618 |
100 |
TEST_TIME |
36 |
4572.93 |
0.9776 |
1.0181 |
1240 |
100 |
TEST_TIME |
37 |
4597.38 |
0.9854 |
1.0116 |
1736 |
100 |
TEST_TIME |
38 |
4617.22 |
0.9807 |
1.0167 |
1477 |
100 |
TEST_TIME |
39 |
4665.55 |
0.9817 |
1.0193 |
1353 |
100 |
TEST_TIME |
40 |
4694.47 |
0.9878 |
1.0097 |
1494 |
100 |
TEST_TIME |
41 |
4697.71 |
0.9844 |
1.0137 |
1421 |
99 |
TEST_TIME |
42 |
4715.00 |
0.9860 |
1.0129 |
1292 |
99 |
TEST_TIME |
43 |
4723.09 |
0.9877 |
1.0144 |
1220 |
100 |
TEST_TIME |
44 |
4748.43 |
0.9861 |
1.0157 |
1420 |
100 |
TEST_TIME |
45 |
4792.43 |
0.9840 |
1.0128 |
1317 |
100 |
TEST_TIME |
46 |
4813.19 |
0.9866 |
1.0110 |
2043 |
100 |
TEST_TIME |
47 |
4832.66 |
0.9856 |
1.0170 |
2089 |
96 |
TEST_TIME |
48 |
4877.52 |
0.9866 |
1.0090 |
1647 |
96 |
TEST_TIME |
49 |
4904.02 |
0.9831 |
1.0070 |
1600 |
100 |
TEST_TIME |
50 |
4877.36 |
0.9922 |
1.0100 |
1655 |
88 |
TEST_TIME |
51 |
4889.35 |
0.9878 |
1.0116 |
1678 |
96 |
TEST_TIME |
52 |
4935.36 |
0.9829 |
1.0160 |
1395 |
100 |
TEST_TIME |
53 |
4947.92 |
0.9943 |
1.0063 |
1474 |
99 |
TEST_TIME |
54 |
4917.24 |
0.9938 |
1.0067 |
1390 |
89 |
TEST_TIME |
55 |
4948.52 |
0.9821 |
1.0062 |
1109 |
100 |
TEST_TIME |
56 |
4933.12 |
0.9913 |
1.0056 |
1424 |
99 |
TEST_TIME |
57 |
4911.98 |
0.9922 |
1.0078 |
1417 |
93 |
TEST_TIME |
58 |
4929.21 |
0.9870 |
1.0062 |
1312 |
100 |
TEST_TIME |
59 |
4928.59 |
0.9893 |
1.0087 |
1218 |
100 |
TEST_TIME |
60 |
4931.64 |
0.9913 |
1.0102 |
1320 |
100 |
TEST_TIME |
61 |
4958.03 |
0.9883 |
1.0139 |
1970 |
100 |
TEST_TIME |
62 |
5001.53 |
0.9910 |
1.0086 |
2108 |
100 |
TEST_TIME |
63 |
5011.19 |
0.9906 |
1.0125 |
1935 |
99 |
TEST_TIME |
64 |
5040.60 |
0.9909 |
1.0128 |
1634 |
98 |
TEST_TIME |
65 |
5091.96 |
0.9871 |
1.0087 |
1354 |
100 |
TEST_TIME |
66 |
5090.53 |
0.9937 |
1.0048 |
1829 |
99 |
TEST_TIME |
67 |
5069.05 |
0.9940 |
1.0062 |
1559 |
93 |
TEST_TIME |
68 |
5075.39 |
0.9902 |
1.0083 |
1486 |
96 |
TEST_TIME |
69 |
5080.56 |
0.9926 |
1.0102 |
1407 |
97 |
TEST_TIME |
70 |
5098.52 |
0.9932 |
1.0041 |
1421 |
100 |
TEST_TIME |
71 |
5082.03 |
0.9932 |
1.0064 |
1374 |
96 |
TEST_TIME |
72 |
5078.10 |
0.9932 |
1.0071 |
1224 |
87 |
TEST_TIME |
73 |
5074.69 |
0.9940 |
1.0042 |
1114 |
88 |
TEST_TIME |
74 |
5048.70 |
0.9957 |
1.0041 |
959 |
76 |
TEST_TIME |
75 |
5038.12 |
0.9928 |
1.0080 |
670 |
100 |
TEST_TIME |
76 |
5036.42 |
0.9951 |
1.0065 |
1537 |
99 |
TEST_TIME |
77 |
5049.21 |
0.9912 |
1.0129 |
1745 |
99 |
TEST_TIME |
78 |
5080.77 |
0.9937 |
1.0061 |
1565 |
96 |
TEST_TIME |
79 |
5093.00 |
0.9909 |
1.0111 |
1439 |
100 |
TEST_TIME |
80 |
5116.05 |
0.9940 |
1.0048 |
1688 |
100 |
TEST_TIME |
81 |
5103.72 |
0.9948 |
1.0064 |
1510 |
93 |
TEST_TIME |
82 |
5114.23 |
0.9921 |
1.0069 |
1334 |
92 |
TEST_TIME |
83 |
5123.16 |
0.9930 |
1.0060 |
1454 |
94 |
TEST_TIME |
84 |
5131.61 |
0.9924 |
1.0026 |
1319 |
94 |
TEST_TIME |
85 |
5108.07 |
0.9953 |
1.0079 |
1177 |
97 |
TEST_TIME |
86 |
5108.94 |
0.9971 |
1.0051 |
1324 |
98 |
TEST_TIME |
87 |
5103.04 |
0.9947 |
1.0081 |
1052 |
98 |
TEST_TIME |
88 |
5130.63 |
0.9913 |
1.0093 |
995 |
100 |
TEST_TIME |
89 |
5149.54 |
0.9944 |
1.0062 |
1272 |
100 |
TEST_TIME |
90 |
5149.82 |
0.9951 |
1.0056 |
1332 |
100 |
TEST_TIME |
91 |
5164.87 |
0.9916 |
1.0048 |
1671 |
100 |
TEST_TIME |
92 |
5166.67 |
0.9936 |
1.0088 |
1575 |
99 |
TEST_TIME |
93 |
5190.82 |
0.9934 |
1.0102 |
1682 |
99 |
TEST_TIME |
94 |
5200.35 |
0.9976 |
1.0023 |
1504 |
97 |
TEST_TIME |
95 |
5184.08 |
0.9948 |
1.0057 |
1234 |
99 |
TEST_TIME |
96 |
5187.02 |
0.9947 |
1.0066 |
1194 |
98 |
TEST_TIME |
97 |
5196.97 |
0.9943 |
1.0074 |
1285 |
96 |
TEST_TIME |
98 |
5195.75 |
0.9974 |
1.0037 |
1420 |
97 |
TEST_TIME |
99 |
5184.65 |
0.9957 |
1.0046 |
1349 |
94 |
TEST_TIME |
100 |
5184.70 |
0.9945 |
1.0052 |
968 |
100 |
TEST_TIME |
101 |
5195.84 |
0.9945 |
1.0027 |
1021 |
100 |
TEST_TIME |
102 |
5173.28 |
0.9973 |
1.0031 |
1355 |
96 |
TEST_TIME |
103 |
5188.50 |
0.9904 |
1.0038 |
1082 |
100 |
TEST_TIME |
104 |
5179.83 |
0.9958 |
1.0046 |
1220 |
100 |
TEST_TIME |
105 |
5170.41 |
0.9969 |
1.0068 |
1103 |
98 |
TEST_TIME |
106 |
5172.26 |
0.9969 |
1.0061 |
1292 |
100 |
TEST_TIME |
107 |
5176.57 |
0.9959 |
1.0052 |
1676 |
99 |
TEST_TIME |
108 |
5197.54 |
0.9919 |
1.0056 |
1586 |
98 |
TEST_TIME |
109 |
5196.67 |
0.9966 |
1.0033 |
1351 |
89 |
TEST_TIME |
110 |
5187.16 |
0.9961 |
1.0050 |
1298 |
87 |
TEST_TIME |
111 |
5198.31 |
0.9938 |
1.0075 |
1409 |
99 |
TEST_TIME |
112 |
5203.21 |
0.9976 |
1.0059 |
1491 |
99 |
TEST_TIME |
113 |
5209.07 |
0.9971 |
1.0030 |
1668 |
100 |
TEST_TIME |
114 |
5203.84 |
0.9952 |
1.0054 |
1604 |
98 |
TEST_TIME |
115 |
5206.12 |
0.9962 |
1.0061 |
1463 |
97 |
TEST_TIME |
116 |
5212.22 |
0.9977 |
1.0031 |
1567 |
95 |
TEST_TIME |
117 |
5213.97 |
0.9941 |
1.0083 |
1296 |
99 |
TEST_TIME |
118 |
5240.65 |
0.9947 |
1.0035 |
1100 |
97 |
TEST_TIME |
119 |
5226.59 |
0.9978 |
1.0029 |
1267 |
93 |
TEST_TIME |
120 |
5221.10 |
0.9956 |
1.0067 |
1285 |
99 |
TEST_TIME |
121 |
5226.99 |
0.9972 |
1.0044 |
1384 |
96 |
TEST_TIME |
122 |
5233.11 |
0.9950 |
1.0044 |
1671 |
97 |
TEST_TIME |
123 |
5236.81 |
0.9955 |
1.0045 |
1441 |
91 |
TEST_TIME |
124 |
5240.96 |
0.9956 |
1.0053 |
1308 |
94 |
TEST_TIME |
125 |
5257.46 |
0.9941 |
1.0037 |
1325 |
99 |
TEST_TIME |
126 |
5271.71 |
0.9930 |
1.0050 |
1332 |
100 |
TEST_TIME |
127 |
5286.78 |
0.9947 |
1.0036 |
1427 |
98 |
TEST_TIME |
128 |
5294.56 |
0.9943 |
1.0030 |
1547 |
99 |
TEST_TIME |
129 |
5288.58 |
0.9963 |
1.0049 |
1443 |
93 |
TEST_TIME |
130 |
5293.30 |
0.9963 |
1.0031 |
1320 |
94 |
TEST_TIME |
131 |
5301.45 |
0.9939 |
1.0035 |
1373 |
93 |
TEST_TIME |
132 |
5297.56 |
0.9967 |
1.0030 |
1257 |
94 |
TEST_TIME |
133 |
5315.27 |
0.9927 |
1.0063 |
1080 |
100 |
TEST_TIME |
134 |
5321.78 |
0.9976 |
1.0022 |
1331 |
99 |
TEST_TIME |
135 |
5312.70 |
0.9964 |
1.0041 |
1232 |
99 |
TEST_TIME |
136 |
5319.46 |
0.9955 |
1.0026 |
1640 |
99 |
TEST_TIME |
137 |
5322.60 |
0.9947 |
1.0059 |
1633 |
97 |
TEST_TIME |
138 |
5341.43 |
0.9951 |
1.0047 |
1688 |
99 |
TEST_TIME |
139 |
5359.17 |
0.9942 |
1.0041 |
1566 |
94 |
TEST_TIME |
140 |
5360.38 |
0.9967 |
1.0062 |
1364 |
92 |
TEST_TIME |
141 |
5369.14 |
0.9974 |
1.0024 |
1787 |
92 |
TEST_TIME |
142 |
5364.39 |
0.9963 |
1.0047 |
1332 |
96 |
TEST_TIME |
143 |
5378.04 |
0.9981 |
1.0012 |
1402 |
100 |
TEST_TIME |
144 |
5375.24 |
0.9948 |
1.0019 |
1185 |
97 |
TEST_TIME |
145 |
5365.03 |
0.9969 |
1.0030 |
1421 |
96 |
TEST_TIME |
146 |
5365.80 |
0.9960 |
1.0055 |
1276 |
96 |
TEST_TIME |
147 |
5367.15 |
0.9985 |
1.0022 |
1368 |
98 |
TEST_TIME |
148 |
5369.52 |
0.9950 |
1.0027 |
1226 |
98 |
TEST_TIME |
149 |
5366.88 |
0.9965 |
1.0029 |
1222 |
100 |
TEST_TIME |
150 |
5357.18 |
0.9980 |
1.0022 |
1359 |
90 |
TEST_TIME |
151 |
5354.37 |
0.9961 |
1.0048 |
1307 |
94 |
TEST_TIME |
152 |
5372.19 |
0.9949 |
1.0042 |
1515 |
96 |
TEST_TIME |
153 |
5380.93 |
0.9960 |
1.0033 |
1602 |
95 |
TEST_TIME |
154 |
5378.09 |
0.9973 |
1.0036 |
1546 |
94 |
TEST_TIME |
155 |
5384.16 |
0.9960 |
1.0029 |
1393 |
96 |
TEST_TIME |
156 |
5388.44 |
0.9957 |
1.0029 |
1044 |
95 |
TEST_TIME |
157 |
5388.71 |
0.9964 |
1.0053 |
1278 |
100 |
TEST_TIME |
158 |
5400.84 |
0.9967 |
1.0018 |
1540 |
100 |
TEST_TIME |
159 |
5402.04 |
0.9978 |
1.0050 |
1242 |
99 |
TEST_TIME |
160 |
5413.43 |
0.9966 |
1.0015 |
1313 |
100 |
TEST_TIME |
161 |
5401.48 |
0.9975 |
1.0036 |
1176 |
95 |
TEST_TIME |
162 |
5417.33 |
0.9951 |
1.0016 |
1198 |
100 |
TEST_TIME |
163 |
5416.04 |
0.9957 |
1.0024 |
1063 |
99 |
TEST_TIME |
164 |
5412.19 |
0.9977 |
1.0026 |
1272 |
99 |
TEST_TIME |
165 |
5406.85 |
0.9977 |
1.0014 |
1299 |
95 |
TEST_TIME |
166 |
5399.59 |
0.9967 |
1.0017 |
1289 |
96 |
TEST_TIME |
167 |
5411.36 |
0.9936 |
1.0045 |
1301 |
100 |
TEST_TIME |
168 |
5422.58 |
0.9965 |
1.0021 |
1537 |
100 |
TEST_TIME |
169 |
5418.96 |
0.9969 |
1.0035 |
1571 |
96 |
TEST_TIME |
170 |
5424.40 |
0.9966 |
1.0034 |
1472 |
93 |
TEST_TIME |
171 |
5432.49 |
0.9961 |
1.0059 |
1294 |
97 |
TEST_TIME |
172 |
5445.18 |
0.9978 |
1.0035 |
1553 |
94 |
TEST_TIME |
173 |
5445.48 |
0.9976 |
1.0049 |
1357 |
84 |
TEST_TIME |
174 |
5463.25 |
0.9959 |
1.0030 |
1009 |
97 |
TEST_TIME |
175 |
5459.57 |
0.9982 |
1.0016 |
1346 |
98 |
TEST_TIME |
176 |
5456.24 |
0.9965 |
1.0050 |
1282 |
100 |
TEST_TIME |
177 |
5466.14 |
0.9978 |
1.0045 |
1289 |
99 |
TEST_TIME |
178 |
5469.10 |
0.9983 |
1.0018 |
1256 |
95 |
TEST_TIME |
179 |
5468.88 |
0.9963 |
1.0050 |
1108 |
98 |
TEST_TIME |
180 |
5475.33 |
0.9983 |
1.0023 |
872 |
98 |
Done for 9080 ms, from 6:57:33.62 to 6:57:42.70.
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 |
40559 |
66953 |
36718 |
<null> |
29590 |
155971 |
47671 |
<null> |
46470 |
88780 |
45247 |
30171 |
48394 |
63724 |
84352 |
19426 |
85125 |
68318 |
<null> |
03:46:46 |
04:04:46 |
fetches per second |
2 |
18053 |
42054 |
11107 |
<null> |
15602 |
4415 |
21831 |
5413 |
19395 |
52437 |
27533 |
3824 |
19230 |
97308 |
23722 |
32818 |
43138 |
90670 |
<null> |
04:04:47 |
04:22:47 |
fetches per second |
3 |
13488 |
38889 |
25437 |
<null> |
17154 |
<null> |
22386 |
4516 |
4761 |
88410 |
17076 |
28050 |
20128 |
5007 |
25919 |
2984 |
175167 |
259572 |
<null> |
04:22:48 |
04:40:48 |
fetches per second |
4 |
8684 |
10105 |
9429 |
<null> |
17041 |
<null> |
17271 |
6599 |
63182 |
2519 |
7436 |
1824 |
14851 |
1317 |
33866 |
2810 |
16931 |
13806 |
<null> |
04:40:49 |
04:58:49 |
fetches per second |
5 |
18960 |
9446 |
16552 |
<null> |
9629 |
<null> |
15935 |
3093 |
3989 |
20000 |
18742 |
1246 |
54602 |
8341 |
7295 |
<null> |
9340 |
380711 |
<null> |
04:58:50 |
05:16:50 |
fetches per second |
6 |
3022 |
3823 |
11174 |
<null> |
11802 |
6707 |
16484 |
3320 |
1030 |
17439 |
7885 |
23326 |
11088 |
1915 |
9232 |
2557 |
31980 |
39956 |
<null> |
05:16:51 |
05:34:51 |
fetches per second |
7 |
3625 |
16594 |
4906 |
8567 |
17000 |
3124 |
9062 |
5855 |
21261 |
8651 |
3544 |
2583 |
15722 |
4728 |
12821 |
<null> |
31030 |
99915 |
<null> |
05:34:52 |
05:52:52 |
fetches per second |
8 |
5156 |
5474 |
8264 |
<null> |
8581 |
8269 |
19082 |
<null> |
85355 |
5805 |
11653 |
3557 |
18320 |
5675 |
48500 |
4617 |
15645 |
57429 |
<null> |
05:52:53 |
06:10:53 |
fetches per second |
9 |
5552 |
2750 |
14621 |
5983 |
7747 |
1541 |
20873 |
11736 |
<null> |
1903 |
14861 |
4928 |
12873 |
<null> |
7101 |
<null> |
21741 |
<null> |
<null> |
06:10:54 |
06:28:54 |
fetches per second |
10 |
3119 |
7136 |
5455 |
<null> |
6922 |
22894 |
9454 |
3323 |
5306 |
<null> |
11292 |
3666 |
19379 |
3257 |
13372 |
4894 |
71674 |
30323 |
<null> |
06:28:55 |
06:46:55 |
marks per second |
1 |
8624 |
8491 |
8027 |
<null> |
6505 |
35057 |
5987 |
<null> |
4458 |
16763 |
6635 |
4753 |
4525 |
10067 |
3705 |
2862 |
26887 |
1435 |
<null> |
03:46:46 |
04:04:46 |
marks per second |
2 |
3948 |
5791 |
2094 |
<null> |
3107 |
1097 |
2837 |
842 |
2372 |
9500 |
4243 |
899 |
1304 |
15108 |
857 |
6685 |
721 |
1625 |
<null> |
04:04:47 |
04:22:47 |
marks per second |
3 |
2841 |
5100 |
5173 |
<null> |
3543 |
<null> |
2712 |
662 |
613 |
16217 |
1892 |
4930 |
1180 |
907 |
760 |
501 |
8865 |
14725 |
<null> |
04:22:48 |
04:40:48 |
marks per second |
4 |
1803 |
1264 |
1772 |
<null> |
3417 |
<null> |
2048 |
1020 |
4916 |
402 |
912 |
313 |
495 |
180 |
1143 |
377 |
2413 |
596 |
<null> |
04:40:49 |
04:58:49 |
marks per second |
5 |
3817 |
1231 |
2705 |
<null> |
1818 |
<null> |
1366 |
459 |
876 |
3970 |
2433 |
182 |
2575 |
1364 |
153 |
<null> |
370 |
31904 |
<null> |
04:58:50 |
05:16:50 |
marks per second |
6 |
623 |
431 |
1767 |
<null> |
2030 |
963 |
1562 |
445 |
134 |
3055 |
756 |
3630 |
415 |
262 |
204 |
424 |
919 |
395 |
<null> |
05:16:51 |
05:34:51 |
marks per second |
7 |
749 |
2403 |
752 |
1222 |
2005 |
787 |
829 |
743 |
2161 |
1371 |
377 |
378 |
509 |
714 |
338 |
<null> |
573 |
989 |
<null> |
05:34:52 |
05:52:52 |
marks per second |
8 |
1106 |
722 |
1288 |
<null> |
1281 |
1644 |
1831 |
<null> |
7289 |
927 |
1511 |
514 |
354 |
858 |
1685 |
660 |
2943 |
1222 |
<null> |
05:52:53 |
06:10:53 |
marks per second |
9 |
1132 |
367 |
2246 |
1544 |
1142 |
338 |
2279 |
1572 |
<null> |
310 |
1414 |
754 |
510 |
<null> |
446 |
<null> |
661 |
<null> |
<null> |
06:10:54 |
06:28:54 |
marks per second |
10 |
654 |
829 |
772 |
<null> |
1098 |
5939 |
782 |
465 |
597 |
<null> |
1695 |
526 |
579 |
768 |
1658 |
682 |
4854 |
489 |
<null> |
06:28:55 |
06:46:55 |
reads/fetches*100 |
1 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
03:46:46 |
04:04:46 |
reads/fetches*100 |
2 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:04:47 |
04:22:47 |
reads/fetches*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:22:48 |
04:40:48 |
reads/fetches*100 |
4 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:40:49 |
04:58:49 |
reads/fetches*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
04:58:50 |
05:16:50 |
reads/fetches*100 |
6 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:16:51 |
05:34:51 |
reads/fetches*100 |
7 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
05:34:52 |
05:52:52 |
reads/fetches*100 |
8 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:52:53 |
06:10:53 |
reads/fetches*100 |
9 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
<null> |
06:10:54 |
06:28:54 |
reads/fetches*100 |
10 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
06:28:55 |
06:46:55 |
writes/marks*100 |
1 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
1 |
0 |
<null> |
03:46:46 |
04:04:46 |
writes/marks*100 |
2 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
4 |
0 |
<null> |
04:04:47 |
04:22:47 |
writes/marks*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0 |
<null> |
04:22:48 |
04:40:48 |
writes/marks*100 |
4 |
1 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0 |
<null> |
04:40:49 |
04:58:49 |
writes/marks*100 |
5 |
0 |
1 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
<null> |
7 |
0 |
<null> |
04:58:50 |
05:16:50 |
writes/marks*100 |
6 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:16:51 |
05:34:51 |
writes/marks*100 |
7 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
5 |
0 |
<null> |
05:34:52 |
05:52:52 |
writes/marks*100 |
8 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0 |
<null> |
05:52:53 |
06:10:53 |
writes/marks*100 |
9 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
1 |
0 |
0 |
0 |
<null> |
0 |
<null> |
4 |
<null> |
<null> |
06:10:54 |
06:28:54 |
writes/marks*100 |
10 |
0 |
0 |
1 |
<null> |
0 |
0 |
0 |
0 |
1 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
<null> |
06:28:55 |
06:46:55 |
Done for 7870 ms, from 6:57:43.62 to 6:57:51.49.
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 |
1692572 |
1598452 |
94120 |
5.56 |
0 |
9298 |
79 |
94120 |
2017-07-12 03:46 |
2017-07-12 06:46 |
doc_list_biud |
1693001 |
1598452 |
94549 |
5.58 |
0 |
7909 |
24 |
94549 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_add_invoice_to_stock |
18621 |
11054 |
7567 |
40.63 |
15 |
202021 |
18270 |
7567 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_cancel_adding_invoice |
3925 |
3190 |
735 |
18.72 |
0 |
119012 |
3843 |
735 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_cancel_client_order |
6669 |
6513 |
156 |
2.33 |
0 |
4259 |
324 |
156 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_cancel_customer_reserve |
256607 |
171040 |
85567 |
33.34 |
0 |
5101 |
103 |
85567 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_cancel_pay_from_customer |
2413 |
2399 |
14 |
0.58 |
0 |
3027 |
172 |
14 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_cancel_pay_to_supplier |
1455 |
1451 |
4 |
0.27 |
0 |
1684 |
167 |
4 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_cancel_supplier_invoice |
8686 |
6939 |
1747 |
20.11 |
0 |
9844 |
689 |
1747 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_cancel_supplier_order |
1522 |
490 |
1032 |
67.80 |
63 |
258352 |
31648 |
1032 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_cancel_write_off |
21919 |
14770 |
7149 |
32.61 |
0 |
3775 |
221 |
7149 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_client_order |
78469 |
78469 |
0 |
0.00 |
0 |
6255 |
623 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_customer_reserve |
563808 |
563808 |
0 |
0.00 |
0 |
9001 |
302 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_fill_shopping_cart |
118772 |
118518 |
254 |
0.21 |
0 |
4976 |
121 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_fill_shopping_cart_clo_res |
563808 |
563808 |
0 |
0.00 |
0 |
4882 |
21 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_get_clo_for_invoice |
11054 |
11054 |
0 |
0.00 |
0 |
8314 |
424 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_kill_cost_storno |
29345 |
21810 |
7535 |
25.67 |
0 |
2433 |
28 |
7535 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_kill_qstorno_ret_qs2qd |
543410 |
364279 |
179131 |
32.96 |
0 |
7878 |
39 |
179131 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_kill_qty_storno |
343683 |
249233 |
94450 |
27.48 |
0 |
7894 |
111 |
94450 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_lock_selected_doc |
76400 |
65308 |
11092 |
14.51 |
0 |
2169 |
9 |
11092 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_make_cost_storno |
93982 |
93982 |
0 |
0.00 |
0 |
9094 |
720 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_multiply_rows_for_pdistr |
93982 |
93982 |
0 |
0.00 |
0 |
3651 |
78 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_multiply_rows_for_qdistr |
78469 |
78469 |
0 |
0.00 |
0 |
3916 |
210 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_pay_from_customer |
25853 |
25853 |
0 |
0.00 |
0 |
7597 |
1176 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_pay_to_supplier |
21838 |
21838 |
0 |
0.00 |
0 |
9594 |
1539 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_payment_common |
47691 |
47691 |
0 |
0.00 |
0 |
3510 |
76 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_qd_handle_on_cancel_clo |
6665 |
6513 |
152 |
2.28 |
0 |
3900 |
146 |
152 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_qd_handle_on_invoice_upd_sts |
14828 |
14244 |
584 |
3.93 |
0 |
5164 |
458 |
584 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_qd_handle_on_reserve_upd_sts |
35237 |
35237 |
0 |
0.00 |
0 |
3978 |
73 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_reserve_write_off |
36619 |
35237 |
1382 |
3.77 |
0 |
7520 |
731 |
1382 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_supplier_invoice |
20130 |
20021 |
109 |
0.54 |
0 |
28017 |
4135 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
sp_supplier_order |
20173 |
20028 |
145 |
0.71 |
0 |
16302 |
2798 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
srv_find_qd_qs_mism |
992156 |
898072 |
94084 |
9.48 |
0 |
4009 |
39 |
94084 |
2017-07-12 03:46 |
2017-07-12 06:46 |
srv_make_invnt_saldo |
1298 |
1298 |
0 |
0.00 |
47 |
30155 |
5047 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
srv_make_money_saldo |
3434 |
3434 |
0 |
0.00 |
0 |
6817 |
71 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
2138 |
34320 |
17512 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-abend:sp_add_invoice_to_stock |
7567 |
7567 |
0 |
0.00 |
0 |
2230 |
127 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-abend:sp_cancel_adding_invoice |
705 |
705 |
0 |
0.00 |
0 |
2605 |
308 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-abend:sp_cancel_client_order |
156 |
156 |
0 |
0.00 |
0 |
2122 |
164 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-abend:sp_cancel_customer_reserve |
85 |
85 |
0 |
0.00 |
0 |
920 |
69 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-abend:sp_cancel_pay_from_customer |
14 |
14 |
0 |
0.00 |
0 |
1498 |
165 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-abend:sp_cancel_pay_to_supplier |
4 |
4 |
0 |
0.00 |
0 |
281 |
93 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-abend:sp_cancel_supplier_invoice |
598 |
598 |
0 |
0.00 |
0 |
2371 |
138 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-abend:sp_cancel_supplier_order |
10925 |
10925 |
0 |
0.00 |
0 |
3307 |
186 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-abend:sp_cancel_write_off |
28 |
28 |
0 |
0.00 |
0 |
827 |
113 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-abend:sp_reserve_write_off |
1382 |
1382 |
0 |
0.00 |
0 |
1498 |
96 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-abend:sp_supplier_invoice |
109 |
109 |
0 |
0.00 |
0 |
749 |
107 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-abend:sp_supplier_order |
145 |
145 |
0 |
0.00 |
0 |
1108 |
111 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-norm:sp_add_invoice_to_stock |
11054 |
11054 |
0 |
0.00 |
0 |
13510 |
945 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-norm:sp_cancel_adding_invoice |
1253 |
1253 |
0 |
0.00 |
0 |
10140 |
1100 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-norm:sp_cancel_client_order |
6513 |
6513 |
0 |
0.00 |
0 |
1872 |
94 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-norm:sp_cancel_customer_reserve |
2373 |
2373 |
0 |
0.00 |
0 |
2091 |
100 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-norm:sp_cancel_pay_from_customer |
2399 |
2399 |
0 |
0.00 |
0 |
1825 |
72 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-norm:sp_cancel_pay_to_supplier |
1451 |
1451 |
0 |
0.00 |
0 |
1419 |
70 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-norm:sp_cancel_supplier_invoice |
947 |
947 |
0 |
0.00 |
0 |
1872 |
107 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-norm:sp_cancel_supplier_order |
490 |
490 |
0 |
0.00 |
0 |
66425 |
3421 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-norm:sp_cancel_write_off |
3591 |
3591 |
0 |
0.00 |
0 |
2122 |
100 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-norm:sp_client_order |
78469 |
78469 |
0 |
0.00 |
0 |
3073 |
111 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-norm:sp_customer_reserve |
3670 |
3670 |
0 |
0.00 |
0 |
1778 |
78 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-norm:sp_pay_from_customer |
25853 |
25853 |
0 |
0.00 |
0 |
2855 |
100 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-norm:sp_pay_to_supplier |
21838 |
21838 |
0 |
0.00 |
0 |
2574 |
101 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-norm:sp_reserve_write_off |
35237 |
35237 |
0 |
0.00 |
0 |
3058 |
107 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-norm:sp_supplier_invoice |
20021 |
20021 |
0 |
0.00 |
0 |
2496 |
104 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-norm:sp_supplier_order |
20028 |
20028 |
0 |
0.00 |
0 |
2590 |
106 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-norm:srv_make_invnt_saldo |
1298 |
1298 |
0 |
0.00 |
0 |
1107 |
48 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-norm:srv_make_money_saldo |
3434 |
3434 |
0 |
0.00 |
0 |
1373 |
40 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
t$perf-norm:srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
0 |
998 |
233 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
v_add_invoice_to_stock |
37242 |
22108 |
15134 |
40.63 |
0 |
9719 |
101 |
15134 |
2017-07-12 03:46 |
2017-07-12 06:46 |
v_all_customers |
117610 |
117610 |
0 |
0.00 |
0 |
1170 |
7 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
v_all_suppliers |
80606 |
80098 |
508 |
0.63 |
0 |
1903 |
7 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
v_all_wares |
156938 |
156938 |
0 |
0.00 |
0 |
1934 |
6 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
v_cancel_adding_invoice |
2958 |
2506 |
452 |
15.28 |
0 |
2481 |
186 |
452 |
2017-07-12 03:46 |
2017-07-12 06:46 |
v_cancel_client_order |
13338 |
13026 |
312 |
2.33 |
0 |
2169 |
8 |
312 |
2017-07-12 03:46 |
2017-07-12 06:46 |
v_cancel_customer_prepayment |
4826 |
4798 |
28 |
0.58 |
0 |
1388 |
10 |
28 |
2017-07-12 03:46 |
2017-07-12 06:46 |
v_cancel_customer_reserve |
4916 |
4746 |
170 |
3.45 |
0 |
999 |
12 |
170 |
2017-07-12 03:46 |
2017-07-12 06:46 |
v_cancel_payment_to_supplier |
2910 |
2902 |
8 |
0.27 |
0 |
1170 |
9 |
8 |
2017-07-12 03:46 |
2017-07-12 06:46 |
v_cancel_supplier_invoice |
3090 |
1894 |
1196 |
38.70 |
0 |
9501 |
99 |
1196 |
2017-07-12 03:46 |
2017-07-12 06:46 |
v_cancel_supplier_order |
3044 |
980 |
2064 |
67.80 |
0 |
530 |
10 |
2064 |
2017-07-12 03:46 |
2017-07-12 06:46 |
v_cancel_write_off |
7238 |
7182 |
56 |
0.77 |
0 |
3027 |
117 |
56 |
2017-07-12 03:46 |
2017-07-12 06:46 |
v_max_id_clo_ord |
20173 |
20028 |
145 |
0.71 |
0 |
1045 |
7 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
v_max_id_clo_res |
3670 |
3670 |
0 |
0.00 |
0 |
2122 |
25 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
v_max_id_ord_sup |
20130 |
20021 |
109 |
0.54 |
0 |
1685 |
7 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
v_max_non_paid_invoice |
21838 |
21838 |
0 |
0.00 |
0 |
1716 |
7 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
v_max_non_paid_realizn |
25853 |
25853 |
0 |
0.00 |
0 |
1201 |
7 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
v_min_id_clo_ord |
20173 |
20028 |
145 |
0.71 |
0 |
1108 |
9 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
v_min_id_clo_res |
3670 |
3670 |
0 |
0.00 |
0 |
843 |
11 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
v_min_id_ord_sup |
20130 |
20021 |
109 |
0.54 |
0 |
1170 |
9 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
v_min_non_paid_invoice |
21838 |
21838 |
0 |
0.00 |
0 |
2200 |
12 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
v_min_non_paid_realizn |
25853 |
25853 |
0 |
0.00 |
0 |
3027 |
11 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
v_our_firm |
39328 |
39328 |
0 |
0.00 |
0 |
1124 |
7 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
v_reserve_write_off |
73238 |
70474 |
2764 |
3.77 |
0 |
2137 |
10 |
2764 |
2017-07-12 03:46 |
2017-07-12 06:46 |
x_lock_depdocs_on_canc_invoice |
16087 |
9182 |
6905 |
42.92 |
0 |
2216 |
45 |
6905 |
2017-07-12 03:46 |
2017-07-12 06:46 |
x_lock_depdocs_on_canc_sup_ord |
1518 |
490 |
1028 |
67.72 |
0 |
1170 |
85 |
1028 |
2017-07-12 03:46 |
2017-07-12 06:46 |
x_make_qstorno_1000_1200 |
20173 |
20028 |
145 |
0.71 |
0 |
14554 |
2526 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
x_make_qstorno_1200_2000 |
20130 |
20021 |
109 |
0.54 |
0 |
27752 |
3864 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
x_make_qstorno_2100_3300 |
563808 |
563808 |
0 |
0.00 |
0 |
8970 |
256 |
0 |
2017-07-12 03:46 |
2017-07-12 06:46 |
Done for 226500 ms, from 7:01:30.71 to 7:05:17.21.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
DTS_BEG |
DTS_END |
deadlock |
83 |
sp_kill_cost_storno |
335544336 |
2017-07-12 03:47 |
2017-07-12 06:39 |
deadlock |
84 |
sp_kill_qstorno_ret_qs2qd |
335544336 |
2017-07-12 03:47 |
2017-07-12 06:46 |
deadlock |
9680 |
sp_lock_selected_doc |
335544336 |
2017-07-12 03:46 |
2017-07-12 06:46 |
deadlock |
152 |
sp_qd_handle_on_cancel_clo |
335544336 |
2017-07-12 03:50 |
2017-07-12 06:45 |
deadlock |
170 |
sp_qd_handle_on_invoice_upd_sts |
335544336 |
2017-07-12 03:47 |
2017-07-12 06:46 |
deadlock |
626 |
x_lock_depdocs_on_canc_invoice |
335544336 |
2017-07-12 03:47 |
2017-07-12 06:46 |
deadlock |
293 |
x_lock_depdocs_on_canc_sup_ord |
335544336 |
2017-07-12 03:47 |
2017-07-12 06:46 |
user_exc |
145 |
x_make_qstorno_1000_1200 |
335544517 |
2017-07-12 03:47 |
2017-07-12 06:41 |
user_exc |
109 |
x_make_qstorno_1200_2000 |
335544517 |
2017-07-12 03:48 |
2017-07-12 06:43 |
Done for 6990 ms, from 7:05:22.01 to 7:05:29.00.
MON$DATABASE_NAME D:\OLTP-EMUL\OLTP30-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 418928
MON$OLDEST_ACTIVE 418929
MON$OLDEST_SNAPSHOT 418929
MON$NEXT_TRANSACTION 418929
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:12:20.4040
MON$PAGES 770720
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-V3.0.3.32749 Firebird 3.0
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.3.32749 Firebird 3.0"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.3.32749 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.3.32749 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
on disk structure version 12.0
Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB"
Database header page information:
Flags 0
Generation 419095
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 418930
Oldest active 418931
Oldest snapshot 418931
Next transaction 418932
Sequence number 0
Next attachment ID 9484
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:12:20
Attributes force write
Variable header data:
Sweep interval: 0
*END*
Database file sequence:
File D:\OLTP-EMUL\OLTP30-SMALL.FDB is the only file
Analyzing database pages ...
AGENTS (154)
Primary pointer page: 311, Index root page: 312
Total formats: 1, used formats: 1
Average record length: 33.58, 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.24
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: 322, 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: 324, 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: 323, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 44
Average key length: 2.04, compression ratio: 0.54
Average prefix length: 1.04, 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: 321, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.16, total dup: 0, max dup: 0
Average key length: 15.86, compression ratio: 0.92
Average prefix length: 1.44, average data length: 13.16
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: 320, 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: 332, Index root page: 333
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: 336, 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: 337, 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: 335, 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: 251, Index root page: 252
Total formats: 1, used formats: 1
Average record length: 47.04, total records: 2071064
Average version length: 47.70, total versions: 3006, 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: 14, data page slots: 22432
Data pages: 22432, average fill: 73%
Primary pages: 22432, secondary pages: 0, swept pages: 13587
Empty pages: 0, full pages: 18388
Fill distribution:
0 - 19% = 2
20 - 39% = 7
40 - 59% = 60
60 - 79% = 22361
80 - 99% = 2
Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26189, depth: 3, leaf buckets: 9812, nodes: 2071064
Average node length: 19.24, total dup: 0, max dup: 0
Average key length: 16.29, compression ratio: 1.66
Average prefix length: 13.71, average data length: 13.29
Clustering factor: 493161, ratio: 0.24
Fill distribution:
0 - 19% = 552
20 - 39% = 1876
40 - 59% = 5104
60 - 79% = 920
80 - 99% = 1360
Index DOC_DATA_ID_DESC (2)
Root page: 45719, depth: 3, leaf buckets: 7401, nodes: 2071064
Average node length: 11.66, total dup: 0, max dup: 0
Average key length: 8.70, compression ratio: 1.03
Average prefix length: 3.29, average data length: 5.71
Clustering factor: 453239, ratio: 0.22
Fill distribution:
0 - 19% = 2
20 - 39% = 3424
40 - 59% = 3930
60 - 79% = 39
80 - 99% = 6
Index FK_DOC_DATA_DOC_LIST (3)
Root page: 175185, depth: 3, leaf buckets: 3643, nodes: 2071064
Average node length: 6.78, total dup: 1520033, max dup: 49
Average key length: 3.83, compression ratio: 2.35
Average prefix length: 7.44, average data length: 1.56
Clustering factor: 454972, ratio: 0.22
Fill distribution:
0 - 19% = 112
20 - 39% = 1262
40 - 59% = 1643
60 - 79% = 115
80 - 99% = 511
DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 60.26, total records: 614782
Average version length: 35.51, total versions: 1132, max versions: 3
Average fragment length: 11.00, total fragments: 8, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 5, data page slots: 7808
Data pages: 7808, average fill: 75%
Primary pages: 7805, secondary pages: 3, swept pages: 7127
Empty pages: 5, full pages: 6837
Fill distribution:
0 - 19% = 10
20 - 39% = 4
40 - 59% = 38
60 - 79% = 7737
80 - 99% = 19
Index DOC_LIST_ID_DESC (1)
Root page: 256855, depth: 3, leaf buckets: 2289, nodes: 614782
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.83, compression ratio: 1.02
Average prefix length: 3.17, average data length: 5.83
Clustering factor: 160914, ratio: 0.26
Fill distribution:
0 - 19% = 0
20 - 39% = 1350
40 - 59% = 923
60 - 79% = 15
80 - 99% = 1
Index FK_DOC_LIST_AGENTS (2)
Root page: 2807, depth: 2, leaf buckets: 643, nodes: 614782
Average node length: 4.87, total dup: 614732, max dup: 43796
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 280989, ratio: 0.46
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 551
60 - 79% = 65
80 - 99% = 27
Index PK_DOC_LIST (0)
Root page: 31589, depth: 3, leaf buckets: 1988, nodes: 614782
Average node length: 11.68, total dup: 0, max dup: 0
Average key length: 8.82, compression ratio: 1.02
Average prefix length: 3.17, average data length: 5.83
Clustering factor: 160914, ratio: 0.26
Fill distribution:
0 - 19% = 129
20 - 39% = 834
40 - 59% = 675
60 - 79% = 139
80 - 99% = 211
DOC_STATES (153)
Primary pointer page: 309, Index root page: 310
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: 318, 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: 319, 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: 317, 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: 338, Index root page: 339
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: 340, 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: 270, Index root page: 271
Total formats: 1, used formats: 1
Average record length: 64.74, total records: 400
Average version length: 21.56, total versions: 104659, max versions: 931
Average fragment length: 17.79, total fragments: 376, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.61
Pointer pages: 2, data page slots: 1712
Data pages: 1712, average fill: 36%
Primary pages: 10, secondary pages: 1702, swept pages: 2
Empty pages: 6, full pages: 4
Fill distribution:
0 - 19% = 6
20 - 39% = 1532
40 - 59% = 169
60 - 79% = 1
80 - 99% = 4
Index PK_INVNT_SALDO (0)
Root page: 282, 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: 292, ratio: 0.73
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
INVNT_TURNOVER_LOG (157)
Primary pointer page: 330, Index root page: 331
Total formats: 1, used formats: 1
Average record length: 4.04, total records: 67203
Average version length: 71.13, total versions: 63394, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 23.77
Pointer pages: 2, data page slots: 1456
Data pages: 1008, average fill: 85%
Primary pages: 1007, secondary pages: 1, swept pages: 0
Empty pages: 11, full pages: 892
Fill distribution:
0 - 19% = 25
20 - 39% = 11
40 - 59% = 37
60 - 79% = 108
80 - 99% = 827
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1845, depth: 2, leaf buckets: 173, nodes: 67203
Average node length: 13.46, total dup: 3043, max dup: 3
Average key length: 11.45, compression ratio: 2.36
Average prefix length: 18.51, average data length: 8.49
Clustering factor: 57446, ratio: 0.85
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 70
60 - 79% = 67
80 - 99% = 35
MONEY_SALDO (143)
Primary pointer page: 262, Index root page: 263
Total formats: 1, used formats: 1
Average record length: 14.92, 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.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 19%
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_MONEY_SALDO (0)
Root page: 273, 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: 260, Index root page: 261
Total formats: 1, used formats: 1
Average record length: 45.49, total records: 118
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.41
Pointer pages: 1, data page slots: 48
Data pages: 16, average fill: 7%
Primary pages: 16, secondary pages: 0, swept pages: 12
Empty pages: 11, full pages: 0
Fill distribution:
0 - 19% = 14
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 0
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 237071, depth: 2, leaf buckets: 1, nodes: 118
Average node length: 9.16, total dup: 78, max dup: 22
Average key length: 7.17, compression ratio: 2.65
Average prefix length: 14.16, average data length: 4.84
Clustering factor: 51, ratio: 0.43
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG (165)
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 MON_LOG_DTS (4)
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_GDSCODE (2)
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
Index MON_LOG_ROWSET_DESC (1)
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
Index MON_LOG_UNIT (3)
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 PK_MON_LOG (0)
Root page: 361, 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: 366, Index root page: 367
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: 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_GDSCODE (2)
Root page: 371, 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: 370, 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: 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
Index PK_MON_LOG_TABLE_STATS (0)
Root page: 369, 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: 239, Index root page: 240
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: 242, 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: 241, 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: 293, Index root page: 294
Total formats: 1, used formats: 1
Average record length: 38.96, total records: 234313
Average version length: 31.90, total versions: 31588, max versions: 8
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.64
Pointer pages: 2, data page slots: 2464
Data pages: 2464, average fill: 73%
Primary pages: 2460, secondary pages: 4, swept pages: 236
Empty pages: 4, full pages: 2306
Fill distribution:
0 - 19% = 14
20 - 39% = 54
40 - 59% = 72
60 - 79% = 2094
80 - 99% = 230
Index PDISTR_AGENT_ID (4)
Root page: 5420, depth: 2, leaf buckets: 202, nodes: 234313
Average node length: 4.55, total dup: 234264, max dup: 9696
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 39588, ratio: 0.17
Fill distribution:
0 - 19% = 1
20 - 39% = 3
40 - 59% = 77
60 - 79% = 80
80 - 99% = 41
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4740, depth: 2, leaf buckets: 259, nodes: 234313
Average node length: 5.51, total dup: 210843, max dup: 43
Average key length: 2.97, compression ratio: 7.40
Average prefix length: 21.13, average data length: 0.87
Clustering factor: 51367, ratio: 0.22
Fill distribution:
0 - 19% = 3
20 - 39% = 20
40 - 59% = 111
60 - 79% = 81
80 - 99% = 44
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 4730, depth: 2, leaf buckets: 255, nodes: 234313
Average node length: 5.51, total dup: 210843, max dup: 43
Average key length: 2.97, compression ratio: 7.40
Average prefix length: 21.13, average data length: 0.87
Clustering factor: 51623, ratio: 0.22
Fill distribution:
0 - 19% = 1
20 - 39% = 16
40 - 59% = 101
60 - 79% = 87
80 - 99% = 50
Index PDISTR_SND_ID (1)
Root page: 4894, depth: 2, leaf buckets: 261, nodes: 234313
Average node length: 5.29, total dup: 210843, max dup: 43
Average key length: 2.75, compression ratio: 3.27
Average prefix length: 8.35, average data length: 0.65
Clustering factor: 51511, ratio: 0.22
Fill distribution:
0 - 19% = 0
20 - 39% = 27
40 - 59% = 112
60 - 79% = 92
80 - 99% = 30
PERF_ESTIMATED (160)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 27.97, total records: 259792
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.14
Pointer pages: 2, data page slots: 2224
Data pages: 2224, average fill: 64%
Primary pages: 2224, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 2219
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 1
60 - 79% = 2219
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 302353, depth: 2, leaf buckets: 207, nodes: 259792
Average node length: 4.51, total dup: 259611, max dup: 2236
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.57, average data length: 0.00
Clustering factor: 65327, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 65
60 - 79% = 89
80 - 99% = 52
PERF_ISQL_STAT (161)
Primary pointer page: 344, Index root page: 345
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: 346, 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: 350, Index root page: 351
Total formats: 1, used formats: 1
Average record length: 151.51, total records: 10542615
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.19
Pointer pages: 154, data page slots: 249744
Data pages: 249744, average fill: 87%
Primary pages: 249744, secondary pages: 0, swept pages: 3
Empty pages: 0, full pages: 249743
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 249743
Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 64458, depth: 3, leaf buckets: 11569, nodes: 10542615
Average node length: 5.63, total dup: 9683546, max dup: 145
Average key length: 2.19, compression ratio: 3.64
Average prefix length: 7.85, average data length: 0.14
Clustering factor: 4937232, ratio: 0.47
Fill distribution:
0 - 19% = 13
20 - 39% = 0
40 - 59% = 5949
60 - 79% = 3682
80 - 99% = 1925
Index PERF_LOG_GDSCODE (3)
Root page: 163628, depth: 3, leaf buckets: 10282, nodes: 10542615
Average node length: 4.50, total dup: 10542611, max dup: 9829632
Average key length: 1.07, compression ratio: 0.32
Average prefix length: 0.34, average data length: 0.00
Clustering factor: 312982, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 10279
60 - 79% = 0
80 - 99% = 2
Index PERF_LOG_TRN_DESC (2)
Root page: 43655, depth: 3, leaf buckets: 12479, nodes: 10542615
Average node length: 5.68, total dup: 10186357, max dup: 16504
Average key length: 2.25, compression ratio: 4.00
Average prefix length: 8.78, average data length: 0.22
Clustering factor: 1055621, ratio: 0.10
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 8759
60 - 79% = 1972
80 - 99% = 1746
Index PERF_LOG_UNIT (1)
Root page: 77766, depth: 3, leaf buckets: 12683, nodes: 10542615
Average node length: 5.51, total dup: 10510868, max dup: 1244378
Average key length: 2.08, compression ratio: 18.17
Average prefix length: 37.66, average data length: 0.07
Clustering factor: 6606676, ratio: 0.63
Fill distribution:
0 - 19% = 18
20 - 39% = 0
40 - 59% = 10767
60 - 79% = 711
80 - 99% = 1187
PHRASES (145)
Primary pointer page: 266, Index root page: 267
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: 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
Index PHRASES_NAME (2)
Root page: 279, 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: 278, 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: 277, 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: 301, Index root page: 302
Total formats: 1, used formats: 1
Average record length: 54.60, total records: 415916
Average version length: 56.10, total versions: 3449, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.47
Pointer pages: 4, data page slots: 4912
Data pages: 4912, average fill: 75%
Primary pages: 4912, secondary pages: 0, swept pages: 2694
Empty pages: 0, full pages: 4862
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 2
60 - 79% = 4899
80 - 99% = 10
Index PSTORNED_RCV_ID (2)
Root page: 645705, depth: 3, leaf buckets: 581, nodes: 415916
Average node length: 6.01, total dup: 344909, max dup: 316
Average key length: 3.24, compression ratio: 2.78
Average prefix length: 7.93, average data length: 1.07
Clustering factor: 56326, ratio: 0.14
Fill distribution:
0 - 19% = 17
20 - 39% = 26
40 - 59% = 405
60 - 79% = 97
80 - 99% = 36
Index PSTORNED_SND_ID (1)
Root page: 2157, depth: 2, leaf buckets: 431, nodes: 415916
Average node length: 5.57, total dup: 371658, max dup: 105
Average key length: 2.80, compression ratio: 3.21
Average prefix length: 8.31, average data length: 0.69
Clustering factor: 102629, ratio: 0.25
Fill distribution:
0 - 19% = 0
20 - 39% = 6
40 - 59% = 162
60 - 79% = 171
80 - 99% = 92
RULES_FOR_PDISTR (152)
Primary pointer page: 303, Index root page: 304
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: 308, 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: 243, Index root page: 244
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: 246, 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: 245, 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: 315, Index root page: 316
Total formats: 1, used formats: 1
Average record length: 34.25, total records: 4
Average version length: 9.00, total versions: 3255, max versions: 2270
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: 16
Data pages: 16, average fill: 65%
Primary pages: 4, secondary pages: 12, swept pages: 0
Empty pages: 4, full pages: 11
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 11
Index PK_SEMAPHORES (0)
Root page: 327, 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: 328, 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: 236, Index root page: 237
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: 238, 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: 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$AUTOGEN$SOURCE (135)
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$DEP_DOCS (129)
Primary pointer page: 198, Index root page: 199
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: 200, 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: 207, Index root page: 224
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: 226, 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: 227, Index root page: 228
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: 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$PERF_LOG (164)
Primary pointer page: 352, Index root page: 353
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: 360, 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: 205, Index root page: 206
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: 201, Index root page: 202
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: 204, 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: 203, 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: 193, Index root page: 194
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: 197, 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: 347, Index root page: 348
Total formats: 1, used formats: 1
Average record length: 57.96, total records: 2391
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: 69%
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% = 0
60 - 79% = 29
80 - 99% = 0
WARES (144)
Primary pointer page: 264, Index root page: 265
Total formats: 1, used formats: 1
Average record length: 78.23, 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.73
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 78%
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: 377, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 67
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 48, 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: 274, 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: 335, ratio: 0.84
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_ID_DESC (2)
Root page: 276, 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: 335, ratio: 0.84
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_NUMB_UNQ (1)
Root page: 507, depth: 2, leaf buckets: 4, nodes: 400
Average node length: 52.86, total dup: 0, max dup: 0
Average key length: 51.84, compression ratio: 1.00
Average prefix length: 2.73, average data length: 48.86
Clustering factor: 334, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3
80 - 99% = 0
WARE_GROUPS (155)
Primary pointer page: 313, Index root page: 314
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: 325, 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: 326, 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: 292, Index root page: 295
Total formats: 1, used formats: 1
Average record length: 3.52, total records: 77586
Average version length: 72.17, total versions: 73807, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 38.59
Pointer pages: 2, data page slots: 1448
Data pages: 1088, average fill: 92%
Primary pages: 1087, secondary pages: 1, swept pages: 0
Empty pages: 7, full pages: 1079
Fill distribution:
0 - 19% = 7
20 - 39% = 0
40 - 59% = 1
60 - 79% = 34
80 - 99% = 1046
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1346, depth: 2, leaf buckets: 83, nodes: 77586
Average node length: 5.45, total dup: 67822, max dup: 14
Average key length: 3.39, compression ratio: 10.91
Average prefix length: 35.73, average data length: 1.27
Clustering factor: 12710, ratio: 0.16
Fill distribution:
0 - 19% = 4
20 - 39% = 1
40 - 59% = 31
60 - 79% = 26
80 - 99% = 21
XQD_1000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 68.93, total records: 1285789
Average version length: 71.41, total versions: 57950, 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: 12, data page slots: 18480
Data pages: 18464, average fill: 77%
Primary pages: 18464, secondary pages: 0, swept pages: 6501
Empty pages: 48, full pages: 17931
Fill distribution:
0 - 19% = 74
20 - 39% = 58
40 - 59% = 122
60 - 79% = 16264
80 - 99% = 1946
Index XQD_1000_3300_DOC (1)
Root page: 355369, depth: 3, leaf buckets: 1505, nodes: 1285789
Average node length: 5.14, total dup: 1250846, max dup: 127
Average key length: 2.20, compression ratio: 4.09
Average prefix length: 8.83, average data length: 0.17
Clustering factor: 148458, ratio: 0.12
Fill distribution:
0 - 19% = 22
20 - 39% = 93
40 - 59% = 1154
60 - 79% = 55
80 - 99% = 181
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 244390, depth: 3, leaf buckets: 1820, nodes: 1285789
Average node length: 6.26, total dup: 1122254, max dup: 27
Average key length: 3.32, compression ratio: 11.13
Average prefix length: 35.80, average data length: 1.20
Clustering factor: 247684, ratio: 0.19
Fill distribution:
0 - 19% = 21
20 - 39% = 121
40 - 59% = 1390
60 - 79% = 143
80 - 99% = 145
XQD_1200_2000 (261)
Primary pointer page: 718, Index root page: 719
Total formats: 1, used formats: 1
Average record length: 8.91, total records: 149457
Average version length: 71.87, total versions: 130989, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 15.27
Pointer pages: 3, data page slots: 3304
Data pages: 2176, average fill: 87%
Primary pages: 2172, secondary pages: 4, swept pages: 0
Empty pages: 36, full pages: 2081
Fill distribution:
0 - 19% = 48
20 - 39% = 13
40 - 59% = 22
60 - 79% = 195
80 - 99% = 1898
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1095, depth: 2, leaf buckets: 172, nodes: 149457
Average node length: 5.95, total dup: 133019, max dup: 67
Average key length: 3.23, compression ratio: 11.47
Average prefix length: 35.88, average data length: 1.12
Clustering factor: 18877, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 75
60 - 79% = 60
80 - 99% = 36
XQD_2000_3300 (263)
Primary pointer page: 735, Index root page: 736
Total formats: 1, used formats: 1
Average record length: 65.70, total records: 1788509
Average version length: 71.99, total versions: 160803, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.07
Pointer pages: 17, data page slots: 26752
Data pages: 26736, average fill: 75%
Primary pages: 26736, secondary pages: 0, swept pages: 7619
Empty pages: 140, full pages: 22414
Fill distribution:
0 - 19% = 334
20 - 39% = 528
40 - 59% = 1363
60 - 79% = 20107
80 - 99% = 4404
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 197261, depth: 3, leaf buckets: 2808, nodes: 1788509
Average node length: 5.62, total dup: 1680410, max dup: 78
Average key length: 2.66, compression ratio: 13.90
Average prefix length: 36.40, average data length: 0.60
Clustering factor: 256528, ratio: 0.14
Fill distribution:
0 - 19% = 13
20 - 39% = 1235
40 - 59% = 1220
60 - 79% = 172
80 - 99% = 168
XQD_2100_3300 (264)
Primary pointer page: 738, Index root page: 739
Total formats: 1, used formats: 1
Average record length: 0.83, total records: 108810
Average version length: 71.84, total versions: 107536, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 164.13
Pointer pages: 3, data page slots: 2704
Data pages: 1816, average fill: 78%
Primary pages: 1814, secondary pages: 2, swept pages: 0
Empty pages: 97, full pages: 1442
Fill distribution:
0 - 19% = 130
20 - 39% = 73
40 - 59% = 112
60 - 79% = 188
80 - 99% = 1313
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1215, depth: 2, leaf buckets: 135, nodes: 108810
Average node length: 5.39, total dup: 99244, max dup: 91
Average key length: 3.07, compression ratio: 12.06
Average prefix length: 36.02, average data length: 0.98
Clustering factor: 13077, ratio: 0.12
Fill distribution:
0 - 19% = 0
20 - 39% = 15
40 - 59% = 77
60 - 79% = 39
80 - 99% = 4
XQD_3300_3400 (265)
Primary pointer page: 741, Index root page: 742
Total formats: 1, used formats: 1
Average record length: 69.87, total records: 2564467
Average version length: 71.60, total versions: 56906, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.95
Pointer pages: 23, data page slots: 36264
Data pages: 36264, average fill: 77%
Primary pages: 36264, secondary pages: 0, swept pages: 17256
Empty pages: 8, full pages: 34867
Fill distribution:
0 - 19% = 11
20 - 39% = 31
40 - 59% = 219
60 - 79% = 34326
80 - 99% = 1677
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 40476, depth: 3, leaf buckets: 5215, nodes: 2564467
Average node length: 6.87, total dup: 2079011, max dup: 15
Average key length: 3.90, compression ratio: 9.48
Average prefix length: 35.29, average data length: 1.71
Clustering factor: 535257, ratio: 0.21
Fill distribution:
0 - 19% = 7
20 - 39% = 2791
40 - 59% = 1996
60 - 79% = 248
80 - 99% = 173
XQS_1000_1200 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 83.46, total records: 4590776
Average version length: 84.66, total versions: 9340, 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: 44, data page slots: 70440
Data pages: 70440, average fill: 80%
Primary pages: 70440, secondary pages: 0, swept pages: 26085
Empty pages: 4, full pages: 70435
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 20434
80 - 99% = 50001
Index XQS_1000_1200_DOC_ID (0)
Root page: 54645, depth: 3, leaf buckets: 4669, nodes: 4590776
Average node length: 5.15, total dup: 4486000, max dup: 145
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 747934, ratio: 0.16
Fill distribution:
0 - 19% = 22
20 - 39% = 68
40 - 59% = 2062
60 - 79% = 1917
80 - 99% = 600
Index XQS_1000_1200_RCV_ID (2)
Root page: 82607, depth: 3, leaf buckets: 5375, nodes: 4590776
Average node length: 5.70, total dup: 4112436, max dup: 49
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 274785, ratio: 0.06
Fill distribution:
0 - 19% = 68
20 - 39% = 163
40 - 59% = 3534
60 - 79% = 256
80 - 99% = 1354
Index XQS_1000_1200_SND_ID (1)
Root page: 47515, depth: 3, leaf buckets: 5193, nodes: 4590776
Average node length: 5.81, total dup: 4016583, max dup: 29
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 802213, ratio: 0.17
Fill distribution:
0 - 19% = 25
20 - 39% = 80
40 - 59% = 2270
60 - 79% = 1990
80 - 99% = 828
XQS_1000_3300 (268)
Primary pointer page: 755, Index root page: 756
Total formats: 1, used formats: 1
Average record length: 81.61, total records: 2252390
Average version length: 84.26, total versions: 36536, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.67
Pointer pages: 22, data page slots: 35112
Data pages: 35112, average fill: 79%
Primary pages: 35112, secondary pages: 0, swept pages: 21544
Empty pages: 6, full pages: 33509
Fill distribution:
0 - 19% = 13
20 - 39% = 55
40 - 59% = 304
60 - 79% = 14882
80 - 99% = 19858
Index XQS_1000_3300_DOC_ID (0)
Root page: 73800, depth: 3, leaf buckets: 2422, nodes: 2252390
Average node length: 5.15, total dup: 2200074, max dup: 201
Average key length: 2.18, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 342468, ratio: 0.15
Fill distribution:
0 - 19% = 5
20 - 39% = 41
40 - 59% = 1466
60 - 79% = 683
80 - 99% = 227
Index XQS_1000_3300_RCV_ID (2)
Root page: 109107, depth: 3, leaf buckets: 3938, nodes: 2252390
Average node length: 6.20, total dup: 1856243, max dup: 14
Average key length: 3.23, compression ratio: 2.79
Average prefix length: 7.94, average data length: 1.06
Clustering factor: 238522, ratio: 0.11
Fill distribution:
0 - 19% = 108
20 - 39% = 1661
40 - 59% = 1590
60 - 79% = 432
80 - 99% = 147
Index XQS_1000_3300_SND_ID (1)
Root page: 63881, depth: 3, leaf buckets: 2776, nodes: 2252390
Average node length: 5.81, total dup: 1972454, max dup: 38
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 410391, ratio: 0.18
Fill distribution:
0 - 19% = 24
20 - 39% = 42
40 - 59% = 1737
60 - 79% = 712
80 - 99% = 261
XQS_1200_2000 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 82.47, total records: 4914575
Average version length: 85.61, total versions: 76051, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.65
Pointer pages: 47, data page slots: 76400
Data pages: 76384, average fill: 80%
Primary pages: 76384, secondary pages: 0, swept pages: 19465
Empty pages: 100, full pages: 73638
Fill distribution:
0 - 19% = 237
20 - 39% = 322
40 - 59% = 769
60 - 79% = 17788
80 - 99% = 57268
Index XQS_1200_2000_DOC_ID (0)
Root page: 57493, depth: 3, leaf buckets: 5246, nodes: 4914575
Average node length: 5.04, total dup: 4886058, max dup: 757
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 749464, ratio: 0.15
Fill distribution:
0 - 19% = 5
20 - 39% = 242
40 - 59% = 3072
60 - 79% = 1449
80 - 99% = 478
Index XQS_1200_2000_RCV_ID (2)
Root page: 83243, depth: 3, leaf buckets: 6171, nodes: 4914575
Average node length: 5.54, total dup: 4521141, max dup: 49
Average key length: 2.55, compression ratio: 3.53
Average prefix length: 8.53, average data length: 0.47
Clustering factor: 320313, ratio: 0.07
Fill distribution:
0 - 19% = 67
20 - 39% = 1708
40 - 59% = 2683
60 - 79% = 541
80 - 99% = 1172
Index XQS_1200_2000_SND_ID (1)
Root page: 49462, depth: 3, leaf buckets: 5873, nodes: 4914575
Average node length: 5.67, total dup: 4417449, max dup: 95
Average key length: 2.69, compression ratio: 3.35
Average prefix length: 8.41, average data length: 0.59
Clustering factor: 829781, ratio: 0.17
Fill distribution:
0 - 19% = 4
20 - 39% = 205
40 - 59% = 3495
60 - 79% = 1590
80 - 99% = 579
XQS_2000_3300 (269)
Primary pointer page: 761, Index root page: 762
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: 763, 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: 765, 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: 764, 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: 767, Index root page: 776
Total formats: 1, used formats: 1
Average record length: 82.20, total records: 3256203
Average version length: 85.03, total versions: 46659, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.65
Pointer pages: 32, data page slots: 50928
Data pages: 50928, average fill: 79%
Primary pages: 50928, secondary pages: 0, swept pages: 30205
Empty pages: 10, full pages: 48371
Fill distribution:
0 - 19% = 22
20 - 39% = 72
40 - 59% = 363
60 - 79% = 21191
80 - 99% = 29280
Index XQS_2100_3300_DOC_ID (0)
Root page: 89055, depth: 3, leaf buckets: 3478, nodes: 3256203
Average node length: 5.03, total dup: 3239665, max dup: 1077
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 728096, ratio: 0.22
Fill distribution:
0 - 19% = 16
20 - 39% = 303
40 - 59% = 1820
60 - 79% = 932
80 - 99% = 407
Index XQS_2100_3300_RCV_ID (2)
Root page: 109104, depth: 3, leaf buckets: 5898, nodes: 3256203
Average node length: 6.23, total dup: 2673324, max dup: 14
Average key length: 3.25, compression ratio: 2.77
Average prefix length: 7.93, average data length: 1.07
Clustering factor: 401849, ratio: 0.12
Fill distribution:
0 - 19% = 197
20 - 39% = 2778
40 - 59% = 2119
60 - 79% = 572
80 - 99% = 232
Index XQS_2100_3300_SND_ID (1)
Root page: 77230, depth: 3, leaf buckets: 3830, nodes: 3256203
Average node length: 5.61, total dup: 2962717, max dup: 91
Average key length: 2.63, compression ratio: 3.42
Average prefix length: 8.46, average data length: 0.54
Clustering factor: 763242, ratio: 0.23
Fill distribution:
0 - 19% = 12
20 - 39% = 314
40 - 59% = 1918
60 - 79% = 1125
80 - 99% = 461
XQS_3300_3400 (271)
Primary pointer page: 780, Index root page: 781
Total formats: 1, used formats: 1
Average record length: 68.93, total records: 706610
Average version length: 70.02, total versions: 4627, 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: 9680
Data pages: 9680, average fill: 77%
Primary pages: 9680, secondary pages: 0, swept pages: 6656
Empty pages: 2, full pages: 9518
Fill distribution:
0 - 19% = 5
20 - 39% = 11
40 - 59% = 32
60 - 79% = 9507
80 - 99% = 125
Index XQS_3300_3400_DOC_ID (0)
Root page: 172543, depth: 3, leaf buckets: 840, nodes: 706610
Average node length: 5.28, total dup: 670072, max dup: 165
Average key length: 2.40, compression ratio: 3.76
Average prefix length: 8.66, average data length: 0.34
Clustering factor: 55319, ratio: 0.08
Fill distribution:
0 - 19% = 2
20 - 39% = 179
40 - 59% = 349
60 - 79% = 225
80 - 99% = 85
Index XQS_3300_3400_SND_ID (1)
Root page: 150306, depth: 3, leaf buckets: 938, nodes: 706610
Average node length: 5.91, total dup: 606452, max dup: 29
Average key length: 3.02, compression ratio: 2.98
Average prefix length: 8.12, average data length: 0.88
Clustering factor: 59784, ratio: 0.08
Fill distribution:
0 - 19% = 3
20 - 39% = 236
40 - 59% = 338
60 - 79% = 242
80 - 99% = 119
ZDOC_DATA (230)
Primary pointer page: 644, Index root page: 645
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: 642, Index root page: 643
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: 646, Index root page: 647
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: 652, Index root page: 653
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: 662, 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: 654, Index root page: 655
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: 663, 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: 648, Index root page: 649
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: 656, 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: 657, 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: 650, Index root page: 651
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: 659, 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: 658, 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: 661, 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: 660, 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: 640, Index root page: 641
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: 614, Index root page: 615
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: 268, Index root page: 269
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: 281, 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 75470 ms, from 7:05:29.44 to 7:06:44.91.
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
VERS_PERCENT |
AGENTS |
50 |
0 |
0.0000 |
BUSINESS_OPS |
19 |
0 |
0.0000 |
DOC_DATA |
2071064 |
3006 |
0.1451 |
DOC_LIST |
614782 |
1132 |
0.1841 |
DOC_STATES |
4 |
0 |
0.0000 |
FB_ERRORS |
758 |
0 |
0.0000 |
INVNT_SALDO |
400 |
104659 |
26164.7500 |
INVNT_TURNOVER_LOG |
67203 |
63394 |
94.3320 |
MONEY_SALDO |
49 |
0 |
0.0000 |
MONEY_TURNOVER_LOG |
118 |
0 |
0.0000 |
OPTYPES |
9 |
0 |
0.0000 |
PDISTR |
234313 |
31588 |
13.4811 |
PERF_ESTIMATED |
259792 |
0 |
0.0000 |
PERF_LOG |
10542615 |
0 |
0.0000 |
PSTORNED |
415916 |
3449 |
0.8292 |
RULES_FOR_PDISTR |
4 |
0 |
0.0000 |
RULES_FOR_QDISTR |
7 |
0 |
0.0000 |
SEMAPHORES |
4 |
3255 |
81375.0000 |
SETTINGS |
114 |
0 |
0.0000 |
TRACE_STAT |
2391 |
0 |
0.0000 |
WARES |
400 |
0 |
0.0000 |
WARE_GROUPS |
8 |
0 |
0.0000 |
XQD_1000_1200 |
77586 |
73807 |
95.1292 |
XQD_1000_3300 |
1285789 |
57950 |
4.5069 |
XQD_1200_2000 |
149457 |
130989 |
87.6432 |
XQD_2000_3300 |
1788509 |
160803 |
8.9908 |
XQD_2100_3300 |
108810 |
107536 |
98.8291 |
XQD_3300_3400 |
2564467 |
56906 |
2.2190 |
XQS_1000_1200 |
4590776 |
9340 |
0.2034 |
XQS_1000_3300 |
2252390 |
36536 |
1.6220 |
XQS_1200_2000 |
4914575 |
76051 |
1.5474 |
XQS_2100_3300 |
3256203 |
46659 |
1.4329 |
XQS_3300_3400 |
706610 |
4627 |
0.6548 |
Z_USED_VIEWS |
29 |
0 |
0.0000 |
Done for 1710 ms, from 7:06:58.49 to 7:07:00.20.
07:07:00.28 Validation started
07:07:00.31 Relation 140 (DOC_LIST)
07:07:00.31 process pointer page 0 of 5
07:07:00.36 process pointer page 1 of 5
07:07:00.39 process pointer page 2 of 5
07:07:00.44 process pointer page 3 of 5
07:07:00.47 process pointer page 4 of 5
07:07:00.50 Index 1 (PK_DOC_LIST)
07:07:00.56 Index 2 (DOC_LIST_ID_DESC)
07:07:00.67 Index 3 (FK_DOC_LIST_AGENTS)
07:07:00.75 Relation 140 (DOC_LIST) is ok
07:07:00.75 Relation 141 (DOC_DATA)
07:07:00.75 process pointer page 0 of 14
07:07:00.78 process pointer page 1 of 14
07:07:00.81 process pointer page 2 of 14
07:07:00.87 process pointer page 3 of 14
07:07:00.92 process pointer page 4 of 14
07:07:00.95 process pointer page 5 of 14
07:07:00.98 process pointer page 6 of 14
07:07:01.01 process pointer page 7 of 14
07:07:01.04 process pointer page 8 of 14
07:07:01.08 process pointer page 9 of 14
07:07:01.11 process pointer page 10 of 14
07:07:01.14 process pointer page 11 of 14
07:07:01.17 process pointer page 12 of 14
07:07:01.18 process pointer page 13 of 14
07:07:01.22 Index 2 (DOC_DATA_DOC_WARE_UNQ)
07:07:01.54 Index 3 (DOC_DATA_ID_DESC)
07:07:02.18 Index 4 (FK_DOC_DATA_DOC_LIST)
07:07:02.57 Relation 141 (DOC_DATA) is ok
07:07:02.57 Relation 147 (INVNT_SALDO)
07:07:02.57 process pointer page 0 of 2
07:07:02.90 process pointer page 1 of 2
07:07:02.90 Index 1 (PK_INVNT_SALDO)
07:07:02.90 Relation 147 (INVNT_SALDO) is ok
07:07:02.90 Relation 150 (PDISTR)
07:07:02.90 process pointer page 0 of 2
07:07:03.03 process pointer page 1 of 2
07:07:03.09 Index 2 (PDISTR_SND_ID)
07:07:03.17 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
07:07:03.23 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
07:07:03.26 Index 5 (PDISTR_AGENT_ID)
07:07:03.29 Relation 150 (PDISTR) is ok
07:07:03.29 Relation 151 (PSTORNED)
07:07:03.29 process pointer page 0 of 4
07:07:03.32 process pointer page 1 of 4
07:07:03.42 process pointer page 2 of 4
07:07:03.51 process pointer page 3 of 4
07:07:03.51 Index 2 (PSTORNED_SND_ID)
07:07:03.57 Index 3 (PSTORNED_RCV_ID)
07:07:03.62 Relation 151 (PSTORNED) is ok
07:07:03.62 Relation 156 (SEMAPHORES)
07:07:03.62 process pointer page 0 of 1
07:07:03.62 Index 1 (PK_SEMAPHORES)
07:07:03.62 Index 2 (SEMAPHORES_TASK_UNQ)
07:07:03.62 Relation 156 (SEMAPHORES) is ok
07:07:03.62 Relation 157 (INVNT_TURNOVER_LOG)
07:07:03.62 process pointer page 0 of 2
07:07:03.68 process pointer page 1 of 2
07:07:03.68 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
07:07:03.70 Relation 157 (INVNT_TURNOVER_LOG) is ok
07:07:03.70 Relation 160 (PERF_ESTIMATED)
07:07:03.70 process pointer page 0 of 2
07:07:03.73 process pointer page 1 of 2
07:07:03.73 Index 1 (PERF_EST_MINUTE_SINCE_START)
07:07:03.76 Relation 160 (PERF_ESTIMATED) is ok
07:07:03.76 Relation 161 (PERF_ISQL_STAT)
07:07:03.76 process pointer page 0 of 1
07:07:03.76 Index 1 (PERF_ISQL_STAT_TRN)
07:07:03.76 Relation 161 (PERF_ISQL_STAT) is ok
07:07:03.76 Relation 162 (TRACE_STAT)
07:07:03.76 process pointer page 0 of 1
07:07:03.76 Relation 162 (TRACE_STAT) is ok
07:07:03.76 Relation 163 (PERF_LOG)
07:07:03.76 process pointer page 0 of 154
07:07:03.79 process pointer page 1 of 154
07:07:03.82 process pointer page 2 of 154
07:07:03.84 process pointer page 3 of 154
07:07:03.88 process pointer page 4 of 154
07:07:03.91 process pointer page 5 of 154
07:07:03.96 process pointer page 6 of 154
07:07:04.02 process pointer page 7 of 154
07:07:04.05 process pointer page 8 of 154
07:07:04.12 process pointer page 9 of 154
07:07:04.20 process pointer page 10 of 154
07:07:04.27 process pointer page 11 of 154
07:07:04.35 process pointer page 12 of 154
07:07:04.43 process pointer page 13 of 154
07:07:04.52 process pointer page 14 of 154
07:07:04.60 process pointer page 15 of 154
07:07:04.68 process pointer page 16 of 154
07:07:04.76 process pointer page 17 of 154
07:07:04.83 process pointer page 18 of 154
07:07:04.93 process pointer page 19 of 154
07:07:05.01 process pointer page 20 of 154
07:07:05.08 process pointer page 21 of 154
07:07:05.13 process pointer page 22 of 154
07:07:05.18 process pointer page 23 of 154
07:07:05.19 process pointer page 24 of 154
07:07:05.26 process pointer page 25 of 154
07:07:05.33 process pointer page 26 of 154
07:07:05.41 process pointer page 27 of 154
07:07:05.44 process pointer page 28 of 154
07:07:05.47 process pointer page 29 of 154
07:07:05.52 process pointer page 30 of 154
07:07:05.57 process pointer page 31 of 154
07:07:05.65 process pointer page 32 of 154
07:07:05.74 process pointer page 33 of 154
07:07:05.82 process pointer page 34 of 154
07:07:05.85 process pointer page 35 of 154
07:07:05.90 process pointer page 36 of 154
07:07:05.94 process pointer page 37 of 154
07:07:05.99 process pointer page 38 of 154
07:07:06.07 process pointer page 39 of 154
07:07:06.15 process pointer page 40 of 154
07:07:06.22 process pointer page 41 of 154
07:07:06.30 process pointer page 42 of 154
07:07:06.39 process pointer page 43 of 154
07:07:06.47 process pointer page 44 of 154
07:07:06.54 process pointer page 45 of 154
07:07:06.57 process pointer page 46 of 154
07:07:06.60 process pointer page 47 of 154
07:07:06.63 process pointer page 48 of 154
07:07:06.66 process pointer page 49 of 154
07:07:06.69 process pointer page 50 of 154
07:07:06.72 process pointer page 51 of 154
07:07:06.74 process pointer page 52 of 154
07:07:06.77 process pointer page 53 of 154
07:07:06.80 process pointer page 54 of 154
07:07:06.83 process pointer page 55 of 154
07:07:06.85 process pointer page 56 of 154
07:07:06.88 process pointer page 57 of 154
07:07:06.89 process pointer page 58 of 154
07:07:06.93 process pointer page 59 of 154
07:07:06.96 process pointer page 60 of 154
07:07:06.99 process pointer page 61 of 154
07:07:07.00 process pointer page 62 of 154
07:07:07.03 process pointer page 63 of 154
07:07:07.05 process pointer page 64 of 154
07:07:07.08 process pointer page 65 of 154
07:07:07.10 process pointer page 66 of 154
07:07:07.13 process pointer page 67 of 154
07:07:07.14 process pointer page 68 of 154
07:07:07.17 process pointer page 69 of 154
07:07:07.19 process pointer page 70 of 154
07:07:07.21 process pointer page 71 of 154
07:07:07.24 process pointer page 72 of 154
07:07:07.25 process pointer page 73 of 154
07:07:07.28 process pointer page 74 of 154
07:07:07.30 process pointer page 75 of 154
07:07:07.33 process pointer page 76 of 154
07:07:07.35 process pointer page 77 of 154
07:07:07.38 process pointer page 78 of 154
07:07:07.41 process pointer page 79 of 154
07:07:07.49 process pointer page 80 of 154
07:07:07.52 process pointer page 81 of 154
07:07:07.55 process pointer page 82 of 154
07:07:07.58 process pointer page 83 of 154
07:07:07.61 process pointer page 84 of 154
07:07:07.64 process pointer page 85 of 154
07:07:07.67 process pointer page 86 of 154
07:07:07.69 process pointer page 87 of 154
07:07:07.72 process pointer page 88 of 154
07:07:07.75 process pointer page 89 of 154
07:07:07.77 process pointer page 90 of 154
07:07:07.80 process pointer page 91 of 154
07:07:07.83 process pointer page 92 of 154
07:07:07.85 process pointer page 93 of 154
07:07:07.88 process pointer page 94 of 154
07:07:07.91 process pointer page 95 of 154
07:07:07.99 process pointer page 96 of 154
07:07:08.05 process pointer page 97 of 154
07:07:08.08 process pointer page 98 of 154
07:07:08.11 process pointer page 99 of 154
07:07:08.14 process pointer page 100 of 154
07:07:08.17 process pointer page 101 of 154
07:07:08.20 process pointer page 102 of 154
07:07:08.24 process pointer page 103 of 154
07:07:08.27 process pointer page 104 of 154
07:07:08.28 process pointer page 105 of 154
07:07:08.31 process pointer page 106 of 154
07:07:08.34 process pointer page 107 of 154
07:07:08.38 process pointer page 108 of 154
07:07:08.41 process pointer page 109 of 154
07:07:08.44 process pointer page 110 of 154
07:07:08.52 process pointer page 111 of 154
07:07:08.59 process pointer page 112 of 154
07:07:08.69 process pointer page 113 of 154
07:07:08.75 process pointer page 114 of 154
07:07:08.78 process pointer page 115 of 154
07:07:08.81 process pointer page 116 of 154
07:07:08.84 process pointer page 117 of 154
07:07:08.91 process pointer page 118 of 154
07:07:08.95 process pointer page 119 of 154
07:07:08.98 process pointer page 120 of 154
07:07:09.02 process pointer page 121 of 154
07:07:09.06 process pointer page 122 of 154
07:07:09.09 process pointer page 123 of 154
07:07:09.11 process pointer page 124 of 154
07:07:09.14 process pointer page 125 of 154
07:07:09.17 process pointer page 126 of 154
07:07:09.20 process pointer page 127 of 154
07:07:09.23 process pointer page 128 of 154
07:07:09.25 process pointer page 129 of 154
07:07:09.28 process pointer page 130 of 154
07:07:09.30 process pointer page 131 of 154
07:07:09.33 process pointer page 132 of 154
07:07:09.34 process pointer page 133 of 154
07:07:09.36 process pointer page 134 of 154
07:07:09.39 process pointer page 135 of 154
07:07:09.42 process pointer page 136 of 154
07:07:09.48 process pointer page 137 of 154
07:07:09.56 process pointer page 138 of 154
07:07:09.64 process pointer page 139 of 154
07:07:09.70 process pointer page 140 of 154
07:07:09.73 process pointer page 141 of 154
07:07:09.81 process pointer page 142 of 154
07:07:09.89 process pointer page 143 of 154
07:07:09.97 process pointer page 144 of 154
07:07:10.05 process pointer page 145 of 154
07:07:10.12 process pointer page 146 of 154
07:07:10.20 process pointer page 147 of 154
07:07:10.29 process pointer page 148 of 154
07:07:10.37 process pointer page 149 of 154
07:07:10.45 process pointer page 150 of 154
07:07:10.53 process pointer page 151 of 154
07:07:10.61 process pointer page 152 of 154
07:07:10.68 process pointer page 153 of 154
07:07:10.68 Index 1 (PERF_LOG_DTS_BEG_DESC)
07:07:12.98 Index 2 (PERF_LOG_UNIT)
07:07:15.72 Index 3 (PERF_LOG_TRN_DESC)
07:07:17.14 Index 4 (PERF_LOG_GDSCODE)
07:07:18.50 Relation 163 (PERF_LOG) is ok
07:07:18.50 Relation 167 (V_STOPTEST)
07:07:18.50 Relation 167 (V_STOPTEST) is ok
07:07:18.50 Relation 184 (V_QDISTR_SOURCE)
07:07:18.50 Relation 184 (V_QDISTR_SOURCE) is ok
07:07:18.50 Relation 185 (V_QSTORNED_SOURCE)
07:07:18.50 Relation 185 (V_QSTORNED_SOURCE) is ok
07:07:18.50 Relation 260 (XQD_1000_1200)
07:07:18.52 process pointer page 0 of 2
07:07:18.66 process pointer page 1 of 2
07:07:18.66 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
07:07:18.69 Relation 260 (XQD_1000_1200) is ok
07:07:18.69 Relation 261 (XQD_1200_2000)
07:07:18.69 process pointer page 0 of 3
07:07:18.72 process pointer page 1 of 3
07:07:18.80 process pointer page 2 of 3
07:07:18.81 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
07:07:18.83 Relation 261 (XQD_1200_2000) is ok
07:07:18.83 Relation 262 (XQD_1000_3300)
07:07:18.83 process pointer page 0 of 12
07:07:18.86 process pointer page 1 of 12
07:07:18.91 process pointer page 2 of 12
07:07:18.97 process pointer page 3 of 12
07:07:19.02 process pointer page 4 of 12
07:07:19.05 process pointer page 5 of 12
07:07:19.12 process pointer page 6 of 12
07:07:19.23 process pointer page 7 of 12
07:07:19.31 process pointer page 8 of 12
07:07:19.41 process pointer page 9 of 12
07:07:19.50 process pointer page 10 of 12
07:07:19.58 process pointer page 11 of 12
07:07:19.62 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
07:07:19.84 Index 2 (XQD_1000_3300_DOC)
07:07:19.97 Relation 262 (XQD_1000_3300) is ok
07:07:19.97 Relation 263 (XQD_2000_3300)
07:07:19.97 process pointer page 0 of 17
07:07:20.00 process pointer page 1 of 17
07:07:20.03 process pointer page 2 of 17
07:07:20.06 process pointer page 3 of 17
07:07:20.09 process pointer page 4 of 17
07:07:20.12 process pointer page 5 of 17
07:07:20.17 process pointer page 6 of 17
07:07:20.20 process pointer page 7 of 17
07:07:20.23 process pointer page 8 of 17
07:07:20.28 process pointer page 9 of 17
07:07:20.31 process pointer page 10 of 17
07:07:20.34 process pointer page 11 of 17
07:07:20.37 process pointer page 12 of 17
07:07:20.40 process pointer page 13 of 17
07:07:20.43 process pointer page 14 of 17
07:07:20.47 process pointer page 15 of 17
07:07:20.48 process pointer page 16 of 17
07:07:20.50 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
07:07:20.67 Relation 263 (XQD_2000_3300) is ok
07:07:20.67 Relation 264 (XQD_2100_3300)
07:07:20.67 process pointer page 0 of 3
07:07:20.73 process pointer page 1 of 3
07:07:20.75 process pointer page 2 of 3
07:07:20.75 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
07:07:20.75 Relation 264 (XQD_2100_3300) is ok
07:07:20.75 Relation 265 (XQD_3300_3400)
07:07:20.75 process pointer page 0 of 23
07:07:20.78 process pointer page 1 of 23
07:07:20.81 process pointer page 2 of 23
07:07:20.84 process pointer page 3 of 23
07:07:20.86 process pointer page 4 of 23
07:07:20.89 process pointer page 5 of 23
07:07:20.92 process pointer page 6 of 23
07:07:20.93 process pointer page 7 of 23
07:07:20.97 process pointer page 8 of 23
07:07:21.00 process pointer page 9 of 23
07:07:21.03 process pointer page 10 of 23
07:07:21.06 process pointer page 11 of 23
07:07:21.09 process pointer page 12 of 23
07:07:21.12 process pointer page 13 of 23
07:07:21.15 process pointer page 14 of 23
07:07:21.17 process pointer page 15 of 23
07:07:21.20 process pointer page 16 of 23
07:07:21.23 process pointer page 17 of 23
07:07:21.25 process pointer page 18 of 23
07:07:21.28 process pointer page 19 of 23
07:07:21.31 process pointer page 20 of 23
07:07:21.34 process pointer page 21 of 23
07:07:21.36 process pointer page 22 of 23
07:07:21.37 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
07:07:21.92 Relation 265 (XQD_3300_3400) is ok
07:07:21.92 Relation 266 (XQS_1000_1200)
07:07:21.92 process pointer page 0 of 44
07:07:21.95 process pointer page 1 of 44
07:07:21.98 process pointer page 2 of 44
07:07:22.03 process pointer page 3 of 44
07:07:22.06 process pointer page 4 of 44
07:07:22.09 process pointer page 5 of 44
07:07:22.12 process pointer page 6 of 44
07:07:22.15 process pointer page 7 of 44
07:07:22.18 process pointer page 8 of 44
07:07:22.21 process pointer page 9 of 44
07:07:22.24 process pointer page 10 of 44
07:07:22.28 process pointer page 11 of 44
07:07:22.31 process pointer page 12 of 44
07:07:22.34 process pointer page 13 of 44
07:07:22.37 process pointer page 14 of 44
07:07:22.40 process pointer page 15 of 44
07:07:22.43 process pointer page 16 of 44
07:07:22.46 process pointer page 17 of 44
07:07:22.49 process pointer page 18 of 44
07:07:22.51 process pointer page 19 of 44
07:07:22.54 process pointer page 20 of 44
07:07:22.57 process pointer page 21 of 44
07:07:22.60 process pointer page 22 of 44
07:07:22.63 process pointer page 23 of 44
07:07:22.67 process pointer page 24 of 44
07:07:22.70 process pointer page 25 of 44
07:07:22.73 process pointer page 26 of 44
07:07:22.76 process pointer page 27 of 44
07:07:22.79 process pointer page 28 of 44
07:07:22.82 process pointer page 29 of 44
07:07:22.85 process pointer page 30 of 44
07:07:22.88 process pointer page 31 of 44
07:07:22.92 process pointer page 32 of 44
07:07:22.96 process pointer page 33 of 44
07:07:23.04 process pointer page 34 of 44
07:07:23.13 process pointer page 35 of 44
07:07:23.27 process pointer page 36 of 44
07:07:23.55 process pointer page 37 of 44
07:07:23.85 process pointer page 38 of 44
07:07:24.13 process pointer page 39 of 44
07:07:24.40 process pointer page 40 of 44
07:07:24.72 process pointer page 41 of 44
07:07:25.04 process pointer page 42 of 44
07:07:25.36 process pointer page 43 of 44
07:07:25.41 Index 1 (XQS_1000_1200_DOC_ID)
07:07:27.39 Index 2 (XQS_1000_1200_SND_ID)
07:07:29.26 Index 3 (XQS_1000_1200_RCV_ID)
07:07:31.17 Relation 266 (XQS_1000_1200) is ok
07:07:31.17 Relation 267 (XQS_1200_2000)
07:07:31.17 process pointer page 0 of 47
07:07:31.53 process pointer page 1 of 47
07:07:31.76 process pointer page 2 of 47
07:07:32.03 process pointer page 3 of 47
07:07:32.35 process pointer page 4 of 47
07:07:32.74 process pointer page 5 of 47
07:07:33.16 process pointer page 6 of 47
07:07:33.45 process pointer page 7 of 47
07:07:33.79 process pointer page 8 of 47
07:07:34.15 process pointer page 9 of 47
07:07:34.57 process pointer page 10 of 47
07:07:35.04 process pointer page 11 of 47
07:07:35.46 process pointer page 12 of 47
07:07:35.89 process pointer page 13 of 47
07:07:36.32 process pointer page 14 of 47
07:07:36.72 process pointer page 15 of 47
07:07:37.14 process pointer page 16 of 47
07:07:37.59 process pointer page 17 of 47
07:07:38.06 process pointer page 18 of 47
07:07:38.45 process pointer page 19 of 47
07:07:38.87 process pointer page 20 of 47
07:07:39.20 process pointer page 21 of 47
07:07:39.64 process pointer page 22 of 47
07:07:40.03 process pointer page 23 of 47
07:07:40.34 process pointer page 24 of 47
07:07:40.78 process pointer page 25 of 47
07:07:41.25 process pointer page 26 of 47
07:07:41.62 process pointer page 27 of 47
07:07:42.09 process pointer page 28 of 47
07:07:42.54 process pointer page 29 of 47
07:07:43.01 process pointer page 30 of 47
07:07:43.48 process pointer page 31 of 47
07:07:43.94 process pointer page 32 of 47
07:07:44.38 process pointer page 33 of 47
07:07:44.79 process pointer page 34 of 47
07:07:45.13 process pointer page 35 of 47
07:07:45.52 process pointer page 36 of 47
07:07:45.99 process pointer page 37 of 47
07:07:46.47 process pointer page 38 of 47
07:07:46.95 process pointer page 39 of 47
07:07:47.34 process pointer page 40 of 47
07:07:47.75 process pointer page 41 of 47
07:07:48.05 process pointer page 42 of 47
07:07:48.39 process pointer page 43 of 47
07:07:48.80 process pointer page 44 of 47
07:07:49.11 process pointer page 45 of 47
07:07:49.45 process pointer page 46 of 47
07:07:49.73 Index 1 (XQS_1200_2000_DOC_ID)
07:07:52.29 Index 2 (XQS_1200_2000_SND_ID)
07:07:54.71 Index 3 (XQS_1200_2000_RCV_ID)
07:07:56.77 Relation 267 (XQS_1200_2000) is ok
07:07:56.77 Relation 268 (XQS_1000_3300)
07:07:56.77 process pointer page 0 of 22
07:07:57.19 process pointer page 1 of 22
07:07:57.61 process pointer page 2 of 22
07:07:58.09 process pointer page 3 of 22
07:07:58.48 process pointer page 4 of 22
07:07:58.89 process pointer page 5 of 22
07:07:59.36 process pointer page 6 of 22
07:07:59.86 process pointer page 7 of 22
07:08:00.28 process pointer page 8 of 22
07:08:00.78 process pointer page 9 of 22
07:08:01.12 process pointer page 10 of 22
07:08:01.53 process pointer page 11 of 22
07:08:01.99 process pointer page 12 of 22
07:08:02.46 process pointer page 13 of 22
07:08:02.94 process pointer page 14 of 22
07:08:03.43 process pointer page 15 of 22
07:08:03.91 process pointer page 16 of 22
07:08:04.40 process pointer page 17 of 22
07:08:04.88 process pointer page 18 of 22
07:08:05.35 process pointer page 19 of 22
07:08:05.80 process pointer page 20 of 22
07:08:06.21 process pointer page 21 of 22
07:08:06.41 Index 1 (XQS_1000_3300_DOC_ID)
07:08:07.33 Index 2 (XQS_1000_3300_SND_ID)
07:08:08.59 Index 3 (XQS_1000_3300_RCV_ID)
07:08:10.20 Relation 268 (XQS_1000_3300) is ok
07:08:10.20 Relation 269 (XQS_2000_3300)
07:08:10.20 process pointer page 0 of 1
07:08:10.20 Index 1 (XQS_2000_3300_DOC_ID)
07:08:10.20 Index 2 (XQS_2000_3300_SND_ID)
07:08:10.20 Index 3 (XQS_2000_3300_RCV_ID)
07:08:10.20 Relation 269 (XQS_2000_3300) is ok
07:08:10.20 Relation 270 (XQS_2100_3300)
07:08:10.20 process pointer page 0 of 32
07:08:10.70 process pointer page 1 of 32
07:08:11.18 process pointer page 2 of 32
07:08:11.67 process pointer page 3 of 32
07:08:12.16 process pointer page 4 of 32
07:08:12.65 process pointer page 5 of 32
07:08:13.16 process pointer page 6 of 32
07:08:13.60 process pointer page 7 of 32
07:08:14.04 process pointer page 8 of 32
07:08:14.43 process pointer page 9 of 32
07:08:14.85 process pointer page 10 of 32
07:08:15.32 process pointer page 11 of 32
07:08:15.78 process pointer page 12 of 32
07:08:16.28 process pointer page 13 of 32
07:08:16.75 process pointer page 14 of 32
07:08:17.09 process pointer page 15 of 32
07:08:17.56 process pointer page 16 of 32
07:08:18.06 process pointer page 17 of 32
07:08:18.42 process pointer page 18 of 32
07:08:18.93 process pointer page 19 of 32
07:08:19.32 process pointer page 20 of 32
07:08:19.79 process pointer page 21 of 32
07:08:20.28 process pointer page 22 of 32
07:08:20.76 process pointer page 23 of 32
07:08:21.29 process pointer page 24 of 32
07:08:21.68 process pointer page 25 of 32
07:08:22.05 process pointer page 26 of 32
07:08:22.49 process pointer page 27 of 32
07:08:22.94 process pointer page 28 of 32
07:08:23.40 process pointer page 29 of 32
07:08:23.85 process pointer page 30 of 32
07:08:24.22 process pointer page 31 of 32
07:08:24.30 Index 1 (XQS_2100_3300_DOC_ID)
07:08:25.77 Index 2 (XQS_2100_3300_SND_ID)
07:08:27.22 Index 3 (XQS_2100_3300_RCV_ID)
07:08:29.20 Relation 270 (XQS_2100_3300) is ok
07:08:29.20 Relation 271 (XQS_3300_3400)
07:08:29.20 process pointer page 0 of 6
07:08:29.65 process pointer page 1 of 6
07:08:30.06 process pointer page 2 of 6
07:08:30.53 process pointer page 3 of 6
07:08:31.04 process pointer page 4 of 6
07:08:31.52 process pointer page 5 of 6
07:08:31.96 Index 1 (XQS_3300_3400_DOC_ID)
07:08:32.38 Index 2 (XQS_3300_3400_SND_ID)
07:08:32.82 Relation 271 (XQS_3300_3400) is ok
07:08:32.85 Validation finished
Done for 92700 ms, from 7:07:00.23 to 7:08:32.93.
Differences between old and current firebird.log
7:08:34.94. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP30\OLTP30_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-07-12 07:08 471 oltp30_fb_log_when_test_finished.log
End of gathering firebird.log AFTER test finish.
+++ Start of comparison +++
Comparing files E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Wed Jul 12 07:07:00 2017
7: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Wed Jul 12 07:08:32 2017
12: Database: D:\OLTP-EMUL\OLTP30-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.oltp30\oltp30_*.*:
ERRORS_CHECKING_RESULT |
NO_SEVERE_ERRORS_FOUND |
ISQL logs are removed because no severe errors occured during test.
2017-07-12 7:08:41.27 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html