ACTION |
AVG_TIMES_PER_MINUTE |
AVG_ELAPSED_MS |
SUCCESSFUL_TIMES_DONE |
JOB_BEG |
JOB_END |
*** OVERALL *** for 180 minutes: |
6474.47 |
2618 |
1165405 |
2017-12-10 03:46 |
2017-12-10 06:46 |
customer order: creation |
456.79 |
376 |
82223 |
2017-12-10 03:46 |
2017-12-10 06:46 |
customer order: refuse |
38.46 |
197 |
6923 |
2017-12-10 03:46 |
2017-12-10 06:46 |
order to supplier: creation |
117.19 |
1572 |
21094 |
2017-12-10 03:46 |
2017-12-10 06:46 |
order to supplier: removal |
3.19 |
15556 |
571 |
2017-12-10 03:46 |
2017-12-10 06:46 |
invoice (draft): creation |
118.61 |
2367 |
21349 |
2017-12-10 03:46 |
2017-12-10 06:46 |
invoice (draft): removal |
45.14 |
343 |
8126 |
2017-12-10 03:46 |
2017-12-10 06:46 |
invoice accept: apply |
66.21 |
7979 |
11917 |
2017-12-10 03:46 |
2017-12-10 06:46 |
invoice accept: cancel |
20.64 |
1898 |
3715 |
2017-12-10 03:46 |
2017-12-10 06:46 |
customer reserve: creation |
3710.39 |
115 |
667871 |
2017-12-10 03:46 |
2017-12-10 06:46 |
customer reserve: removal |
1263.29 |
44 |
227393 |
2017-12-10 03:46 |
2017-12-10 06:46 |
realization accept: apply |
212.64 |
443 |
38276 |
2017-12-10 03:46 |
2017-12-10 06:46 |
realization accept: cancel |
89.83 |
122 |
16170 |
2017-12-10 03:46 |
2017-12-10 06:46 |
payment from customer: creation |
154.58 |
722 |
27825 |
2017-12-10 03:46 |
2017-12-10 06:46 |
payment from customer: removal |
14.09 |
109 |
2537 |
2017-12-10 03:46 |
2017-12-10 06:46 |
payment to supplier: creation |
126.52 |
373 |
22773 |
2017-12-10 03:46 |
2017-12-10 06:46 |
payment to supplier: removal |
9.26 |
114 |
1667 |
2017-12-10 03:46 |
2017-12-10 06:46 |
service: total inventory turnovers |
10.66 |
2019 |
1919 |
2017-12-10 03:46 |
2017-12-10 06:46 |
service: total monetary turnovers |
16.92 |
54 |
3045 |
2017-12-10 03:46 |
2017-12-10 06:46 |
service: refresh index statistics |
0.07 |
15331 |
11 |
2017-12-10 03:46 |
2017-12-10 06:46 |
Done for 78090 ms, from 6:50:26.53 to 6:51:44.62.
ACTION |
ITRV_NO |
CNT_OK_PER_MINUTE |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
ITRV_BEG |
ITRV_END |
interval # 1, overall |
1 |
4752 |
99143 |
85537 |
13606 |
13.72 |
03:46:46 |
04:04:46 |
interval # 2, overall |
2 |
6980 |
138590 |
125643 |
12947 |
9.34 |
04:04:47 |
04:22:47 |
interval # 3, overall |
3 |
6565 |
135092 |
118165 |
16927 |
12.53 |
04:22:48 |
04:40:48 |
interval # 4, overall |
4 |
6829 |
143517 |
122925 |
20592 |
14.35 |
04:40:49 |
04:58:49 |
interval # 5, overall |
5 |
6754 |
144495 |
121578 |
22917 |
15.86 |
04:58:50 |
05:16:50 |
interval # 6, overall |
6 |
7376 |
154713 |
132765 |
21948 |
14.19 |
05:16:51 |
05:34:51 |
interval # 7, overall |
7 |
6941 |
142297 |
124931 |
17366 |
12.20 |
05:34:52 |
05:52:52 |
interval # 8, overall |
8 |
6477 |
133676 |
116589 |
17087 |
12.78 |
05:52:53 |
06:10:53 |
interval # 9, overall |
9 |
6045 |
124552 |
108813 |
15739 |
12.64 |
06:10:54 |
06:28:54 |
interval # 10, overall |
10 |
6026 |
125042 |
108459 |
16583 |
13.26 |
06:28:55 |
06:46:55 |
Done for 198750 ms, from 6:55:09.20 to 6:58:27.95.
TEST_PHASE |
MINUTE_SINCE_TEST_START |
AVG_ESTIMATED |
MIN_TO_AVG_RATIO |
MAX_TO_AVG_RATIO |
ROWS_AGGREGATED |
DISTINCT_ATTACHMENTS |
TEST_TIME |
1 |
2790.31 |
0.1311 |
1.8714 |
2588 |
25 |
TEST_TIME |
2 |
3118.25 |
0.8374 |
1.2001 |
1514 |
24 |
TEST_TIME |
3 |
2928.15 |
0.8521 |
1.1479 |
1338 |
25 |
TEST_TIME |
4 |
2743.26 |
0.9190 |
1.0842 |
854 |
21 |
TEST_TIME |
5 |
2816.10 |
0.8450 |
1.1030 |
1145 |
16 |
TEST_TIME |
6 |
2797.55 |
0.9253 |
1.0814 |
1023 |
26 |
TEST_TIME |
7 |
2799.16 |
0.9264 |
1.0735 |
1644 |
30 |
TEST_TIME |
8 |
2841.21 |
0.9254 |
1.0746 |
1590 |
25 |
TEST_TIME |
9 |
3051.69 |
0.8893 |
1.0899 |
1469 |
22 |
TEST_TIME |
10 |
3269.83 |
0.9155 |
1.0834 |
1674 |
26 |
TEST_TIME |
11 |
3455.66 |
0.9319 |
1.0764 |
1302 |
72 |
TEST_TIME |
12 |
3588.60 |
0.9503 |
1.0599 |
1494 |
100 |
TEST_TIME |
13 |
3740.18 |
0.9387 |
1.0541 |
1828 |
100 |
TEST_TIME |
14 |
3900.63 |
0.9386 |
1.0678 |
1726 |
100 |
TEST_TIME |
15 |
4088.68 |
0.9508 |
1.0556 |
2063 |
100 |
TEST_TIME |
16 |
4271.89 |
0.9472 |
1.0539 |
2233 |
100 |
TEST_TIME |
17 |
4476.58 |
0.9474 |
1.0517 |
2363 |
100 |
TEST_TIME |
18 |
4649.91 |
0.9563 |
1.0450 |
2047 |
100 |
TEST_TIME |
19 |
4798.11 |
0.9595 |
1.0429 |
1823 |
100 |
TEST_TIME |
20 |
4942.16 |
0.9619 |
1.0368 |
1927 |
100 |
TEST_TIME |
21 |
5062.16 |
0.9641 |
1.0324 |
1558 |
100 |
TEST_TIME |
22 |
5137.27 |
0.9710 |
1.0382 |
1655 |
100 |
TEST_TIME |
23 |
5245.95 |
0.9730 |
1.0256 |
1695 |
100 |
TEST_TIME |
24 |
5287.75 |
0.9759 |
1.0269 |
1518 |
100 |
TEST_TIME |
25 |
5330.47 |
0.9779 |
1.0183 |
1366 |
100 |
TEST_TIME |
26 |
5352.20 |
0.9752 |
1.0251 |
1464 |
100 |
TEST_TIME |
27 |
5371.62 |
0.9836 |
1.0205 |
1276 |
100 |
TEST_TIME |
28 |
5395.93 |
0.9797 |
1.0167 |
1308 |
100 |
TEST_TIME |
29 |
5382.54 |
0.9844 |
1.0157 |
1189 |
100 |
TEST_TIME |
30 |
5429.87 |
0.9733 |
1.0246 |
2361 |
100 |
TEST_TIME |
31 |
5520.36 |
0.9753 |
1.0269 |
2187 |
100 |
TEST_TIME |
32 |
5610.97 |
0.9788 |
1.0214 |
1917 |
100 |
TEST_TIME |
33 |
5669.30 |
0.9808 |
1.0172 |
1615 |
100 |
TEST_TIME |
34 |
5700.75 |
0.9819 |
1.0160 |
1433 |
100 |
TEST_TIME |
35 |
5728.60 |
0.9822 |
1.0195 |
1750 |
100 |
TEST_TIME |
36 |
5797.75 |
0.9794 |
1.0189 |
1677 |
100 |
TEST_TIME |
37 |
5816.88 |
0.9881 |
1.0155 |
1559 |
100 |
TEST_TIME |
38 |
5839.20 |
0.9850 |
1.0145 |
1381 |
100 |
TEST_TIME |
39 |
5850.41 |
0.9867 |
1.0123 |
1324 |
100 |
TEST_TIME |
40 |
5843.80 |
0.9882 |
1.0083 |
1236 |
100 |
TEST_TIME |
41 |
5810.59 |
0.9893 |
1.0122 |
1309 |
100 |
TEST_TIME |
42 |
5806.76 |
0.9887 |
1.0107 |
1295 |
100 |
TEST_TIME |
43 |
5787.36 |
0.9905 |
1.0112 |
1177 |
100 |
TEST_TIME |
44 |
5821.16 |
0.9825 |
1.0114 |
1199 |
100 |
TEST_TIME |
45 |
5848.74 |
0.9843 |
1.0088 |
2002 |
100 |
TEST_TIME |
46 |
5850.05 |
0.9867 |
1.0190 |
1797 |
100 |
TEST_TIME |
47 |
5920.00 |
0.9856 |
1.0105 |
1728 |
100 |
TEST_TIME |
48 |
5912.92 |
0.9907 |
1.0134 |
1665 |
100 |
TEST_TIME |
49 |
5916.31 |
0.9921 |
1.0163 |
1593 |
100 |
TEST_TIME |
50 |
5963.06 |
0.9882 |
1.0132 |
1361 |
100 |
TEST_TIME |
51 |
5997.05 |
0.9880 |
1.0111 |
1841 |
100 |
TEST_TIME |
52 |
6013.10 |
0.9890 |
1.0089 |
1803 |
100 |
TEST_TIME |
53 |
6055.96 |
0.9829 |
1.0100 |
1595 |
100 |
TEST_TIME |
54 |
6062.54 |
0.9902 |
1.0092 |
1576 |
100 |
TEST_TIME |
55 |
6077.24 |
0.9885 |
1.0129 |
1447 |
100 |
TEST_TIME |
56 |
6108.77 |
0.9897 |
1.0093 |
1453 |
100 |
TEST_TIME |
57 |
6108.37 |
0.9916 |
1.0125 |
1425 |
100 |
TEST_TIME |
58 |
6121.28 |
0.9931 |
1.0076 |
1382 |
100 |
TEST_TIME |
59 |
6114.32 |
0.9916 |
1.0074 |
1290 |
100 |
TEST_TIME |
60 |
6139.28 |
0.9866 |
1.0099 |
2164 |
100 |
TEST_TIME |
61 |
6180.00 |
0.9872 |
1.0128 |
2334 |
100 |
TEST_TIME |
62 |
6235.11 |
0.9876 |
1.0098 |
1727 |
100 |
TEST_TIME |
63 |
6275.41 |
0.9874 |
1.0106 |
1571 |
100 |
TEST_TIME |
64 |
6306.71 |
0.9900 |
1.0072 |
1587 |
100 |
TEST_TIME |
65 |
6290.96 |
0.9942 |
1.0045 |
1757 |
99 |
TEST_TIME |
66 |
6280.95 |
0.9952 |
1.0049 |
1545 |
98 |
TEST_TIME |
67 |
6288.09 |
0.9888 |
1.0064 |
1345 |
100 |
TEST_TIME |
68 |
6280.92 |
0.9928 |
1.0094 |
1487 |
100 |
TEST_TIME |
69 |
6295.89 |
0.9924 |
1.0060 |
1503 |
100 |
TEST_TIME |
70 |
6287.12 |
0.9930 |
1.0074 |
1558 |
100 |
TEST_TIME |
71 |
6278.67 |
0.9946 |
1.0033 |
1701 |
99 |
TEST_TIME |
72 |
6258.95 |
0.9925 |
1.0032 |
1171 |
100 |
TEST_TIME |
73 |
6248.93 |
0.9911 |
1.0045 |
1303 |
100 |
TEST_TIME |
74 |
6233.92 |
0.9933 |
1.0083 |
1315 |
100 |
TEST_TIME |
75 |
6273.60 |
0.9886 |
1.0134 |
2086 |
100 |
TEST_TIME |
76 |
6322.54 |
0.9923 |
1.0068 |
1741 |
100 |
TEST_TIME |
77 |
6351.94 |
0.9892 |
1.0092 |
1760 |
100 |
TEST_TIME |
78 |
6383.95 |
0.9912 |
1.0095 |
1590 |
100 |
TEST_TIME |
79 |
6418.03 |
0.9915 |
1.0089 |
1637 |
100 |
TEST_TIME |
80 |
6434.50 |
0.9938 |
1.0060 |
1667 |
100 |
TEST_TIME |
81 |
6437.37 |
0.9932 |
1.0062 |
1533 |
100 |
TEST_TIME |
82 |
6441.36 |
0.9939 |
1.0077 |
1414 |
100 |
TEST_TIME |
83 |
6430.61 |
0.9972 |
1.0034 |
1374 |
98 |
TEST_TIME |
84 |
6443.78 |
0.9895 |
1.0046 |
1083 |
100 |
TEST_TIME |
85 |
6407.93 |
0.9983 |
1.0028 |
1341 |
97 |
TEST_TIME |
86 |
6407.69 |
0.9947 |
1.0046 |
1157 |
100 |
TEST_TIME |
87 |
6389.79 |
0.9958 |
1.0051 |
1105 |
100 |
TEST_TIME |
88 |
6372.52 |
0.9964 |
1.0023 |
1314 |
100 |
TEST_TIME |
89 |
6348.73 |
0.9968 |
1.0025 |
1406 |
97 |
TEST_TIME |
90 |
6336.11 |
0.9933 |
1.0078 |
1396 |
100 |
TEST_TIME |
91 |
6367.74 |
0.9918 |
1.0071 |
1846 |
100 |
TEST_TIME |
92 |
6376.56 |
0.9948 |
1.0064 |
2053 |
100 |
TEST_TIME |
93 |
6378.07 |
0.9953 |
1.0041 |
1948 |
99 |
TEST_TIME |
94 |
6391.73 |
0.9913 |
1.0068 |
1540 |
100 |
TEST_TIME |
95 |
6424.45 |
0.9911 |
1.0083 |
1444 |
100 |
TEST_TIME |
96 |
6449.23 |
0.9940 |
1.0052 |
1708 |
100 |
TEST_TIME |
97 |
6455.93 |
0.9939 |
1.0054 |
1736 |
100 |
TEST_TIME |
98 |
6471.60 |
0.9927 |
1.0073 |
1358 |
100 |
TEST_TIME |
99 |
6488.97 |
0.9944 |
1.0053 |
1443 |
100 |
TEST_TIME |
100 |
6495.66 |
0.9942 |
1.0076 |
1276 |
100 |
TEST_TIME |
101 |
6509.22 |
0.9955 |
1.0046 |
1406 |
100 |
TEST_TIME |
102 |
6501.12 |
0.9959 |
1.0050 |
1341 |
100 |
TEST_TIME |
103 |
6498.89 |
0.9956 |
1.0062 |
1275 |
100 |
TEST_TIME |
104 |
6501.70 |
0.9963 |
1.0038 |
1279 |
100 |
TEST_TIME |
105 |
6495.53 |
0.9952 |
1.0053 |
1582 |
100 |
TEST_TIME |
106 |
6505.40 |
0.9946 |
1.0039 |
1791 |
100 |
TEST_TIME |
107 |
6502.26 |
0.9950 |
1.0076 |
1687 |
99 |
TEST_TIME |
108 |
6519.33 |
0.9958 |
1.0040 |
1576 |
100 |
TEST_TIME |
109 |
6513.14 |
0.9958 |
1.0049 |
1584 |
100 |
TEST_TIME |
110 |
6518.74 |
0.9950 |
1.0046 |
1799 |
100 |
TEST_TIME |
111 |
6523.39 |
0.9948 |
1.0071 |
1442 |
100 |
TEST_TIME |
112 |
6545.55 |
0.9950 |
1.0049 |
1404 |
100 |
TEST_TIME |
113 |
6563.68 |
0.9933 |
1.0039 |
1491 |
100 |
TEST_TIME |
114 |
6565.18 |
0.9948 |
1.0037 |
1284 |
100 |
TEST_TIME |
115 |
6550.11 |
0.9973 |
1.0041 |
1503 |
99 |
TEST_TIME |
116 |
6552.04 |
0.9959 |
1.0043 |
1449 |
100 |
TEST_TIME |
117 |
6550.54 |
0.9959 |
1.0034 |
1279 |
100 |
TEST_TIME |
118 |
6541.54 |
0.9963 |
1.0034 |
1274 |
100 |
TEST_TIME |
119 |
6566.30 |
0.9912 |
1.0033 |
1153 |
100 |
TEST_TIME |
120 |
6558.22 |
0.9964 |
1.0051 |
1493 |
100 |
TEST_TIME |
121 |
6569.23 |
0.9953 |
1.0041 |
2234 |
100 |
TEST_TIME |
122 |
6576.12 |
0.9965 |
1.0025 |
1888 |
98 |
TEST_TIME |
123 |
6575.56 |
0.9945 |
1.0052 |
1474 |
99 |
TEST_TIME |
124 |
6575.23 |
0.9972 |
1.0047 |
1631 |
97 |
TEST_TIME |
125 |
6578.48 |
0.9961 |
1.0022 |
1543 |
100 |
TEST_TIME |
126 |
6563.02 |
0.9965 |
1.0048 |
1624 |
97 |
TEST_TIME |
127 |
6567.64 |
0.9961 |
1.0036 |
1448 |
99 |
TEST_TIME |
128 |
6554.39 |
0.9978 |
1.0051 |
1479 |
96 |
TEST_TIME |
129 |
6553.77 |
0.9976 |
1.0023 |
1486 |
95 |
TEST_TIME |
130 |
6537.37 |
0.9971 |
1.0041 |
1328 |
95 |
TEST_TIME |
131 |
6528.25 |
0.9978 |
1.0020 |
1453 |
99 |
TEST_TIME |
132 |
6522.75 |
0.9952 |
1.0019 |
1444 |
97 |
TEST_TIME |
133 |
6509.62 |
0.9964 |
1.0039 |
1385 |
94 |
TEST_TIME |
134 |
6508.35 |
0.9966 |
1.0047 |
1311 |
99 |
TEST_TIME |
135 |
6522.57 |
0.9951 |
1.0059 |
1989 |
100 |
TEST_TIME |
136 |
6544.79 |
0.9952 |
1.0036 |
2036 |
100 |
TEST_TIME |
137 |
6579.47 |
0.9926 |
1.0056 |
1736 |
100 |
TEST_TIME |
138 |
6589.30 |
0.9968 |
1.0019 |
1774 |
100 |
TEST_TIME |
139 |
6578.87 |
0.9963 |
1.0037 |
1785 |
93 |
TEST_TIME |
140 |
6590.47 |
0.9948 |
1.0036 |
1386 |
95 |
TEST_TIME |
141 |
6581.56 |
0.9978 |
1.0017 |
1469 |
95 |
TEST_TIME |
142 |
6559.95 |
0.9979 |
1.0033 |
1451 |
91 |
TEST_TIME |
143 |
6571.79 |
0.9945 |
1.0039 |
1022 |
100 |
TEST_TIME |
144 |
6564.44 |
0.9981 |
1.0023 |
1522 |
98 |
TEST_TIME |
145 |
6553.39 |
0.9974 |
1.0012 |
1434 |
99 |
TEST_TIME |
146 |
6539.39 |
0.9965 |
1.0045 |
1191 |
99 |
TEST_TIME |
147 |
6543.97 |
0.9970 |
1.0027 |
1239 |
100 |
TEST_TIME |
148 |
6529.25 |
0.9981 |
1.0014 |
1370 |
98 |
TEST_TIME |
149 |
6532.71 |
0.9941 |
1.0036 |
1037 |
100 |
TEST_TIME |
150 |
6531.42 |
0.9971 |
1.0039 |
1241 |
100 |
TEST_TIME |
151 |
6526.91 |
0.9980 |
1.0028 |
2142 |
98 |
TEST_TIME |
152 |
6522.32 |
0.9969 |
1.0035 |
1705 |
94 |
TEST_TIME |
153 |
6529.80 |
0.9958 |
1.0028 |
1407 |
91 |
TEST_TIME |
154 |
6531.07 |
0.9961 |
1.0023 |
1496 |
92 |
TEST_TIME |
155 |
6519.18 |
0.9977 |
1.0026 |
1720 |
95 |
TEST_TIME |
156 |
6524.19 |
0.9954 |
1.0045 |
1408 |
99 |
TEST_TIME |
157 |
6526.91 |
0.9977 |
1.0014 |
1416 |
100 |
TEST_TIME |
158 |
6509.67 |
0.9978 |
1.0022 |
1564 |
99 |
TEST_TIME |
159 |
6508.12 |
0.9961 |
1.0031 |
1420 |
97 |
TEST_TIME |
160 |
6510.98 |
0.9964 |
1.0028 |
1283 |
100 |
TEST_TIME |
161 |
6503.62 |
0.9977 |
1.0034 |
1526 |
100 |
TEST_TIME |
162 |
6501.09 |
0.9976 |
1.0032 |
1383 |
100 |
TEST_TIME |
163 |
6508.36 |
0.9959 |
1.0039 |
1242 |
100 |
TEST_TIME |
164 |
6509.29 |
0.9977 |
1.0031 |
1210 |
100 |
TEST_TIME |
165 |
6509.49 |
0.9970 |
1.0044 |
1379 |
100 |
TEST_TIME |
166 |
6516.23 |
0.9973 |
1.0022 |
1919 |
99 |
TEST_TIME |
167 |
6515.28 |
0.9964 |
1.0038 |
1625 |
96 |
TEST_TIME |
168 |
6514.99 |
0.9979 |
1.0033 |
1642 |
93 |
TEST_TIME |
169 |
6511.30 |
0.9980 |
1.0022 |
1685 |
92 |
TEST_TIME |
170 |
6512.93 |
0.9961 |
1.0031 |
1454 |
95 |
TEST_TIME |
171 |
6514.11 |
0.9970 |
1.0027 |
1417 |
99 |
TEST_TIME |
172 |
6513.02 |
0.9971 |
1.0018 |
1186 |
100 |
TEST_TIME |
173 |
6512.19 |
0.9961 |
1.0043 |
1338 |
100 |
TEST_TIME |
174 |
6510.75 |
0.9987 |
1.0012 |
1292 |
92 |
TEST_TIME |
175 |
6492.48 |
0.9982 |
1.0016 |
1184 |
80 |
TEST_TIME |
176 |
6484.16 |
0.9972 |
1.0022 |
1157 |
90 |
TEST_TIME |
177 |
6480.18 |
0.9972 |
1.0028 |
1214 |
89 |
TEST_TIME |
178 |
6483.22 |
0.9967 |
1.0023 |
1281 |
91 |
TEST_TIME |
179 |
6481.87 |
0.9969 |
1.0029 |
1121 |
99 |
TEST_TIME |
180 |
6469.53 |
0.9992 |
1.0007 |
1042 |
99 |
Done for 8500 ms, from 6:58:28.74 to 6:58:37.24.
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 |
46814 |
35387 |
45415 |
<null> |
58083 |
71873 |
59869 |
58580 |
69975 |
<null> |
70178 |
53638 |
89544 |
68337 |
74458 |
37014 |
470242 |
603056 |
<null> |
03:46:46 |
04:04:46 |
fetches per second |
2 |
65433 |
55513 |
43790 |
<null> |
52527 |
21341 |
75344 |
101078 |
78977 |
159983 |
61410 |
65836 |
63539 |
75742 |
121772 |
64211 |
270419 |
878033 |
<null> |
04:04:47 |
04:22:47 |
fetches per second |
3 |
39869 |
52574 |
43838 |
<null> |
22457 |
103510 |
47149 |
77452 |
39564 |
79955 |
75852 |
44943 |
91992 |
20589 |
105475 |
75495 |
18309 |
313466 |
<null> |
04:22:48 |
04:40:48 |
fetches per second |
4 |
51121 |
35624 |
49396 |
<null> |
64945 |
18363 |
55832 |
46895 |
4153 |
17059 |
67697 |
45846 |
66901 |
75187 |
72673 |
82102 |
144023 |
123666 |
<null> |
04:40:49 |
04:58:49 |
fetches per second |
5 |
36824 |
39281 |
37505 |
137067 |
37031 |
1993 |
65094 |
1739 |
71317 |
58309 |
66366 |
65678 |
84270 |
31997 |
52651 |
3397 |
350534 |
1126714 |
<null> |
04:58:50 |
05:16:50 |
fetches per second |
6 |
42930 |
83755 |
54236 |
<null> |
22037 |
4704 |
72345 |
4753 |
42458 |
14200 |
47385 |
23960 |
57939 |
24616 |
76690 |
46905 |
173231 |
497249 |
<null> |
05:16:51 |
05:34:51 |
fetches per second |
7 |
19175 |
7679 |
22387 |
<null> |
19975 |
<null> |
29019 |
36106 |
17235 |
90591 |
24539 |
6103 |
45321 |
99913 |
40631 |
13842 |
<null> |
191536 |
<null> |
05:34:52 |
05:52:52 |
fetches per second |
8 |
13232 |
20939 |
13809 |
<null> |
18203 |
<null> |
14581 |
3699 |
14946 |
39271 |
18383 |
2047 |
48573 |
2886 |
52198 |
<null> |
274398 |
99381 |
<null> |
05:52:53 |
06:10:53 |
fetches per second |
9 |
16809 |
43903 |
2580 |
<null> |
19544 |
<null> |
30218 |
3427 |
<null> |
34026 |
27520 |
2928 |
47713 |
18911 |
3361 |
3683 |
285000 |
121085 |
<null> |
06:10:54 |
06:28:54 |
fetches per second |
10 |
10126 |
27972 |
16569 |
<null> |
11023 |
<null> |
31191 |
6485 |
2431 |
6005 |
15920 |
3510 |
69779 |
97910 |
15174 |
55074 |
16437 |
49973 |
<null> |
06:28:55 |
06:46:55 |
marks per second |
1 |
9931 |
4473 |
8866 |
<null> |
11415 |
13483 |
7832 |
10260 |
10409 |
<null> |
11194 |
8805 |
6461 |
12503 |
3391 |
5522 |
3823 |
12333 |
<null> |
03:46:46 |
04:04:46 |
marks per second |
2 |
13694 |
6747 |
9929 |
<null> |
11752 |
4876 |
10255 |
14213 |
11934 |
27557 |
9162 |
11966 |
4861 |
17470 |
8246 |
10188 |
39142 |
49200 |
<null> |
04:04:47 |
04:22:47 |
marks per second |
3 |
8583 |
6628 |
9749 |
<null> |
4759 |
23014 |
6012 |
12022 |
5022 |
12743 |
9373 |
6930 |
6481 |
3329 |
9723 |
11994 |
2469 |
31400 |
<null> |
04:22:48 |
04:40:48 |
marks per second |
4 |
10499 |
4458 |
10765 |
<null> |
14553 |
4305 |
6571 |
7757 |
590 |
2812 |
8364 |
7192 |
4556 |
13619 |
8902 |
15357 |
13994 |
10538 |
<null> |
04:40:49 |
04:58:49 |
marks per second |
5 |
7992 |
5030 |
8149 |
19309 |
7887 |
341 |
7767 |
286 |
7478 |
9888 |
5730 |
9901 |
3973 |
7089 |
5963 |
527 |
59038 |
35285 |
<null> |
04:58:50 |
05:16:50 |
marks per second |
6 |
8830 |
10530 |
10973 |
<null> |
4586 |
1206 |
9096 |
691 |
6195 |
2343 |
6223 |
4140 |
3199 |
3556 |
13388 |
7179 |
13081 |
11713 |
<null> |
05:16:51 |
05:34:51 |
marks per second |
7 |
3996 |
951 |
4660 |
<null> |
3854 |
<null> |
3175 |
5077 |
2016 |
14094 |
2925 |
1034 |
2228 |
9308 |
5379 |
2245 |
<null> |
23804 |
<null> |
05:34:52 |
05:52:52 |
marks per second |
8 |
2790 |
2895 |
2707 |
<null> |
4725 |
<null> |
1614 |
522 |
1811 |
6014 |
3580 |
329 |
2397 |
411 |
6478 |
<null> |
14729 |
3415 |
<null> |
05:52:53 |
06:10:53 |
marks per second |
9 |
3222 |
5676 |
433 |
<null> |
2963 |
<null> |
3896 |
498 |
<null> |
5512 |
3038 |
480 |
1465 |
3266 |
459 |
666 |
10469 |
1400 |
<null> |
06:10:54 |
06:28:54 |
marks per second |
10 |
2094 |
3706 |
3083 |
<null> |
1746 |
<null> |
4055 |
900 |
365 |
835 |
1950 |
596 |
1755 |
16934 |
1165 |
6058 |
2540 |
633 |
<null> |
06:28:55 |
06:46:55 |
reads/fetches*100 |
1 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
03:46:46 |
04:04:46 |
reads/fetches*100 |
2 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:04:47 |
04:22:47 |
reads/fetches*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:22:48 |
04:40:48 |
reads/fetches*100 |
4 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:40:49 |
04:58:49 |
reads/fetches*100 |
5 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:58:50 |
05:16:50 |
reads/fetches*100 |
6 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:16:51 |
05:34:51 |
reads/fetches*100 |
7 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
05:34:52 |
05:52:52 |
reads/fetches*100 |
8 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
05:52:53 |
06:10:53 |
reads/fetches*100 |
9 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
06:10:54 |
06:28:54 |
reads/fetches*100 |
10 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
06:28:55 |
06:46:55 |
writes/marks*100 |
1 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
0 |
4 |
0 |
<null> |
03:46:46 |
04:04:46 |
writes/marks*100 |
2 |
1 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
1 |
0 |
1 |
2 |
0 |
<null> |
04:04:47 |
04:22:47 |
writes/marks*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0 |
<null> |
04:22:48 |
04:40:48 |
writes/marks*100 |
4 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
<null> |
04:40:49 |
04:58:49 |
writes/marks*100 |
5 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:58:50 |
05:16:50 |
writes/marks*100 |
6 |
0 |
0 |
1 |
<null> |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0 |
<null> |
05:16:51 |
05:34:51 |
writes/marks*100 |
7 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
1 |
1 |
0 |
<null> |
0 |
<null> |
05:34:52 |
05:52:52 |
writes/marks*100 |
8 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
05:52:53 |
06:10:53 |
writes/marks*100 |
9 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
4 |
0 |
<null> |
06:10:54 |
06:28:54 |
writes/marks*100 |
10 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
6 |
0 |
<null> |
06:28:55 |
06:46:55 |
Done for 8330 ms, from 6:58:38.21 to 6:58:46.54.
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 |
2043451 |
1879875 |
163576 |
8.00 |
0 |
9188 |
34 |
163576 |
2017-12-10 03:46 |
2017-12-10 06:46 |
doc_list_biud |
2043936 |
1879875 |
164061 |
8.02 |
0 |
6115 |
12 |
164061 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_add_invoice_to_stock |
20303 |
11917 |
8386 |
41.30 |
15 |
168730 |
7979 |
8386 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_cancel_adding_invoice |
4795 |
3715 |
1080 |
22.52 |
0 |
55833 |
1898 |
1080 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_cancel_client_order |
7074 |
6923 |
151 |
2.13 |
0 |
3073 |
197 |
151 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_cancel_customer_reserve |
380332 |
227393 |
152939 |
40.21 |
0 |
3057 |
44 |
152939 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_cancel_pay_from_customer |
2549 |
2537 |
12 |
0.47 |
0 |
2106 |
109 |
12 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_cancel_pay_to_supplier |
1673 |
1667 |
6 |
0.35 |
0 |
2434 |
114 |
6 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_cancel_supplier_invoice |
10639 |
8126 |
2513 |
23.62 |
0 |
7160 |
343 |
2513 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_cancel_supplier_order |
1635 |
571 |
1064 |
65.07 |
0 |
137374 |
15556 |
1064 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_cancel_write_off |
24398 |
16170 |
8228 |
33.72 |
0 |
3557 |
122 |
8228 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_client_order |
82223 |
82223 |
0 |
0.00 |
0 |
7254 |
376 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_customer_reserve |
667871 |
667871 |
0 |
0.00 |
0 |
7581 |
115 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_fill_shopping_cart |
124983 |
124666 |
317 |
0.25 |
0 |
7020 |
75 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_fill_shopping_cart_clo_res |
667871 |
667871 |
0 |
0.00 |
0 |
3042 |
8 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_get_clo_for_invoice |
11917 |
11917 |
0 |
0.00 |
0 |
6708 |
243 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_kill_cost_storno |
33048 |
24089 |
8959 |
27.10 |
0 |
2902 |
16 |
8959 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_kill_qstorno_ret_qs2qd |
795377 |
479653 |
315724 |
39.69 |
0 |
5991 |
16 |
315724 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_kill_qty_storno |
477060 |
313091 |
163969 |
34.37 |
0 |
5991 |
51 |
163969 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_lock_selected_doc |
82235 |
70601 |
11634 |
14.14 |
0 |
2106 |
6 |
11634 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_make_cost_storno |
100791 |
100791 |
0 |
0.00 |
0 |
8908 |
309 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_multiply_rows_for_pdistr |
100791 |
100791 |
0 |
0.00 |
0 |
2433 |
46 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_multiply_rows_for_qdistr |
82223 |
82223 |
0 |
0.00 |
0 |
4368 |
124 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_pay_from_customer |
27825 |
27825 |
0 |
0.00 |
0 |
9297 |
722 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_pay_to_supplier |
22773 |
22773 |
0 |
0.00 |
0 |
8533 |
373 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_payment_common |
50598 |
50598 |
0 |
0.00 |
0 |
4227 |
52 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_qd_handle_on_cancel_clo |
7072 |
6923 |
149 |
2.10 |
0 |
2652 |
85 |
149 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_qd_handle_on_invoice_upd_sts |
16541 |
15632 |
909 |
5.49 |
0 |
5273 |
261 |
909 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_qd_handle_on_reserve_upd_sts |
38276 |
38276 |
0 |
0.00 |
0 |
3354 |
38 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_reserve_write_off |
39292 |
38276 |
1016 |
2.58 |
0 |
7098 |
443 |
1016 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_supplier_invoice |
21470 |
21349 |
121 |
0.56 |
0 |
27082 |
2367 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
sp_supplier_order |
21290 |
21094 |
196 |
0.92 |
0 |
13696 |
1572 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
srv_find_qd_qs_mism |
1232656 |
1069082 |
163574 |
13.27 |
0 |
3807 |
18 |
163574 |
2017-12-10 03:46 |
2017-12-10 06:46 |
srv_make_invnt_saldo |
1919 |
1919 |
0 |
0.00 |
0 |
25257 |
2019 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
srv_make_money_saldo |
3045 |
3045 |
0 |
0.00 |
0 |
2402 |
54 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
srv_recalc_idx_stat |
11 |
11 |
0 |
0.00 |
2511 |
35038 |
15331 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-abend:sp_add_invoice_to_stock |
8386 |
8386 |
0 |
0.00 |
0 |
3947 |
78 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-abend:sp_cancel_adding_invoice |
753 |
753 |
0 |
0.00 |
0 |
2012 |
164 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-abend:sp_cancel_client_order |
151 |
151 |
0 |
0.00 |
0 |
1186 |
91 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-abend:sp_cancel_customer_reserve |
69 |
69 |
0 |
0.00 |
0 |
1123 |
53 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-abend:sp_cancel_pay_from_customer |
12 |
12 |
0 |
0.00 |
0 |
1264 |
115 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-abend:sp_cancel_pay_to_supplier |
6 |
6 |
0 |
0.00 |
0 |
687 |
210 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-abend:sp_cancel_supplier_invoice |
672 |
672 |
0 |
0.00 |
0 |
1404 |
79 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-abend:sp_cancel_supplier_order |
18647 |
18647 |
0 |
0.00 |
0 |
3557 |
86 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-abend:sp_cancel_write_off |
25 |
25 |
0 |
0.00 |
0 |
296 |
74 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-abend:sp_reserve_write_off |
1016 |
1016 |
0 |
0.00 |
0 |
1045 |
47 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-abend:sp_supplier_invoice |
121 |
121 |
0 |
0.00 |
0 |
1076 |
72 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-abend:sp_supplier_order |
196 |
196 |
0 |
0.00 |
0 |
1186 |
69 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-norm:sp_add_invoice_to_stock |
11917 |
11917 |
0 |
0.00 |
0 |
11607 |
462 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-norm:sp_cancel_adding_invoice |
1370 |
1370 |
0 |
0.00 |
0 |
8954 |
489 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-norm:sp_cancel_client_order |
6923 |
6923 |
0 |
0.00 |
0 |
2262 |
52 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-norm:sp_cancel_customer_reserve |
2552 |
2552 |
0 |
0.00 |
0 |
1888 |
48 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-norm:sp_cancel_pay_from_customer |
2537 |
2537 |
0 |
0.00 |
0 |
2340 |
38 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-norm:sp_cancel_pay_to_supplier |
1667 |
1667 |
0 |
0.00 |
0 |
1263 |
36 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-norm:sp_cancel_supplier_invoice |
938 |
938 |
0 |
0.00 |
0 |
1654 |
57 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-norm:sp_cancel_supplier_order |
571 |
571 |
0 |
0.00 |
0 |
36083 |
1446 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-norm:sp_cancel_write_off |
3850 |
3850 |
0 |
0.00 |
0 |
1965 |
56 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-norm:sp_client_order |
82223 |
82223 |
0 |
0.00 |
0 |
2621 |
62 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-norm:sp_customer_reserve |
3801 |
3801 |
0 |
0.00 |
0 |
2231 |
42 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-norm:sp_pay_from_customer |
27825 |
27825 |
0 |
0.00 |
0 |
3994 |
52 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-norm:sp_pay_to_supplier |
22773 |
22773 |
0 |
0.00 |
0 |
2449 |
44 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-norm:sp_reserve_write_off |
38276 |
38276 |
0 |
0.00 |
0 |
4009 |
57 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-norm:sp_supplier_invoice |
21349 |
21349 |
0 |
0.00 |
0 |
2605 |
51 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-norm:sp_supplier_order |
21094 |
21094 |
0 |
0.00 |
0 |
2277 |
53 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-norm:srv_make_invnt_saldo |
1919 |
1919 |
0 |
0.00 |
0 |
1591 |
22 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-norm:srv_make_money_saldo |
3045 |
3045 |
0 |
0.00 |
0 |
733 |
22 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
t$perf-norm:srv_recalc_idx_stat |
11 |
11 |
0 |
0.00 |
0 |
982 |
112 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
v_add_invoice_to_stock |
40606 |
23834 |
16772 |
41.30 |
0 |
2152 |
14 |
16772 |
2017-12-10 03:46 |
2017-12-10 06:46 |
v_all_customers |
123334 |
123334 |
0 |
0.00 |
0 |
718 |
4 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
v_all_suppliers |
86420 |
85786 |
634 |
0.73 |
0 |
1435 |
4 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
v_all_wares |
164446 |
164446 |
0 |
0.00 |
0 |
952 |
3 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
v_cancel_adding_invoice |
3206 |
2740 |
466 |
14.53 |
0 |
2387 |
115 |
466 |
2017-12-10 03:46 |
2017-12-10 06:46 |
v_cancel_client_order |
14148 |
13846 |
302 |
2.13 |
0 |
2402 |
6 |
302 |
2017-12-10 03:46 |
2017-12-10 06:46 |
v_cancel_customer_prepayment |
5098 |
5074 |
24 |
0.47 |
0 |
2091 |
7 |
24 |
2017-12-10 03:46 |
2017-12-10 06:46 |
v_cancel_customer_reserve |
5242 |
5104 |
138 |
2.63 |
0 |
2387 |
8 |
138 |
2017-12-10 03:46 |
2017-12-10 06:46 |
v_cancel_payment_to_supplier |
3346 |
3334 |
12 |
0.35 |
0 |
2324 |
8 |
12 |
2017-12-10 03:46 |
2017-12-10 06:46 |
v_cancel_supplier_invoice |
3220 |
1876 |
1344 |
41.73 |
0 |
1670 |
15 |
1344 |
2017-12-10 03:46 |
2017-12-10 06:46 |
v_cancel_supplier_order |
3270 |
1142 |
2128 |
65.07 |
0 |
952 |
7 |
2128 |
2017-12-10 03:46 |
2017-12-10 06:46 |
v_cancel_write_off |
7750 |
7700 |
50 |
0.64 |
0 |
2715 |
85 |
50 |
2017-12-10 03:46 |
2017-12-10 06:46 |
v_max_id_clo_ord |
21290 |
21094 |
196 |
0.92 |
0 |
998 |
4 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
v_max_id_clo_res |
3801 |
3801 |
0 |
0.00 |
0 |
1965 |
17 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
v_max_id_ord_sup |
21470 |
21349 |
121 |
0.56 |
0 |
702 |
4 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
v_max_non_paid_invoice |
22323 |
22323 |
0 |
0.00 |
0 |
905 |
5 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
v_max_non_paid_realizn |
27825 |
27825 |
0 |
0.00 |
0 |
983 |
5 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
v_min_id_clo_ord |
21290 |
21094 |
196 |
0.92 |
0 |
593 |
5 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
v_min_id_clo_res |
3801 |
3801 |
0 |
0.00 |
0 |
2886 |
11 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
v_min_id_ord_sup |
21470 |
21349 |
121 |
0.56 |
0 |
1544 |
6 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
v_min_non_paid_invoice |
22773 |
22773 |
0 |
0.00 |
0 |
2199 |
9 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
v_min_non_paid_realizn |
27825 |
27825 |
0 |
0.00 |
0 |
1950 |
8 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
v_our_firm |
41112 |
41112 |
0 |
0.00 |
0 |
749 |
5 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
v_reserve_write_off |
78584 |
76552 |
2032 |
2.58 |
0 |
2464 |
7 |
2032 |
2017-12-10 03:46 |
2017-12-10 06:46 |
x_lock_depdocs_on_canc_invoice |
20400 |
10903 |
9497 |
46.55 |
0 |
2386 |
24 |
9497 |
2017-12-10 03:46 |
2017-12-10 06:46 |
x_lock_depdocs_on_canc_sup_ord |
1633 |
571 |
1062 |
65.03 |
0 |
1294 |
46 |
1062 |
2017-12-10 03:46 |
2017-12-10 06:46 |
x_make_qstorno_1000_1200 |
21290 |
21094 |
196 |
0.92 |
0 |
13618 |
1405 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
x_make_qstorno_1200_2000 |
21470 |
21349 |
121 |
0.56 |
0 |
26879 |
2194 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
x_make_qstorno_2100_3300 |
667871 |
667871 |
0 |
0.00 |
0 |
7566 |
95 |
0 |
2017-12-10 03:46 |
2017-12-10 06:46 |
Done for 295950 ms, from 7:03:32.46 to 7:08:28.41.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
DTS_BEG |
DTS_END |
deadlock |
85 |
sp_kill_cost_storno |
335544336 |
2017-12-10 03:47 |
2017-12-10 06:45 |
deadlock |
95 |
sp_kill_qstorno_ret_qs2qd |
335544336 |
2017-12-10 04:02 |
2017-12-10 06:45 |
deadlock |
10183 |
sp_lock_selected_doc |
335544336 |
2017-12-10 03:46 |
2017-12-10 06:46 |
deadlock |
149 |
sp_qd_handle_on_cancel_clo |
335544336 |
2017-12-10 03:58 |
2017-12-10 06:43 |
deadlock |
187 |
sp_qd_handle_on_invoice_upd_sts |
335544336 |
2017-12-10 03:47 |
2017-12-10 06:45 |
deadlock |
660 |
x_lock_depdocs_on_canc_invoice |
335544336 |
2017-12-10 03:46 |
2017-12-10 06:46 |
deadlock |
273 |
x_lock_depdocs_on_canc_sup_ord |
335544336 |
2017-12-10 03:48 |
2017-12-10 06:46 |
user_exc |
196 |
x_make_qstorno_1000_1200 |
335544517 |
2017-12-10 03:46 |
2017-12-10 06:45 |
user_exc |
121 |
x_make_qstorno_1200_2000 |
335544517 |
2017-12-10 03:48 |
2017-12-10 06:44 |
Done for 10330 ms, from 7:08:35.14 to 7:08:45.47.
MON$DATABASE_NAME D:\OLTP-EMUL\OLTP30-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 443416
MON$OLDEST_ACTIVE 443417
MON$OLDEST_SNAPSHOT 443417
MON$NEXT_TRANSACTION 443417
MON$PAGE_BUFFERS 786432
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2017-01-11 15:12:20.4040
MON$PAGES 836288
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-V3.0.3.32852 Firebird 3.0
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.3.32852 Firebird 3.0"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.3.32852 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.3.32852 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
on disk structure version 12.0
Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB"
Gstat execution time Sun Dec 10 07:08:45 2017
Database header page information:
Flags 0
Generation 443571
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 443418
Oldest active 443419
Oldest snapshot 443419
Next transaction 443420
Sequence number 0
Next attachment ID 9536
Implementation HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jan 11, 2017 15:12:20
Attributes force write
Variable header data:
Sweep interval: 0
*END*
Database file sequence:
File D:\OLTP-EMUL\OLTP30-SMALL.FDB is the only file
Analyzing database pages ...
AGENTS (154)
Primary pointer page: 311, Index root page: 312
Total formats: 1, used formats: 1
Average record length: 33.58, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 344.00, compression ratio: 10.24
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_ID_DESC (2)
Root page: 322, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_OUR_FIRM (4)
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 48
Average key length: 2.04, compression ratio: 0.50
Average prefix length: 0.96, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_SUPPLIER (3)
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 44
Average key length: 2.04, compression ratio: 0.54
Average prefix length: 1.04, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_NAME_UNQ (1)
Root page: 321, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.16, total dup: 0, max dup: 0
Average key length: 15.86, compression ratio: 0.92
Average prefix length: 1.44, average data length: 13.16
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_AGENTS (0)
Root page: 320, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BUSINESS_OPS (158)
Primary pointer page: 332, Index root page: 333
Total formats: 1, used formats: 1
Average record length: 107.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1236.00, compression ratio: 11.55
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 29%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BO_UNIT_UNQ (1)
Root page: 336, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 18.00, total dup: 0, max dup: 0
Average key length: 16.95, compression ratio: 1.25
Average prefix length: 7.21, average data length: 14.00
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BUSINESS_OPS_RND_WGTH (2)
Root page: 337, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 4.05, total dup: 7, max dup: 3
Average key length: 3.00, compression ratio: 0.75
Average prefix length: 1.42, average data length: 0.84
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$1 (0)
Root page: 335, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 5.26, total dup: 0, max dup: 0
Average key length: 4.21, compression ratio: 0.64
Average prefix length: 1.05, average data length: 1.63
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DOC_DATA (141)
Primary pointer page: 251, Index root page: 252
Total formats: 1, used formats: 1
Average record length: 47.10, total records: 2170418
Average version length: 47.68, total versions: 3487, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.36
Pointer pages: 15, data page slots: 23472
Data pages: 23472, average fill: 73%
Primary pages: 23472, secondary pages: 0, swept pages: 12908
Empty pages: 3, full pages: 21428
Fill distribution:
0 - 19% = 4
20 - 39% = 5
40 - 59% = 51
60 - 79% = 23405
80 - 99% = 7
Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26189, depth: 3, leaf buckets: 10575, nodes: 2170418
Average node length: 19.38, total dup: 0, max dup: 0
Average key length: 16.42, compression ratio: 1.64
Average prefix length: 13.57, average data length: 13.43
Clustering factor: 410666, ratio: 0.19
Fill distribution:
0 - 19% = 728
20 - 39% = 2582
40 - 59% = 4579
60 - 79% = 1163
80 - 99% = 1523
Index DOC_DATA_ID_DESC (2)
Root page: 45719, depth: 3, leaf buckets: 7783, nodes: 2170418
Average node length: 11.63, total dup: 0, max dup: 0
Average key length: 8.68, compression ratio: 1.04
Average prefix length: 3.32, average data length: 5.68
Clustering factor: 394169, ratio: 0.18
Fill distribution:
0 - 19% = 0
20 - 39% = 3706
40 - 59% = 3975
60 - 79% = 94
80 - 99% = 8
Index FK_DOC_DATA_DOC_LIST (3)
Root page: 179522, depth: 3, leaf buckets: 3759, nodes: 2170418
Average node length: 6.86, total dup: 1569534, max dup: 49
Average key length: 3.90, compression ratio: 2.31
Average prefix length: 7.37, average data length: 1.63
Clustering factor: 373140, ratio: 0.17
Fill distribution:
0 - 19% = 142
20 - 39% = 1196
40 - 59% = 1520
60 - 79% = 332
80 - 99% = 569
DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 60.35, total records: 667870
Average version length: 37.34, total versions: 3388, max versions: 3
Average fragment length: 18.85, total fragments: 13, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 6, data page slots: 8448
Data pages: 8448, average fill: 75%
Primary pages: 8444, secondary pages: 4, swept pages: 6414
Empty pages: 6, full pages: 7987
Fill distribution:
0 - 19% = 12
20 - 39% = 8
40 - 59% = 36
60 - 79% = 8338
80 - 99% = 54
Index DOC_LIST_ID_DESC (1)
Root page: 245867, depth: 3, leaf buckets: 2454, nodes: 667870
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.82, compression ratio: 1.02
Average prefix length: 3.17, average data length: 5.83
Clustering factor: 165240, ratio: 0.25
Fill distribution:
0 - 19% = 0
20 - 39% = 1314
40 - 59% = 1085
60 - 79% = 47
80 - 99% = 8
Index FK_DOC_LIST_AGENTS (2)
Root page: 2807, depth: 2, leaf buckets: 701, nodes: 667870
Average node length: 4.88, total dup: 667820, max dup: 43990
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 305623, ratio: 0.46
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 606
60 - 79% = 71
80 - 99% = 24
Index PK_DOC_LIST (0)
Root page: 333415, depth: 3, leaf buckets: 1872, nodes: 667870
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.82, compression ratio: 1.02
Average prefix length: 3.18, average data length: 5.82
Clustering factor: 165240, ratio: 0.25
Fill distribution:
0 - 19% = 124
20 - 39% = 460
40 - 59% = 663
60 - 79% = 304
80 - 99% = 321
DOC_STATES (153)
Primary pointer page: 309, Index root page: 310
Total formats: 1, used formats: 1
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 650.00, compression ratio: 9.63
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_MCODE_UNQ (1)
Root page: 318, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 17.75, total dup: 0, max dup: 0
Average key length: 16.50, compression ratio: 1.08
Average prefix length: 4.00, average data length: 13.75
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_NAME_UNQ (2)
Root page: 319, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 33.25, total dup: 0, max dup: 0
Average key length: 32.00, compression ratio: 0.99
Average prefix length: 2.50, average data length: 29.25
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_DOC_STATES (0)
Root page: 317, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 4.75, total dup: 0, max dup: 0
Average key length: 3.50, compression ratio: 0.86
Average prefix length: 1.50, average data length: 1.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
FB_ERRORS (159)
Primary pointer page: 338, Index root page: 339
Total formats: 1, used formats: 1
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 148.00, compression ratio: 1.86
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 56%
Primary pages: 16, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 11
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7
Index FB_ERRORS_GDS_CODE (0)
Root page: 340, depth: 1, leaf buckets: 1, nodes: 758
Average node length: 4.24, total dup: 0, max dup: 0
Average key length: 3.04, compression ratio: 1.64
Average prefix length: 3.97, average data length: 1.03
Clustering factor: 353, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
INVNT_SALDO (147)
Primary pointer page: 270, Index root page: 271
Total formats: 1, used formats: 1
Average record length: 65.11, total records: 400
Average version length: 20.79, total versions: 45872, max versions: 128
Average fragment length: 18.07, total fragments: 375, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.60
Pointer pages: 1, data page slots: 568
Data pages: 288, average fill: 77%
Primary pages: 9, secondary pages: 279, swept pages: 0
Empty pages: 5, full pages: 282
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 188
80 - 99% = 95
Index PK_INVNT_SALDO (0)
Root page: 282, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 292, ratio: 0.73
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
INVNT_TURNOVER_LOG (157)
Primary pointer page: 330, Index root page: 331
Total formats: 1, used formats: 1
Average record length: 3.42, total records: 9251
Average version length: 71.18, total versions: 8807, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 28.07
Pointer pages: 1, data page slots: 1080
Data pages: 440, average fill: 28%
Primary pages: 438, secondary pages: 2, swept pages: 183
Empty pages: 198, full pages: 59
Fill distribution:
0 - 19% = 226
20 - 39% = 75
40 - 59% = 35
60 - 79% = 59
80 - 99% = 45
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1845, depth: 2, leaf buckets: 35, nodes: 9251
Average node length: 14.43, total dup: 14, max dup: 1
Average key length: 12.49, compression ratio: 2.16
Average prefix length: 17.50, average data length: 9.50
Clustering factor: 8105, ratio: 0.88
Fill distribution:
0 - 19% = 0
20 - 39% = 7
40 - 59% = 23
60 - 79% = 5
80 - 99% = 0
MONEY_SALDO (143)
Primary pointer page: 262, Index root page: 263
Total formats: 1, used formats: 1
Average record length: 15.02, total records: 49
Average version length: 9.02, total versions: 4193, max versions: 1024
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 2.13
Pointer pages: 1, data page slots: 24
Data pages: 24, average fill: 60%
Primary pages: 2, secondary pages: 22, swept pages: 0
Empty pages: 1, full pages: 12
Fill distribution:
0 - 19% = 3
20 - 39% = 1
40 - 59% = 7
60 - 79% = 3
80 - 99% = 10
Index PK_MONEY_SALDO (0)
Root page: 273, depth: 1, leaf buckets: 1, nodes: 49
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MONEY_TURNOVER_LOG (142)
Primary pointer page: 260, Index root page: 261
Total formats: 1, used formats: 1
Average record length: 4.67, total records: 525
Average version length: 44.95, total versions: 471, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 13.69
Pointer pages: 1, data page slots: 56
Data pages: 40, average fill: 13%
Primary pages: 38, secondary pages: 2, swept pages: 11
Empty pages: 30, full pages: 4
Fill distribution:
0 - 19% = 33
20 - 39% = 0
40 - 59% = 2
60 - 79% = 2
80 - 99% = 3
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 179693, depth: 2, leaf buckets: 1, nodes: 525
Average node length: 5.21, total dup: 454, max dup: 59
Average key length: 3.76, compression ratio: 5.05
Average prefix length: 17.37, average data length: 1.63
Clustering factor: 251, ratio: 0.48
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG (165)
Primary pointer page: 354, Index root page: 355
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_DTS (4)
Root page: 365, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_GDSCODE (2)
Root page: 363, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_ROWSET_DESC (1)
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_UNIT (3)
Root page: 364, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG (0)
Root page: 361, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG_TABLE_STATS (166)
Primary pointer page: 366, Index root page: 367
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_DTS (4)
Root page: 373, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_GDSCODE (2)
Root page: 371, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_ROWSET (1)
Root page: 370, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_TN_UNIT (3)
Root page: 372, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG_TABLE_STATS (0)
Root page: 369, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
OPTYPES (138)
Primary pointer page: 239, Index root page: 240
Total formats: 1, used formats: 1
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 5.54
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 9%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OPTYPES_MCODE_UNQ (1)
Root page: 242, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 8.56, total dup: 0, max dup: 0
Average key length: 6.89, compression ratio: 0.73
Average prefix length: 0.44, average data length: 4.56
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_OPTYPES (0)
Root page: 241, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 6.11, total dup: 0, max dup: 0
Average key length: 5.00, compression ratio: 0.60
Average prefix length: 0.89, average data length: 2.11
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PDISTR (150)
Primary pointer page: 293, Index root page: 294
Total formats: 1, used formats: 1
Average record length: 41.80, total records: 218702
Average version length: 31.12, total versions: 7516, max versions: 11
Average fragment length: 34.00, total fragments: 2, max fragments: 1
Average unpacked length: 64.00, compression ratio: 1.53
Pointer pages: 2, data page slots: 2560
Data pages: 2560, average fill: 64%
Primary pages: 2542, secondary pages: 18, swept pages: 1218
Empty pages: 20, full pages: 668
Fill distribution:
0 - 19% = 46
20 - 39% = 100
40 - 59% = 404
60 - 79% = 2000
80 - 99% = 10
Index PDISTR_AGENT_ID (4)
Root page: 5420, depth: 2, leaf buckets: 210, nodes: 218702
Average node length: 4.55, total dup: 218653, max dup: 11053
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 37054, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 16
40 - 59% = 112
60 - 79% = 65
80 - 99% = 17
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4740, depth: 2, leaf buckets: 239, nodes: 218702
Average node length: 5.49, total dup: 197170, max dup: 48
Average key length: 2.95, compression ratio: 7.46
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 48757, ratio: 0.22
Fill distribution:
0 - 19% = 1
20 - 39% = 12
40 - 59% = 111
60 - 79% = 76
80 - 99% = 39
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 4730, depth: 2, leaf buckets: 240, nodes: 218702
Average node length: 5.49, total dup: 197170, max dup: 48
Average key length: 2.95, compression ratio: 7.45
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 48835, ratio: 0.22
Fill distribution:
0 - 19% = 1
20 - 39% = 14
40 - 59% = 95
60 - 79% = 92
80 - 99% = 38
Index PDISTR_SND_ID (1)
Root page: 4894, depth: 2, leaf buckets: 233, nodes: 218702
Average node length: 5.28, total dup: 197170, max dup: 48
Average key length: 2.74, compression ratio: 3.29
Average prefix length: 8.36, average data length: 0.64
Clustering factor: 48808, ratio: 0.22
Fill distribution:
0 - 19% = 2
20 - 39% = 13
40 - 59% = 97
60 - 79% = 87
80 - 99% = 34
PERF_ESTIMATED (160)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 27.97, total records: 275791
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 1.14
Pointer pages: 2, data page slots: 2360
Data pages: 2360, average fill: 64%
Primary pages: 2360, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 2355
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 1
60 - 79% = 2355
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 641901, depth: 2, leaf buckets: 219, nodes: 275791
Average node length: 4.54, total dup: 275610, max dup: 2587
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.59, average data length: 0.00
Clustering factor: 47510, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 76
60 - 79% = 69
80 - 99% = 72
PERF_ISQL_STAT (161)
Primary pointer page: 344, Index root page: 345
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PERF_ISQL_STAT_TRN (0)
Root page: 346, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PERF_LOG (163)
Primary pointer page: 350, Index root page: 351
Total formats: 1, used formats: 1
Average record length: 151.73, total records: 12441050
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.18
Pointer pages: 181, data page slots: 295304
Data pages: 295304, average fill: 87%
Primary pages: 295304, secondary pages: 0, swept pages: 3
Empty pages: 6, full pages: 295297
Fill distribution:
0 - 19% = 6
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 295297
Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 64458, depth: 3, leaf buckets: 14164, nodes: 12441050
Average node length: 5.68, total dup: 11595426, max dup: 142
Average key length: 2.16, compression ratio: 3.69
Average prefix length: 7.87, average data length: 0.12
Clustering factor: 3635155, ratio: 0.29
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 8034
60 - 79% = 4067
80 - 99% = 2058
Index PERF_LOG_GDSCODE (3)
Root page: 163628, depth: 3, leaf buckets: 12445, nodes: 12441050
Average node length: 4.62, total dup: 12441046, max dup: 11237016
Average key length: 1.10, compression ratio: 0.44
Average prefix length: 0.48, average data length: 0.00
Clustering factor: 366963, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 12443
60 - 79% = 1
80 - 99% = 1
Index PERF_LOG_TRN_DESC (2)
Root page: 43655, depth: 3, leaf buckets: 15320, nodes: 12441050
Average node length: 5.74, total dup: 12069477, max dup: 27054
Average key length: 2.22, compression ratio: 4.05
Average prefix length: 8.81, average data length: 0.19
Clustering factor: 911802, ratio: 0.07
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 11606
60 - 79% = 2092
80 - 99% = 1620
Index PERF_LOG_UNIT (1)
Root page: 77766, depth: 3, leaf buckets: 15162, nodes: 12441050
Average node length: 5.59, total dup: 12414852, max dup: 1769733
Average key length: 2.07, compression ratio: 18.31
Average prefix length: 37.80, average data length: 0.07
Clustering factor: 6407016, ratio: 0.51
Fill distribution:
0 - 19% = 16
20 - 39% = 3
40 - 59% = 13065
60 - 79% = 556
80 - 99% = 1522
PHRASES (145)
Primary pointer page: 266, Index root page: 267
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_ID_DESC (3)
Root page: 280, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_NAME (2)
Root page: 279, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_UNQ (1)
Root page: 278, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_PHRASES (0)
Root page: 277, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PSTORNED (151)
Primary pointer page: 301, Index root page: 302
Total formats: 1, used formats: 1
Average record length: 55.05, total records: 469876
Average version length: 55.83, total versions: 865, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.45
Pointer pages: 4, data page slots: 5576
Data pages: 5576, average fill: 75%
Primary pages: 5576, secondary pages: 0, swept pages: 3550
Empty pages: 8, full pages: 5324
Fill distribution:
0 - 19% = 11
20 - 39% = 7
40 - 59% = 17
60 - 79% = 5539
80 - 99% = 2
Index PSTORNED_RCV_ID (2)
Root page: 619913, depth: 3, leaf buckets: 609, nodes: 469876
Average node length: 5.92, total dup: 397416, max dup: 604
Average key length: 3.12, compression ratio: 2.88
Average prefix length: 8.03, average data length: 0.97
Clustering factor: 61015, ratio: 0.13
Fill distribution:
0 - 19% = 7
20 - 39% = 28
40 - 59% = 370
60 - 79% = 141
80 - 99% = 63
Index PSTORNED_SND_ID (1)
Root page: 2157, depth: 2, leaf buckets: 505, nodes: 469876
Average node length: 5.61, total dup: 419028, max dup: 104
Average key length: 2.81, compression ratio: 3.21
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 115078, ratio: 0.24
Fill distribution:
0 - 19% = 0
20 - 39% = 7
40 - 59% = 226
60 - 79% = 179
80 - 99% = 93
RULES_FOR_PDISTR (152)
Primary pointer page: 303, Index root page: 304
Total formats: 1, used formats: 1
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 336.00, compression ratio: 18.67
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 2%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_PDISTR_UNQ (0)
Root page: 308, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 11.50, total dup: 0, max dup: 0
Average key length: 10.25, compression ratio: 0.88
Average prefix length: 1.50, average data length: 7.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RULES_FOR_QDISTR (139)
Primary pointer page: 243, Index root page: 244
Total formats: 1, used formats: 1
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 332.00, compression ratio: 10.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_RCVOP (1)
Root page: 246, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 5.29, total dup: 2, max dup: 2
Average key length: 4.14, compression ratio: 0.72
Average prefix length: 1.43, average data length: 1.57
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_UNQ (0)
Root page: 245, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 10.14, total dup: 0, max dup: 0
Average key length: 8.86, compression ratio: 0.94
Average prefix length: 2.14, average data length: 6.14
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SEMAPHORES (156)
Primary pointer page: 315, Index root page: 316
Total formats: 1, used formats: 1
Average record length: 34.25, total records: 4
Average version length: 9.00, total versions: 1301, max versions: 1169
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: 7
Data pages: 6, average fill: 72%
Primary pages: 1, secondary pages: 5, swept pages: 0
Empty pages: 0, full pages: 3
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 3
80 - 99% = 2
Index PK_SEMAPHORES (0)
Root page: 327, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 12.50, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.50, average data length: 8.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SEMAPHORES_TASK_UNQ (1)
Root page: 328, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 22.50, total dup: 0, max dup: 0
Average key length: 21.00, compression ratio: 1.07
Average prefix length: 4.00, average data length: 18.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SETTINGS (137)
Primary pointer page: 236, Index root page: 237
Total formats: 1, used formats: 1
Average record length: 98.31, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1347.00, compression ratio: 13.70
Pointer pages: 1, data page slots: 2
Data pages: 2, average fill: 80%
Primary pages: 2, secondary pages: 0, swept pages: 2
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1
Index SETTINGS_MODE_CODE (0)
Root page: 238, depth: 1, leaf buckets: 1, nodes: 114
Average node length: 27.11, total dup: 0, max dup: 0
Average key length: 26.10, compression ratio: 1.70
Average prefix length: 21.18, average data length: 23.11
Clustering factor: 6, ratio: 0.05
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$RAND$CALLS (136)
Primary pointer page: 234, Index root page: 235
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$SOURCE (135)
Primary pointer page: 232, Index root page: 233
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$DEP_DOCS (129)
Primary pointer page: 198, Index root page: 199
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_DEP_DOCS_UNQ (0)
Root page: 200, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$IDX_RECALC (132)
Primary pointer page: 207, Index root page: 224
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0)
Root page: 226, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG (133)
Primary pointer page: 227, Index root page: 228
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG_TABLE_STATS (134)
Primary pointer page: 230, Index root page: 231
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_LOG (164)
Primary pointer page: 352, Index root page: 353
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Root page: 360, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_MON (131)
Primary pointer page: 205, Index root page: 206
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$RESULT_SET (130)
Primary pointer page: 201, Index root page: 202
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_DOC (1)
Root page: 204, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_WARE_DOC (0)
Root page: 203, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$SHOPPING_CART (128)
Primary pointer page: 193, Index root page: 194
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_SHOPCART_UNQ (0)
Root page: 197, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRACE_STAT (162)
Primary pointer page: 347, Index root page: 348
Total formats: 1, used formats: 1
Average record length: 57.57, total records: 2697
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 6.53
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% = 1
60 - 79% = 32
80 - 99% = 0
WARES (144)
Primary pointer page: 264, Index root page: 265
Total formats: 1, used formats: 1
Average record length: 78.23, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 448.00, compression ratio: 5.73
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 78%
Primary pages: 6, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2
Index FK_WARES_WARE_GROUPS (3)
Root page: 377, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 67
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 48, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARES (0)
Root page: 274, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 335, ratio: 0.84
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_ID_DESC (2)
Root page: 276, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 335, ratio: 0.84
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_NUMB_UNQ (1)
Root page: 507, depth: 2, leaf buckets: 4, nodes: 400
Average node length: 52.86, total dup: 0, max dup: 0
Average key length: 51.84, compression ratio: 1.00
Average prefix length: 2.73, average data length: 48.86
Clustering factor: 334, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3
80 - 99% = 0
WARE_GROUPS (155)
Primary pointer page: 313, Index root page: 314
Total formats: 1, used formats: 1
Average record length: 32.13, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 352.00, compression ratio: 10.96
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 5%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARE_GROUPS (0)
Root page: 325, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 11.25, total dup: 0, max dup: 0
Average key length: 10.13, compression ratio: 0.89
Average prefix length: 1.75, average data length: 7.25
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index WARE_GROUPS_NAME_UNQ (1)
Root page: 326, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 19.88, total dup: 0, max dup: 0
Average key length: 18.13, compression ratio: 0.89
Average prefix length: 0.25, average data length: 15.88
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQD_1000_1200 (260)
Primary pointer page: 292, Index root page: 295
Total formats: 1, used formats: 1
Average record length: 14.64, total records: 18445
Average version length: 72.21, total versions: 14708, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 9.29
Pointer pages: 2, data page slots: 1952
Data pages: 520, average fill: 46%
Primary pages: 519, secondary pages: 1, swept pages: 113
Empty pages: 159, full pages: 236
Fill distribution:
0 - 19% = 226
20 - 39% = 34
40 - 59% = 16
60 - 79% = 40
80 - 99% = 204
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1346, depth: 2, leaf buckets: 27, nodes: 18445
Average node length: 5.92, total dup: 16088, max dup: 14
Average key length: 3.81, compression ratio: 9.71
Average prefix length: 35.32, average data length: 1.68
Clustering factor: 2956, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 7
40 - 59% = 11
60 - 79% = 5
80 - 99% = 3
XQD_1000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 71.58, total records: 993807
Average version length: 71.88, total versions: 8259, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.90
Pointer pages: 10, data page slots: 14792
Data pages: 14792, average fill: 74%
Primary pages: 14792, secondary pages: 0, swept pages: 7452
Empty pages: 22, full pages: 11643
Fill distribution:
0 - 19% = 51
20 - 39% = 140
40 - 59% = 626
60 - 79% = 13908
80 - 99% = 67
Index XQD_1000_3300_DOC (1)
Root page: 521322, depth: 3, leaf buckets: 1112, nodes: 993807
Average node length: 5.12, total dup: 967315, max dup: 124
Average key length: 2.19, compression ratio: 4.10
Average prefix length: 8.83, average data length: 0.17
Clustering factor: 114452, ratio: 0.12
Fill distribution:
0 - 19% = 13
20 - 39% = 77
40 - 59% = 794
60 - 79% = 41
80 - 99% = 187
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 193506, depth: 3, leaf buckets: 1421, nodes: 993807
Average node length: 6.24, total dup: 867862, max dup: 14
Average key length: 3.32, compression ratio: 11.16
Average prefix length: 35.81, average data length: 1.19
Clustering factor: 192462, ratio: 0.19
Fill distribution:
0 - 19% = 13
20 - 39% = 148
40 - 59% = 995
60 - 79% = 156
80 - 99% = 109
XQD_1200_2000 (261)
Primary pointer page: 718, Index root page: 719
Total formats: 1, used formats: 1
Average record length: 22.71, total records: 58873
Average version length: 72.08, total versions: 40353, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 5.99
Pointer pages: 4, data page slots: 4696
Data pages: 1992, average fill: 37%
Primary pages: 1991, secondary pages: 1, swept pages: 402
Empty pages: 711, full pages: 571
Fill distribution:
0 - 19% = 966
20 - 39% = 124
40 - 59% = 150
60 - 79% = 333
80 - 99% = 419
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 832787, depth: 3, leaf buckets: 103, nodes: 58873
Average node length: 6.20, total dup: 51597, max dup: 49
Average key length: 3.48, compression ratio: 10.64
Average prefix length: 35.65, average data length: 1.35
Clustering factor: 6663, ratio: 0.11
Fill distribution:
0 - 19% = 5
20 - 39% = 38
40 - 59% = 38
60 - 79% = 19
80 - 99% = 3
XQD_2000_3300 (263)
Primary pointer page: 735, Index root page: 736
Total formats: 1, used formats: 1
Average record length: 70.30, total records: 1641903
Average version length: 71.77, total versions: 42886, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.93
Pointer pages: 17, data page slots: 26312
Data pages: 26152, average fill: 69%
Primary pages: 26151, secondary pages: 1, swept pages: 14240
Empty pages: 455, full pages: 17900
Fill distribution:
0 - 19% = 855
20 - 39% = 1076
40 - 59% = 2677
60 - 79% = 20752
80 - 99% = 792
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 196671, depth: 3, leaf buckets: 2611, nodes: 1641903
Average node length: 5.60, total dup: 1545620, max dup: 49
Average key length: 2.64, compression ratio: 14.00
Average prefix length: 36.41, average data length: 0.59
Clustering factor: 209004, ratio: 0.13
Fill distribution:
0 - 19% = 11
20 - 39% = 1216
40 - 59% = 1060
60 - 79% = 156
80 - 99% = 168
XQD_2100_3300 (264)
Primary pointer page: 738, Index root page: 739
Total formats: 1, used formats: 1
Average record length: 7.71, total records: 8177
Average version length: 72.00, total versions: 7279, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 17.64
Pointer pages: 4, data page slots: 2488
Data pages: 1064, average fill: 11%
Primary pages: 1063, secondary pages: 1, swept pages: 302
Empty pages: 644, full pages: 22
Fill distribution:
0 - 19% = 836
20 - 39% = 118
40 - 59% = 69
60 - 79% = 22
80 - 99% = 19
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1215, depth: 2, leaf buckets: 15, nodes: 8177
Average node length: 6.24, total dup: 7342, max dup: 51
Average key length: 4.06, compression ratio: 9.12
Average prefix length: 35.04, average data length: 1.96
Clustering factor: 1177, ratio: 0.14
Fill distribution:
0 - 19% = 0
20 - 39% = 8
40 - 59% = 4
60 - 79% = 2
80 - 99% = 1
XQD_3300_3400 (265)
Primary pointer page: 741, Index root page: 742
Total formats: 1, used formats: 1
Average record length: 71.08, total records: 2754607
Average version length: 71.03, total versions: 17601, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.91
Pointer pages: 25, data page slots: 39336
Data pages: 39336, average fill: 76%
Primary pages: 39336, secondary pages: 0, swept pages: 27428
Empty pages: 71, full pages: 35681
Fill distribution:
0 - 19% = 91
20 - 39% = 87
40 - 59% = 589
60 - 79% = 38130
80 - 99% = 439
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 40476, depth: 3, leaf buckets: 5718, nodes: 2754607
Average node length: 6.89, total dup: 2223853, max dup: 15
Average key length: 3.92, compression ratio: 9.45
Average prefix length: 35.28, average data length: 1.72
Clustering factor: 488471, ratio: 0.18
Fill distribution:
0 - 19% = 8
20 - 39% = 3100
40 - 59% = 2155
60 - 79% = 284
80 - 99% = 171
XQS_1000_1200 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 83.73, total records: 4724681
Average version length: 84.79, total versions: 2706, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.62
Pointer pages: 45, data page slots: 72640
Data pages: 72640, average fill: 80%
Primary pages: 72640, secondary pages: 0, swept pages: 26846
Empty pages: 8, full pages: 72049
Fill distribution:
0 - 19% = 10
20 - 39% = 3
40 - 59% = 37
60 - 79% = 20722
80 - 99% = 51868
Index XQS_1000_1200_DOC_ID (0)
Root page: 54645, depth: 3, leaf buckets: 4914, nodes: 4724681
Average node length: 5.16, total dup: 4616813, max dup: 135
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 740420, ratio: 0.16
Fill distribution:
0 - 19% = 20
20 - 39% = 113
40 - 59% = 2326
60 - 79% = 1950
80 - 99% = 505
Index XQS_1000_1200_RCV_ID (2)
Root page: 82607, depth: 3, leaf buckets: 4951, nodes: 4724681
Average node length: 5.70, total dup: 4225519, max dup: 49
Average key length: 2.72, compression ratio: 3.31
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 219137, ratio: 0.05
Fill distribution:
0 - 19% = 44
20 - 39% = 148
40 - 59% = 2477
60 - 79% = 321
80 - 99% = 1961
Index XQS_1000_1200_SND_ID (1)
Root page: 47515, depth: 3, leaf buckets: 5437, nodes: 4724681
Average node length: 5.81, total dup: 4134042, max dup: 28
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 796697, ratio: 0.17
Fill distribution:
0 - 19% = 23
20 - 39% = 117
40 - 59% = 2478
60 - 79% = 2089
80 - 99% = 730
XQS_1000_3300 (268)
Primary pointer page: 755, Index root page: 756
Total formats: 1, used formats: 1
Average record length: 83.02, total records: 2581161
Average version length: 82.88, total versions: 13802, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.64
Pointer pages: 26, data page slots: 40952
Data pages: 40952, average fill: 78%
Primary pages: 40952, secondary pages: 0, swept pages: 30404
Empty pages: 89, full pages: 36985
Fill distribution:
0 - 19% = 148
20 - 39% = 217
40 - 59% = 867
60 - 79% = 17729
80 - 99% = 21991
Index XQS_1000_3300_DOC_ID (0)
Root page: 73800, depth: 3, leaf buckets: 2774, nodes: 2581161
Average node length: 5.15, total dup: 2520860, max dup: 187
Average key length: 2.18, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 405343, ratio: 0.16
Fill distribution:
0 - 19% = 2
20 - 39% = 60
40 - 59% = 1649
60 - 79% = 790
80 - 99% = 273
Index XQS_1000_3300_RCV_ID (2)
Root page: 109107, depth: 3, leaf buckets: 4253, nodes: 2581161
Average node length: 6.24, total dup: 2110465, max dup: 14
Average key length: 3.27, compression ratio: 2.75
Average prefix length: 7.91, average data length: 1.09
Clustering factor: 234137, ratio: 0.09
Fill distribution:
0 - 19% = 123
20 - 39% = 1550
40 - 59% = 1663
60 - 79% = 590
80 - 99% = 327
Index XQS_1000_3300_SND_ID (1)
Root page: 63881, depth: 3, leaf buckets: 3154, nodes: 2581161
Average node length: 5.81, total dup: 2258207, max dup: 29
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 487581, ratio: 0.19
Fill distribution:
0 - 19% = 22
20 - 39% = 75
40 - 59% = 1867
60 - 79% = 894
80 - 99% = 296
XQS_1200_2000 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 83.73, total records: 5008533
Average version length: 85.42, total versions: 10709, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.62
Pointer pages: 49, data page slots: 78944
Data pages: 78880, average fill: 79%
Primary pages: 78880, secondary pages: 0, swept pages: 24311
Empty pages: 424, full pages: 72890
Fill distribution:
0 - 19% = 640
20 - 39% = 639
40 - 59% = 1782
60 - 79% = 16563
80 - 99% = 59256
Index XQS_1200_2000_DOC_ID (0)
Root page: 57493, depth: 3, leaf buckets: 5269, nodes: 5008533
Average node length: 5.04, total dup: 4979066, max dup: 725
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 738795, ratio: 0.15
Fill distribution:
0 - 19% = 6
20 - 39% = 186
40 - 59% = 3059
60 - 79% = 1463
80 - 99% = 555
Index XQS_1200_2000_RCV_ID (2)
Root page: 83243, depth: 3, leaf buckets: 6060, nodes: 5008533
Average node length: 5.53, total dup: 4613831, max dup: 49
Average key length: 2.54, compression ratio: 3.54
Average prefix length: 8.54, average data length: 0.46
Clustering factor: 246325, ratio: 0.05
Fill distribution:
0 - 19% = 100
20 - 39% = 1542
40 - 59% = 2439
60 - 79% = 608
80 - 99% = 1371
Index XQS_1200_2000_SND_ID (1)
Root page: 49462, depth: 3, leaf buckets: 5929, nodes: 5008533
Average node length: 5.69, total dup: 4488674, max dup: 67
Average key length: 2.70, compression ratio: 3.33
Average prefix length: 8.40, average data length: 0.60
Clustering factor: 819239, ratio: 0.16
Fill distribution:
0 - 19% = 4
20 - 39% = 169
40 - 59% = 3459
60 - 79% = 1667
80 - 99% = 630
XQS_2000_3300 (269)
Primary pointer page: 761, Index root page: 762
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_DOC_ID (0)
Root page: 763, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_RCV_ID (2)
Root page: 765, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_SND_ID (1)
Root page: 764, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQS_2100_3300 (270)
Primary pointer page: 767, Index root page: 776
Total formats: 1, used formats: 1
Average record length: 83.33, total records: 3410995
Average version length: 83.34, total versions: 13086, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 34, data page slots: 53936
Data pages: 53936, average fill: 78%
Primary pages: 53936, secondary pages: 0, swept pages: 38374
Empty pages: 99, full pages: 49356
Fill distribution:
0 - 19% = 171
20 - 39% = 282
40 - 59% = 1042
60 - 79% = 20803
80 - 99% = 31638
Index XQS_2100_3300_DOC_ID (0)
Root page: 89055, depth: 3, leaf buckets: 3729, nodes: 3410995
Average node length: 5.03, total dup: 3394297, max dup: 1217
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 663514, ratio: 0.19
Fill distribution:
0 - 19% = 16
20 - 39% = 405
40 - 59% = 2026
60 - 79% = 880
80 - 99% = 402
Index XQS_2100_3300_RCV_ID (2)
Root page: 109104, depth: 3, leaf buckets: 5629, nodes: 3410995
Average node length: 6.26, total dup: 2784786, max dup: 14
Average key length: 3.28, compression ratio: 2.75
Average prefix length: 7.90, average data length: 1.10
Clustering factor: 346652, ratio: 0.10
Fill distribution:
0 - 19% = 188
20 - 39% = 2027
40 - 59% = 2200
60 - 79% = 743
80 - 99% = 471
Index XQS_2100_3300_SND_ID (1)
Root page: 77230, depth: 3, leaf buckets: 4121, nodes: 3410995
Average node length: 5.59, total dup: 3109249, max dup: 61
Average key length: 2.61, compression ratio: 3.45
Average prefix length: 8.48, average data length: 0.52
Clustering factor: 709553, ratio: 0.21
Fill distribution:
0 - 19% = 11
20 - 39% = 425
40 - 59% = 2171
60 - 79% = 1060
80 - 99% = 454
XQS_3300_3400 (271)
Primary pointer page: 780, Index root page: 781
Total formats: 1, used formats: 1
Average record length: 69.05, total records: 665026
Average version length: 69.09, total versions: 4123, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.97
Pointer pages: 6, data page slots: 9288
Data pages: 9288, average fill: 76%
Primary pages: 9288, secondary pages: 0, swept pages: 7055
Empty pages: 15, full pages: 8540
Fill distribution:
0 - 19% = 38
20 - 39% = 57
40 - 59% = 194
60 - 79% = 8916
80 - 99% = 83
Index XQS_3300_3400_DOC_ID (0)
Root page: 178269, depth: 3, leaf buckets: 813, nodes: 665026
Average node length: 5.31, total dup: 627047, max dup: 135
Average key length: 2.44, compression ratio: 3.70
Average prefix length: 8.62, average data length: 0.38
Clustering factor: 55187, ratio: 0.08
Fill distribution:
0 - 19% = 2
20 - 39% = 204
40 - 59% = 322
60 - 79% = 199
80 - 99% = 86
Index XQS_3300_3400_SND_ID (1)
Root page: 150306, depth: 3, leaf buckets: 908, nodes: 665026
Average node length: 5.93, total dup: 568008, max dup: 23
Average key length: 3.05, compression ratio: 2.95
Average prefix length: 8.09, average data length: 0.91
Clustering factor: 60881, ratio: 0.09
Fill distribution:
0 - 19% = 1
20 - 39% = 215
40 - 59% = 395
60 - 79% = 207
80 - 99% = 90
ZDOC_DATA (230)
Primary pointer page: 644, Index root page: 645
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZDOC_LIST (229)
Primary pointer page: 642, Index root page: 643
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZINVNT_TURNOVER_LOG (231)
Primary pointer page: 646, Index root page: 647
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPDISTR (234)
Primary pointer page: 652, Index root page: 653
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPDISTR_ID (0)
Root page: 662, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPSTORNED (235)
Primary pointer page: 654, Index root page: 655
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPSTORNED_ID (0)
Root page: 663, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQDISTR (232)
Primary pointer page: 648, Index root page: 649
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_ID (0)
Root page: 656, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Root page: 657, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQSTORNED (233)
Primary pointer page: 650, Index root page: 651
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_DOC_ID (1)
Root page: 659, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_ID (0)
Root page: 658, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_RCV_ID (3)
Root page: 661, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_SND_ID (2)
Root page: 660, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_DEP_DOCS (228)
Primary pointer page: 640, Index root page: 641
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_SHOPPING_CART (227)
Primary pointer page: 614, Index root page: 615
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Z_USED_VIEWS (146)
Primary pointer page: 268, Index root page: 269
Total formats: 1, used formats: 1
Average record length: 29.38, total records: 29
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 99.00, compression ratio: 3.37
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 16%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index Z_USED_VIEWS_UNQ (0)
Root page: 281, depth: 1, leaf buckets: 1, nodes: 29
Average node length: 15.17, total dup: 0, max dup: 0
Average key length: 14.14, compression ratio: 1.44
Average prefix length: 9.17, average data length: 11.17
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Gstat completion time Sun Dec 10 07:09:47 2017
Done for 61900 ms, from 7:08:45.94 to 7:09:47.84.
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
VERS_PERCENT |
AGENTS |
50 |
0 |
0.0000 |
BUSINESS_OPS |
19 |
0 |
0.0000 |
DOC_DATA |
2170418 |
3487 |
0.1606 |
DOC_LIST |
667870 |
3388 |
0.5072 |
DOC_STATES |
4 |
0 |
0.0000 |
FB_ERRORS |
758 |
0 |
0.0000 |
INVNT_SALDO |
400 |
45872 |
11468.0000 |
INVNT_TURNOVER_LOG |
9251 |
8807 |
95.2005 |
MONEY_SALDO |
49 |
4193 |
8557.1428 |
MONEY_TURNOVER_LOG |
525 |
471 |
89.7142 |
OPTYPES |
9 |
0 |
0.0000 |
PDISTR |
218702 |
7516 |
3.4366 |
PERF_ESTIMATED |
275791 |
0 |
0.0000 |
PERF_LOG |
12441050 |
0 |
0.0000 |
PSTORNED |
469876 |
865 |
0.1840 |
RULES_FOR_PDISTR |
4 |
0 |
0.0000 |
RULES_FOR_QDISTR |
7 |
0 |
0.0000 |
SEMAPHORES |
4 |
1301 |
32525.0000 |
SETTINGS |
114 |
0 |
0.0000 |
TRACE_STAT |
2697 |
0 |
0.0000 |
WARES |
400 |
0 |
0.0000 |
WARE_GROUPS |
8 |
0 |
0.0000 |
XQD_1000_1200 |
18445 |
14708 |
79.7397 |
XQD_1000_3300 |
993807 |
8259 |
0.8310 |
XQD_1200_2000 |
58873 |
40353 |
68.5424 |
XQD_2000_3300 |
1641903 |
42886 |
2.6119 |
XQD_2100_3300 |
8177 |
7279 |
89.0179 |
XQD_3300_3400 |
2754607 |
17601 |
0.6389 |
XQS_1000_1200 |
4724681 |
2706 |
0.0572 |
XQS_1000_3300 |
2581161 |
13802 |
0.5347 |
XQS_1200_2000 |
5008533 |
10709 |
0.2138 |
XQS_2100_3300 |
3410995 |
13086 |
0.3836 |
XQS_3300_3400 |
665026 |
4123 |
0.6199 |
Z_USED_VIEWS |
29 |
0 |
0.0000 |
Done for 2100 ms, from 7:09:59.06 to 7:10:01.16.
07:10:01.27 Validation started
07:10:01.30 Relation 140 (DOC_LIST)
07:10:01.30 process pointer page 0 of 6
07:10:01.41 process pointer page 1 of 6
07:10:01.51 process pointer page 2 of 6
07:10:01.55 process pointer page 3 of 6
07:10:01.60 process pointer page 4 of 6
07:10:01.69 process pointer page 5 of 6
07:10:01.71 Index 1 (PK_DOC_LIST)
07:10:01.88 Index 2 (DOC_LIST_ID_DESC)
07:10:02.01 Index 3 (FK_DOC_LIST_AGENTS)
07:10:02.13 Relation 140 (DOC_LIST) is ok
07:10:02.13 Relation 141 (DOC_DATA)
07:10:02.13 process pointer page 0 of 15
07:10:02.24 process pointer page 1 of 15
07:10:02.33 process pointer page 2 of 15
07:10:02.41 process pointer page 3 of 15
07:10:02.46 process pointer page 4 of 15
07:10:02.51 process pointer page 5 of 15
07:10:02.54 process pointer page 6 of 15
07:10:02.57 process pointer page 7 of 15
07:10:02.62 process pointer page 8 of 15
07:10:02.65 process pointer page 9 of 15
07:10:02.68 process pointer page 10 of 15
07:10:02.72 process pointer page 11 of 15
07:10:02.82 process pointer page 12 of 15
07:10:02.93 process pointer page 13 of 15
07:10:02.97 process pointer page 14 of 15
07:10:02.99 Index 2 (DOC_DATA_DOC_WARE_UNQ)
07:10:03.38 Index 3 (DOC_DATA_ID_DESC)
07:10:03.96 Index 4 (FK_DOC_DATA_DOC_LIST)
07:10:04.32 Relation 141 (DOC_DATA) is ok
07:10:04.32 Relation 147 (INVNT_SALDO)
07:10:04.32 process pointer page 0 of 1
07:10:04.36 Index 1 (PK_INVNT_SALDO)
07:10:04.36 Relation 147 (INVNT_SALDO) is ok
07:10:04.36 Relation 150 (PDISTR)
07:10:04.36 process pointer page 0 of 2
07:10:04.39 process pointer page 1 of 2
07:10:04.42 Index 2 (PDISTR_SND_ID)
07:10:04.44 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
07:10:04.47 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
07:10:04.49 Index 5 (PDISTR_AGENT_ID)
07:10:04.50 Relation 150 (PDISTR) is ok
07:10:04.50 Relation 151 (PSTORNED)
07:10:04.50 process pointer page 0 of 4
07:10:04.53 process pointer page 1 of 4
07:10:04.57 process pointer page 2 of 4
07:10:04.60 process pointer page 3 of 4
07:10:04.61 Index 2 (PSTORNED_SND_ID)
07:10:04.64 Index 3 (PSTORNED_RCV_ID)
07:10:04.69 Relation 151 (PSTORNED) is ok
07:10:04.69 Relation 156 (SEMAPHORES)
07:10:04.69 process pointer page 0 of 1
07:10:04.69 Index 1 (PK_SEMAPHORES)
07:10:04.69 Index 2 (SEMAPHORES_TASK_UNQ)
07:10:04.69 Relation 156 (SEMAPHORES) is ok
07:10:04.69 Relation 157 (INVNT_TURNOVER_LOG)
07:10:04.69 process pointer page 0 of 1
07:10:04.69 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
07:10:04.69 Relation 157 (INVNT_TURNOVER_LOG) is ok
07:10:04.69 Relation 160 (PERF_ESTIMATED)
07:10:04.69 process pointer page 0 of 2
07:10:04.72 process pointer page 1 of 2
07:10:04.74 Index 1 (PERF_EST_MINUTE_SINCE_START)
07:10:04.77 Relation 160 (PERF_ESTIMATED) is ok
07:10:04.77 Relation 161 (PERF_ISQL_STAT)
07:10:04.77 process pointer page 0 of 1
07:10:04.77 Index 1 (PERF_ISQL_STAT_TRN)
07:10:04.77 Relation 161 (PERF_ISQL_STAT) is ok
07:10:04.77 Relation 162 (TRACE_STAT)
07:10:04.77 process pointer page 0 of 1
07:10:04.77 Relation 162 (TRACE_STAT) is ok
07:10:04.77 Relation 163 (PERF_LOG)
07:10:04.77 process pointer page 0 of 181
07:10:04.81 process pointer page 1 of 181
07:10:04.85 process pointer page 2 of 181
07:10:04.92 process pointer page 3 of 181
07:10:05.00 process pointer page 4 of 181
07:10:05.10 process pointer page 5 of 181
07:10:05.14 process pointer page 6 of 181
07:10:05.20 process pointer page 7 of 181
07:10:05.30 process pointer page 8 of 181
07:10:05.36 process pointer page 9 of 181
07:10:05.41 process pointer page 10 of 181
07:10:05.44 process pointer page 11 of 181
07:10:05.50 process pointer page 12 of 181
07:10:05.56 process pointer page 13 of 181
07:10:05.61 process pointer page 14 of 181
07:10:05.64 process pointer page 15 of 181
07:10:05.67 process pointer page 16 of 181
07:10:05.70 process pointer page 17 of 181
07:10:05.74 process pointer page 18 of 181
07:10:05.77 process pointer page 19 of 181
07:10:05.80 process pointer page 20 of 181
07:10:05.83 process pointer page 21 of 181
07:10:05.86 process pointer page 22 of 181
07:10:05.89 process pointer page 23 of 181
07:10:05.95 process pointer page 24 of 181
07:10:06.02 process pointer page 25 of 181
07:10:06.05 process pointer page 26 of 181
07:10:06.09 process pointer page 27 of 181
07:10:06.16 process pointer page 28 of 181
07:10:06.25 process pointer page 29 of 181
07:10:06.34 process pointer page 30 of 181
07:10:06.42 process pointer page 31 of 181
07:10:06.52 process pointer page 32 of 181
07:10:06.59 process pointer page 33 of 181
07:10:06.69 process pointer page 34 of 181
07:10:06.76 process pointer page 35 of 181
07:10:06.80 process pointer page 36 of 181
07:10:06.83 process pointer page 37 of 181
07:10:06.89 process pointer page 38 of 181
07:10:06.98 process pointer page 39 of 181
07:10:07.03 process pointer page 40 of 181
07:10:07.06 process pointer page 41 of 181
07:10:07.11 process pointer page 42 of 181
07:10:07.20 process pointer page 43 of 181
07:10:07.28 process pointer page 44 of 181
07:10:07.37 process pointer page 45 of 181
07:10:07.45 process pointer page 46 of 181
07:10:07.50 process pointer page 47 of 181
07:10:07.53 process pointer page 48 of 181
07:10:07.58 process pointer page 49 of 181
07:10:07.67 process pointer page 50 of 181
07:10:07.70 process pointer page 51 of 181
07:10:07.73 process pointer page 52 of 181
07:10:07.76 process pointer page 53 of 181
07:10:07.81 process pointer page 54 of 181
07:10:07.89 process pointer page 55 of 181
07:10:07.93 process pointer page 56 of 181
07:10:07.97 process pointer page 57 of 181
07:10:08.01 process pointer page 58 of 181
07:10:08.04 process pointer page 59 of 181
07:10:08.08 process pointer page 60 of 181
07:10:08.12 process pointer page 61 of 181
07:10:08.20 process pointer page 62 of 181
07:10:08.29 process pointer page 63 of 181
07:10:08.39 process pointer page 64 of 181
07:10:08.47 process pointer page 65 of 181
07:10:08.50 process pointer page 66 of 181
07:10:08.53 process pointer page 67 of 181
07:10:08.57 process pointer page 68 of 181
07:10:08.61 process pointer page 69 of 181
07:10:08.64 process pointer page 70 of 181
07:10:08.68 process pointer page 71 of 181
07:10:08.71 process pointer page 72 of 181
07:10:08.75 process pointer page 73 of 181
07:10:08.78 process pointer page 74 of 181
07:10:08.81 process pointer page 75 of 181
07:10:08.84 process pointer page 76 of 181
07:10:08.87 process pointer page 77 of 181
07:10:08.90 process pointer page 78 of 181
07:10:08.92 process pointer page 79 of 181
07:10:08.95 process pointer page 80 of 181
07:10:08.98 process pointer page 81 of 181
07:10:09.01 process pointer page 82 of 181
07:10:09.03 process pointer page 83 of 181
07:10:09.06 process pointer page 84 of 181
07:10:09.09 process pointer page 85 of 181
07:10:09.10 process pointer page 86 of 181
07:10:09.14 process pointer page 87 of 181
07:10:09.17 process pointer page 88 of 181
07:10:09.20 process pointer page 89 of 181
07:10:09.26 process pointer page 90 of 181
07:10:09.29 process pointer page 91 of 181
07:10:09.32 process pointer page 92 of 181
07:10:09.35 process pointer page 93 of 181
07:10:09.39 process pointer page 94 of 181
07:10:09.42 process pointer page 95 of 181
07:10:09.43 process pointer page 96 of 181
07:10:09.46 process pointer page 97 of 181
07:10:09.48 process pointer page 98 of 181
07:10:09.51 process pointer page 99 of 181
07:10:09.56 process pointer page 100 of 181
07:10:09.59 process pointer page 101 of 181
07:10:09.62 process pointer page 102 of 181
07:10:09.65 process pointer page 103 of 181
07:10:09.71 process pointer page 104 of 181
07:10:09.76 process pointer page 105 of 181
07:10:09.82 process pointer page 106 of 181
07:10:09.85 process pointer page 107 of 181
07:10:09.92 process pointer page 108 of 181
07:10:10.01 process pointer page 109 of 181
07:10:10.07 process pointer page 110 of 181
07:10:10.10 process pointer page 111 of 181
07:10:10.13 process pointer page 112 of 181
07:10:10.20 process pointer page 113 of 181
07:10:10.29 process pointer page 114 of 181
07:10:10.37 process pointer page 115 of 181
07:10:10.46 process pointer page 116 of 181
07:10:10.56 process pointer page 117 of 181
07:10:10.62 process pointer page 118 of 181
07:10:10.65 process pointer page 119 of 181
07:10:10.74 process pointer page 120 of 181
07:10:10.84 process pointer page 121 of 181
07:10:10.91 process pointer page 122 of 181
07:10:10.98 process pointer page 123 of 181
07:10:11.01 process pointer page 124 of 181
07:10:11.04 process pointer page 125 of 181
07:10:11.10 process pointer page 126 of 181
07:10:11.20 process pointer page 127 of 181
07:10:11.29 process pointer page 128 of 181
07:10:11.37 process pointer page 129 of 181
07:10:11.46 process pointer page 130 of 181
07:10:11.55 process pointer page 131 of 181
07:10:11.62 process pointer page 132 of 181
07:10:11.66 process pointer page 133 of 181
07:10:11.69 process pointer page 134 of 181
07:10:11.73 process pointer page 135 of 181
07:10:11.76 process pointer page 136 of 181
07:10:11.79 process pointer page 137 of 181
07:10:11.83 process pointer page 138 of 181
07:10:11.91 process pointer page 139 of 181
07:10:11.94 process pointer page 140 of 181
07:10:11.99 process pointer page 141 of 181
07:10:12.02 process pointer page 142 of 181
07:10:12.05 process pointer page 143 of 181
07:10:12.08 process pointer page 144 of 181
07:10:12.13 process pointer page 145 of 181
07:10:12.22 process pointer page 146 of 181
07:10:12.32 process pointer page 147 of 181
07:10:12.40 process pointer page 148 of 181
07:10:12.49 process pointer page 149 of 181
07:10:12.57 process pointer page 150 of 181
07:10:12.60 process pointer page 151 of 181
07:10:12.63 process pointer page 152 of 181
07:10:12.68 process pointer page 153 of 181
07:10:12.71 process pointer page 154 of 181
07:10:12.74 process pointer page 155 of 181
07:10:12.77 process pointer page 156 of 181
07:10:12.80 process pointer page 157 of 181
07:10:12.83 process pointer page 158 of 181
07:10:12.86 process pointer page 159 of 181
07:10:12.96 process pointer page 160 of 181
07:10:13.04 process pointer page 161 of 181
07:10:13.11 process pointer page 162 of 181
07:10:13.15 process pointer page 163 of 181
07:10:13.19 process pointer page 164 of 181
07:10:13.22 process pointer page 165 of 181
07:10:13.25 process pointer page 166 of 181
07:10:13.29 process pointer page 167 of 181
07:10:13.32 process pointer page 168 of 181
07:10:13.35 process pointer page 169 of 181
07:10:13.38 process pointer page 170 of 181
07:10:13.41 process pointer page 171 of 181
07:10:13.44 process pointer page 172 of 181
07:10:13.52 process pointer page 173 of 181
07:10:13.58 process pointer page 174 of 181
07:10:13.63 process pointer page 175 of 181
07:10:13.72 process pointer page 176 of 181
07:10:13.78 process pointer page 177 of 181
07:10:13.82 process pointer page 178 of 181
07:10:13.85 process pointer page 179 of 181
07:10:13.93 process pointer page 180 of 181
07:10:13.97 Index 1 (PERF_LOG_DTS_BEG_DESC)
07:10:16.22 Index 2 (PERF_LOG_UNIT)
07:10:20.13 Index 3 (PERF_LOG_TRN_DESC)
07:10:22.26 Index 4 (PERF_LOG_GDSCODE)
07:10:23.55 Relation 163 (PERF_LOG) is ok
07:10:23.55 Relation 167 (V_STOPTEST)
07:10:23.55 Relation 167 (V_STOPTEST) is ok
07:10:23.55 Relation 184 (V_QDISTR_SOURCE)
07:10:23.55 Relation 184 (V_QDISTR_SOURCE) is ok
07:10:23.55 Relation 185 (V_QSTORNED_SOURCE)
07:10:23.55 Relation 185 (V_QSTORNED_SOURCE) is ok
07:10:23.55 Relation 260 (XQD_1000_1200)
07:10:23.55 process pointer page 0 of 2
07:10:23.57 process pointer page 1 of 2
07:10:23.57 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
07:10:23.57 Relation 260 (XQD_1000_1200) is ok
07:10:23.57 Relation 261 (XQD_1200_2000)
07:10:23.57 process pointer page 0 of 4
07:10:23.58 process pointer page 1 of 4
07:10:23.60 process pointer page 2 of 4
07:10:23.66 process pointer page 3 of 4
07:10:23.68 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
07:10:23.69 Relation 261 (XQD_1200_2000) is ok
07:10:23.69 Relation 262 (XQD_1000_3300)
07:10:23.69 process pointer page 0 of 10
07:10:23.80 process pointer page 1 of 10
07:10:23.89 process pointer page 2 of 10
07:10:23.94 process pointer page 3 of 10
07:10:24.02 process pointer page 4 of 10
07:10:24.11 process pointer page 5 of 10
07:10:24.21 process pointer page 6 of 10
07:10:24.30 process pointer page 7 of 10
07:10:24.38 process pointer page 8 of 10
07:10:24.41 process pointer page 9 of 10
07:10:24.41 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
07:10:24.55 Index 2 (XQD_1000_3300_DOC)
07:10:24.64 Relation 262 (XQD_1000_3300) is ok
07:10:24.64 Relation 263 (XQD_2000_3300)
07:10:24.64 process pointer page 0 of 17
07:10:24.67 process pointer page 1 of 17
07:10:24.70 process pointer page 2 of 17
07:10:24.74 process pointer page 3 of 17
07:10:24.77 process pointer page 4 of 17
07:10:24.80 process pointer page 5 of 17
07:10:24.81 process pointer page 6 of 17
07:10:24.85 process pointer page 7 of 17
07:10:24.89 process pointer page 8 of 17
07:10:24.92 process pointer page 9 of 17
07:10:24.97 process pointer page 10 of 17
07:10:25.00 process pointer page 11 of 17
07:10:25.02 process pointer page 12 of 17
07:10:25.05 process pointer page 13 of 17
07:10:25.08 process pointer page 14 of 17
07:10:25.11 process pointer page 15 of 17
07:10:25.14 process pointer page 16 of 17
07:10:25.14 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
07:10:25.52 Relation 263 (XQD_2000_3300) is ok
07:10:25.52 Relation 264 (XQD_2100_3300)
07:10:25.52 process pointer page 0 of 4
07:10:25.53 process pointer page 1 of 4
07:10:25.55 process pointer page 2 of 4
07:10:25.55 process pointer page 3 of 4
07:10:25.55 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
07:10:25.55 Relation 264 (XQD_2100_3300) is ok
07:10:25.55 Relation 265 (XQD_3300_3400)
07:10:25.55 process pointer page 0 of 25
07:10:25.63 process pointer page 1 of 25
07:10:25.73 process pointer page 2 of 25
07:10:25.84 process pointer page 3 of 25
07:10:25.94 process pointer page 4 of 25
07:10:26.05 process pointer page 5 of 25
07:10:26.12 process pointer page 6 of 25
07:10:26.16 process pointer page 7 of 25
07:10:26.20 process pointer page 8 of 25
07:10:26.30 process pointer page 9 of 25
07:10:26.37 process pointer page 10 of 25
07:10:26.41 process pointer page 11 of 25
07:10:26.50 process pointer page 12 of 25
07:10:26.61 process pointer page 13 of 25
07:10:26.64 process pointer page 14 of 25
07:10:26.69 process pointer page 15 of 25
07:10:26.72 process pointer page 16 of 25
07:10:26.78 process pointer page 17 of 25
07:10:26.87 process pointer page 18 of 25
07:10:26.98 process pointer page 19 of 25
07:10:27.04 process pointer page 20 of 25
07:10:27.08 process pointer page 21 of 25
07:10:27.12 process pointer page 22 of 25
07:10:27.15 process pointer page 23 of 25
07:10:27.19 process pointer page 24 of 25
07:10:27.20 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
07:10:27.90 Relation 265 (XQD_3300_3400) is ok
07:10:27.90 Relation 266 (XQS_1000_1200)
07:10:27.90 process pointer page 0 of 45
07:10:27.95 process pointer page 1 of 45
07:10:27.98 process pointer page 2 of 45
07:10:28.03 process pointer page 3 of 45
07:10:28.06 process pointer page 4 of 45
07:10:28.09 process pointer page 5 of 45
07:10:28.12 process pointer page 6 of 45
07:10:28.15 process pointer page 7 of 45
07:10:28.18 process pointer page 8 of 45
07:10:28.21 process pointer page 9 of 45
07:10:28.25 process pointer page 10 of 45
07:10:28.28 process pointer page 11 of 45
07:10:28.36 process pointer page 12 of 45
07:10:28.45 process pointer page 13 of 45
07:10:28.53 process pointer page 14 of 45
07:10:28.59 process pointer page 15 of 45
07:10:28.68 process pointer page 16 of 45
07:10:28.79 process pointer page 17 of 45
07:10:28.89 process pointer page 18 of 45
07:10:28.98 process pointer page 19 of 45
07:10:29.06 process pointer page 20 of 45
07:10:29.10 process pointer page 21 of 45
07:10:29.15 process pointer page 22 of 45
07:10:29.18 process pointer page 23 of 45
07:10:29.21 process pointer page 24 of 45
07:10:29.24 process pointer page 25 of 45
07:10:29.35 process pointer page 26 of 45
07:10:29.40 process pointer page 27 of 45
07:10:29.48 process pointer page 28 of 45
07:10:29.57 process pointer page 29 of 45
07:10:29.67 process pointer page 30 of 45
07:10:29.70 process pointer page 31 of 45
07:10:29.81 process pointer page 32 of 45
07:10:29.92 process pointer page 33 of 45
07:10:30.01 process pointer page 34 of 45
07:10:30.12 process pointer page 35 of 45
07:10:30.21 process pointer page 36 of 45
07:10:30.32 process pointer page 37 of 45
07:10:30.41 process pointer page 38 of 45
07:10:30.52 process pointer page 39 of 45
07:10:30.59 process pointer page 40 of 45
07:10:30.63 process pointer page 41 of 45
07:10:30.66 process pointer page 42 of 45
07:10:30.71 process pointer page 43 of 45
07:10:30.76 process pointer page 44 of 45
07:10:30.77 Index 1 (XQS_1000_1200_DOC_ID)
07:10:31.38 Index 2 (XQS_1000_1200_SND_ID)
07:10:32.54 Index 3 (XQS_1000_1200_RCV_ID)
07:10:33.46 Relation 266 (XQS_1000_1200) is ok
07:10:33.46 Relation 267 (XQS_1200_2000)
07:10:33.46 process pointer page 0 of 49
07:10:33.57 process pointer page 1 of 49
07:10:33.67 process pointer page 2 of 49
07:10:33.77 process pointer page 3 of 49
07:10:33.82 process pointer page 4 of 49
07:10:33.85 process pointer page 5 of 49
07:10:33.89 process pointer page 6 of 49
07:10:33.99 process pointer page 7 of 49
07:10:34.06 process pointer page 8 of 49
07:10:34.11 process pointer page 9 of 49
07:10:34.16 process pointer page 10 of 49
07:10:34.19 process pointer page 11 of 49
07:10:34.24 process pointer page 12 of 49
07:10:34.27 process pointer page 13 of 49
07:10:34.30 process pointer page 14 of 49
07:10:34.35 process pointer page 15 of 49
07:10:34.38 process pointer page 16 of 49
07:10:34.41 process pointer page 17 of 49
07:10:34.50 process pointer page 18 of 49
07:10:34.55 process pointer page 19 of 49
07:10:34.60 process pointer page 20 of 49
07:10:34.63 process pointer page 21 of 49
07:10:34.67 process pointer page 22 of 49
07:10:34.70 process pointer page 23 of 49
07:10:34.74 process pointer page 24 of 49
07:10:34.77 process pointer page 25 of 49
07:10:34.81 process pointer page 26 of 49
07:10:34.83 process pointer page 27 of 49
07:10:34.91 process pointer page 28 of 49
07:10:34.99 process pointer page 29 of 49
07:10:35.02 process pointer page 30 of 49
07:10:35.06 process pointer page 31 of 49
07:10:35.09 process pointer page 32 of 49
07:10:35.13 process pointer page 33 of 49
07:10:35.17 process pointer page 34 of 49
07:10:35.20 process pointer page 35 of 49
07:10:35.23 process pointer page 36 of 49
07:10:35.28 process pointer page 37 of 49
07:10:35.39 process pointer page 38 of 49
07:10:35.48 process pointer page 39 of 49
07:10:35.59 process pointer page 40 of 49
07:10:35.64 process pointer page 41 of 49
07:10:35.67 process pointer page 42 of 49
07:10:35.72 process pointer page 43 of 49
07:10:35.75 process pointer page 44 of 49
07:10:35.80 process pointer page 45 of 49
07:10:35.83 process pointer page 46 of 49
07:10:35.86 process pointer page 47 of 49
07:10:35.89 process pointer page 48 of 49
07:10:35.91 Index 1 (XQS_1200_2000_DOC_ID)
07:10:36.84 Index 2 (XQS_1200_2000_SND_ID)
07:10:37.65 Index 3 (XQS_1200_2000_RCV_ID)
07:10:38.14 Relation 267 (XQS_1200_2000) is ok
07:10:38.14 Relation 268 (XQS_1000_3300)
07:10:38.14 process pointer page 0 of 26
07:10:38.18 process pointer page 1 of 26
07:10:38.23 process pointer page 2 of 26
07:10:38.26 process pointer page 3 of 26
07:10:38.31 process pointer page 4 of 26
07:10:38.34 process pointer page 5 of 26
07:10:38.43 process pointer page 6 of 26
07:10:38.54 process pointer page 7 of 26
07:10:38.67 process pointer page 8 of 26
07:10:38.76 process pointer page 9 of 26
07:10:38.81 process pointer page 10 of 26
07:10:38.85 process pointer page 11 of 26
07:10:38.90 process pointer page 12 of 26
07:10:38.99 process pointer page 13 of 26
07:10:39.04 process pointer page 14 of 26
07:10:39.09 process pointer page 15 of 26
07:10:39.13 process pointer page 16 of 26
07:10:39.18 process pointer page 17 of 26
07:10:39.21 process pointer page 18 of 26
07:10:39.26 process pointer page 19 of 26
07:10:39.37 process pointer page 20 of 26
07:10:39.46 process pointer page 21 of 26
07:10:39.51 process pointer page 22 of 26
07:10:39.56 process pointer page 23 of 26
07:10:39.60 process pointer page 24 of 26
07:10:39.63 process pointer page 25 of 26
07:10:39.65 Index 1 (XQS_1000_3300_DOC_ID)
07:10:40.49 Index 2 (XQS_1000_3300_SND_ID)
07:10:41.38 Index 3 (XQS_1000_3300_RCV_ID)
07:10:41.77 Relation 268 (XQS_1000_3300) is ok
07:10:41.77 Relation 269 (XQS_2000_3300)
07:10:41.77 process pointer page 0 of 1
07:10:41.77 Index 1 (XQS_2000_3300_DOC_ID)
07:10:41.77 Index 2 (XQS_2000_3300_SND_ID)
07:10:41.77 Index 3 (XQS_2000_3300_RCV_ID)
07:10:41.77 Relation 269 (XQS_2000_3300) is ok
07:10:41.77 Relation 270 (XQS_2100_3300)
07:10:41.77 process pointer page 0 of 34
07:10:42.19 process pointer page 1 of 34
07:10:42.60 process pointer page 2 of 34
07:10:43.05 process pointer page 3 of 34
07:10:43.53 process pointer page 4 of 34
07:10:44.00 process pointer page 5 of 34
07:10:44.49 process pointer page 6 of 34
07:10:44.97 process pointer page 7 of 34
07:10:45.44 process pointer page 8 of 34
07:10:45.87 process pointer page 9 of 34
07:10:46.34 process pointer page 10 of 34
07:10:46.81 process pointer page 11 of 34
07:10:47.26 process pointer page 12 of 34
07:10:47.65 process pointer page 13 of 34
07:10:48.00 process pointer page 14 of 34
07:10:48.45 process pointer page 15 of 34
07:10:48.90 process pointer page 16 of 34
07:10:49.35 process pointer page 17 of 34
07:10:49.82 process pointer page 18 of 34
07:10:50.32 process pointer page 19 of 34
07:10:50.76 process pointer page 20 of 34
07:10:51.21 process pointer page 21 of 34
07:10:51.65 process pointer page 22 of 34
07:10:52.08 process pointer page 23 of 34
07:10:52.52 process pointer page 24 of 34
07:10:52.97 process pointer page 25 of 34
07:10:53.36 process pointer page 26 of 34
07:10:53.78 process pointer page 27 of 34
07:10:54.17 process pointer page 28 of 34
07:10:54.63 process pointer page 29 of 34
07:10:55.08 process pointer page 30 of 34
07:10:55.53 process pointer page 31 of 34
07:10:55.97 process pointer page 32 of 34
07:10:56.42 process pointer page 33 of 34
07:10:56.44 Index 1 (XQS_2100_3300_DOC_ID)
07:10:58.12 Index 2 (XQS_2100_3300_SND_ID)
07:10:59.90 Index 3 (XQS_2100_3300_RCV_ID)
07:11:02.10 Relation 270 (XQS_2100_3300) is ok
07:11:02.10 Relation 271 (XQS_3300_3400)
07:11:02.10 process pointer page 0 of 6
07:11:02.57 process pointer page 1 of 6
07:11:03.05 process pointer page 2 of 6
07:11:03.53 process pointer page 3 of 6
07:11:04.02 process pointer page 4 of 6
07:11:04.47 process pointer page 5 of 6
07:11:04.77 Index 1 (XQS_3300_3400_DOC_ID)
07:11:05.06 Index 2 (XQS_3300_3400_SND_ID)
07:11:05.36 Relation 271 (XQS_3300_3400) is ok
07:11:05.36 Validation finished
Done for 64190 ms, from 7:10:01.20 to 7:11:05.39.
Differences between old and current firebird.log
7:11:07.06. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2017-12-10 07:11 471 oltp30_fb_log_when_test_finished.log
End of gathering firebird.log AFTER test finish.
+++ Start of comparison +++
Comparing files E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Sun Dec 10 07:10:01 2017
7: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Sun Dec 10 07:11:05 2017
12: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++
Remove 401 logs of every ISQL session if there were no serious errors.
Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp30\oltp30_*.*:
ERRORS_CHECKING_RESULT |
NO_SEVERE_ERRORS_FOUND |
ISQL logs are removed because no severe errors occured during test.
2017-12-10 7:11:14.63 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html