ACTION |
AVG_TIMES_PER_MINUTE |
AVG_ELAPSED_MS |
SUCCESSFUL_TIMES_DONE |
JOB_BEG |
JOB_END |
*** OVERALL *** for 180 minutes: |
5248.09 |
7164 |
944656 |
2016-11-27 03:56 |
2016-11-27 06:56 |
customer order: creation |
400.95 |
1033 |
72171 |
2016-11-27 03:56 |
2016-11-27 06:56 |
customer order: refuse |
31.38 |
76 |
5648 |
2016-11-27 03:56 |
2016-11-27 06:56 |
order to supplier: creation |
101.64 |
7396 |
18296 |
2016-11-27 03:56 |
2016-11-27 06:56 |
order to supplier: removal |
2.41 |
78523 |
429 |
2016-11-27 03:56 |
2016-11-27 06:56 |
invoice (draft): creation |
103.11 |
11491 |
18559 |
2016-11-27 03:56 |
2016-11-27 06:56 |
invoice (draft): removal |
35.47 |
2440 |
6350 |
2016-11-27 03:56 |
2016-11-27 06:56 |
invoice accept: apply |
63.99 |
21866 |
11518 |
2016-11-27 03:56 |
2016-11-27 06:56 |
invoice accept: cancel |
16.21 |
4907 |
2917 |
2016-11-27 03:56 |
2016-11-27 06:56 |
customer reserve: creation |
3121.54 |
382 |
561877 |
2016-11-27 03:56 |
2016-11-27 06:56 |
customer reserve: removal |
831.69 |
142 |
148873 |
2016-11-27 03:56 |
2016-11-27 06:56 |
realization accept: apply |
183.81 |
337 |
33086 |
2016-11-27 03:56 |
2016-11-27 06:56 |
realization accept: cancel |
51.72 |
229 |
9257 |
2016-11-27 03:56 |
2016-11-27 06:56 |
payment from customer: creation |
134.43 |
306 |
24197 |
2016-11-27 03:56 |
2016-11-27 06:56 |
payment from customer: removal |
12.75 |
103 |
2282 |
2016-11-27 03:56 |
2016-11-27 06:56 |
payment to supplier: creation |
110.00 |
670 |
19800 |
2016-11-27 03:56 |
2016-11-27 06:56 |
payment to supplier: removal |
7.56 |
143 |
1353 |
2016-11-27 03:56 |
2016-11-27 06:56 |
service: total inventory turnovers |
21.34 |
1319 |
3842 |
2016-11-27 03:56 |
2016-11-27 06:56 |
service: total monetary turnovers |
23.27 |
56 |
4189 |
2016-11-27 03:56 |
2016-11-27 06:56 |
service: refresh index statistics |
0.07 |
4690 |
12 |
2016-11-27 03:56 |
2016-11-27 06:56 |
Done for 74960 ms, from 6:57:54.27 to 6:59:09.23.
ACTION |
ITRV_NO |
CNT_OK_PER_MINUTE |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
ITRV_BEG |
ITRV_END |
interval # 1, overall |
1 |
3564 |
71308 |
64147 |
7161 |
10.04 |
03:56:06 |
04:14:06 |
interval # 2, overall |
2 |
5073 |
97199 |
91315 |
5884 |
6.05 |
04:14:07 |
04:32:07 |
interval # 3, overall |
3 |
5438 |
102342 |
97885 |
4457 |
4.36 |
04:32:08 |
04:50:08 |
interval # 4, overall |
4 |
5582 |
106325 |
100472 |
5853 |
5.50 |
04:50:09 |
05:08:09 |
interval # 5, overall |
5 |
5487 |
104400 |
98764 |
5636 |
5.40 |
05:08:10 |
05:26:10 |
interval # 6, overall |
6 |
5670 |
109441 |
102058 |
7383 |
6.75 |
05:26:11 |
05:44:11 |
interval # 7, overall |
7 |
5740 |
108376 |
103314 |
5062 |
4.67 |
05:44:12 |
06:02:12 |
interval # 8, overall |
8 |
5288 |
100650 |
95176 |
5474 |
5.44 |
06:02:13 |
06:20:13 |
interval # 9, overall |
9 |
5269 |
100811 |
94833 |
5978 |
5.93 |
06:20:14 |
06:38:14 |
interval # 10, overall |
10 |
5372 |
99999 |
96692 |
3307 |
3.31 |
06:38:15 |
06:56:15 |
Done for 135780 ms, from 6:59:52.98 to 7:02:08.76.
TEST_PHASE |
MINUTE_SINCE_TEST_START |
AVG_ESTIMATED |
MIN_TO_AVG_RATIO |
MAX_TO_AVG_RATIO |
ROWS_AGGREGATED |
DISTINCT_ATTACHMENTS |
WARM_TIME |
1 |
5892.13 |
0.7340 |
1.2233 |
2678 |
94 |
WARM_TIME |
2 |
4141.86 |
0.8702 |
1.1352 |
1976 |
78 |
WARM_TIME |
3 |
3376.52 |
0.9284 |
1.0739 |
1390 |
53 |
WARM_TIME |
4 |
2921.21 |
0.9311 |
1.0703 |
1261 |
51 |
WARM_TIME |
5 |
2664.20 |
0.9389 |
1.0544 |
993 |
43 |
WARM_TIME |
6 |
2439.15 |
0.9598 |
1.0398 |
831 |
36 |
WARM_TIME |
7 |
2299.77 |
0.9453 |
1.0453 |
859 |
42 |
WARM_TIME |
8 |
2213.55 |
0.9503 |
1.0506 |
928 |
43 |
WARM_TIME |
9 |
2203.95 |
0.9379 |
1.0505 |
1185 |
53 |
WARM_TIME |
10 |
2174.89 |
0.9581 |
1.0422 |
1182 |
52 |
TEST_TIME |
11 |
2134.96 |
0.9652 |
1.0458 |
957 |
54 |
TEST_TIME |
12 |
2173.77 |
0.9416 |
1.0643 |
1274 |
72 |
TEST_TIME |
13 |
2257.58 |
0.9460 |
1.0550 |
1467 |
82 |
TEST_TIME |
14 |
2362.65 |
0.9361 |
1.0572 |
1507 |
90 |
TEST_TIME |
15 |
2452.37 |
0.9506 |
1.0473 |
1548 |
91 |
TEST_TIME |
16 |
2517.56 |
0.9564 |
1.0469 |
1611 |
94 |
TEST_TIME |
17 |
2587.97 |
0.9585 |
1.0381 |
1552 |
94 |
TEST_TIME |
18 |
2619.97 |
0.9684 |
1.0356 |
1452 |
95 |
TEST_TIME |
19 |
2680.79 |
0.9588 |
1.0360 |
1297 |
98 |
TEST_TIME |
20 |
2717.60 |
0.9708 |
1.0339 |
1332 |
97 |
TEST_TIME |
21 |
2757.17 |
0.9706 |
1.0332 |
1436 |
95 |
TEST_TIME |
22 |
2800.95 |
0.9708 |
1.0249 |
1440 |
90 |
TEST_TIME |
23 |
2826.19 |
0.9716 |
1.0333 |
1362 |
93 |
TEST_TIME |
24 |
2859.76 |
0.9786 |
1.0251 |
1138 |
99 |
TEST_TIME |
25 |
2909.02 |
0.9675 |
1.0368 |
1189 |
100 |
TEST_TIME |
26 |
2982.37 |
0.9724 |
1.0306 |
2095 |
99 |
TEST_TIME |
27 |
3068.79 |
0.9645 |
1.0363 |
2106 |
98 |
TEST_TIME |
28 |
3148.58 |
0.9740 |
1.0260 |
1927 |
96 |
TEST_TIME |
29 |
3223.83 |
0.9675 |
1.0267 |
1927 |
99 |
TEST_TIME |
30 |
3281.89 |
0.9749 |
1.0236 |
1825 |
97 |
TEST_TIME |
31 |
3326.12 |
0.9774 |
1.0228 |
1545 |
97 |
TEST_TIME |
32 |
3384.31 |
0.9738 |
1.0231 |
1579 |
98 |
TEST_TIME |
33 |
3428.47 |
0.9794 |
1.0237 |
1662 |
96 |
TEST_TIME |
34 |
3480.45 |
0.9787 |
1.0213 |
1566 |
95 |
TEST_TIME |
35 |
3516.65 |
0.9819 |
1.0181 |
1542 |
97 |
TEST_TIME |
36 |
3530.65 |
0.9859 |
1.0117 |
1406 |
97 |
TEST_TIME |
37 |
3531.18 |
0.9842 |
1.0169 |
1405 |
94 |
TEST_TIME |
38 |
3562.18 |
0.9815 |
1.0173 |
1362 |
95 |
TEST_TIME |
39 |
3587.99 |
0.9841 |
1.0150 |
1272 |
97 |
TEST_TIME |
40 |
3626.56 |
0.9791 |
1.0249 |
1906 |
96 |
TEST_TIME |
41 |
3692.35 |
0.9821 |
1.0145 |
1467 |
99 |
TEST_TIME |
42 |
3703.88 |
0.9872 |
1.0144 |
1321 |
88 |
TEST_TIME |
43 |
3742.30 |
0.9810 |
1.0209 |
1824 |
92 |
TEST_TIME |
44 |
3810.53 |
0.9798 |
1.0191 |
1679 |
93 |
TEST_TIME |
45 |
3856.05 |
0.9847 |
1.0141 |
1443 |
96 |
TEST_TIME |
46 |
3858.65 |
0.9914 |
1.0119 |
1241 |
84 |
TEST_TIME |
47 |
3895.42 |
0.9810 |
1.0143 |
1387 |
96 |
TEST_TIME |
48 |
3924.22 |
0.9859 |
1.0165 |
1414 |
94 |
TEST_TIME |
49 |
3956.04 |
0.9878 |
1.0131 |
1480 |
99 |
TEST_TIME |
50 |
3975.20 |
0.9882 |
1.0103 |
1315 |
97 |
TEST_TIME |
51 |
3986.03 |
0.9881 |
1.0108 |
1430 |
96 |
TEST_TIME |
52 |
4001.27 |
0.9876 |
1.0104 |
1499 |
94 |
TEST_TIME |
53 |
4004.68 |
0.9905 |
1.0092 |
1237 |
97 |
TEST_TIME |
54 |
4006.88 |
0.9900 |
1.0093 |
1274 |
91 |
TEST_TIME |
55 |
4038.10 |
0.9833 |
1.0146 |
1882 |
95 |
TEST_TIME |
56 |
4086.27 |
0.9848 |
1.0180 |
1649 |
97 |
TEST_TIME |
57 |
4137.40 |
0.9877 |
1.0119 |
1780 |
96 |
TEST_TIME |
58 |
4179.29 |
0.9845 |
1.0147 |
1515 |
94 |
TEST_TIME |
59 |
4213.67 |
0.9894 |
1.0108 |
1411 |
93 |
TEST_TIME |
60 |
4248.24 |
0.9859 |
1.0099 |
1686 |
94 |
TEST_TIME |
61 |
4266.06 |
0.9892 |
1.0103 |
1505 |
98 |
TEST_TIME |
62 |
4278.22 |
0.9912 |
1.0091 |
1449 |
97 |
TEST_TIME |
63 |
4284.56 |
0.9917 |
1.0082 |
1358 |
91 |
TEST_TIME |
64 |
4302.47 |
0.9883 |
1.0090 |
1332 |
92 |
TEST_TIME |
65 |
4313.53 |
0.9909 |
1.0086 |
1359 |
95 |
TEST_TIME |
66 |
4335.89 |
0.9882 |
1.0089 |
1309 |
96 |
TEST_TIME |
67 |
4342.09 |
0.9925 |
1.0075 |
1389 |
92 |
TEST_TIME |
68 |
4349.23 |
0.9912 |
1.0086 |
1328 |
93 |
TEST_TIME |
69 |
4351.76 |
0.9934 |
1.0068 |
1237 |
88 |
TEST_TIME |
70 |
4380.39 |
0.9860 |
1.0124 |
1541 |
97 |
TEST_TIME |
71 |
4415.71 |
0.9902 |
1.0080 |
1634 |
93 |
TEST_TIME |
72 |
4427.30 |
0.9914 |
1.0110 |
1431 |
93 |
TEST_TIME |
73 |
4452.82 |
0.9915 |
1.0091 |
1546 |
95 |
TEST_TIME |
74 |
4470.92 |
0.9915 |
1.0096 |
1585 |
95 |
TEST_TIME |
75 |
4479.03 |
0.9943 |
1.0073 |
1325 |
85 |
TEST_TIME |
76 |
4485.21 |
0.9927 |
1.0078 |
1209 |
90 |
TEST_TIME |
77 |
4501.65 |
0.9911 |
1.0108 |
1357 |
92 |
TEST_TIME |
78 |
4527.36 |
0.9921 |
1.0077 |
1304 |
93 |
TEST_TIME |
79 |
4546.85 |
0.9909 |
1.0059 |
1187 |
90 |
TEST_TIME |
80 |
4555.87 |
0.9914 |
1.0079 |
1275 |
89 |
TEST_TIME |
81 |
4570.58 |
0.9922 |
1.0069 |
1368 |
93 |
TEST_TIME |
82 |
4576.98 |
0.9933 |
1.0063 |
1271 |
92 |
TEST_TIME |
83 |
4583.27 |
0.9928 |
1.0056 |
1157 |
88 |
TEST_TIME |
84 |
4589.37 |
0.9924 |
1.0081 |
1076 |
90 |
TEST_TIME |
85 |
4608.76 |
0.9921 |
1.0070 |
1449 |
95 |
TEST_TIME |
86 |
4615.73 |
0.9938 |
1.0045 |
1012 |
85 |
TEST_TIME |
87 |
4605.13 |
0.9953 |
1.0073 |
1263 |
88 |
TEST_TIME |
88 |
4624.43 |
0.9917 |
1.0072 |
1438 |
94 |
TEST_TIME |
89 |
4647.95 |
0.9908 |
1.0079 |
1507 |
94 |
TEST_TIME |
90 |
4661.11 |
0.9939 |
1.0068 |
1389 |
94 |
TEST_TIME |
91 |
4672.04 |
0.9935 |
1.0062 |
1432 |
95 |
TEST_TIME |
92 |
4676.63 |
0.9943 |
1.0053 |
1389 |
95 |
TEST_TIME |
93 |
4680.48 |
0.9937 |
1.0062 |
1355 |
91 |
TEST_TIME |
94 |
4688.75 |
0.9937 |
1.0064 |
1387 |
93 |
TEST_TIME |
95 |
4695.49 |
0.9944 |
1.0056 |
1227 |
89 |
TEST_TIME |
96 |
4701.02 |
0.9939 |
1.0059 |
1296 |
91 |
TEST_TIME |
97 |
4710.69 |
0.9935 |
1.0060 |
1170 |
93 |
TEST_TIME |
98 |
4717.22 |
0.9944 |
1.0058 |
1127 |
93 |
TEST_TIME |
99 |
4723.64 |
0.9943 |
1.0045 |
1207 |
92 |
TEST_TIME |
100 |
4727.31 |
0.9937 |
1.0055 |
1372 |
94 |
TEST_TIME |
101 |
4738.95 |
0.9931 |
1.0071 |
1574 |
94 |
TEST_TIME |
102 |
4765.64 |
0.9916 |
1.0056 |
1260 |
94 |
TEST_TIME |
103 |
4784.91 |
0.9919 |
1.0066 |
1355 |
94 |
TEST_TIME |
104 |
4798.09 |
0.9942 |
1.0060 |
1331 |
92 |
TEST_TIME |
105 |
4810.63 |
0.9939 |
1.0055 |
1356 |
93 |
TEST_TIME |
106 |
4818.69 |
0.9943 |
1.0052 |
1371 |
91 |
TEST_TIME |
107 |
4824.07 |
0.9947 |
1.0056 |
1315 |
90 |
TEST_TIME |
108 |
4836.61 |
0.9937 |
1.0061 |
1156 |
89 |
TEST_TIME |
109 |
4845.14 |
0.9951 |
1.0059 |
1217 |
93 |
TEST_TIME |
110 |
4846.73 |
0.9965 |
1.0026 |
1133 |
93 |
TEST_TIME |
111 |
4826.71 |
0.9977 |
1.0026 |
1074 |
77 |
TEST_TIME |
112 |
4813.43 |
0.9964 |
1.0039 |
1068 |
77 |
TEST_TIME |
113 |
4815.27 |
0.9947 |
1.0040 |
1277 |
87 |
TEST_TIME |
114 |
4816.23 |
0.9950 |
1.0047 |
1180 |
92 |
TEST_TIME |
115 |
4827.07 |
0.9938 |
1.0049 |
1431 |
91 |
TEST_TIME |
116 |
4832.09 |
0.9954 |
1.0047 |
1386 |
89 |
TEST_TIME |
117 |
4844.22 |
0.9936 |
1.0061 |
1543 |
90 |
TEST_TIME |
118 |
4854.46 |
0.9955 |
1.0052 |
1307 |
89 |
TEST_TIME |
119 |
4865.60 |
0.9945 |
1.0065 |
1397 |
93 |
TEST_TIME |
120 |
4881.06 |
0.9949 |
1.0047 |
1244 |
91 |
TEST_TIME |
121 |
4884.38 |
0.9957 |
1.0040 |
1292 |
89 |
TEST_TIME |
122 |
4891.20 |
0.9944 |
1.0053 |
1213 |
89 |
TEST_TIME |
123 |
4902.28 |
0.9949 |
1.0053 |
1123 |
86 |
TEST_TIME |
124 |
4909.82 |
0.9956 |
1.0065 |
1047 |
88 |
TEST_TIME |
125 |
4922.80 |
0.9959 |
1.0034 |
998 |
90 |
TEST_TIME |
126 |
4915.13 |
0.9970 |
1.0031 |
1094 |
81 |
TEST_TIME |
127 |
4922.34 |
0.9938 |
1.0046 |
1184 |
92 |
TEST_TIME |
128 |
4924.81 |
0.9962 |
1.0042 |
1130 |
92 |
TEST_TIME |
129 |
4925.05 |
0.9964 |
1.0042 |
1191 |
88 |
TEST_TIME |
130 |
4934.31 |
0.9947 |
1.0057 |
1530 |
94 |
TEST_TIME |
131 |
4947.33 |
0.9954 |
1.0043 |
1527 |
95 |
TEST_TIME |
132 |
4958.95 |
0.9944 |
1.0046 |
1420 |
94 |
TEST_TIME |
133 |
4965.50 |
0.9957 |
1.0042 |
1353 |
92 |
TEST_TIME |
134 |
4971.10 |
0.9956 |
1.0038 |
1417 |
92 |
TEST_TIME |
135 |
4978.56 |
0.9948 |
1.0051 |
1212 |
91 |
TEST_TIME |
136 |
4990.44 |
0.9954 |
1.0045 |
1325 |
89 |
TEST_TIME |
137 |
4997.54 |
0.9958 |
1.0040 |
1194 |
90 |
TEST_TIME |
138 |
5001.19 |
0.9960 |
1.0032 |
1289 |
93 |
TEST_TIME |
139 |
4999.47 |
0.9963 |
1.0033 |
1201 |
89 |
TEST_TIME |
140 |
4996.44 |
0.9967 |
1.0031 |
1142 |
89 |
TEST_TIME |
141 |
4994.59 |
0.9965 |
1.0038 |
1259 |
94 |
TEST_TIME |
142 |
4998.23 |
0.9960 |
1.0044 |
1099 |
96 |
TEST_TIME |
143 |
5001.29 |
0.9968 |
1.0031 |
1196 |
90 |
TEST_TIME |
144 |
4995.17 |
0.9974 |
1.0030 |
1185 |
91 |
TEST_TIME |
145 |
4992.04 |
0.9967 |
1.0043 |
1534 |
95 |
TEST_TIME |
146 |
4997.49 |
0.9964 |
1.0031 |
1430 |
93 |
TEST_TIME |
147 |
5002.22 |
0.9953 |
1.0037 |
1407 |
90 |
TEST_TIME |
148 |
5003.10 |
0.9968 |
1.0038 |
1242 |
92 |
TEST_TIME |
149 |
5002.76 |
0.9971 |
1.0027 |
1133 |
85 |
TEST_TIME |
150 |
5000.79 |
0.9964 |
1.0046 |
1049 |
86 |
TEST_TIME |
151 |
5009.03 |
0.9963 |
1.0034 |
1173 |
90 |
TEST_TIME |
152 |
5011.31 |
0.9964 |
1.0040 |
1058 |
90 |
TEST_TIME |
153 |
5017.15 |
0.9963 |
1.0034 |
1397 |
91 |
TEST_TIME |
154 |
5015.83 |
0.9972 |
1.0044 |
1245 |
91 |
TEST_TIME |
155 |
5025.95 |
0.9959 |
1.0034 |
1090 |
90 |
TEST_TIME |
156 |
5033.23 |
0.9955 |
1.0038 |
1086 |
91 |
TEST_TIME |
157 |
5031.87 |
0.9976 |
1.0026 |
1055 |
90 |
TEST_TIME |
158 |
5026.59 |
0.9973 |
1.0031 |
1161 |
91 |
TEST_TIME |
159 |
5024.13 |
0.9973 |
1.0033 |
1106 |
90 |
TEST_TIME |
160 |
5029.13 |
0.9961 |
1.0029 |
1193 |
91 |
TEST_TIME |
161 |
5020.76 |
0.9983 |
1.0016 |
867 |
71 |
TEST_TIME |
162 |
5011.22 |
0.9973 |
1.0035 |
1097 |
82 |
TEST_TIME |
163 |
5014.03 |
0.9968 |
1.0031 |
1184 |
84 |
TEST_TIME |
164 |
5019.31 |
0.9959 |
1.0038 |
1232 |
89 |
TEST_TIME |
165 |
5032.22 |
0.9952 |
1.0032 |
1387 |
95 |
TEST_TIME |
166 |
5031.44 |
0.9973 |
1.0030 |
1398 |
91 |
TEST_TIME |
167 |
5029.63 |
0.9973 |
1.0023 |
1352 |
89 |
TEST_TIME |
168 |
5041.09 |
0.9942 |
1.0032 |
1282 |
95 |
TEST_TIME |
169 |
5039.81 |
0.9975 |
1.0029 |
1171 |
92 |
TEST_TIME |
170 |
5039.03 |
0.9972 |
1.0027 |
1102 |
94 |
TEST_TIME |
171 |
5038.33 |
0.9969 |
1.0040 |
1184 |
92 |
TEST_TIME |
172 |
5041.91 |
0.9975 |
1.0030 |
1124 |
91 |
TEST_TIME |
173 |
5045.60 |
0.9966 |
1.0029 |
1029 |
90 |
TEST_TIME |
174 |
5042.74 |
0.9977 |
1.0027 |
1052 |
88 |
TEST_TIME |
175 |
5043.75 |
0.9967 |
1.0034 |
1301 |
90 |
TEST_TIME |
176 |
5047.50 |
0.9970 |
1.0027 |
1338 |
88 |
TEST_TIME |
177 |
5057.30 |
0.9951 |
1.0046 |
1472 |
92 |
TEST_TIME |
178 |
5065.63 |
0.9973 |
1.0029 |
1284 |
91 |
TEST_TIME |
179 |
5067.04 |
0.9971 |
1.0028 |
1056 |
85 |
TEST_TIME |
180 |
5067.52 |
0.9971 |
1.0024 |
1151 |
88 |
TEST_TIME |
181 |
5064.96 |
0.9973 |
1.0022 |
1237 |
87 |
TEST_TIME |
182 |
5063.61 |
0.9969 |
1.0022 |
1274 |
87 |
TEST_TIME |
183 |
5060.19 |
0.9975 |
1.0022 |
1211 |
88 |
TEST_TIME |
184 |
5061.23 |
0.9966 |
1.0026 |
1118 |
89 |
TEST_TIME |
185 |
5064.97 |
0.9964 |
1.0035 |
1161 |
90 |
TEST_TIME |
186 |
5067.56 |
0.9976 |
1.0032 |
1015 |
88 |
TEST_TIME |
187 |
5072.89 |
0.9968 |
1.0030 |
1083 |
90 |
TEST_TIME |
188 |
5079.06 |
0.9965 |
1.0026 |
1099 |
91 |
TEST_TIME |
189 |
5079.42 |
0.9972 |
1.0024 |
1096 |
92 |
TEST_TIME |
190 |
5070.01 |
0.9990 |
1.0047 |
189 |
100 |
Done for 15830 ms, from 7:02:10.52 to 7:02:26.35.
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 |
5418 |
3523 |
2809 |
<null> |
3352 |
<null> |
6121 |
<null> |
8924 |
1540 |
5477 |
1812 |
8494 |
<null> |
43330 |
1752 |
195204 |
250692 |
<null> |
03:56:06 |
04:14:06 |
fetches per second |
2 |
1642 |
5009 |
2752 |
2874 |
2999 |
<null> |
5881 |
2861 |
3336 |
3047 |
2931 |
2650 |
15694 |
<null> |
18873 |
<null> |
241679 |
167723 |
<null> |
04:14:07 |
04:32:07 |
fetches per second |
3 |
1596 |
4138 |
2847 |
<null> |
3346 |
3316 |
6689 |
3163 |
10878 |
2793 |
5014 |
2068 |
13849 |
2586 |
22266 |
3693 |
261735 |
137632 |
<null> |
04:32:08 |
04:50:08 |
fetches per second |
4 |
1665 |
4614 |
3066 |
<null> |
3622 |
<null> |
7682 |
<null> |
10283 |
2864 |
3495 |
3153 |
18082 |
2281 |
17021 |
<null> |
310143 |
217157 |
<null> |
04:50:09 |
05:08:09 |
fetches per second |
5 |
1555 |
4380 |
3210 |
<null> |
3501 |
2462 |
7325 |
4360 |
9375 |
3095 |
2926 |
3177 |
17264 |
2267 |
23720 |
1755 |
325770 |
<null> |
<null> |
05:08:10 |
05:26:10 |
fetches per second |
6 |
1510 |
4146 |
3962 |
2408 |
4303 |
2460 |
8388 |
3483 |
16017 |
2623 |
7578 |
2835 |
21871 |
2397 |
19559 |
2221 |
336705 |
219619 |
<null> |
05:26:11 |
05:44:11 |
fetches per second |
7 |
1561 |
4795 |
3290 |
<null> |
3970 |
2488 |
8195 |
3190 |
17915 |
3520 |
4202 |
2073 |
17583 |
3703 |
21974 |
2215 |
291778 |
258262 |
<null> |
05:44:12 |
06:02:12 |
fetches per second |
8 |
1411 |
5368 |
3762 |
<null> |
5022 |
2570 |
9321 |
3834 |
15863 |
2369 |
4928 |
2693 |
18750 |
2198 |
23489 |
2885 |
<null> |
228916 |
<null> |
06:02:13 |
06:20:13 |
fetches per second |
9 |
1635 |
3835 |
3360 |
<null> |
3652 |
2598 |
8177 |
3394 |
4944 |
2375 |
4368 |
2349 |
30952 |
2067 |
18002 |
2127 |
309643 |
214712 |
<null> |
06:20:14 |
06:38:14 |
fetches per second |
10 |
1524 |
4080 |
3481 |
<null> |
4089 |
<null> |
8174 |
3414 |
29236 |
2379 |
4247 |
1857 |
27012 |
1591 |
16571 |
1739 |
347668 |
289625 |
<null> |
06:38:15 |
06:56:15 |
marks per second |
1 |
1069 |
422 |
281 |
<null> |
260 |
<null> |
352 |
<null> |
405 |
333 |
953 |
278 |
440 |
<null> |
1106 |
290 |
1709 |
711 |
<null> |
03:56:06 |
04:14:06 |
marks per second |
2 |
329 |
610 |
288 |
637 |
296 |
<null> |
402 |
404 |
331 |
498 |
417 |
408 |
497 |
<null> |
510 |
<null> |
1495 |
721 |
<null> |
04:14:07 |
04:32:07 |
marks per second |
3 |
316 |
548 |
271 |
<null> |
312 |
710 |
412 |
439 |
371 |
381 |
493 |
291 |
512 |
448 |
541 |
526 |
1235 |
728 |
<null> |
04:32:08 |
04:50:08 |
marks per second |
4 |
321 |
584 |
272 |
<null> |
292 |
<null> |
361 |
<null> |
648 |
381 |
454 |
487 |
435 |
438 |
489 |
<null> |
2298 |
1189 |
<null> |
04:50:09 |
05:08:09 |
marks per second |
5 |
301 |
557 |
276 |
<null> |
334 |
553 |
392 |
580 |
411 |
495 |
395 |
464 |
455 |
345 |
451 |
297 |
1231 |
<null> |
<null> |
05:08:10 |
05:26:10 |
marks per second |
6 |
297 |
554 |
285 |
551 |
291 |
552 |
382 |
466 |
488 |
369 |
411 |
462 |
390 |
312 |
434 |
400 |
1183 |
396 |
<null> |
05:26:11 |
05:44:11 |
marks per second |
7 |
308 |
612 |
270 |
<null> |
334 |
573 |
406 |
405 |
371 |
520 |
425 |
342 |
1087 |
543 |
485 |
394 |
1355 |
2494 |
<null> |
05:44:12 |
06:02:12 |
marks per second |
8 |
282 |
725 |
277 |
<null> |
262 |
560 |
395 |
509 |
384 |
379 |
382 |
373 |
426 |
323 |
489 |
526 |
<null> |
570 |
<null> |
06:02:13 |
06:20:13 |
marks per second |
9 |
314 |
472 |
278 |
<null> |
296 |
627 |
412 |
454 |
876 |
392 |
394 |
348 |
375 |
317 |
423 |
345 |
1489 |
755 |
<null> |
06:20:14 |
06:38:14 |
marks per second |
10 |
303 |
500 |
267 |
<null> |
275 |
<null> |
513 |
467 |
515 |
360 |
401 |
261 |
362 |
217 |
410 |
333 |
1194 |
775 |
<null> |
06:38:15 |
06:56:15 |
reads/fetches*100 |
1 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
<null> |
03:56:06 |
04:14:06 |
reads/fetches*100 |
2 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
<null> |
04:14:07 |
04:32:07 |
reads/fetches*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:32:08 |
04:50:08 |
reads/fetches*100 |
4 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
04:50:09 |
05:08:09 |
reads/fetches*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
05:08:10 |
05:26:10 |
reads/fetches*100 |
6 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:26:11 |
05:44:11 |
reads/fetches*100 |
7 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:44:12 |
06:02:12 |
reads/fetches*100 |
8 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
06:02:13 |
06:20:13 |
reads/fetches*100 |
9 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
06:20:14 |
06:38:14 |
reads/fetches*100 |
10 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
06:38:15 |
06:56:15 |
writes/marks*100 |
1 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
1 |
1 |
0 |
0 |
0 |
<null> |
0 |
0 |
6 |
0 |
<null> |
03:56:06 |
04:14:06 |
writes/marks*100 |
2 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
<null> |
0 |
<null> |
2 |
0 |
<null> |
04:14:07 |
04:32:07 |
writes/marks*100 |
3 |
1 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
1 |
4 |
0 |
<null> |
04:32:08 |
04:50:08 |
writes/marks*100 |
4 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
5 |
1 |
<null> |
04:50:09 |
05:08:09 |
writes/marks*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
4 |
<null> |
<null> |
05:08:10 |
05:26:10 |
writes/marks*100 |
6 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
3 |
0 |
0 |
0 |
0 |
0 |
1 |
3 |
0 |
<null> |
05:26:11 |
05:44:11 |
writes/marks*100 |
7 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
4 |
0 |
<null> |
05:44:12 |
06:02:12 |
writes/marks*100 |
8 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
1 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
06:02:13 |
06:20:13 |
writes/marks*100 |
9 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
4 |
0 |
<null> |
06:20:14 |
06:38:14 |
writes/marks*100 |
10 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
3 |
0 |
<null> |
06:38:15 |
06:56:15 |
Done for 15050 ms, from 7:02:27.50 to 7:02:42.55.
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 |
1594838 |
1547625 |
47213 |
2.96 |
0 |
13564 |
24 |
47213 |
2016-11-27 03:56 |
2016-11-27 06:56 |
doc_list_biud |
1595245 |
1547624 |
47621 |
2.98 |
0 |
18292 |
44 |
47621 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_add_invoice_to_stock |
17309 |
11518 |
5791 |
33.45 |
26 |
229457 |
21866 |
5791 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_cancel_adding_invoice |
3581 |
2917 |
664 |
18.54 |
119 |
153637 |
4907 |
664 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_cancel_client_order |
5927 |
5648 |
279 |
4.70 |
3 |
2252 |
76 |
279 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_cancel_customer_reserve |
192187 |
148873 |
43314 |
22.53 |
1 |
18335 |
142 |
43314 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_cancel_pay_from_customer |
2310 |
2282 |
28 |
1.21 |
3 |
3356 |
103 |
28 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_cancel_pay_to_supplier |
1376 |
1353 |
23 |
1.67 |
9 |
967 |
143 |
23 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_cancel_supplier_invoice |
7588 |
6350 |
1238 |
16.31 |
38 |
9780 |
2440 |
1238 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_cancel_supplier_order |
1404 |
429 |
975 |
69.44 |
43 |
454396 |
78523 |
975 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_cancel_write_off |
12081 |
9257 |
2824 |
23.37 |
2 |
2721 |
229 |
2824 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_client_order |
72171 |
72171 |
0 |
0.00 |
5 |
18832 |
1033 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_customer_reserve |
561877 |
561877 |
0 |
0.00 |
1 |
23227 |
382 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_fill_shopping_cart |
109026 |
109026 |
0 |
0.00 |
1 |
13395 |
215 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_fill_shopping_cart_clo_res |
561877 |
561877 |
0 |
0.00 |
0 |
5979 |
1 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_get_clo_for_invoice |
11518 |
11518 |
0 |
0.00 |
1 |
17921 |
1043 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_kill_cost_storno |
19023 |
15809 |
3214 |
16.89 |
0 |
3265 |
80 |
3214 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_kill_qstorno_ret_qs2qd |
403767 |
313782 |
89985 |
22.28 |
0 |
10059 |
111 |
89985 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_kill_qty_storno |
265599 |
218078 |
47521 |
17.89 |
0 |
18289 |
306 |
47521 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_lock_selected_doc |
70841 |
61869 |
8972 |
12.66 |
0 |
692 |
3 |
8972 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_make_cost_storno |
88603 |
88603 |
0 |
0.00 |
0 |
10671 |
228 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_multiply_rows_for_pdistr |
88602 |
88602 |
0 |
0.00 |
0 |
4271 |
147 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_multiply_rows_for_qdistr |
72174 |
72174 |
0 |
0.00 |
0 |
17860 |
766 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_pay_from_customer |
24197 |
24197 |
0 |
0.00 |
15 |
8183 |
306 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_pay_to_supplier |
19800 |
19800 |
0 |
0.00 |
12 |
15685 |
670 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_payment_common |
43997 |
43997 |
0 |
0.00 |
2 |
7171 |
33 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_qd_handle_on_cancel_clo |
5926 |
5648 |
278 |
4.69 |
0 |
550 |
50 |
278 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_qd_handle_on_invoice_upd_sts |
14915 |
14435 |
480 |
3.21 |
1 |
8043 |
1831 |
480 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_qd_handle_on_reserve_upd_sts |
33087 |
33086 |
1 |
0.00 |
0 |
3820 |
132 |
1 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_reserve_write_off |
34145 |
33086 |
1059 |
3.10 |
6 |
17672 |
337 |
1059 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_supplier_invoice |
18559 |
18559 |
0 |
0.00 |
30 |
48392 |
11491 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
sp_supplier_order |
18296 |
18296 |
0 |
0.00 |
11 |
29185 |
7396 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
srv_find_qd_qs_mism |
906225 |
859059 |
47166 |
5.20 |
0 |
2729 |
2 |
47166 |
2016-11-27 03:56 |
2016-11-27 06:56 |
srv_make_invnt_saldo |
3842 |
3842 |
0 |
0.00 |
166 |
44394 |
1319 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
srv_make_money_saldo |
4189 |
4189 |
0 |
0.00 |
3 |
1763 |
56 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
2299 |
20024 |
4690 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-abend:sp_add_invoice_to_stock |
5791 |
5791 |
0 |
0.00 |
1 |
680 |
143 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-abend:sp_cancel_adding_invoice |
547 |
547 |
0 |
0.00 |
10 |
2812 |
1144 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-abend:sp_cancel_client_order |
279 |
279 |
0 |
0.00 |
49 |
461 |
223 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-abend:sp_cancel_customer_reserve |
78 |
78 |
0 |
0.00 |
21 |
311 |
145 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-abend:sp_cancel_pay_from_customer |
28 |
28 |
0 |
0.00 |
105 |
404 |
213 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-abend:sp_cancel_pay_to_supplier |
23 |
23 |
0 |
0.00 |
45 |
369 |
231 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-abend:sp_cancel_supplier_invoice |
446 |
446 |
0 |
0.00 |
2 |
501 |
137 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-abend:sp_cancel_supplier_order |
5889 |
5889 |
0 |
0.00 |
6 |
4301 |
1523 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-abend:sp_cancel_write_off |
63 |
63 |
0 |
0.00 |
72 |
289 |
146 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-abend:sp_reserve_write_off |
1059 |
1059 |
0 |
0.00 |
1 |
1557 |
141 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-norm:sp_add_invoice_to_stock |
11579 |
11579 |
0 |
0.00 |
2 |
48698 |
10688 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-norm:sp_cancel_adding_invoice |
1198 |
1198 |
0 |
0.00 |
20 |
31995 |
9004 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-norm:sp_cancel_client_order |
5648 |
5648 |
0 |
0.00 |
0 |
1745 |
253 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-norm:sp_cancel_customer_reserve |
2205 |
2205 |
0 |
0.00 |
1 |
641 |
279 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-norm:sp_cancel_pay_from_customer |
2282 |
2282 |
0 |
0.00 |
0 |
711 |
196 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-norm:sp_cancel_pay_to_supplier |
1353 |
1353 |
0 |
0.00 |
1 |
574 |
196 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-norm:sp_cancel_supplier_invoice |
909 |
909 |
0 |
0.00 |
2 |
1492 |
249 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-norm:sp_cancel_supplier_order |
429 |
429 |
0 |
0.00 |
3 |
336874 |
48818 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-norm:sp_cancel_write_off |
3241 |
3241 |
0 |
0.00 |
0 |
785 |
277 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-norm:sp_client_order |
72179 |
72179 |
0 |
0.00 |
0 |
2781 |
336 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-norm:sp_customer_reserve |
3378 |
3378 |
0 |
0.00 |
0 |
811 |
186 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-norm:sp_pay_from_customer |
24197 |
24197 |
0 |
0.00 |
0 |
1787 |
227 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-norm:sp_pay_to_supplier |
19803 |
19803 |
0 |
0.00 |
0 |
2399 |
226 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-norm:sp_reserve_write_off |
33087 |
33087 |
0 |
0.00 |
0 |
1920 |
309 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-norm:sp_supplier_invoice |
18568 |
18568 |
0 |
0.00 |
1 |
1996 |
338 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-norm:sp_supplier_order |
18302 |
18302 |
0 |
0.00 |
0 |
2384 |
339 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-norm:srv_make_invnt_saldo |
3842 |
3842 |
0 |
0.00 |
0 |
233 |
28 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-norm:srv_make_money_saldo |
4189 |
4189 |
0 |
0.00 |
0 |
324 |
31 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
t$perf-norm:srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
886 |
2509 |
1391 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
v_add_invoice_to_stock |
34618 |
23036 |
11582 |
33.45 |
0 |
415 |
5 |
11582 |
2016-11-27 03:56 |
2016-11-27 06:56 |
v_all_customers |
108832 |
108832 |
0 |
0.00 |
0 |
283 |
5 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
v_all_suppliers |
74184 |
74184 |
0 |
0.00 |
0 |
195 |
6 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
v_all_wares |
144342 |
144342 |
0 |
0.00 |
0 |
278 |
9 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
v_cancel_adding_invoice |
2856 |
2396 |
460 |
16.10 |
0 |
525 |
54 |
460 |
2016-11-27 03:56 |
2016-11-27 06:56 |
v_cancel_client_order |
11854 |
11296 |
558 |
4.70 |
0 |
119 |
5 |
558 |
2016-11-27 03:56 |
2016-11-27 06:56 |
v_cancel_customer_prepayment |
4620 |
4564 |
56 |
1.21 |
0 |
126 |
5 |
56 |
2016-11-27 03:56 |
2016-11-27 06:56 |
v_cancel_customer_reserve |
4566 |
4410 |
156 |
3.41 |
0 |
167 |
6 |
156 |
2016-11-27 03:56 |
2016-11-27 06:56 |
v_cancel_payment_to_supplier |
2752 |
2706 |
46 |
1.67 |
1 |
83 |
6 |
46 |
2016-11-27 03:56 |
2016-11-27 06:56 |
v_cancel_supplier_invoice |
2710 |
1818 |
892 |
32.91 |
0 |
77 |
6 |
892 |
2016-11-27 03:56 |
2016-11-27 06:56 |
v_cancel_supplier_order |
2808 |
858 |
1950 |
69.44 |
1 |
103 |
6 |
1950 |
2016-11-27 03:56 |
2016-11-27 06:56 |
v_cancel_write_off |
6608 |
6482 |
126 |
1.90 |
0 |
405 |
29 |
126 |
2016-11-27 03:56 |
2016-11-27 06:56 |
v_max_id_clo_ord |
18296 |
18296 |
0 |
0.00 |
0 |
774 |
16 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
v_max_id_clo_res |
3378 |
3378 |
0 |
0.00 |
1 |
243 |
22 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
v_max_id_ord_sup |
18559 |
18559 |
0 |
0.00 |
0 |
458 |
16 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
v_max_non_paid_invoice |
19563 |
19563 |
0 |
0.00 |
0 |
677 |
7 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
v_max_non_paid_realizn |
24197 |
24197 |
0 |
0.00 |
0 |
732 |
6 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
v_min_id_clo_ord |
18296 |
18296 |
0 |
0.00 |
0 |
482 |
11 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
v_min_id_clo_res |
3378 |
3378 |
0 |
0.00 |
0 |
2468 |
12 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
v_min_id_ord_sup |
18559 |
18559 |
0 |
0.00 |
0 |
319 |
12 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
v_min_non_paid_invoice |
19800 |
19800 |
0 |
0.00 |
0 |
7153 |
26 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
v_min_non_paid_realizn |
24197 |
24197 |
0 |
0.00 |
0 |
685 |
5 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
v_our_firm |
35510 |
35510 |
0 |
0.00 |
0 |
244 |
5 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
v_reserve_write_off |
68290 |
66172 |
2118 |
3.10 |
0 |
407 |
5 |
2118 |
2016-11-27 03:56 |
2016-11-27 06:56 |
x_lock_depdocs_on_canc_invoice |
12939 |
8358 |
4581 |
35.40 |
0 |
1237 |
8 |
4581 |
2016-11-27 03:56 |
2016-11-27 06:56 |
x_lock_depdocs_on_canc_sup_ord |
1402 |
429 |
973 |
69.40 |
0 |
80 |
5 |
973 |
2016-11-27 03:56 |
2016-11-27 06:56 |
x_make_qstorno_1000_1200 |
18296 |
18296 |
0 |
0.00 |
3 |
25709 |
6848 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
x_make_qstorno_1200_2000 |
18561 |
18561 |
0 |
0.00 |
22 |
47640 |
10981 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
x_make_qstorno_2100_3300 |
561877 |
561877 |
0 |
0.00 |
0 |
23140 |
379 |
0 |
2016-11-27 03:56 |
2016-11-27 06:56 |
Done for 248580 ms, from 7:07:21.78 to 7:11:30.36.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
DTS_BEG |
DTS_END |
deadlock |
130 |
sp_kill_cost_storno |
335544336 |
2016-11-27 03:56 |
2016-11-27 06:46 |
deadlock |
12 |
sp_kill_qstorno_ret_qs2qd |
335544336 |
2016-11-27 04:02 |
2016-11-27 06:15 |
deadlock |
84 |
sp_lock_selected_doc |
335544336 |
2016-11-27 03:59 |
2016-11-27 06:52 |
deadlock |
278 |
sp_qd_handle_on_cancel_clo |
335544336 |
2016-11-27 03:56 |
2016-11-27 06:55 |
deadlock |
80 |
sp_qd_handle_on_invoice_upd_sts |
335544336 |
2016-11-27 03:56 |
2016-11-27 06:46 |
deadlock |
1 |
sp_qd_handle_on_reserve_upd_sts |
335544336 |
2016-11-27 04:02 |
2016-11-27 04:02 |
deadlock |
2 |
x_lock_depdocs_on_canc_invoice |
335544336 |
2016-11-27 04:14 |
2016-11-27 05:28 |
concurrent_transaction |
7386 |
sp_lock_selected_doc |
335544878 |
2016-11-27 03:56 |
2016-11-27 06:56 |
concurrent_transaction |
489 |
x_lock_depdocs_on_canc_invoice |
335544878 |
2016-11-27 03:56 |
2016-11-27 06:54 |
concurrent_transaction |
507 |
x_lock_depdocs_on_canc_sup_ord |
335544878 |
2016-11-27 03:56 |
2016-11-27 06:55 |
Done for 7070 ms, from 7:11:37.70 to 7:11:44.77.
MON$DATABASE_NAME D:\OLTP-EMUL\OLTP30-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 337912
MON$OLDEST_ACTIVE 337913
MON$OLDEST_SNAPSHOT 337913
MON$NEXT_TRANSACTION 337913
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 2015-12-11 13:07:49.8140
MON$PAGES 713984
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-V3.0.2.32641 Firebird 3.0
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.2.32641 Firebird 3.0"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.2.32641 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P14"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.2.32641 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P14"
on disk structure version 12.0
Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB"
Database header page information:
Flags 0
Generation 338264
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 337914
Oldest active 337915
Oldest snapshot 337915
Next transaction 337916
Sequence number 0
Next attachment ID 5156
Implementation HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Dec 11, 2015 13:07:49
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: 34.24, 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.05
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: 45
Average key length: 2.04, compression ratio: 0.53
Average prefix length: 1.02, 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.92, total dup: 0, max dup: 0
Average key length: 16.60, compression ratio: 0.92
Average prefix length: 1.34, average data length: 13.92
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: 103.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: 996.00, compression ratio: 9.67
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 28%
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.06, total records: 1691869
Average version length: 47.74, total versions: 8840, 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: 12, data page slots: 18936
Data pages: 18936, average fill: 71%
Primary pages: 18936, secondary pages: 0, swept pages: 13312
Empty pages: 0, full pages: 7532
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 272
60 - 79% = 18664
80 - 99% = 0
Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 19783, depth: 3, leaf buckets: 7778, nodes: 1691869
Average node length: 20.00, total dup: 0, max dup: 0
Average key length: 17.06, compression ratio: 1.58
Average prefix length: 12.94, average data length: 14.06
Clustering factor: 669634, ratio: 0.40
Fill distribution:
0 - 19% = 252
20 - 39% = 399
40 - 59% = 5053
60 - 79% = 1448
80 - 99% = 626
Index DOC_DATA_ID_DESC (2)
Root page: 46992, depth: 3, leaf buckets: 6010, nodes: 1691869
Average node length: 11.61, total dup: 0, max dup: 0
Average key length: 8.67, compression ratio: 1.04
Average prefix length: 3.33, average data length: 5.67
Clustering factor: 615135, ratio: 0.36
Fill distribution:
0 - 19% = 0
20 - 39% = 2837
40 - 59% = 3170
60 - 79% = 3
80 - 99% = 0
Index FK_DOC_DATA_DOC_LIST (3)
Root page: 97996, depth: 3, leaf buckets: 3150, nodes: 1691869
Average node length: 7.18, total dup: 1148565, max dup: 49
Average key length: 4.24, compression ratio: 2.12
Average prefix length: 7.08, average data length: 1.92
Clustering factor: 627962, ratio: 0.37
Fill distribution:
0 - 19% = 79
20 - 39% = 534
40 - 59% = 2231
60 - 79% = 100
80 - 99% = 206
DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 59.94, total records: 594192
Average version length: 36.38, total versions: 6244, max versions: 4
Average fragment length: 7.63, total fragments: 73, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.60
Pointer pages: 5, data page slots: 7840
Data pages: 7840, average fill: 72%
Primary pages: 7831, secondary pages: 9, swept pages: 6709
Empty pages: 5, full pages: 4508
Fill distribution:
0 - 19% = 15
20 - 39% = 5
40 - 59% = 178
60 - 79% = 7595
80 - 99% = 47
Index DOC_LIST_ID_DESC (1)
Root page: 228962, depth: 3, leaf buckets: 2256, nodes: 594192
Average node length: 11.78, total dup: 0, max dup: 0
Average key length: 8.92, compression ratio: 1.01
Average prefix length: 3.08, average data length: 5.92
Clustering factor: 176887, ratio: 0.30
Fill distribution:
0 - 19% = 0
20 - 39% = 1359
40 - 59% = 895
60 - 79% = 2
80 - 99% = 0
Index FK_DOC_LIST_AGENTS (2)
Root page: 2964, depth: 2, leaf buckets: 663, nodes: 594192
Average node length: 4.87, total dup: 594142, max dup: 44584
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 285343, ratio: 0.48
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 604
60 - 79% = 39
80 - 99% = 18
Index PK_DOC_LIST (0)
Root page: 255127, depth: 3, leaf buckets: 2124, nodes: 594192
Average node length: 11.78, total dup: 0, max dup: 0
Average key length: 8.92, compression ratio: 1.01
Average prefix length: 3.08, average data length: 5.92
Clustering factor: 176887, ratio: 0.30
Fill distribution:
0 - 19% = 53
20 - 39% = 1035
40 - 59% = 959
60 - 79% = 4
80 - 99% = 73
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: 269, Index root page: 270
Total formats: 1, used formats: 1
Average record length: 64.12, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 17.69, total fragments: 399, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.62
Pointer pages: 3, data page slots: 1518
Data pages: 28, average fill: 24%
Primary pages: 4, secondary pages: 24, swept pages: 4
Empty pages: 12, full pages: 3
Fill distribution:
0 - 19% = 16
20 - 39% = 7
40 - 59% = 1
60 - 79% = 1
80 - 99% = 3
Index PK_INVNT_SALDO (0)
Root page: 281, 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: 262, ratio: 0.66
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: 65.90, total records: 11259
Average version length: 71.19, total versions: 819, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.46
Pointer pages: 3, data page slots: 3912
Data pages: 2152, average fill: 8%
Primary pages: 2151, secondary pages: 1, swept pages: 2115
Empty pages: 234, full pages: 12
Fill distribution:
0 - 19% = 2066
20 - 39% = 56
40 - 59% = 16
60 - 79% = 12
80 - 99% = 2
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 997, depth: 2, leaf buckets: 53, nodes: 11259
Average node length: 14.32, total dup: 1309, max dup: 1
Average key length: 11.41, compression ratio: 2.37
Average prefix length: 18.47, average data length: 8.53
Clustering factor: 9281, ratio: 0.82
Fill distribution:
0 - 19% = 1
20 - 39% = 31
40 - 59% = 17
60 - 79% = 4
80 - 99% = 0
MONEY_SALDO (143)
Primary pointer page: 261, Index root page: 262
Total formats: 1, used formats: 1
Average record length: 15.10, 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.12
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 20%
Primary pages: 1, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MONEY_SALDO (0)
Root page: 272, 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: 259, Index root page: 260
Total formats: 1, used formats: 1
Average record length: 4.42, total records: 2311
Average version length: 45.52, total versions: 2099, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 14.49
Pointer pages: 1, data page slots: 136
Data pages: 119, average fill: 23%
Primary pages: 118, secondary pages: 1, swept pages: 36
Empty pages: 34, full pages: 13
Fill distribution:
0 - 19% = 86
20 - 39% = 8
40 - 59% = 8
60 - 79% = 5
80 - 99% = 12
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 94637, depth: 2, leaf buckets: 5, nodes: 2311
Average node length: 4.31, total dup: 2234, max dup: 281
Average key length: 2.44, compression ratio: 7.79
Average prefix length: 18.59, average data length: 0.41
Clustering factor: 1164, ratio: 0.50
Fill distribution:
0 - 19% = 1
20 - 39% = 4
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG (164)
Primary pointer page: 352, Index root page: 353
Total formats: 2, 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: 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_GDSCODE (2)
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
Index MON_LOG_ROWSET_DESC (1)
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
Index MON_LOG_UNIT (3)
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 PK_MON_LOG (0)
Root page: 359, 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 (165)
Primary pointer page: 364, Index root page: 365
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: 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_GDSCODE (2)
Root page: 368, 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: 367, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_TN_UNIT (3)
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
Index PK_MON_LOG_TABLE_STATS (0)
Root page: 366, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
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: 41.24, total records: 250349
Average version length: 32.01, total versions: 10135, max versions: 14
Average fragment length: 33.45, total fragments: 44, max fragments: 1
Average unpacked length: 64.00, compression ratio: 1.55
Pointer pages: 3, data page slots: 3504
Data pages: 3504, average fill: 55%
Primary pages: 3468, secondary pages: 36, swept pages: 2822
Empty pages: 13, full pages: 291
Fill distribution:
0 - 19% = 116
20 - 39% = 510
40 - 59% = 1261
60 - 79% = 1584
80 - 99% = 33
Index PDISTR_AGENT_ID (4)
Root page: 3600, depth: 2, leaf buckets: 237, nodes: 250349
Average node length: 4.63, total dup: 250300, max dup: 12176
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 35936, ratio: 0.14
Fill distribution:
0 - 19% = 0
20 - 39% = 23
40 - 59% = 100
60 - 79% = 83
80 - 99% = 31
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4281, depth: 2, leaf buckets: 288, nodes: 250349
Average node length: 5.60, total dup: 225300, max dup: 29
Average key length: 2.98, compression ratio: 7.38
Average prefix length: 21.12, average data length: 0.88
Clustering factor: 42442, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 34
40 - 59% = 114
60 - 79% = 89
80 - 99% = 51
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3974, depth: 2, leaf buckets: 290, nodes: 250349
Average node length: 5.61, total dup: 225300, max dup: 29
Average key length: 2.98, compression ratio: 7.38
Average prefix length: 21.12, average data length: 0.88
Clustering factor: 42587, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 29
40 - 59% = 112
60 - 79% = 114
80 - 99% = 35
Index PDISTR_SND_ID (1)
Root page: 4313, depth: 2, leaf buckets: 306, nodes: 250349
Average node length: 5.39, total dup: 225300, max dup: 29
Average key length: 2.76, compression ratio: 3.26
Average prefix length: 8.34, average data length: 0.66
Clustering factor: 42540, ratio: 0.17
Fill distribution:
0 - 19% = 2
20 - 39% = 54
40 - 59% = 148
60 - 79% = 74
80 - 99% = 28
PERF_ESTIMATED (160)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 27.88, total records: 254567
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 1.15
Pointer pages: 2, data page slots: 2176
Data pages: 2176, average fill: 64%
Primary pages: 2176, secondary pages: 0, swept pages: 0
Empty pages: 3, full pages: 2172
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2172
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 460731, depth: 2, leaf buckets: 204, nodes: 254567
Average node length: 4.50, total dup: 254376, max dup: 2677
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.58, average data length: 0.00
Clustering factor: 32619, ratio: 0.13
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 68
60 - 79% = 82
80 - 99% = 54
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 (162)
Primary pointer page: 348, Index root page: 349
Total formats: 2, used formats: 2
Average record length: 148.78, total records: 9354168
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: 1440.09, compression ratio: 9.68
Pointer pages: 134, data page slots: 218080
Data pages: 218080, average fill: 87%
Primary pages: 218080, secondary pages: 0, swept pages: 3
Empty pages: 2, full pages: 218077
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 218077
Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 59394, depth: 3, leaf buckets: 10411, nodes: 9354168
Average node length: 6.03, total dup: 4043621, max dup: 14
Average key length: 2.68, compression ratio: 2.98
Average prefix length: 7.37, average data length: 0.63
Clustering factor: 7404808, ratio: 0.79
Fill distribution:
0 - 19% = 13
20 - 39% = 0
40 - 59% = 4061
60 - 79% = 3971
80 - 99% = 2366
Index PERF_LOG_GDSCODE (3)
Root page: 162370, depth: 3, leaf buckets: 8972, nodes: 9354168
Average node length: 4.39, total dup: 9354163, max dup: 8959032
Average key length: 1.04, compression ratio: 0.20
Average prefix length: 0.21, average data length: 0.00
Clustering factor: 364779, ratio: 0.04
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 8944
60 - 79% = 0
80 - 99% = 28
Index PERF_LOG_TRN_DESC (2)
Root page: 43359, depth: 3, leaf buckets: 10385, nodes: 9354168
Average node length: 5.59, total dup: 9053922, max dup: 11660
Average key length: 2.24, compression ratio: 4.02
Average prefix length: 8.79, average data length: 0.21
Clustering factor: 4721732, ratio: 0.50
Fill distribution:
0 - 19% = 3
20 - 39% = 2
40 - 59% = 6219
60 - 79% = 2381
80 - 99% = 1780
Index PERF_LOG_UNIT (1)
Root page: 65474, depth: 3, leaf buckets: 10627, nodes: 9354168
Average node length: 5.56, total dup: 9197459, max dup: 1041888
Average key length: 2.21, compression ratio: 17.04
Average prefix length: 37.46, average data length: 0.19
Clustering factor: 6710120, ratio: 0.72
Fill distribution:
0 - 19% = 36
20 - 39% = 4
40 - 59% = 7475
60 - 79% = 1506
80 - 99% = 1606
PHRASES (145)
Primary pointer page: 265, Index root page: 266
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: 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_NAME (2)
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 PHRASES_UNQ (1)
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
Index PK_PHRASES (0)
Root page: 276, 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.33, total records: 311373
Average version length: 55.43, total versions: 3614, 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: 3, data page slots: 3864
Data pages: 3864, average fill: 71%
Primary pages: 3864, secondary pages: 0, swept pages: 2832
Empty pages: 2, full pages: 2492
Fill distribution:
0 - 19% = 10
20 - 39% = 29
40 - 59% = 194
60 - 79% = 3618
80 - 99% = 13
Index PSTORNED_RCV_ID (2)
Root page: 2296, depth: 2, leaf buckets: 422, nodes: 311373
Average node length: 6.00, total dup: 256525, max dup: 365
Average key length: 3.30, compression ratio: 2.72
Average prefix length: 7.87, average data length: 1.13
Clustering factor: 33602, ratio: 0.11
Fill distribution:
0 - 19% = 2
20 - 39% = 16
40 - 59% = 289
60 - 79% = 101
80 - 99% = 14
Index PSTORNED_SND_ID (1)
Root page: 2211, depth: 2, leaf buckets: 336, nodes: 311373
Average node length: 5.53, total dup: 277466, max dup: 343
Average key length: 2.83, compression ratio: 3.18
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 67357, ratio: 0.22
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 148
60 - 79% = 140
80 - 99% = 45
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: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 338.00, compression ratio: 9.87
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 3%
Primary pages: 1, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_SEMAPHORES (0)
Root page: 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.32, 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: 81%
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.07, total dup: 0, max dup: 0
Average key length: 26.06, compression ratio: 1.70
Average prefix length: 21.23, average data length: 23.07
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 (163)
Primary pointer page: 350, Index root page: 351
Total formats: 2, 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: 358, 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 (276)
Primary pointer page: 557, Index root page: 68921
Total formats: 1, used formats: 1
Average record length: 54.33, total records: 2830
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: 136.00, compression ratio: 2.50
Pointer pages: 1, data page slots: 40
Data pages: 40, average fill: 62%
Primary pages: 40, secondary pages: 0, swept pages: 0
Empty pages: 7, full pages: 32
Fill distribution:
0 - 19% = 7
20 - 39% = 0
40 - 59% = 0
60 - 79% = 33
80 - 99% = 0
WARES (144)
Primary pointer page: 263, Index root page: 264
Total formats: 1, used formats: 1
Average record length: 77.53, 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.78
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 77%
Primary pages: 6, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2
Index FK_WARES_WARE_GROUPS (3)
Root page: 374, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 64
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: 273, 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: 328, ratio: 0.82
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_ID_DESC (2)
Root page: 275, 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: 328, ratio: 0.82
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_NUMB_UNQ (1)
Root page: 504, depth: 2, leaf buckets: 3, nodes: 400
Average node length: 52.95, total dup: 0, max dup: 0
Average key length: 51.92, compression ratio: 0.99
Average prefix length: 2.65, average data length: 48.95
Clustering factor: 334, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 2
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 (259)
Primary pointer page: 254, Index root page: 284
Total formats: 1, used formats: 1
Average record length: 70.94, total records: 3682
Average version length: 72.09, total versions: 57, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.92
Pointer pages: 5, data page slots: 5608
Data pages: 456, average fill: 10%
Primary pages: 455, secondary pages: 1, swept pages: 400
Empty pages: 288, full pages: 8
Fill distribution:
0 - 19% = 375
20 - 39% = 39
40 - 59% = 23
60 - 79% = 19
80 - 99% = 0
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1235, depth: 2, leaf buckets: 10, nodes: 3682
Average node length: 7.76, total dup: 3184, max dup: 14
Average key length: 4.99, compression ratio: 7.41
Average prefix length: 34.14, average data length: 2.86
Clustering factor: 566, ratio: 0.15
Fill distribution:
0 - 19% = 1
20 - 39% = 6
40 - 59% = 2
60 - 79% = 1
80 - 99% = 0
XQD_1000_3300 (261)
Primary pointer page: 708, Index root page: 709
Total formats: 1, used formats: 1
Average record length: 70.16, total records: 1366038
Average version length: 71.85, total versions: 37929, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.94
Pointer pages: 14, data page slots: 22136
Data pages: 22136, average fill: 69%
Primary pages: 22136, secondary pages: 0, swept pages: 15767
Empty pages: 36, full pages: 11788
Fill distribution:
0 - 19% = 141
20 - 39% = 870
40 - 59% = 2892
60 - 79% = 17758
80 - 99% = 475
Index XQD_1000_3300_DOC (1)
Root page: 185728, depth: 3, leaf buckets: 1770, nodes: 1366038
Average node length: 5.16, total dup: 1329165, max dup: 125
Average key length: 2.21, compression ratio: 4.08
Average prefix length: 8.82, average data length: 0.18
Clustering factor: 291089, ratio: 0.21
Fill distribution:
0 - 19% = 27
20 - 39% = 128
40 - 59% = 1488
60 - 79% = 101
80 - 99% = 26
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 115735, depth: 3, leaf buckets: 2038, nodes: 1366038
Average node length: 6.29, total dup: 1191570, max dup: 29
Average key length: 3.33, compression ratio: 11.10
Average prefix length: 35.79, average data length: 1.21
Clustering factor: 364077, ratio: 0.27
Fill distribution:
0 - 19% = 31
20 - 39% = 183
40 - 59% = 1577
60 - 79% = 138
80 - 99% = 109
XQD_1200_2000 (260)
Primary pointer page: 705, Index root page: 706
Total formats: 1, used formats: 1
Average record length: 68.63, total records: 49969
Average version length: 72.11, total versions: 2147, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.98
Pointer pages: 8, data page slots: 9872
Data pages: 4072, average fill: 15%
Primary pages: 4072, secondary pages: 0, swept pages: 3735
Empty pages: 1535, full pages: 24
Fill distribution:
0 - 19% = 2825
20 - 39% = 794
40 - 59% = 370
60 - 79% = 78
80 - 99% = 5
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 178621, depth: 3, leaf buckets: 111, nodes: 49969
Average node length: 6.56, total dup: 43369, max dup: 48
Average key length: 3.63, compression ratio: 10.20
Average prefix length: 35.50, average data length: 1.50
Clustering factor: 8383, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 72
40 - 59% = 34
60 - 79% = 4
80 - 99% = 1
XQD_2000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 67.19, total records: 1450018
Average version length: 71.89, total versions: 100487, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.02
Pointer pages: 21, data page slots: 32808
Data pages: 32768, average fill: 51%
Primary pages: 32768, secondary pages: 0, swept pages: 26405
Empty pages: 308, full pages: 4501
Fill distribution:
0 - 19% = 1489
20 - 39% = 7458
40 - 59% = 13538
60 - 79% = 9326
80 - 99% = 957
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 110774, depth: 3, leaf buckets: 2342, nodes: 1450018
Average node length: 5.63, total dup: 1362718, max dup: 91
Average key length: 2.66, compression ratio: 13.90
Average prefix length: 36.40, average data length: 0.60
Clustering factor: 460371, ratio: 0.32
Fill distribution:
0 - 19% = 26
20 - 39% = 1142
40 - 59% = 770
60 - 79% = 289
80 - 99% = 115
XQD_2100_3300 (263)
Primary pointer page: 734, Index root page: 735
Total formats: 1, used formats: 1
Average record length: 4.44, total records: 26823
Average version length: 71.98, total versions: 25124, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 30.65
Pointer pages: 6, data page slots: 8800
Data pages: 2464, average fill: 15%
Primary pages: 2462, secondary pages: 2, swept pages: 1691
Empty pages: 1550, full pages: 254
Fill distribution:
0 - 19% = 1915
20 - 39% = 198
40 - 59% = 69
60 - 79% = 79
80 - 99% = 203
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1530, depth: 2, leaf buckets: 53, nodes: 26823
Average node length: 6.34, total dup: 24143, max dup: 49
Average key length: 3.48, compression ratio: 10.63
Average prefix length: 35.62, average data length: 1.38
Clustering factor: 3490, ratio: 0.13
Fill distribution:
0 - 19% = 0
20 - 39% = 30
40 - 59% = 18
60 - 79% = 5
80 - 99% = 0
XQD_3300_3400 (264)
Primary pointer page: 737, Index root page: 738
Total formats: 1, used formats: 1
Average record length: 69.75, total records: 2228473
Average version length: 71.02, total versions: 56916, 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: 22, data page slots: 34760
Data pages: 34760, average fill: 70%
Primary pages: 34760, secondary pages: 0, swept pages: 25012
Empty pages: 35, full pages: 16546
Fill distribution:
0 - 19% = 82
20 - 39% = 233
40 - 59% = 3252
60 - 79% = 30545
80 - 99% = 648
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 41262, depth: 3, leaf buckets: 4722, nodes: 2228473
Average node length: 6.96, total dup: 1784593, max dup: 25
Average key length: 3.99, compression ratio: 9.28
Average prefix length: 35.21, average data length: 1.79
Clustering factor: 624664, ratio: 0.28
Fill distribution:
0 - 19% = 5
20 - 39% = 2566
40 - 59% = 1836
60 - 79% = 205
80 - 99% = 110
XQS_1000_1200 (265)
Primary pointer page: 740, Index root page: 741
Total formats: 1, used formats: 1
Average record length: 83.60, total records: 3804456
Average version length: 84.01, total versions: 17104, 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: 37, data page slots: 59624
Data pages: 59624, average fill: 79%
Primary pages: 59624, secondary pages: 0, swept pages: 31191
Empty pages: 6, full pages: 56164
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 117
60 - 79% = 30174
80 - 99% = 29327
Index XQS_1000_1200_DOC_ID (0)
Root page: 54649, depth: 3, leaf buckets: 3689, nodes: 3804456
Average node length: 5.16, total dup: 3716634, max dup: 133
Average key length: 2.17, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 877736, ratio: 0.23
Fill distribution:
0 - 19% = 10
20 - 39% = 35
40 - 59% = 1405
60 - 79% = 1444
80 - 99% = 795
Index XQS_1000_1200_RCV_ID (2)
Root page: 78654, depth: 3, leaf buckets: 5021, nodes: 3804456
Average node length: 5.65, total dup: 3434786, max dup: 49
Average key length: 2.66, compression ratio: 3.38
Average prefix length: 8.43, average data length: 0.57
Clustering factor: 590328, ratio: 0.16
Fill distribution:
0 - 19% = 48
20 - 39% = 124
40 - 59% = 3979
60 - 79% = 405
80 - 99% = 465
Index XQS_1000_1200_SND_ID (1)
Root page: 48486, depth: 3, leaf buckets: 4182, nodes: 3804456
Average node length: 5.79, total dup: 3328584, max dup: 29
Average key length: 2.81, compression ratio: 3.20
Average prefix length: 8.31, average data length: 0.69
Clustering factor: 927006, ratio: 0.24
Fill distribution:
0 - 19% = 4
20 - 39% = 49
40 - 59% = 1793
60 - 79% = 1379
80 - 99% = 957
XQS_1000_3300 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 80.83, total records: 1570427
Average version length: 82.85, total versions: 40998, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.68
Pointer pages: 16, data page slots: 25984
Data pages: 25984, average fill: 75%
Primary pages: 25984, secondary pages: 0, swept pages: 18444
Empty pages: 23, full pages: 18130
Fill distribution:
0 - 19% = 65
20 - 39% = 137
40 - 59% = 1474
60 - 79% = 16838
80 - 99% = 7470
Index XQS_1000_3300_DOC_ID (0)
Root page: 75516, depth: 3, leaf buckets: 1743, nodes: 1570427
Average node length: 5.14, total dup: 1533540, max dup: 210
Average key length: 2.18, compression ratio: 4.12
Average prefix length: 8.84, average data length: 0.16
Clustering factor: 327908, ratio: 0.21
Fill distribution:
0 - 19% = 0
20 - 39% = 30
40 - 59% = 1101
60 - 79% = 515
80 - 99% = 97
Index XQS_1000_3300_RCV_ID (2)
Root page: 131765, depth: 3, leaf buckets: 3017, nodes: 1570427
Average node length: 6.29, total dup: 1274100, max dup: 14
Average key length: 3.33, compression ratio: 2.70
Average prefix length: 7.86, average data length: 1.14
Clustering factor: 239914, ratio: 0.15
Fill distribution:
0 - 19% = 57
20 - 39% = 1578
40 - 59% = 1138
60 - 79% = 209
80 - 99% = 35
Index XQS_1000_3300_SND_ID (1)
Root page: 65477, depth: 3, leaf buckets: 1920, nodes: 1570427
Average node length: 5.78, total dup: 1376870, max dup: 41
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 353899, ratio: 0.23
Fill distribution:
0 - 19% = 3
20 - 39% = 29
40 - 59% = 1186
60 - 79% = 540
80 - 99% = 162
XQS_1200_2000 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 81.70, total records: 4112330
Average version length: 85.42, total versions: 116505, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.66
Pointer pages: 43, data page slots: 70040
Data pages: 70024, average fill: 73%
Primary pages: 70024, secondary pages: 0, swept pages: 38834
Empty pages: 30, full pages: 46646
Fill distribution:
0 - 19% = 167
20 - 39% = 1285
40 - 59% = 5944
60 - 79% = 42150
80 - 99% = 20478
Index XQS_1200_2000_DOC_ID (0)
Root page: 57323, depth: 3, leaf buckets: 4720, nodes: 4112330
Average node length: 5.04, total dup: 4088850, max dup: 599
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 1111096, ratio: 0.27
Fill distribution:
0 - 19% = 6
20 - 39% = 478
40 - 59% = 2957
60 - 79% = 1057
80 - 99% = 222
Index XQS_1200_2000_RCV_ID (2)
Root page: 78658, depth: 3, leaf buckets: 5835, nodes: 4112330
Average node length: 5.49, total dup: 3811602, max dup: 49
Average key length: 2.51, compression ratio: 3.59
Average prefix length: 8.57, average data length: 0.43
Clustering factor: 875892, ratio: 0.21
Fill distribution:
0 - 19% = 39
20 - 39% = 2126
40 - 59% = 2697
60 - 79% = 426
80 - 99% = 547
Index XQS_1200_2000_SND_ID (1)
Root page: 49624, depth: 3, leaf buckets: 5234, nodes: 4112330
Average node length: 5.62, total dup: 3730041, max dup: 109
Average key length: 2.63, compression ratio: 3.42
Average prefix length: 8.46, average data length: 0.54
Clustering factor: 1178384, ratio: 0.29
Fill distribution:
0 - 19% = 8
20 - 39% = 430
40 - 59% = 3413
60 - 79% = 1100
80 - 99% = 283
XQS_2000_3300 (268)
Primary pointer page: 757, Index root page: 758
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: 760, 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: 762, 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: 761, 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 (269)
Primary pointer page: 763, Index root page: 764
Total formats: 1, used formats: 1
Average record length: 82.11, total records: 2700521
Average version length: 84.12, total versions: 55926, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.66
Pointer pages: 28, data page slots: 45024
Data pages: 45024, average fill: 75%
Primary pages: 45024, secondary pages: 0, swept pages: 31251
Empty pages: 23, full pages: 30036
Fill distribution:
0 - 19% = 64
20 - 39% = 125
40 - 59% = 1899
60 - 79% = 31627
80 - 99% = 11309
Index XQS_2100_3300_DOC_ID (0)
Root page: 92254, depth: 3, leaf buckets: 2974, nodes: 2700521
Average node length: 5.02, total dup: 2687064, max dup: 1007
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 707931, ratio: 0.26
Fill distribution:
0 - 19% = 14
20 - 39% = 371
40 - 59% = 1540
60 - 79% = 738
80 - 99% = 311
Index XQS_2100_3300_RCV_ID (2)
Root page: 98176, depth: 3, leaf buckets: 5471, nodes: 2700521
Average node length: 6.31, total dup: 2186545, max dup: 14
Average key length: 3.34, compression ratio: 2.70
Average prefix length: 7.85, average data length: 1.15
Clustering factor: 572826, ratio: 0.21
Fill distribution:
0 - 19% = 175
20 - 39% = 3091
40 - 59% = 1939
60 - 79% = 205
80 - 99% = 61
Index XQS_2100_3300_SND_ID (1)
Root page: 78028, depth: 3, leaf buckets: 3172, nodes: 2700521
Average node length: 5.53, total dup: 2484351, max dup: 99
Average key length: 2.56, compression ratio: 3.52
Average prefix length: 8.52, average data length: 0.48
Clustering factor: 741768, ratio: 0.27
Fill distribution:
0 - 19% = 7
20 - 39% = 303
40 - 59% = 1531
60 - 79% = 1000
80 - 99% = 331
XQS_3300_3400 (270)
Primary pointer page: 776, Index root page: 777
Total formats: 1, used formats: 1
Average record length: 67.78, total records: 483662
Average version length: 69.35, total versions: 10624, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.01
Pointer pages: 5, data page slots: 6792
Data pages: 6792, average fill: 76%
Primary pages: 6792, secondary pages: 0, swept pages: 4789
Empty pages: 12, full pages: 5981
Fill distribution:
0 - 19% = 23
20 - 39% = 33
40 - 59% = 140
60 - 79% = 6356
80 - 99% = 240
Index XQS_3300_3400_DOC_ID (0)
Root page: 545921, depth: 3, leaf buckets: 553, nodes: 483662
Average node length: 5.37, total dup: 450295, max dup: 165
Average key length: 2.53, compression ratio: 3.56
Average prefix length: 8.54, average data length: 0.46
Clustering factor: 45068, ratio: 0.09
Fill distribution:
0 - 19% = 3
20 - 39% = 59
40 - 59% = 251
60 - 79% = 175
80 - 99% = 65
Index XQS_3300_3400_SND_ID (1)
Root page: 374849, depth: 3, leaf buckets: 626, nodes: 483662
Average node length: 5.93, total dup: 411313, max dup: 29
Average key length: 3.10, compression ratio: 2.91
Average prefix length: 8.05, average data length: 0.95
Clustering factor: 52420, ratio: 0.11
Fill distribution:
0 - 19% = 0
20 - 39% = 76
40 - 59% = 303
60 - 79% = 195
80 - 99% = 52
ZDOC_DATA (229)
Primary pointer page: 632, Index root page: 633
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 (228)
Primary pointer page: 630, Index root page: 631
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 (230)
Primary pointer page: 634, Index root page: 635
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 (233)
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
Index ZPDISTR_ID (0)
Root page: 650, 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 (234)
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
Index ZPSTORNED_ID (0)
Root page: 651, 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 (231)
Primary pointer page: 636, Index root page: 637
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: 644, 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: 645, 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 (232)
Primary pointer page: 638, Index root page: 639
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: 647, 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: 646, 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: 649, 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: 648, 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 (227)
Primary pointer page: 628, Index root page: 629
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 (226)
Primary pointer page: 625, Index root page: 626
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: 267, Index root page: 268
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: 280, 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 111230 ms, from 7:11:45.16 to 7:13:36.39.
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
VERS_PERCENT |
AGENTS |
50 |
0 |
0.0000 |
BUSINESS_OPS |
19 |
0 |
0.0000 |
DOC_DATA |
1691869 |
8840 |
0.5224 |
DOC_LIST |
594192 |
6244 |
1.0508 |
DOC_STATES |
4 |
0 |
0.0000 |
FB_ERRORS |
758 |
0 |
0.0000 |
INVNT_SALDO |
400 |
0 |
0.0000 |
INVNT_TURNOVER_LOG |
11259 |
819 |
7.2741 |
MONEY_SALDO |
49 |
0 |
0.0000 |
MONEY_TURNOVER_LOG |
2311 |
2099 |
90.8264 |
OPTYPES |
9 |
0 |
0.0000 |
PDISTR |
250349 |
10135 |
4.0483 |
PERF_ESTIMATED |
254567 |
0 |
0.0000 |
PERF_LOG |
9354168 |
0 |
0.0000 |
PSTORNED |
311373 |
3614 |
1.1606 |
RULES_FOR_PDISTR |
4 |
0 |
0.0000 |
RULES_FOR_QDISTR |
7 |
0 |
0.0000 |
SEMAPHORES |
4 |
0 |
0.0000 |
SETTINGS |
114 |
0 |
0.0000 |
TRACE_STAT |
2830 |
0 |
0.0000 |
WARES |
400 |
0 |
0.0000 |
WARE_GROUPS |
8 |
0 |
0.0000 |
XQD_1000_1200 |
3682 |
57 |
1.5480 |
XQD_1000_3300 |
1366038 |
37929 |
2.7765 |
XQD_1200_2000 |
49969 |
2147 |
4.2966 |
XQD_2000_3300 |
1450018 |
100487 |
6.9300 |
XQD_2100_3300 |
26823 |
25124 |
93.6658 |
XQD_3300_3400 |
2228473 |
56916 |
2.5540 |
XQS_1000_1200 |
3804456 |
17104 |
0.4495 |
XQS_1000_3300 |
1570427 |
40998 |
2.6106 |
XQS_1200_2000 |
4112330 |
116505 |
2.8330 |
XQS_2100_3300 |
2700521 |
55926 |
2.0709 |
XQS_3300_3400 |
483662 |
10624 |
2.1965 |
Z_USED_VIEWS |
29 |
0 |
0.0000 |
Done for 2970 ms, from 7:13:48.20 to 7:13:51.17.
07:13:51.31 Validation started
07:13:51.32 Relation 140 (DOC_LIST)
07:13:51.32 process pointer page 0 of 5
07:13:51.43 process pointer page 1 of 5
07:13:51.55 process pointer page 2 of 5
07:13:51.65 process pointer page 3 of 5
07:13:51.76 process pointer page 4 of 5
07:13:51.85 Index 1 (PK_DOC_LIST)
07:13:52.12 Index 2 (DOC_LIST_ID_DESC)
07:13:52.41 Index 3 (FK_DOC_LIST_AGENTS)
07:13:52.59 Relation 140 (DOC_LIST) is ok
07:13:52.59 Relation 141 (DOC_DATA)
07:13:52.59 process pointer page 0 of 12
07:13:52.68 process pointer page 1 of 12
07:13:52.77 process pointer page 2 of 12
07:13:52.83 process pointer page 3 of 12
07:13:52.87 process pointer page 4 of 12
07:13:52.90 process pointer page 5 of 12
07:13:52.94 process pointer page 6 of 12
07:13:53.00 process pointer page 7 of 12
07:13:53.09 process pointer page 8 of 12
07:13:53.18 process pointer page 9 of 12
07:13:53.27 process pointer page 10 of 12
07:13:53.36 process pointer page 11 of 12
07:13:53.42 Index 2 (DOC_DATA_DOC_WARE_UNQ)
07:13:54.13 Index 3 (DOC_DATA_ID_DESC)
07:13:54.79 Index 4 (FK_DOC_DATA_DOC_LIST)
07:13:55.24 Relation 141 (DOC_DATA) is ok
07:13:55.24 Relation 147 (INVNT_SALDO)
07:13:55.24 process pointer page 0 of 3
07:13:55.24 process pointer page 1 of 3
07:13:55.24 process pointer page 2 of 3
07:13:55.24 Index 1 (PK_INVNT_SALDO)
07:13:55.24 Relation 147 (INVNT_SALDO) is ok
07:13:55.24 Relation 150 (PDISTR)
07:13:55.24 process pointer page 0 of 3
07:13:55.28 process pointer page 1 of 3
07:13:55.33 process pointer page 2 of 3
07:13:55.34 Index 2 (PDISTR_SND_ID)
07:13:55.43 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
07:13:55.48 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
07:13:55.53 Index 5 (PDISTR_AGENT_ID)
07:13:55.60 Relation 150 (PDISTR) is ok
07:13:55.60 Relation 151 (PSTORNED)
07:13:55.60 process pointer page 0 of 3
07:13:55.70 process pointer page 1 of 3
07:13:55.74 process pointer page 2 of 3
07:13:55.76 Index 2 (PSTORNED_SND_ID)
07:13:55.79 Index 3 (PSTORNED_RCV_ID)
07:13:55.83 Relation 151 (PSTORNED) is ok
07:13:55.83 Relation 156 (SEMAPHORES)
07:13:55.83 process pointer page 0 of 1
07:13:55.83 Index 1 (PK_SEMAPHORES)
07:13:55.83 Index 2 (SEMAPHORES_TASK_UNQ)
07:13:55.83 Relation 156 (SEMAPHORES) is ok
07:13:55.83 Relation 157 (INVNT_TURNOVER_LOG)
07:13:55.83 process pointer page 0 of 3
07:13:55.83 process pointer page 1 of 3
07:13:55.85 process pointer page 2 of 3
07:13:55.86 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
07:13:55.86 Relation 157 (INVNT_TURNOVER_LOG) is ok
07:13:55.86 Relation 160 (PERF_ESTIMATED)
07:13:55.86 process pointer page 0 of 2
07:13:55.90 process pointer page 1 of 2
07:13:55.91 Index 1 (PERF_EST_MINUTE_SINCE_START)
07:13:55.93 Relation 160 (PERF_ESTIMATED) is ok
07:13:55.93 Relation 161 (PERF_ISQL_STAT)
07:13:55.93 process pointer page 0 of 1
07:13:55.93 Index 1 (PERF_ISQL_STAT_TRN)
07:13:55.93 Relation 161 (PERF_ISQL_STAT) is ok
07:13:55.93 Relation 162 (PERF_LOG)
07:13:55.93 process pointer page 0 of 134
07:13:55.96 process pointer page 1 of 134
07:13:55.99 process pointer page 2 of 134
07:13:56.02 process pointer page 3 of 134
07:13:56.05 process pointer page 4 of 134
07:13:56.08 process pointer page 5 of 134
07:13:56.12 process pointer page 6 of 134
07:13:56.15 process pointer page 7 of 134
07:13:56.21 process pointer page 8 of 134
07:13:56.30 process pointer page 9 of 134
07:13:56.38 process pointer page 10 of 134
07:13:56.46 process pointer page 11 of 134
07:13:56.54 process pointer page 12 of 134
07:13:56.62 process pointer page 13 of 134
07:13:56.69 process pointer page 14 of 134
07:13:56.77 process pointer page 15 of 134
07:13:56.85 process pointer page 16 of 134
07:13:56.92 process pointer page 17 of 134
07:13:56.95 process pointer page 18 of 134
07:13:57.01 process pointer page 19 of 134
07:13:57.08 process pointer page 20 of 134
07:13:57.16 process pointer page 21 of 134
07:13:57.24 process pointer page 22 of 134
07:13:57.32 process pointer page 23 of 134
07:13:57.39 process pointer page 24 of 134
07:13:57.47 process pointer page 25 of 134
07:13:57.55 process pointer page 26 of 134
07:13:57.63 process pointer page 27 of 134
07:13:57.71 process pointer page 28 of 134
07:13:57.79 process pointer page 29 of 134
07:13:57.86 process pointer page 30 of 134
07:13:57.94 process pointer page 31 of 134
07:13:57.98 process pointer page 32 of 134
07:13:58.01 process pointer page 33 of 134
07:13:58.04 process pointer page 34 of 134
07:13:58.07 process pointer page 35 of 134
07:13:58.11 process pointer page 36 of 134
07:13:58.14 process pointer page 37 of 134
07:13:58.18 process pointer page 38 of 134
07:13:58.26 process pointer page 39 of 134
07:13:58.32 process pointer page 40 of 134
07:13:58.35 process pointer page 41 of 134
07:13:58.42 process pointer page 42 of 134
07:13:58.50 process pointer page 43 of 134
07:13:58.54 process pointer page 44 of 134
07:13:58.57 process pointer page 45 of 134
07:13:58.60 process pointer page 46 of 134
07:13:58.63 process pointer page 47 of 134
07:13:58.66 process pointer page 48 of 134
07:13:58.74 process pointer page 49 of 134
07:13:58.82 process pointer page 50 of 134
07:13:58.89 process pointer page 51 of 134
07:13:58.97 process pointer page 52 of 134
07:13:59.05 process pointer page 53 of 134
07:13:59.13 process pointer page 54 of 134
07:13:59.21 process pointer page 55 of 134
07:13:59.29 process pointer page 56 of 134
07:13:59.36 process pointer page 57 of 134
07:13:59.39 process pointer page 58 of 134
07:13:59.42 process pointer page 59 of 134
07:13:59.46 process pointer page 60 of 134
07:13:59.53 process pointer page 61 of 134
07:13:59.60 process pointer page 62 of 134
07:13:59.64 process pointer page 63 of 134
07:13:59.68 process pointer page 64 of 134
07:13:59.76 process pointer page 65 of 134
07:13:59.84 process pointer page 66 of 134
07:13:59.92 process pointer page 67 of 134
07:13:59.99 process pointer page 68 of 134
07:14:00.07 process pointer page 69 of 134
07:14:00.15 process pointer page 70 of 134
07:14:00.23 process pointer page 71 of 134
07:14:00.30 process pointer page 72 of 134
07:14:00.38 process pointer page 73 of 134
07:14:00.46 process pointer page 74 of 134
07:14:00.54 process pointer page 75 of 134
07:14:00.61 process pointer page 76 of 134
07:14:00.69 process pointer page 77 of 134
07:14:00.77 process pointer page 78 of 134
07:14:00.82 process pointer page 79 of 134
07:14:00.85 process pointer page 80 of 134
07:14:00.89 process pointer page 81 of 134
07:14:00.92 process pointer page 82 of 134
07:14:00.95 process pointer page 83 of 134
07:14:01.01 process pointer page 84 of 134
07:14:01.09 process pointer page 85 of 134
07:14:01.16 process pointer page 86 of 134
07:14:01.24 process pointer page 87 of 134
07:14:01.32 process pointer page 88 of 134
07:14:01.39 process pointer page 89 of 134
07:14:01.47 process pointer page 90 of 134
07:14:01.55 process pointer page 91 of 134
07:14:01.62 process pointer page 92 of 134
07:14:01.70 process pointer page 93 of 134
07:14:01.78 process pointer page 94 of 134
07:14:01.86 process pointer page 95 of 134
07:14:01.94 process pointer page 96 of 134
07:14:02.01 process pointer page 97 of 134
07:14:02.07 process pointer page 98 of 134
07:14:02.10 process pointer page 99 of 134
07:14:02.13 process pointer page 100 of 134
07:14:02.16 process pointer page 101 of 134
07:14:02.19 process pointer page 102 of 134
07:14:02.22 process pointer page 103 of 134
07:14:02.25 process pointer page 104 of 134
07:14:02.28 process pointer page 105 of 134
07:14:02.30 process pointer page 106 of 134
07:14:02.37 process pointer page 107 of 134
07:14:02.45 process pointer page 108 of 134
07:14:02.53 process pointer page 109 of 134
07:14:02.61 process pointer page 110 of 134
07:14:02.69 process pointer page 111 of 134
07:14:02.76 process pointer page 112 of 134
07:14:02.84 process pointer page 113 of 134
07:14:02.92 process pointer page 114 of 134
07:14:03.00 process pointer page 115 of 134
07:14:03.07 process pointer page 116 of 134
07:14:03.15 process pointer page 117 of 134
07:14:03.23 process pointer page 118 of 134
07:14:03.28 process pointer page 119 of 134
07:14:03.31 process pointer page 120 of 134
07:14:03.34 process pointer page 121 of 134
07:14:03.39 process pointer page 122 of 134
07:14:03.47 process pointer page 123 of 134
07:14:03.55 process pointer page 124 of 134
07:14:03.62 process pointer page 125 of 134
07:14:03.70 process pointer page 126 of 134
07:14:03.74 process pointer page 127 of 134
07:14:03.77 process pointer page 128 of 134
07:14:03.80 process pointer page 129 of 134
07:14:03.83 process pointer page 130 of 134
07:14:03.86 process pointer page 131 of 134
07:14:03.89 process pointer page 132 of 134
07:14:03.94 process pointer page 133 of 134
07:14:03.99 Index 1 (PERF_LOG_DTS_BEG_DESC)
07:14:07.10 Index 2 (PERF_LOG_UNIT)
07:14:13.78 Index 3 (PERF_LOG_TRN_DESC)
07:14:17.16 Index 4 (PERF_LOG_GDSCODE)
07:14:19.03 Relation 162 (PERF_LOG) is ok
07:14:19.03 Relation 166 (V_STOPTEST)
07:14:19.03 Relation 166 (V_STOPTEST) is ok
07:14:19.03 Relation 183 (V_QDISTR_SOURCE)
07:14:19.03 Relation 183 (V_QDISTR_SOURCE) is ok
07:14:19.03 Relation 184 (V_QSTORNED_SOURCE)
07:14:19.03 Relation 184 (V_QSTORNED_SOURCE) is ok
07:14:19.03 Relation 259 (XQD_1000_1200)
07:14:19.04 process pointer page 0 of 5
07:14:19.04 process pointer page 1 of 5
07:14:19.04 process pointer page 2 of 5
07:14:19.05 process pointer page 3 of 5
07:14:19.05 process pointer page 4 of 5
07:14:19.05 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
07:14:19.06 Relation 259 (XQD_1000_1200) is ok
07:14:19.06 Relation 260 (XQD_1200_2000)
07:14:19.06 process pointer page 0 of 8
07:14:19.09 process pointer page 1 of 8
07:14:19.10 process pointer page 2 of 8
07:14:19.11 process pointer page 3 of 8
07:14:19.14 process pointer page 4 of 8
07:14:19.17 process pointer page 5 of 8
07:14:19.20 process pointer page 6 of 8
07:14:19.20 process pointer page 7 of 8
07:14:19.21 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
07:14:19.23 Relation 260 (XQD_1200_2000) is ok
07:14:19.23 Relation 261 (XQD_1000_3300)
07:14:19.23 process pointer page 0 of 14
07:14:19.32 process pointer page 1 of 14
07:14:19.40 process pointer page 2 of 14
07:14:19.44 process pointer page 3 of 14
07:14:19.51 process pointer page 4 of 14
07:14:19.60 process pointer page 5 of 14
07:14:19.70 process pointer page 6 of 14
07:14:19.81 process pointer page 7 of 14
07:14:19.90 process pointer page 8 of 14
07:14:19.99 process pointer page 9 of 14
07:14:20.08 process pointer page 10 of 14
07:14:20.17 process pointer page 11 of 14
07:14:20.26 process pointer page 12 of 14
07:14:20.34 process pointer page 13 of 14
07:14:20.39 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
07:14:20.92 Index 2 (XQD_1000_3300_DOC)
07:14:21.34 Relation 261 (XQD_1000_3300) is ok
07:14:21.34 Relation 262 (XQD_2000_3300)
07:14:21.35 process pointer page 0 of 21
07:14:21.44 process pointer page 1 of 21
07:14:21.52 process pointer page 2 of 21
07:14:21.58 process pointer page 3 of 21
07:14:21.63 process pointer page 4 of 21
07:14:21.73 process pointer page 5 of 21
07:14:21.81 process pointer page 6 of 21
07:14:21.89 process pointer page 7 of 21
07:14:21.97 process pointer page 8 of 21
07:14:22.00 process pointer page 9 of 21
07:14:22.04 process pointer page 10 of 21
07:14:22.07 process pointer page 11 of 21
07:14:22.11 process pointer page 12 of 21
07:14:22.19 process pointer page 13 of 21
07:14:22.27 process pointer page 14 of 21
07:14:22.36 process pointer page 15 of 21
07:14:22.42 process pointer page 16 of 21
07:14:22.45 process pointer page 17 of 21
07:14:22.49 process pointer page 18 of 21
07:14:22.52 process pointer page 19 of 21
07:14:22.56 process pointer page 20 of 21
07:14:22.56 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
07:14:23.11 Relation 262 (XQD_2000_3300) is ok
07:14:23.11 Relation 263 (XQD_2100_3300)
07:14:23.11 process pointer page 0 of 6
07:14:23.13 process pointer page 1 of 6
07:14:23.14 process pointer page 2 of 6
07:14:23.16 process pointer page 3 of 6
07:14:23.17 process pointer page 4 of 6
07:14:23.21 process pointer page 5 of 6
07:14:23.24 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
07:14:23.25 Relation 263 (XQD_2100_3300) is ok
07:14:23.25 Relation 264 (XQD_3300_3400)
07:14:23.25 process pointer page 0 of 22
07:14:23.34 process pointer page 1 of 22
07:14:23.44 process pointer page 2 of 22
07:14:23.52 process pointer page 3 of 22
07:14:23.56 process pointer page 4 of 22
07:14:23.59 process pointer page 5 of 22
07:14:23.66 process pointer page 6 of 22
07:14:23.75 process pointer page 7 of 22
07:14:23.85 process pointer page 8 of 22
07:14:23.94 process pointer page 9 of 22
07:14:24.03 process pointer page 10 of 22
07:14:24.12 process pointer page 11 of 22
07:14:24.21 process pointer page 12 of 22
07:14:24.30 process pointer page 13 of 22
07:14:24.40 process pointer page 14 of 22
07:14:24.47 process pointer page 15 of 22
07:14:24.51 process pointer page 16 of 22
07:14:24.60 process pointer page 17 of 22
07:14:24.69 process pointer page 18 of 22
07:14:24.78 process pointer page 19 of 22
07:14:24.83 process pointer page 20 of 22
07:14:24.87 process pointer page 21 of 22
07:14:24.88 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
07:14:25.63 Relation 264 (XQD_3300_3400) is ok
07:14:25.63 Relation 265 (XQS_1000_1200)
07:14:25.63 process pointer page 0 of 37
07:14:25.67 process pointer page 1 of 37
07:14:25.70 process pointer page 2 of 37
07:14:25.73 process pointer page 3 of 37
07:14:25.76 process pointer page 4 of 37
07:14:25.80 process pointer page 5 of 37
07:14:25.88 process pointer page 6 of 37
07:14:25.97 process pointer page 7 of 37
07:14:26.06 process pointer page 8 of 37
07:14:26.15 process pointer page 9 of 37
07:14:26.24 process pointer page 10 of 37
07:14:26.34 process pointer page 11 of 37
07:14:26.43 process pointer page 12 of 37
07:14:26.52 process pointer page 13 of 37
07:14:26.61 process pointer page 14 of 37
07:14:26.68 process pointer page 15 of 37
07:14:26.72 process pointer page 16 of 37
07:14:26.81 process pointer page 17 of 37
07:14:26.90 process pointer page 18 of 37
07:14:26.99 process pointer page 19 of 37
07:14:27.04 process pointer page 20 of 37
07:14:27.10 process pointer page 21 of 37
07:14:27.18 process pointer page 22 of 37
07:14:27.27 process pointer page 23 of 37
07:14:27.36 process pointer page 24 of 37
07:14:27.46 process pointer page 25 of 37
07:14:27.55 process pointer page 26 of 37
07:14:27.64 process pointer page 27 of 37
07:14:27.73 process pointer page 28 of 37
07:14:27.82 process pointer page 29 of 37
07:14:27.91 process pointer page 30 of 37
07:14:28.00 process pointer page 31 of 37
07:14:28.09 process pointer page 32 of 37
07:14:28.18 process pointer page 33 of 37
07:14:28.26 process pointer page 34 of 37
07:14:28.36 process pointer page 35 of 37
07:14:28.45 process pointer page 36 of 37
07:14:28.47 Index 1 (XQS_1000_1200_DOC_ID)
07:14:29.46 Index 2 (XQS_1000_1200_SND_ID)
07:14:30.40 Index 3 (XQS_1000_1200_RCV_ID)
07:14:31.25 Relation 265 (XQS_1000_1200) is ok
07:14:31.25 Relation 266 (XQS_1200_2000)
07:14:31.25 process pointer page 0 of 43
07:14:31.33 process pointer page 1 of 43
07:14:31.42 process pointer page 2 of 43
07:14:31.51 process pointer page 3 of 43
07:14:31.60 process pointer page 4 of 43
07:14:31.69 process pointer page 5 of 43
07:14:31.77 process pointer page 6 of 43
07:14:31.80 process pointer page 7 of 43
07:14:31.89 process pointer page 8 of 43
07:14:31.98 process pointer page 9 of 43
07:14:32.08 process pointer page 10 of 43
07:14:32.16 process pointer page 11 of 43
07:14:32.20 process pointer page 12 of 43
07:14:32.24 process pointer page 13 of 43
07:14:32.27 process pointer page 14 of 43
07:14:32.32 process pointer page 15 of 43
07:14:32.41 process pointer page 16 of 43
07:14:32.50 process pointer page 17 of 43
07:14:32.57 process pointer page 18 of 43
07:14:32.61 process pointer page 19 of 43
07:14:32.64 process pointer page 20 of 43
07:14:32.68 process pointer page 21 of 43
07:14:32.71 process pointer page 22 of 43
07:14:32.75 process pointer page 23 of 43
07:14:32.83 process pointer page 24 of 43
07:14:32.93 process pointer page 25 of 43
07:14:33.02 process pointer page 26 of 43
07:14:33.12 process pointer page 27 of 43
07:14:33.21 process pointer page 28 of 43
07:14:33.30 process pointer page 29 of 43
07:14:33.39 process pointer page 30 of 43
07:14:33.47 process pointer page 31 of 43
07:14:33.50 process pointer page 32 of 43
07:14:33.59 process pointer page 33 of 43
07:14:33.68 process pointer page 34 of 43
07:14:33.77 process pointer page 35 of 43
07:14:33.80 process pointer page 36 of 43
07:14:33.89 process pointer page 37 of 43
07:14:33.99 process pointer page 38 of 43
07:14:34.09 process pointer page 39 of 43
07:14:34.17 process pointer page 40 of 43
07:14:34.20 process pointer page 41 of 43
07:14:34.24 process pointer page 42 of 43
07:14:34.29 Index 1 (XQS_1200_2000_DOC_ID)
07:14:35.52 Index 2 (XQS_1200_2000_SND_ID)
07:14:36.98 Index 3 (XQS_1200_2000_RCV_ID)
07:14:38.23 Relation 266 (XQS_1200_2000) is ok
07:14:38.23 Relation 267 (XQS_1000_3300)
07:14:38.23 process pointer page 0 of 16
07:14:38.34 process pointer page 1 of 16
07:14:38.45 process pointer page 2 of 16
07:14:38.56 process pointer page 3 of 16
07:14:38.67 process pointer page 4 of 16
07:14:38.78 process pointer page 5 of 16
07:14:38.87 process pointer page 6 of 16
07:14:38.92 process pointer page 7 of 16
07:14:39.03 process pointer page 8 of 16
07:14:39.14 process pointer page 9 of 16
07:14:39.24 process pointer page 10 of 16
07:14:39.29 process pointer page 11 of 16
07:14:39.33 process pointer page 12 of 16
07:14:39.38 process pointer page 13 of 16
07:14:39.42 process pointer page 14 of 16
07:14:39.46 process pointer page 15 of 16
07:14:39.55 Index 1 (XQS_1000_3300_DOC_ID)
07:14:40.09 Index 2 (XQS_1000_3300_SND_ID)
07:14:40.60 Index 3 (XQS_1000_3300_RCV_ID)
07:14:41.07 Relation 267 (XQS_1000_3300) is ok
07:14:41.07 Relation 268 (XQS_2000_3300)
07:14:41.07 process pointer page 0 of 1
07:14:41.07 Index 1 (XQS_2000_3300_DOC_ID)
07:14:41.08 Index 2 (XQS_2000_3300_SND_ID)
07:14:41.08 Index 3 (XQS_2000_3300_RCV_ID)
07:14:41.08 Relation 268 (XQS_2000_3300) is ok
07:14:41.08 Relation 269 (XQS_2100_3300)
07:14:41.08 process pointer page 0 of 28
07:14:41.18 process pointer page 1 of 28
07:14:41.29 process pointer page 2 of 28
07:14:41.40 process pointer page 3 of 28
07:14:41.50 process pointer page 4 of 28
07:14:41.61 process pointer page 5 of 28
07:14:41.71 process pointer page 6 of 28
07:14:41.81 process pointer page 7 of 28
07:14:41.85 process pointer page 8 of 28
07:14:41.89 process pointer page 9 of 28
07:14:41.97 process pointer page 10 of 28
07:14:42.08 process pointer page 11 of 28
07:14:42.19 process pointer page 12 of 28
07:14:42.30 process pointer page 13 of 28
07:14:42.40 process pointer page 14 of 28
07:14:42.50 process pointer page 15 of 28
07:14:42.61 process pointer page 16 of 28
07:14:42.72 process pointer page 17 of 28
07:14:42.78 process pointer page 18 of 28
07:14:42.82 process pointer page 19 of 28
07:14:42.86 process pointer page 20 of 28
07:14:42.90 process pointer page 21 of 28
07:14:42.94 process pointer page 22 of 28
07:14:42.97 process pointer page 23 of 28
07:14:43.01 process pointer page 24 of 28
07:14:43.04 process pointer page 25 of 28
07:14:43.11 process pointer page 26 of 28
07:14:43.21 process pointer page 27 of 28
07:14:43.27 Index 1 (XQS_2100_3300_DOC_ID)
07:14:43.96 Index 2 (XQS_2100_3300_SND_ID)
07:14:44.81 Index 3 (XQS_2100_3300_RCV_ID)
07:14:45.48 Relation 269 (XQS_2100_3300) is ok
07:14:45.48 Relation 270 (XQS_3300_3400)
07:14:45.48 process pointer page 0 of 5
07:14:45.54 process pointer page 1 of 5
07:14:45.62 process pointer page 2 of 5
07:14:45.66 process pointer page 3 of 5
07:14:45.70 process pointer page 4 of 5
07:14:45.71 Index 1 (XQS_3300_3400_DOC_ID)
07:14:45.77 Index 2 (XQS_3300_3400_SND_ID)
07:14:45.82 Relation 270 (XQS_3300_3400) is ok
07:14:45.82 Relation 276 (TRACE_STAT)
07:14:45.82 process pointer page 0 of 1
07:14:45.82 Relation 276 (TRACE_STAT) is ok
07:14:45.82 Validation finished
Done for 54620 ms, from 7:13:51.20 to 7:14:45.82.
Differences between old and current firebird.log
7:14:46.73. 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:
2016-11-27 07:14 504 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 Sun Nov 27 07:13:51 2016
7: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Sun Nov 27 07:14:45 2016
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.
2016-11-27 7:14:54.39 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html