ACTION |
AVG_TIMES_PER_MINUTE |
AVG_ELAPSED_MS |
SUCCESSFUL_TIMES_DONE |
JOB_BEG |
JOB_END |
*** OVERALL *** for 179 minutes: |
6795.12 |
2678 |
1216326 |
2017-03-14 08:19 |
2017-03-14 11:18 |
customer order: creation |
471.49 |
248 |
84397 |
2017-03-14 08:19 |
2017-03-14 11:18 |
customer order: refuse |
39.06 |
157 |
6991 |
2017-03-14 08:19 |
2017-03-14 11:18 |
order to supplier: creation |
121.31 |
1074 |
21714 |
2017-03-14 08:19 |
2017-03-14 11:18 |
order to supplier: removal |
3.28 |
15239 |
588 |
2017-03-14 08:19 |
2017-03-14 11:18 |
invoice (draft): creation |
119.82 |
1575 |
21447 |
2017-03-14 08:19 |
2017-03-14 11:18 |
invoice (draft): removal |
48.35 |
326 |
8655 |
2017-03-14 08:19 |
2017-03-14 11:18 |
invoice accept: apply |
65.58 |
7009 |
11738 |
2017-03-14 08:19 |
2017-03-14 11:18 |
invoice accept: cancel |
20.96 |
1738 |
3752 |
2017-03-14 08:19 |
2017-03-14 11:18 |
customer reserve: creation |
3887.11 |
97 |
695793 |
2017-03-14 08:19 |
2017-03-14 11:18 |
customer reserve: removal |
1358.47 |
40 |
243167 |
2017-03-14 08:19 |
2017-03-14 11:18 |
realization accept: apply |
219.24 |
288 |
39244 |
2017-03-14 08:19 |
2017-03-14 11:18 |
realization accept: cancel |
94.67 |
97 |
16946 |
2017-03-14 08:19 |
2017-03-14 11:18 |
payment from customer: creation |
156.82 |
517 |
28070 |
2017-03-14 08:19 |
2017-03-14 11:18 |
payment from customer: removal |
15.19 |
67 |
2719 |
2017-03-14 08:19 |
2017-03-14 11:18 |
payment to supplier: creation |
130.22 |
691 |
23309 |
2017-03-14 08:19 |
2017-03-14 11:18 |
payment to supplier: removal |
8.84 |
66 |
1583 |
2017-03-14 08:19 |
2017-03-14 11:18 |
service: total inventory turnovers |
13.59 |
1662 |
2433 |
2017-03-14 08:19 |
2017-03-14 11:18 |
service: total monetary turnovers |
21.05 |
33 |
3768 |
2017-03-14 08:19 |
2017-03-14 11:18 |
service: refresh index statistics |
0.07 |
19960 |
12 |
2017-03-14 08:19 |
2017-03-14 11:18 |
Done for 144300 ms, from 11:22:23.04 to 11:24:47.34.
ACTION |
ITRV_NO |
CNT_OK_PER_MINUTE |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
ITRV_BEG |
ITRV_END |
interval # 1, overall |
1 |
4917 |
99574 |
88501 |
11073 |
11.12 |
08:18:56 |
08:36:55 |
interval # 2, overall |
2 |
7621 |
150522 |
137174 |
13348 |
8.87 |
08:36:56 |
08:54:55 |
interval # 3, overall |
3 |
8040 |
165600 |
144723 |
20877 |
12.61 |
08:54:56 |
09:12:55 |
interval # 4, overall |
4 |
7217 |
144738 |
129900 |
14838 |
10.25 |
09:12:56 |
09:30:55 |
interval # 5, overall |
5 |
5839 |
118583 |
105096 |
13487 |
11.37 |
09:30:56 |
09:48:55 |
interval # 6, overall |
6 |
6544 |
142358 |
117785 |
24573 |
17.26 |
09:48:56 |
10:06:55 |
interval # 7, overall |
7 |
6418 |
134891 |
115529 |
19362 |
14.35 |
10:06:56 |
10:24:55 |
interval # 8, overall |
8 |
6771 |
140120 |
121873 |
18247 |
13.02 |
10:24:56 |
10:42:55 |
interval # 9, overall |
9 |
7327 |
141623 |
131892 |
9731 |
6.87 |
10:42:56 |
11:00:55 |
interval # 10, overall |
10 |
6881 |
142584 |
123853 |
18731 |
13.14 |
11:00:56 |
11:18:55 |
Done for 267310 ms, from 11:29:08.44 to 11:33:35.75.
TEST_PHASE |
MINUTE_SINCE_TEST_START |
AVG_ESTIMATED |
MIN_TO_AVG_RATIO |
MAX_TO_AVG_RATIO |
ROWS_AGGREGATED |
DISTINCT_ATTACHMENTS |
TEST_TIME |
1 |
2069.73 |
0.0004 |
2.1597 |
2334 |
51 |
TEST_TIME |
2 |
3564.48 |
0.6271 |
1.3923 |
2031 |
58 |
TEST_TIME |
3 |
4109.40 |
0.8056 |
1.1507 |
1496 |
91 |
TEST_TIME |
4 |
4074.07 |
0.8705 |
1.1163 |
1701 |
91 |
TEST_TIME |
5 |
3974.00 |
0.9156 |
1.1065 |
1491 |
91 |
TEST_TIME |
6 |
4099.14 |
0.8940 |
1.0942 |
1708 |
91 |
TEST_TIME |
7 |
4279.80 |
0.8984 |
1.0837 |
2055 |
91 |
TEST_TIME |
8 |
4434.75 |
0.9151 |
1.1068 |
1867 |
91 |
TEST_TIME |
9 |
4585.88 |
0.9514 |
1.0309 |
1386 |
84 |
TEST_TIME |
10 |
4440.17 |
0.9583 |
1.0490 |
2093 |
82 |
TEST_TIME |
11 |
4536.38 |
0.9334 |
1.0443 |
1661 |
91 |
TEST_TIME |
12 |
4567.40 |
0.9508 |
1.0636 |
1776 |
90 |
TEST_TIME |
13 |
4640.43 |
0.9663 |
1.0280 |
1430 |
91 |
TEST_TIME |
14 |
4662.02 |
0.9534 |
1.0202 |
1467 |
88 |
TEST_TIME |
15 |
4587.67 |
0.9676 |
1.0413 |
1614 |
90 |
TEST_TIME |
16 |
4589.43 |
0.9758 |
1.0238 |
1947 |
85 |
TEST_TIME |
17 |
4588.17 |
0.9639 |
1.0377 |
1954 |
72 |
TEST_TIME |
18 |
4701.36 |
0.9565 |
1.0454 |
1838 |
58 |
TEST_TIME |
19 |
4852.93 |
0.9595 |
1.0457 |
2032 |
42 |
TEST_TIME |
20 |
4984.36 |
0.9672 |
1.0329 |
1710 |
49 |
TEST_TIME |
21 |
5076.67 |
0.9658 |
1.0258 |
1435 |
91 |
TEST_TIME |
22 |
5155.45 |
0.9649 |
1.0372 |
2002 |
91 |
TEST_TIME |
23 |
5292.85 |
0.9663 |
1.0299 |
1623 |
91 |
TEST_TIME |
24 |
5398.17 |
0.9684 |
1.0309 |
1831 |
91 |
TEST_TIME |
25 |
5508.30 |
0.9699 |
1.0266 |
1718 |
91 |
TEST_TIME |
26 |
5544.71 |
0.9806 |
1.0235 |
1701 |
91 |
TEST_TIME |
27 |
5597.06 |
0.9764 |
1.0257 |
1604 |
91 |
TEST_TIME |
28 |
5660.83 |
0.9783 |
1.0276 |
1608 |
91 |
TEST_TIME |
29 |
5726.38 |
0.9808 |
1.0218 |
1577 |
91 |
TEST_TIME |
30 |
5749.67 |
0.9845 |
1.0179 |
1403 |
91 |
TEST_TIME |
31 |
5842.12 |
0.9695 |
1.0321 |
2321 |
91 |
TEST_TIME |
32 |
5999.12 |
0.9737 |
1.0236 |
2137 |
91 |
TEST_TIME |
33 |
6091.90 |
0.9775 |
1.0261 |
2053 |
91 |
TEST_TIME |
34 |
6188.71 |
0.9804 |
1.0234 |
2087 |
91 |
TEST_TIME |
35 |
6268.51 |
0.9815 |
1.0191 |
1785 |
91 |
TEST_TIME |
36 |
6236.81 |
0.9958 |
1.0051 |
346 |
54 |
TEST_TIME |
38 |
5985.74 |
0.9921 |
1.0100 |
934 |
91 |
TEST_TIME |
39 |
5998.65 |
0.9824 |
1.0195 |
1815 |
91 |
TEST_TIME |
40 |
6067.61 |
0.9827 |
1.0153 |
1449 |
91 |
TEST_TIME |
41 |
6106.54 |
0.9842 |
1.0157 |
1480 |
91 |
TEST_TIME |
42 |
6141.35 |
0.9863 |
1.0151 |
1698 |
91 |
TEST_TIME |
43 |
6193.02 |
0.9832 |
1.0194 |
1390 |
91 |
TEST_TIME |
44 |
6250.05 |
0.9875 |
1.0147 |
1381 |
91 |
TEST_TIME |
45 |
6277.05 |
0.9880 |
1.0124 |
1390 |
91 |
TEST_TIME |
46 |
6342.93 |
0.9801 |
1.0194 |
1814 |
91 |
TEST_TIME |
47 |
6457.03 |
0.9801 |
1.0184 |
2009 |
91 |
TEST_TIME |
48 |
6540.78 |
0.9844 |
1.0163 |
2091 |
91 |
TEST_TIME |
49 |
6615.46 |
0.9844 |
1.0156 |
1799 |
91 |
TEST_TIME |
50 |
6683.89 |
0.9851 |
1.0132 |
1733 |
91 |
TEST_TIME |
51 |
6729.01 |
0.9867 |
1.0120 |
1730 |
91 |
TEST_TIME |
52 |
6763.95 |
0.9874 |
1.0157 |
1563 |
91 |
TEST_TIME |
53 |
6806.01 |
0.9904 |
1.0115 |
1409 |
91 |
TEST_TIME |
54 |
6809.06 |
0.9927 |
1.0074 |
1389 |
90 |
TEST_TIME |
55 |
6794.53 |
0.9912 |
1.0095 |
1286 |
56 |
TEST_TIME |
56 |
6798.06 |
0.9910 |
1.0143 |
1176 |
10 |
TEST_TIME |
57 |
6836.76 |
0.9909 |
1.0092 |
1262 |
15 |
TEST_TIME |
58 |
6837.42 |
0.9917 |
1.0079 |
1224 |
22 |
TEST_TIME |
59 |
6828.46 |
0.9922 |
1.0058 |
1029 |
74 |
TEST_TIME |
60 |
6810.70 |
0.9916 |
1.0080 |
1288 |
91 |
TEST_TIME |
61 |
6838.45 |
0.9875 |
1.0110 |
2095 |
91 |
TEST_TIME |
62 |
6879.11 |
0.9888 |
1.0116 |
2035 |
90 |
TEST_TIME |
63 |
6947.33 |
0.9872 |
1.0076 |
1768 |
90 |
TEST_TIME |
64 |
6953.35 |
0.9910 |
1.0067 |
1988 |
88 |
TEST_TIME |
65 |
6960.95 |
0.9902 |
1.0093 |
1098 |
86 |
TEST_TIME |
66 |
6948.75 |
0.9958 |
1.0063 |
2098 |
81 |
TEST_TIME |
67 |
6952.80 |
0.9907 |
1.0089 |
1536 |
80 |
TEST_TIME |
68 |
6957.34 |
0.9935 |
1.0083 |
1508 |
81 |
TEST_TIME |
69 |
6959.90 |
0.9933 |
1.0032 |
1470 |
82 |
TEST_TIME |
70 |
6919.40 |
0.9947 |
1.0052 |
1604 |
81 |
TEST_TIME |
71 |
6932.11 |
0.9931 |
1.0054 |
1476 |
89 |
TEST_TIME |
72 |
6902.41 |
0.9957 |
1.0049 |
1482 |
90 |
TEST_TIME |
73 |
6872.14 |
0.9955 |
1.0049 |
1281 |
86 |
TEST_TIME |
74 |
6857.88 |
0.9934 |
1.0030 |
1389 |
88 |
TEST_TIME |
75 |
6824.18 |
0.9945 |
1.0046 |
1263 |
85 |
TEST_TIME |
76 |
6794.89 |
0.9956 |
1.0082 |
1442 |
85 |
TEST_TIME |
77 |
6806.24 |
0.9934 |
1.0053 |
1929 |
80 |
TEST_TIME |
78 |
6774.91 |
0.9970 |
1.0079 |
1003 |
82 |
TEST_TIME |
79 |
6768.32 |
0.9961 |
1.0054 |
2093 |
77 |
TEST_TIME |
80 |
6781.13 |
0.9910 |
1.0067 |
2038 |
74 |
TEST_TIME |
81 |
6784.67 |
0.9937 |
1.0083 |
2003 |
70 |
TEST_TIME |
82 |
6780.44 |
0.9966 |
1.0052 |
1932 |
66 |
TEST_TIME |
83 |
6775.90 |
0.9938 |
1.0054 |
1467 |
79 |
TEST_TIME |
84 |
6765.28 |
0.9950 |
1.0063 |
1160 |
74 |
TEST_TIME |
85 |
6756.95 |
0.9957 |
1.0043 |
1410 |
63 |
TEST_TIME |
86 |
6751.91 |
0.9937 |
1.0027 |
1244 |
61 |
TEST_TIME |
87 |
6726.05 |
0.9950 |
1.0040 |
1477 |
55 |
TEST_TIME |
88 |
6724.16 |
0.9929 |
1.0036 |
1234 |
55 |
TEST_TIME |
89 |
6706.78 |
0.9949 |
1.0043 |
1311 |
70 |
TEST_TIME |
90 |
6699.54 |
0.9942 |
1.0039 |
1427 |
68 |
TEST_TIME |
91 |
6687.85 |
0.9947 |
1.0060 |
2104 |
62 |
TEST_TIME |
92 |
6703.49 |
0.9928 |
1.0059 |
2087 |
56 |
TEST_TIME |
93 |
6704.78 |
0.9949 |
1.0067 |
2013 |
60 |
TEST_TIME |
94 |
6749.80 |
0.9896 |
1.0053 |
1754 |
58 |
TEST_TIME |
95 |
6758.07 |
0.9935 |
1.0071 |
1780 |
46 |
TEST_TIME |
96 |
6770.66 |
0.9948 |
1.0052 |
1761 |
45 |
TEST_TIME |
97 |
6769.02 |
0.9951 |
1.0051 |
1742 |
40 |
TEST_TIME |
98 |
6766.57 |
0.9952 |
1.0055 |
1415 |
25 |
TEST_TIME |
99 |
6781.06 |
0.9933 |
1.0034 |
1204 |
17 |
TEST_TIME |
100 |
6764.80 |
0.9958 |
1.0032 |
1415 |
31 |
TEST_TIME |
101 |
6758.08 |
0.9943 |
1.0051 |
1229 |
50 |
TEST_TIME |
102 |
6764.17 |
0.9945 |
1.0069 |
1212 |
51 |
TEST_TIME |
103 |
6751.77 |
0.9990 |
1.0035 |
875 |
48 |
TEST_TIME |
104 |
6723.67 |
0.9980 |
1.0019 |
618 |
46 |
TEST_TIME |
105 |
6684.98 |
0.9982 |
1.0014 |
857 |
46 |
TEST_TIME |
106 |
6671.08 |
0.9941 |
1.0058 |
2204 |
44 |
TEST_TIME |
107 |
6680.27 |
0.9950 |
1.0042 |
1577 |
45 |
TEST_TIME |
108 |
6672.57 |
0.9961 |
1.0037 |
1558 |
44 |
TEST_TIME |
109 |
6670.30 |
0.9949 |
1.0046 |
2342 |
43 |
TEST_TIME |
110 |
6660.67 |
0.9969 |
1.0045 |
1453 |
28 |
TEST_TIME |
111 |
6635.25 |
0.9993 |
1.0006 |
173 |
9 |
TEST_TIME |
112 |
6613.52 |
0.9949 |
1.0052 |
1973 |
39 |
TEST_TIME |
113 |
6623.67 |
0.9948 |
1.0039 |
1183 |
91 |
TEST_TIME |
114 |
6622.11 |
0.9953 |
1.0046 |
1737 |
91 |
TEST_TIME |
115 |
6626.97 |
0.9951 |
1.0049 |
1729 |
91 |
TEST_TIME |
116 |
6636.94 |
0.9947 |
1.0051 |
1588 |
91 |
TEST_TIME |
117 |
6646.19 |
0.9951 |
1.0039 |
1445 |
91 |
TEST_TIME |
118 |
6647.17 |
0.9952 |
1.0060 |
1400 |
91 |
TEST_TIME |
119 |
6660.58 |
0.9958 |
1.0055 |
1368 |
91 |
TEST_TIME |
120 |
6665.18 |
0.9964 |
1.0031 |
1290 |
91 |
TEST_TIME |
121 |
6643.75 |
0.9980 |
1.0019 |
1295 |
86 |
TEST_TIME |
122 |
6616.99 |
0.9977 |
1.0033 |
1370 |
75 |
TEST_TIME |
123 |
6621.21 |
0.9945 |
1.0049 |
1842 |
85 |
TEST_TIME |
124 |
6622.07 |
0.9967 |
1.0040 |
2054 |
88 |
TEST_TIME |
125 |
6622.57 |
0.9959 |
1.0047 |
1866 |
85 |
TEST_TIME |
126 |
6623.67 |
0.9966 |
1.0060 |
1597 |
82 |
TEST_TIME |
127 |
6625.80 |
0.9977 |
1.0032 |
1731 |
83 |
TEST_TIME |
128 |
6622.95 |
0.9958 |
1.0030 |
1526 |
80 |
TEST_TIME |
129 |
6624.36 |
0.9967 |
1.0037 |
1470 |
60 |
TEST_TIME |
130 |
6618.68 |
0.9969 |
1.0053 |
1489 |
44 |
TEST_TIME |
131 |
6630.11 |
0.9959 |
1.0029 |
1331 |
38 |
TEST_TIME |
132 |
6630.27 |
0.9953 |
1.0045 |
1287 |
34 |
TEST_TIME |
133 |
6637.41 |
0.9959 |
1.0043 |
1258 |
32 |
TEST_TIME |
134 |
6636.33 |
0.9970 |
1.0030 |
1265 |
37 |
TEST_TIME |
135 |
6626.25 |
0.9971 |
1.0040 |
1235 |
50 |
TEST_TIME |
136 |
6638.86 |
0.9948 |
1.0036 |
1623 |
91 |
TEST_TIME |
137 |
6647.79 |
0.9950 |
1.0034 |
2290 |
91 |
TEST_TIME |
138 |
6647.78 |
0.9962 |
1.0046 |
1838 |
86 |
TEST_TIME |
139 |
6668.61 |
0.9942 |
1.0029 |
873 |
78 |
TEST_TIME |
140 |
6653.46 |
0.9990 |
1.0006 |
1058 |
75 |
TEST_TIME |
141 |
6627.33 |
0.9974 |
1.0033 |
1560 |
70 |
TEST_TIME |
142 |
6623.69 |
0.9968 |
1.0041 |
1145 |
72 |
TEST_TIME |
143 |
6627.86 |
0.9964 |
1.0056 |
1524 |
75 |
TEST_TIME |
144 |
6645.14 |
0.9961 |
1.0043 |
1507 |
75 |
TEST_TIME |
145 |
6642.10 |
0.9978 |
1.0038 |
1592 |
71 |
TEST_TIME |
146 |
6636.27 |
0.9978 |
1.0025 |
1673 |
68 |
TEST_TIME |
147 |
6649.49 |
0.9937 |
1.0052 |
1060 |
91 |
TEST_TIME |
148 |
6662.76 |
0.9964 |
1.0033 |
1273 |
91 |
TEST_TIME |
149 |
6663.52 |
0.9965 |
1.0027 |
1325 |
91 |
TEST_TIME |
150 |
6657.37 |
0.9969 |
1.0023 |
1484 |
91 |
TEST_TIME |
151 |
6640.07 |
0.9982 |
1.0025 |
1582 |
89 |
TEST_TIME |
152 |
6639.11 |
0.9960 |
1.0034 |
2173 |
83 |
TEST_TIME |
153 |
6644.90 |
0.9961 |
1.0045 |
1847 |
72 |
TEST_TIME |
154 |
6656.37 |
0.9962 |
1.0033 |
1808 |
58 |
TEST_TIME |
155 |
6659.35 |
0.9964 |
1.0051 |
1451 |
53 |
TEST_TIME |
156 |
6670.07 |
0.9971 |
1.0043 |
1723 |
52 |
TEST_TIME |
157 |
6683.22 |
0.9959 |
1.0049 |
1689 |
53 |
TEST_TIME |
158 |
6712.49 |
0.9942 |
1.0030 |
1389 |
54 |
TEST_TIME |
159 |
6708.26 |
0.9973 |
1.0033 |
1525 |
45 |
TEST_TIME |
160 |
6712.01 |
0.9968 |
1.0033 |
1511 |
35 |
TEST_TIME |
161 |
6712.73 |
0.9972 |
1.0037 |
1410 |
26 |
TEST_TIME |
162 |
6717.64 |
0.9968 |
1.0030 |
1291 |
32 |
TEST_TIME |
163 |
6712.05 |
0.9977 |
1.0023 |
1143 |
53 |
TEST_TIME |
164 |
6708.94 |
0.9967 |
1.0038 |
914 |
58 |
TEST_TIME |
165 |
6703.57 |
0.9985 |
1.0023 |
1287 |
54 |
TEST_TIME |
166 |
6700.94 |
0.9967 |
1.0029 |
1808 |
55 |
TEST_TIME |
167 |
6716.51 |
0.9946 |
1.0058 |
1602 |
57 |
TEST_TIME |
168 |
6739.10 |
0.9964 |
1.0017 |
1382 |
54 |
TEST_TIME |
169 |
6735.89 |
0.9963 |
1.0027 |
1180 |
49 |
TEST_TIME |
170 |
6743.51 |
0.9957 |
1.0031 |
1827 |
43 |
TEST_TIME |
171 |
6748.74 |
0.9965 |
1.0027 |
1115 |
41 |
TEST_TIME |
172 |
6740.86 |
0.9980 |
1.0027 |
1733 |
33 |
TEST_TIME |
173 |
6737.95 |
0.9974 |
1.0023 |
1274 |
43 |
TEST_TIME |
174 |
6739.14 |
0.9963 |
1.0027 |
1171 |
50 |
TEST_TIME |
175 |
6751.58 |
0.9951 |
1.0031 |
1463 |
41 |
TEST_TIME |
176 |
6751.58 |
0.9975 |
1.0024 |
1390 |
28 |
TEST_TIME |
177 |
6744.05 |
0.9979 |
1.0027 |
1334 |
27 |
TEST_TIME |
178 |
6739.35 |
0.9977 |
1.0036 |
1200 |
27 |
TEST_TIME |
179 |
6738.96 |
0.9981 |
1.0022 |
1063 |
43 |
TEST_TIME |
180 |
6737.42 |
0.9967 |
1.0029 |
893 |
62 |
TEST_TIME |
181 |
6720.04 |
1.0000 |
1.0000 |
1 |
1 |
Done for 10880 ms, from 11:33:37.71 to 11:33:48.59.
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 |
2 |
74054 |
94324 |
73036 |
86783 |
78725 |
<null> |
104016 |
139400 |
59279 |
99152 |
98714 |
78733 |
101244 |
89500 |
140170 |
101848 |
<null> |
171819 |
<null> |
08:36:56 |
08:54:55 |
fetches per second |
3 |
78332 |
89004 |
67858 |
109038 |
57053 |
<null> |
102142 |
82297 |
80341 |
37112 |
100603 |
59635 |
101331 |
88750 |
151165 |
142666 |
319948 |
438087 |
<null> |
08:54:56 |
09:12:55 |
fetches per second |
4 |
18591 |
34435 |
22005 |
<null> |
25000 |
<null> |
13309 |
6246 |
8665 |
3852 |
16913 |
45185 |
46161 |
66921 |
65632 |
9463 |
67169 |
<null> |
<null> |
09:12:56 |
09:30:55 |
fetches per second |
5 |
15517 |
3111 |
5676 |
<null> |
12486 |
6064 |
6082 |
<null> |
6770 |
53873 |
20955 |
12106 |
16639 |
26559 |
36929 |
1663 |
<null> |
19780 |
<null> |
09:30:56 |
09:48:55 |
fetches per second |
6 |
39284 |
46319 |
25695 |
222825 |
38147 |
<null> |
45193 |
<null> |
27479 |
76514 |
38677 |
29679 |
48702 |
4023 |
64199 |
92750 |
575156 |
17406 |
<null> |
09:48:56 |
10:06:55 |
fetches per second |
7 |
49097 |
65855 |
42081 |
170004 |
50965 |
27626 |
52378 |
132539 |
45263 |
53401 |
57305 |
41846 |
63165 |
41470 |
111085 |
<null> |
378574 |
499406 |
<null> |
10:06:56 |
10:24:55 |
fetches per second |
8 |
33897 |
11152 |
14422 |
<null> |
106839 |
4727 |
67233 |
15131 |
109699 |
37354 |
40751 |
21491 |
29059 |
6196 |
63545 |
3228 |
<null> |
774624 |
<null> |
10:24:56 |
10:42:55 |
fetches per second |
9 |
27256 |
2530 |
19019 |
148320 |
18335 |
<null> |
30945 |
4739 |
1406 |
4235 |
21100 |
1743 |
25161 |
22076 |
24110 |
16531 |
166302 |
31745 |
<null> |
10:42:56 |
11:00:55 |
fetches per second |
10 |
30054 |
21909 |
29996 |
269462 |
49498 |
52215 |
40140 |
23128 |
10867 |
67284 |
34108 |
58555 |
32399 |
6593 |
67678 |
<null> |
49303 |
100759 |
<null> |
11:00:56 |
11:18:55 |
marks per second |
2 |
16279 |
13601 |
16610 |
16302 |
18003 |
<null> |
15034 |
27164 |
9271 |
17153 |
14303 |
13859 |
10430 |
14095 |
4136 |
17640 |
<null> |
13767 |
<null> |
08:36:56 |
08:54:55 |
marks per second |
3 |
17397 |
11724 |
14872 |
20091 |
12919 |
<null> |
14293 |
13611 |
12464 |
5999 |
12947 |
10945 |
8103 |
21750 |
3481 |
26166 |
29002 |
35712 |
<null> |
08:54:56 |
09:12:55 |
marks per second |
4 |
4065 |
4878 |
4390 |
<null> |
5275 |
<null> |
1695 |
1079 |
999 |
583 |
1801 |
6815 |
3047 |
13420 |
1132 |
1501 |
4685 |
<null> |
<null> |
09:12:56 |
09:30:55 |
marks per second |
5 |
3336 |
438 |
1083 |
<null> |
2537 |
1366 |
854 |
<null> |
954 |
6405 |
4136 |
1823 |
789 |
4482 |
730 |
262 |
<null> |
987 |
<null> |
09:30:56 |
09:48:55 |
marks per second |
6 |
8307 |
5931 |
3542 |
39502 |
6166 |
<null> |
5770 |
<null> |
2336 |
12171 |
6317 |
4720 |
2302 |
662 |
1777 |
14000 |
5127 |
656 |
<null> |
09:48:56 |
10:06:55 |
marks per second |
7 |
10496 |
8592 |
8606 |
29861 |
10846 |
5939 |
6267 |
20957 |
6521 |
7994 |
7099 |
6999 |
4215 |
6000 |
7898 |
<null> |
53634 |
24709 |
<null> |
10:06:56 |
10:24:55 |
marks per second |
8 |
7611 |
1444 |
2425 |
<null> |
20399 |
997 |
9427 |
2671 |
12730 |
5949 |
6182 |
3461 |
1218 |
1137 |
5697 |
580 |
<null> |
27321 |
<null> |
10:24:56 |
10:42:55 |
marks per second |
9 |
5675 |
396 |
3873 |
25190 |
3716 |
<null> |
4753 |
752 |
174 |
734 |
3189 |
268 |
1254 |
3389 |
4827 |
2680 |
4402 |
1909 |
<null> |
10:42:56 |
11:00:55 |
marks per second |
10 |
6557 |
3031 |
5013 |
43581 |
8501 |
11511 |
5088 |
4009 |
1474 |
11824 |
6888 |
5690 |
1409 |
1067 |
10610 |
<null> |
1756 |
3148 |
<null> |
11:00:56 |
11:18:55 |
reads/fetches*100 |
2 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
08:36:56 |
08:54:55 |
reads/fetches*100 |
3 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
08:54:56 |
09:12:55 |
reads/fetches*100 |
4 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
09:12:56 |
09:30:55 |
reads/fetches*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
09:30:56 |
09:48:55 |
reads/fetches*100 |
6 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
09:48:56 |
10:06:55 |
reads/fetches*100 |
7 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
10:06:56 |
10:24:55 |
reads/fetches*100 |
8 |
0 |
1 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
10:24:56 |
10:42:55 |
reads/fetches*100 |
9 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
10:42:56 |
11:00:55 |
reads/fetches*100 |
10 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
11:00:56 |
11:18:55 |
writes/marks*100 |
2 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
<null> |
0 |
<null> |
08:36:56 |
08:54:55 |
writes/marks*100 |
3 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
08:54:56 |
09:12:55 |
writes/marks*100 |
4 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
6 |
<null> |
<null> |
09:12:56 |
09:30:55 |
writes/marks*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
1 |
1 |
0 |
1 |
0 |
0 |
0 |
0 |
<null> |
7 |
<null> |
09:30:56 |
09:48:55 |
writes/marks*100 |
6 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
5 |
0 |
<null> |
09:48:56 |
10:06:55 |
writes/marks*100 |
7 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
3 |
0 |
<null> |
3 |
0 |
<null> |
10:06:56 |
10:24:55 |
writes/marks*100 |
8 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
<null> |
0 |
<null> |
10:24:56 |
10:42:55 |
writes/marks*100 |
9 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
1 |
1 |
0 |
1 |
0 |
1 |
0 |
0 |
5 |
0 |
<null> |
10:42:56 |
11:00:55 |
writes/marks*100 |
10 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
<null> |
5 |
0 |
<null> |
11:00:56 |
11:18:55 |
Done for 9440 ms, from 11:33:49.96 to 11:33:59.40.
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 |
2101789 |
1948938 |
152851 |
7.27 |
0 |
12121 |
31 |
152851 |
2017-03-14 08:18 |
2017-03-14 11:18 |
doc_list_biud |
2102189 |
1948938 |
153251 |
7.29 |
0 |
7301 |
10 |
153251 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_add_invoice_to_stock |
19938 |
11738 |
8200 |
41.12 |
15 |
123068 |
7009 |
8200 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_cancel_adding_invoice |
4770 |
3752 |
1018 |
21.34 |
0 |
56612 |
1738 |
1018 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_cancel_client_order |
7139 |
6991 |
148 |
2.07 |
0 |
5850 |
157 |
148 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_cancel_customer_reserve |
386291 |
243167 |
143124 |
37.05 |
0 |
8128 |
40 |
143124 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_cancel_pay_from_customer |
2732 |
2719 |
13 |
0.47 |
0 |
2542 |
67 |
13 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_cancel_pay_to_supplier |
1585 |
1583 |
2 |
0.12 |
0 |
1700 |
66 |
2 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_cancel_supplier_invoice |
10919 |
8655 |
2264 |
20.73 |
0 |
8424 |
326 |
2264 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_cancel_supplier_order |
1645 |
588 |
1057 |
64.25 |
0 |
197044 |
15239 |
1057 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_cancel_write_off |
24556 |
16946 |
7610 |
30.99 |
0 |
3635 |
97 |
7610 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_client_order |
84397 |
84397 |
0 |
0.00 |
0 |
6677 |
248 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_customer_reserve |
695793 |
695793 |
0 |
0.00 |
0 |
10202 |
97 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_fill_shopping_cart |
127879 |
127558 |
321 |
0.25 |
0 |
3650 |
54 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_fill_shopping_cart_clo_res |
695793 |
695793 |
0 |
0.00 |
0 |
2309 |
7 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_get_clo_for_invoice |
11738 |
11738 |
0 |
0.00 |
0 |
6224 |
208 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_kill_cost_storno |
33274 |
25000 |
8274 |
24.86 |
0 |
2293 |
8 |
8274 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_kill_qstorno_ret_qs2qd |
807770 |
512523 |
295247 |
36.55 |
0 |
7130 |
15 |
295247 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_kill_qty_storno |
484268 |
331081 |
153187 |
31.63 |
0 |
7301 |
44 |
153187 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_lock_selected_doc |
82861 |
71918 |
10943 |
13.20 |
0 |
1248 |
4 |
10943 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_make_cost_storno |
102361 |
102361 |
0 |
0.00 |
0 |
12121 |
316 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_multiply_rows_for_pdistr |
102361 |
102361 |
0 |
0.00 |
0 |
3775 |
24 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_multiply_rows_for_qdistr |
84397 |
84397 |
0 |
0.00 |
0 |
6583 |
82 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_pay_from_customer |
28070 |
28070 |
0 |
0.00 |
0 |
12152 |
517 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_pay_to_supplier |
23309 |
23309 |
0 |
0.00 |
0 |
9188 |
691 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_payment_common |
51379 |
51379 |
0 |
0.00 |
0 |
2684 |
34 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_qd_handle_on_cancel_clo |
7135 |
6991 |
144 |
2.01 |
0 |
5741 |
82 |
144 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_qd_handle_on_invoice_upd_sts |
16312 |
15490 |
822 |
5.03 |
0 |
5210 |
210 |
822 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_qd_handle_on_reserve_upd_sts |
39244 |
39244 |
0 |
0.00 |
0 |
2590 |
28 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_reserve_write_off |
39754 |
39244 |
510 |
1.28 |
0 |
8877 |
288 |
510 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_supplier_invoice |
21559 |
21447 |
112 |
0.51 |
0 |
21341 |
1575 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
sp_supplier_order |
21923 |
21714 |
209 |
0.95 |
0 |
12449 |
1074 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
srv_find_qd_qs_mism |
1265006 |
1112169 |
152837 |
12.08 |
0 |
8798 |
15 |
152837 |
2017-03-14 08:18 |
2017-03-14 11:18 |
srv_make_invnt_saldo |
2433 |
2433 |
0 |
0.00 |
0 |
56660 |
1662 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
srv_make_money_saldo |
3768 |
3768 |
0 |
0.00 |
0 |
1779 |
33 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
1919 |
100854 |
19960 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-abend:sp_add_invoice_to_stock |
8200 |
8200 |
0 |
0.00 |
0 |
1731 |
43 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-abend:sp_cancel_adding_invoice |
612 |
612 |
0 |
0.00 |
0 |
3104 |
145 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-abend:sp_cancel_client_order |
148 |
148 |
0 |
0.00 |
0 |
593 |
50 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-abend:sp_cancel_customer_reserve |
33 |
33 |
0 |
0.00 |
0 |
390 |
44 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-abend:sp_cancel_pay_from_customer |
13 |
13 |
0 |
0.00 |
0 |
156 |
27 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-abend:sp_cancel_pay_to_supplier |
2 |
2 |
0 |
0.00 |
0 |
15 |
7 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-abend:sp_cancel_supplier_invoice |
724 |
724 |
0 |
0.00 |
0 |
5600 |
57 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-abend:sp_cancel_supplier_order |
17598 |
17598 |
0 |
0.00 |
0 |
2418 |
61 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-abend:sp_cancel_write_off |
21 |
21 |
0 |
0.00 |
0 |
141 |
17 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-abend:sp_reserve_write_off |
510 |
510 |
0 |
0.00 |
0 |
1108 |
37 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-abend:sp_supplier_invoice |
112 |
112 |
0 |
0.00 |
0 |
483 |
32 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-abend:sp_supplier_order |
209 |
209 |
0 |
0.00 |
0 |
671 |
30 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-norm:sp_add_invoice_to_stock |
11738 |
11738 |
0 |
0.00 |
0 |
8299 |
375 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-norm:sp_cancel_adding_invoice |
1393 |
1393 |
0 |
0.00 |
0 |
10546 |
374 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-norm:sp_cancel_client_order |
6991 |
6991 |
0 |
0.00 |
0 |
2013 |
23 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-norm:sp_cancel_customer_reserve |
2632 |
2632 |
0 |
0.00 |
0 |
1498 |
24 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-norm:sp_cancel_pay_from_customer |
2719 |
2719 |
0 |
0.00 |
0 |
1341 |
18 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-norm:sp_cancel_pay_to_supplier |
1583 |
1583 |
0 |
0.00 |
0 |
2246 |
20 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-norm:sp_cancel_supplier_invoice |
1002 |
1002 |
0 |
0.00 |
0 |
7971 |
32 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-norm:sp_cancel_supplier_order |
588 |
588 |
0 |
0.00 |
0 |
18174 |
1077 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-norm:sp_cancel_write_off |
4028 |
4028 |
0 |
0.00 |
0 |
1170 |
26 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-norm:sp_client_order |
84397 |
84397 |
0 |
0.00 |
0 |
7706 |
30 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-norm:sp_customer_reserve |
3856 |
3856 |
0 |
0.00 |
0 |
2480 |
19 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-norm:sp_pay_from_customer |
28070 |
28070 |
0 |
0.00 |
0 |
7426 |
27 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-norm:sp_pay_to_supplier |
23309 |
23309 |
0 |
0.00 |
0 |
7379 |
25 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-norm:sp_reserve_write_off |
39244 |
39244 |
0 |
0.00 |
0 |
7816 |
26 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-norm:sp_supplier_invoice |
21447 |
21447 |
0 |
0.00 |
0 |
7441 |
29 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-norm:sp_supplier_order |
21714 |
21714 |
0 |
0.00 |
0 |
7566 |
30 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-norm:srv_make_invnt_saldo |
2433 |
2433 |
0 |
0.00 |
0 |
1311 |
8 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-norm:srv_make_money_saldo |
3768 |
3768 |
0 |
0.00 |
0 |
499 |
8 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
t$perf-norm:srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
0 |
1232 |
188 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
v_add_invoice_to_stock |
39876 |
23476 |
16400 |
41.12 |
0 |
3604 |
44 |
16400 |
2017-03-14 08:18 |
2017-03-14 11:18 |
v_all_customers |
126328 |
126328 |
0 |
0.00 |
0 |
765 |
3 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
v_all_suppliers |
89314 |
88672 |
642 |
0.71 |
0 |
1014 |
3 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
v_all_wares |
168794 |
168794 |
0 |
0.00 |
0 |
1342 |
2 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
v_cancel_adding_invoice |
3256 |
2786 |
470 |
14.43 |
0 |
2059 |
77 |
470 |
2017-03-14 08:18 |
2017-03-14 11:18 |
v_cancel_client_order |
14278 |
13982 |
296 |
2.07 |
0 |
375 |
3 |
296 |
2017-03-14 08:18 |
2017-03-14 11:18 |
v_cancel_customer_prepayment |
5464 |
5438 |
26 |
0.47 |
0 |
624 |
3 |
26 |
2017-03-14 08:18 |
2017-03-14 11:18 |
v_cancel_customer_reserve |
5330 |
5264 |
66 |
1.23 |
0 |
405 |
4 |
66 |
2017-03-14 08:18 |
2017-03-14 11:18 |
v_cancel_payment_to_supplier |
3170 |
3166 |
4 |
0.12 |
0 |
312 |
4 |
4 |
2017-03-14 08:18 |
2017-03-14 11:18 |
v_cancel_supplier_invoice |
3452 |
2004 |
1448 |
41.94 |
0 |
4196 |
47 |
1448 |
2017-03-14 08:18 |
2017-03-14 11:18 |
v_cancel_supplier_order |
3290 |
1176 |
2114 |
64.25 |
0 |
171 |
4 |
2114 |
2017-03-14 08:18 |
2017-03-14 11:18 |
v_cancel_write_off |
8098 |
8056 |
42 |
0.51 |
0 |
2917 |
60 |
42 |
2017-03-14 08:18 |
2017-03-14 11:18 |
v_max_id_clo_ord |
21923 |
21714 |
209 |
0.95 |
0 |
530 |
3 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
v_max_id_clo_res |
3856 |
3856 |
0 |
0.00 |
0 |
671 |
7 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
v_max_id_ord_sup |
21559 |
21447 |
112 |
0.51 |
0 |
343 |
3 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
v_max_non_paid_invoice |
22134 |
22134 |
0 |
0.00 |
0 |
2434 |
3 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
v_max_non_paid_realizn |
28070 |
28070 |
0 |
0.00 |
0 |
796 |
3 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
v_min_id_clo_ord |
21923 |
21714 |
209 |
0.95 |
0 |
452 |
3 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
v_min_id_clo_res |
3856 |
3856 |
0 |
0.00 |
0 |
733 |
4 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
v_min_id_ord_sup |
21559 |
21447 |
112 |
0.51 |
0 |
967 |
3 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
v_min_non_paid_invoice |
23309 |
23309 |
0 |
0.00 |
0 |
1420 |
3 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
v_min_non_paid_realizn |
28070 |
28070 |
0 |
0.00 |
0 |
2184 |
3 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
v_our_firm |
42466 |
42466 |
0 |
0.00 |
0 |
733 |
3 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
v_reserve_write_off |
79508 |
78488 |
1020 |
1.28 |
0 |
998 |
4 |
1020 |
2017-03-14 08:18 |
2017-03-14 11:18 |
x_lock_depdocs_on_canc_invoice |
20879 |
11405 |
9474 |
45.37 |
0 |
2355 |
25 |
9474 |
2017-03-14 08:18 |
2017-03-14 11:18 |
x_lock_depdocs_on_canc_sup_ord |
1645 |
588 |
1057 |
64.25 |
0 |
1357 |
46 |
1057 |
2017-03-14 08:18 |
2017-03-14 11:18 |
x_make_qstorno_1000_1200 |
21923 |
21714 |
209 |
0.95 |
0 |
11138 |
951 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
x_make_qstorno_1200_2000 |
21559 |
21447 |
112 |
0.51 |
0 |
21013 |
1455 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
x_make_qstorno_2100_3300 |
695793 |
695793 |
0 |
0.00 |
0 |
10093 |
81 |
0 |
2017-03-14 08:18 |
2017-03-14 11:18 |
Done for 533030 ms, from 11:42:44.53 to 11:51:37.56.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
DTS_BEG |
DTS_END |
deadlock |
71 |
sp_kill_cost_storno |
335544336 |
2017-03-14 08:19 |
2017-03-14 11:14 |
deadlock |
91 |
sp_kill_qstorno_ret_qs2qd |
335544336 |
2017-03-14 08:20 |
2017-03-14 11:10 |
deadlock |
2334 |
sp_lock_selected_doc |
335544336 |
2017-03-14 08:19 |
2017-03-14 11:18 |
deadlock |
144 |
sp_qd_handle_on_cancel_clo |
335544336 |
2017-03-14 08:19 |
2017-03-14 11:15 |
deadlock |
150 |
sp_qd_handle_on_invoice_upd_sts |
335544336 |
2017-03-14 08:19 |
2017-03-14 11:18 |
deadlock |
40 |
x_lock_depdocs_on_canc_invoice |
335544336 |
2017-03-14 08:24 |
2017-03-14 11:12 |
deadlock |
16 |
x_lock_depdocs_on_canc_sup_ord |
335544336 |
2017-03-14 08:21 |
2017-03-14 11:02 |
user_exc |
209 |
x_make_qstorno_1000_1200 |
335544517 |
2017-03-14 08:19 |
2017-03-14 11:15 |
user_exc |
112 |
x_make_qstorno_1200_2000 |
335544517 |
2017-03-14 08:19 |
2017-03-14 11:10 |
concurrent_transaction |
7171 |
sp_lock_selected_doc |
335544878 |
2017-03-14 08:19 |
2017-03-14 11:18 |
concurrent_transaction |
652 |
x_lock_depdocs_on_canc_invoice |
335544878 |
2017-03-14 08:19 |
2017-03-14 11:18 |
concurrent_transaction |
271 |
x_lock_depdocs_on_canc_sup_ord |
335544878 |
2017-03-14 08:21 |
2017-03-14 11:18 |
Done for 12940 ms, from 11:51:49.89 to 11:52:02.83.
MON$DATABASE_NAME D:\OLTP-EMUL\OLTP40-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 13
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 171939
MON$OLDEST_ACTIVE 444486
MON$OLDEST_SNAPSHOT 444486
MON$NEXT_TRANSACTION 444486
MON$PAGE_BUFFERS 786432
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2017-01-11 15:15:54.2050
MON$PAGES 885472
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-T4.0.0.553 Firebird 4.0 Unstable
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.553 Firebird 4.0 Unstable"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T4.0.0.553 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P15"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T4.0.0.553 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P15"
on disk structure version 13.0
Database "D:\OLTP-EMUL\OLTP40-SMALL.FDB"
Database header page information:
Flags 0
Generation 444551
System Change Number 0
Page size 8192
ODS version 13.0
Oldest transaction 171939
Oldest active 444488
Oldest snapshot 444488
Next transaction 444489
Sequence number 0
Next attachment ID 9402
Implementation HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jan 11, 2017 15:15:54
Attributes force write
Variable header data:
Sweep interval: 0
*END*
Database file sequence:
File D:\OLTP-EMUL\OLTP40-SMALL.FDB is the only file
Analyzing database pages ...
AGENTS (154)
Primary pointer page: 314, Index root page: 315
Total formats: 1, used formats: 1
Average record length: 33.50, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 344.00, compression ratio: 10.27
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_ID_DESC (2)
Root page: 325, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_OUR_FIRM (4)
Root page: 327, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 48
Average key length: 2.04, compression ratio: 0.50
Average prefix length: 0.96, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_SUPPLIER (3)
Root page: 326, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 43
Average key length: 2.04, compression ratio: 0.55
Average prefix length: 1.06, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_NAME_UNQ (1)
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.32, total dup: 0, max dup: 0
Average key length: 15.94, compression ratio: 0.91
Average prefix length: 1.20, average data length: 13.32
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_AGENTS (0)
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BUSINESS_OPS (158)
Primary pointer page: 335, Index root page: 336
Total formats: 1, used formats: 1
Average record length: 107.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1236.00, compression ratio: 11.55
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 29%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BO_UNIT_UNQ (1)
Root page: 339, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 18.00, total dup: 0, max dup: 0
Average key length: 16.95, compression ratio: 1.25
Average prefix length: 7.21, average data length: 14.00
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BUSINESS_OPS_RND_WGTH (2)
Root page: 340, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 4.05, total dup: 7, max dup: 3
Average key length: 3.00, compression ratio: 0.75
Average prefix length: 1.42, average data length: 0.84
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$1 (0)
Root page: 338, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 5.26, total dup: 0, max dup: 0
Average key length: 4.21, compression ratio: 0.64
Average prefix length: 1.05, average data length: 1.63
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DOC_DATA (141)
Primary pointer page: 254, Index root page: 255
Total formats: 1, used formats: 1
Average record length: 47.10, total records: 2212940
Average version length: 47.67, total versions: 3245, 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: 24072
Data pages: 24072, average fill: 72%
Primary pages: 24072, secondary pages: 0, swept pages: 2009
Empty pages: 1, full pages: 19621
Fill distribution:
0 - 19% = 3
20 - 39% = 7
40 - 59% = 170
60 - 79% = 23886
80 - 99% = 6
Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26714, depth: 3, leaf buckets: 11282, nodes: 2212940
Average node length: 19.37, total dup: 0, max dup: 0
Average key length: 16.41, compression ratio: 1.65
Average prefix length: 13.58, average data length: 13.42
Clustering factor: 385597, ratio: 0.17
Fill distribution:
0 - 19% = 881
20 - 39% = 3080
40 - 59% = 4938
60 - 79% = 891
80 - 99% = 1492
Index DOC_DATA_ID_DESC (2)
Root page: 46473, depth: 3, leaf buckets: 8024, nodes: 2212940
Average node length: 11.62, total dup: 0, max dup: 0
Average key length: 8.66, compression ratio: 1.04
Average prefix length: 3.34, average data length: 5.66
Clustering factor: 360473, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 4080
40 - 59% = 3824
60 - 79% = 111
80 - 99% = 9
Index FK_DOC_DATA_DOC_LIST (3)
Root page: 171379, depth: 3, leaf buckets: 4013, nodes: 2212940
Average node length: 6.85, total dup: 1603173, max dup: 49
Average key length: 3.89, compression ratio: 2.31
Average prefix length: 7.38, average data length: 1.62
Clustering factor: 348538, ratio: 0.16
Fill distribution:
0 - 19% = 180
20 - 39% = 1535
40 - 59% = 1452
60 - 79% = 294
80 - 99% = 552
DOC_LIST (140)
Primary pointer page: 249, Index root page: 250
Total formats: 1, used formats: 1
Average record length: 60.40, total records: 676745
Average version length: 61.42, total versions: 985, max versions: 2
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 6, data page slots: 8576
Data pages: 8576, average fill: 75%
Primary pages: 8574, secondary pages: 2, swept pages: 40
Empty pages: 7, full pages: 7984
Fill distribution:
0 - 19% = 7
20 - 39% = 6
40 - 59% = 53
60 - 79% = 8490
80 - 99% = 20
Index DOC_LIST_ID_DESC (1)
Root page: 249557, depth: 3, leaf buckets: 2524, nodes: 676745
Average node length: 11.70, total dup: 0, max dup: 0
Average key length: 8.83, compression ratio: 1.02
Average prefix length: 3.17, average data length: 5.83
Clustering factor: 161808, ratio: 0.24
Fill distribution:
0 - 19% = 0
20 - 39% = 1479
40 - 59% = 991
60 - 79% = 47
80 - 99% = 7
Index FK_DOC_LIST_AGENTS (2)
Root page: 2940, depth: 2, leaf buckets: 713, nodes: 676745
Average node length: 4.88, total dup: 676695, max dup: 35126
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 307768, ratio: 0.45
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 612
60 - 79% = 80
80 - 99% = 20
Index PK_DOC_LIST (0)
Root page: 336762, depth: 3, leaf buckets: 1984, nodes: 676745
Average node length: 11.70, total dup: 0, max dup: 0
Average key length: 8.83, compression ratio: 1.02
Average prefix length: 3.17, average data length: 5.83
Clustering factor: 161808, ratio: 0.24
Fill distribution:
0 - 19% = 164
20 - 39% = 626
40 - 59% = 572
60 - 79% = 302
80 - 99% = 320
DOC_STATES (153)
Primary pointer page: 312, Index root page: 313
Total formats: 1, used formats: 1
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 650.00, compression ratio: 9.63
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_MCODE_UNQ (1)
Root page: 321, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 17.75, total dup: 0, max dup: 0
Average key length: 16.50, compression ratio: 1.08
Average prefix length: 4.00, average data length: 13.75
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_NAME_UNQ (2)
Root page: 322, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 33.25, total dup: 0, max dup: 0
Average key length: 32.00, compression ratio: 0.99
Average prefix length: 2.50, average data length: 29.25
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_DOC_STATES (0)
Root page: 320, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 4.75, total dup: 0, max dup: 0
Average key length: 3.50, compression ratio: 0.86
Average prefix length: 1.50, average data length: 1.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
FB_ERRORS (159)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 148.00, compression ratio: 1.86
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 56%
Primary pages: 16, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 11
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7
Index FB_ERRORS_GDS_CODE (0)
Root page: 343, depth: 1, leaf buckets: 1, nodes: 758
Average node length: 4.24, total dup: 0, max dup: 0
Average key length: 3.04, compression ratio: 1.64
Average prefix length: 3.97, average data length: 1.03
Clustering factor: 353, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
INVNT_SALDO (147)
Primary pointer page: 273, Index root page: 274
Total formats: 1, used formats: 1
Average record length: 64.66, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 17.08, total fragments: 384, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.61
Pointer pages: 1, data page slots: 496
Data pages: 36, average fill: 20%
Primary pages: 8, secondary pages: 28, swept pages: 0
Empty pages: 20, full pages: 3
Fill distribution:
0 - 19% = 24
20 - 39% = 5
40 - 59% = 3
60 - 79% = 1
80 - 99% = 3
Index PK_INVNT_SALDO (0)
Root page: 285, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 303, ratio: 0.76
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
INVNT_TURNOVER_LOG (157)
Primary pointer page: 333, Index root page: 334
Total formats: 1, used formats: 1
Average record length: 15.79, total records: 3451
Average version length: 71.33, total versions: 2686, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 6.08
Pointer pages: 2, data page slots: 928
Data pages: 296, average fill: 18%
Primary pages: 295, secondary pages: 1, swept pages: 72
Empty pages: 90, full pages: 15
Fill distribution:
0 - 19% = 186
20 - 39% = 83
40 - 59% = 11
60 - 79% = 10
80 - 99% = 6
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1481, depth: 2, leaf buckets: 16, nodes: 3451
Average node length: 14.69, total dup: 289, max dup: 1
Average key length: 12.68, compression ratio: 2.13
Average prefix length: 17.23, average data length: 9.77
Clustering factor: 2166, ratio: 0.63
Fill distribution:
0 - 19% = 0
20 - 39% = 9
40 - 59% = 6
60 - 79% = 0
80 - 99% = 1
MONEY_SALDO (143)
Primary pointer page: 265, Index root page: 266
Total formats: 1, used formats: 1
Average record length: 14.98, total records: 49
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 2.14
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 20%
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_MONEY_SALDO (0)
Root page: 276, depth: 1, leaf buckets: 1, nodes: 49
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MONEY_TURNOVER_LOG (142)
Primary pointer page: 263, Index root page: 264
Total formats: 1, used formats: 1
Average record length: 40.90, total records: 71
Average version length: 49.86, total versions: 7, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.56
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 5%
Primary pages: 15, secondary pages: 1, swept pages: 4
Empty pages: 8, full pages: 0
Fill distribution:
0 - 19% = 15
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 238156, depth: 2, leaf buckets: 1, nodes: 71
Average node length: 10.20, total dup: 40, max dup: 18
Average key length: 9.15, compression ratio: 2.08
Average prefix length: 12.27, average data length: 6.73
Clustering factor: 26, ratio: 0.37
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG (165)
Primary pointer page: 356, Index root page: 357
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_DTS (4)
Root page: 367, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_GDSCODE (2)
Root page: 365, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_ROWSET_DESC (1)
Root page: 364, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_UNIT (3)
Root page: 366, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG (0)
Root page: 363, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG_TABLE_STATS (166)
Primary pointer page: 369, Index root page: 370
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_DTS (4)
Root page: 376, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_GDSCODE (2)
Root page: 374, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_ROWSET (1)
Root page: 373, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_TN_UNIT (3)
Root page: 375, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG_TABLE_STATS (0)
Root page: 372, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
OPTYPES (138)
Primary pointer page: 241, Index root page: 242
Total formats: 1, used formats: 1
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 5.54
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 9%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OPTYPES_MCODE_UNQ (1)
Root page: 244, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 8.56, total dup: 0, max dup: 0
Average key length: 6.89, compression ratio: 0.73
Average prefix length: 0.44, average data length: 4.56
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_OPTYPES (0)
Root page: 243, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 6.11, total dup: 0, max dup: 0
Average key length: 5.00, compression ratio: 0.60
Average prefix length: 0.89, average data length: 2.11
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PDISTR (150)
Primary pointer page: 296, Index root page: 297
Total formats: 1, used formats: 1
Average record length: 24.35, total records: 499472
Average version length: 42.73, total versions: 875, max versions: 5
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 2.63
Pointer pages: 3, data page slots: 3544
Data pages: 3544, average fill: 73%
Primary pages: 3542, secondary pages: 2, swept pages: 34
Empty pages: 3, full pages: 2907
Fill distribution:
0 - 19% = 13
20 - 39% = 40
40 - 59% = 105
60 - 79% = 3185
80 - 99% = 201
Index PDISTR_AGENT_ID (4)
Root page: 3976, depth: 2, leaf buckets: 214, nodes: 229273
Average node length: 4.81, total dup: 229224, max dup: 14738
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 33182, ratio: 0.14
Fill distribution:
0 - 19% = 0
20 - 39% = 11
40 - 59% = 92
60 - 79% = 66
80 - 99% = 45
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 3600, depth: 2, leaf buckets: 269, nodes: 229273
Average node length: 5.75, total dup: 206773, max dup: 69
Average key length: 2.95, compression ratio: 7.46
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 39238, ratio: 0.17
Fill distribution:
0 - 19% = 1
20 - 39% = 25
40 - 59% = 106
60 - 79% = 95
80 - 99% = 42
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3602, depth: 2, leaf buckets: 267, nodes: 229273
Average node length: 5.75, total dup: 206773, max dup: 69
Average key length: 2.95, compression ratio: 7.46
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 39279, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 28
40 - 59% = 106
60 - 79% = 94
80 - 99% = 39
Index PDISTR_SND_ID (1)
Root page: 3001, depth: 2, leaf buckets: 273, nodes: 229273
Average node length: 5.54, total dup: 206773, max dup: 69
Average key length: 2.74, compression ratio: 3.29
Average prefix length: 8.36, average data length: 0.64
Clustering factor: 39348, ratio: 0.17
Fill distribution:
0 - 19% = 2
20 - 39% = 40
40 - 59% = 118
60 - 79% = 87
80 - 99% = 26
PERF_ESTIMATED (160)
Primary pointer page: 344, Index root page: 345
Total formats: 1, used formats: 1
Average record length: 27.99, total records: 277128
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: 2376
Data pages: 2376, average fill: 64%
Primary pages: 2376, secondary pages: 0, swept pages: 0
Empty pages: 7, full pages: 2368
Fill distribution:
0 - 19% = 7
20 - 39% = 1
40 - 59% = 0
60 - 79% = 2368
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 260333, depth: 2, leaf buckets: 223, nodes: 277128
Average node length: 4.54, total dup: 276948, max dup: 2341
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.57, average data length: 0.00
Clustering factor: 39054, ratio: 0.14
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 84
60 - 79% = 83
80 - 99% = 56
PERF_ISQL_STAT (161)
Primary pointer page: 347, Index root page: 348
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PERF_ISQL_STAT_TRN (0)
Root page: 349, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PERF_LOG (163)
Primary pointer page: 352, Index root page: 353
Total formats: 1, used formats: 1
Average record length: 151.77, total records: 12725434
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.17
Pointer pages: 186, data page slots: 302120
Data pages: 302120, average fill: 87%
Primary pages: 302120, secondary pages: 0, swept pages: 2
Empty pages: 0, full pages: 302115
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 0
60 - 79% = 2
80 - 99% = 302115
Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 61748, depth: 3, leaf buckets: 14388, nodes: 12725210
Average node length: 5.70, total dup: 11859031, max dup: 154
Average key length: 2.17, compression ratio: 3.69
Average prefix length: 7.87, average data length: 0.12
Clustering factor: 3767604, ratio: 0.30
Fill distribution:
0 - 19% = 8
20 - 39% = 0
40 - 59% = 8046
60 - 79% = 4045
80 - 99% = 2289
Index PERF_LOG_GDSCODE (3)
Root page: 163282, depth: 3, leaf buckets: 12721, nodes: 12725423
Average node length: 4.62, total dup: 12725418, max dup: 11599210
Average key length: 1.09, compression ratio: 0.41
Average prefix length: 0.44, average data length: 0.00
Clustering factor: 366679, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 12694
60 - 79% = 3
80 - 99% = 24
Index PERF_LOG_TRN_DESC (2)
Root page: 42827, depth: 3, leaf buckets: 15649, nodes: 12725210
Average node length: 5.75, total dup: 12350179, max dup: 24395
Average key length: 2.22, compression ratio: 4.06
Average prefix length: 8.81, average data length: 0.19
Clustering factor: 834564, ratio: 0.07
Fill distribution:
0 - 19% = 2
20 - 39% = 3
40 - 59% = 11800
60 - 79% = 2118
80 - 99% = 1726
Index PERF_LOG_UNIT (1)
Root page: 77433, depth: 3, leaf buckets: 15548, nodes: 12725322
Average node length: 5.59, total dup: 12703192, max dup: 1817976
Average key length: 2.06, compression ratio: 18.33
Average prefix length: 37.79, average data length: 0.06
Clustering factor: 6576260, ratio: 0.52
Fill distribution:
0 - 19% = 11
20 - 39% = 2
40 - 59% = 13466
60 - 79% = 516
80 - 99% = 1553
PHRASES (145)
Primary pointer page: 269, Index root page: 270
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_ID_DESC (3)
Root page: 283, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_NAME (2)
Root page: 282, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_UNQ (1)
Root page: 281, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_PHRASES (0)
Root page: 280, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PSTORNED (151)
Primary pointer page: 303, Index root page: 304
Total formats: 1, used formats: 1
Average record length: 55.01, total records: 425977
Average version length: 55.70, total versions: 864, 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: 5112
Data pages: 5112, average fill: 74%
Primary pages: 5112, secondary pages: 0, swept pages: 271
Empty pages: 0, full pages: 4410
Fill distribution:
0 - 19% = 10
20 - 39% = 11
40 - 59% = 68
60 - 79% = 5021
80 - 99% = 2
Index PSTORNED_RCV_ID (2)
Root page: 714761, depth: 3, leaf buckets: 584, nodes: 425977
Average node length: 5.98, total dup: 355552, max dup: 730
Average key length: 3.20, compression ratio: 2.81
Average prefix length: 7.96, average data length: 1.04
Clustering factor: 51715, ratio: 0.12
Fill distribution:
0 - 19% = 6
20 - 39% = 35
40 - 59% = 385
60 - 79% = 124
80 - 99% = 34
Index PSTORNED_SND_ID (1)
Root page: 2643, depth: 2, leaf buckets: 453, nodes: 425977
Average node length: 5.59, total dup: 380107, max dup: 90
Average key length: 2.81, compression ratio: 3.20
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 99526, ratio: 0.23
Fill distribution:
0 - 19% = 1
20 - 39% = 8
40 - 59% = 180
60 - 79% = 178
80 - 99% = 86
RULES_FOR_PDISTR (152)
Primary pointer page: 305, Index root page: 306
Total formats: 1, used formats: 1
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 336.00, compression ratio: 18.67
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 2%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_PDISTR_UNQ (0)
Root page: 310, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 11.50, total dup: 0, max dup: 0
Average key length: 10.25, compression ratio: 0.88
Average prefix length: 1.50, average data length: 7.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RULES_FOR_QDISTR (139)
Primary pointer page: 245, Index root page: 246
Total formats: 1, used formats: 1
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 332.00, compression ratio: 10.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_RCVOP (1)
Root page: 248, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 5.29, total dup: 2, max dup: 2
Average key length: 4.14, compression ratio: 0.72
Average prefix length: 1.43, average data length: 1.57
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_UNQ (0)
Root page: 247, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 10.14, total dup: 0, max dup: 0
Average key length: 8.86, compression ratio: 0.94
Average prefix length: 2.14, average data length: 6.14
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SEMAPHORES (156)
Primary pointer page: 318, Index root page: 319
Total formats: 1, used formats: 1
Average record length: 34.25, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 338.00, compression ratio: 9.87
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 3%
Primary pages: 1, secondary pages: 0, swept pages: 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_SEMAPHORES (0)
Root page: 330, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 12.50, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.50, average data length: 8.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SEMAPHORES_TASK_UNQ (1)
Root page: 331, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 22.50, total dup: 0, max dup: 0
Average key length: 21.00, compression ratio: 1.07
Average prefix length: 4.00, average data length: 18.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SETTINGS (137)
Primary pointer page: 238, Index root page: 239
Total formats: 1, used formats: 1
Average record length: 98.31, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1347.00, compression ratio: 13.70
Pointer pages: 1, data page slots: 2
Data pages: 2, average fill: 80%
Primary pages: 2, secondary pages: 0, swept pages: 2
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1
Index SETTINGS_MODE_CODE (0)
Root page: 240, depth: 1, leaf buckets: 1, nodes: 114
Average node length: 27.11, total dup: 0, max dup: 0
Average key length: 26.10, compression ratio: 1.70
Average prefix length: 21.18, average data length: 23.11
Clustering factor: 6, ratio: 0.05
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$RAND$CALLS (136)
Primary pointer page: 236, Index root page: 237
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$SOURCE (135)
Primary pointer page: 234, Index root page: 235
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$DEP_DOCS (129)
Primary pointer page: 216, Index root page: 217
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_DEP_DOCS_UNQ (0)
Root page: 218, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$IDX_RECALC (132)
Primary pointer page: 226, Index root page: 227
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0)
Root page: 229, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG (133)
Primary pointer page: 230, Index root page: 231
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG_TABLE_STATS (134)
Primary pointer page: 232, Index root page: 233
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_LOG (164)
Primary pointer page: 354, Index root page: 355
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_MON (131)
Primary pointer page: 224, Index root page: 225
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$RESULT_SET (130)
Primary pointer page: 219, Index root page: 220
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_DOC (1)
Root page: 222, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_WARE_DOC (0)
Root page: 221, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$SHOPPING_CART (128)
Primary pointer page: 211, Index root page: 212
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_SHOPCART_UNQ (0)
Root page: 215, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRACE_STAT (162)
Primary pointer page: 350, Index root page: 351
Total formats: 1, used formats: 1
Average record length: 57.84, total records: 2313
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.50
Pointer pages: 1, data page slots: 32
Data pages: 32, average fill: 66%
Primary pages: 32, secondary pages: 0, swept pages: 0
Empty pages: 3, full pages: 28
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 0
60 - 79% = 28
80 - 99% = 0
WARES (144)
Primary pointer page: 267, Index root page: 268
Total formats: 1, used formats: 1
Average record length: 77.71, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 448.00, compression ratio: 5.77
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 77%
Primary pages: 6, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2
Index FK_WARES_WARE_GROUPS (3)
Root page: 380, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 65
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 47, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARES (0)
Root page: 277, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 333, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_ID_DESC (2)
Root page: 279, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 333, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_NUMB_UNQ (1)
Root page: 585, depth: 2, leaf buckets: 4, nodes: 400
Average node length: 52.81, total dup: 0, max dup: 0
Average key length: 51.79, compression ratio: 1.00
Average prefix length: 2.72, average data length: 48.81
Clustering factor: 342, ratio: 0.85
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3
80 - 99% = 0
WARE_GROUPS (155)
Primary pointer page: 316, Index root page: 317
Total formats: 1, used formats: 1
Average record length: 32.13, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 352.00, compression ratio: 10.96
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 5%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARE_GROUPS (0)
Root page: 328, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 11.25, total dup: 0, max dup: 0
Average key length: 10.13, compression ratio: 0.89
Average prefix length: 1.75, average data length: 7.25
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index WARE_GROUPS_NAME_UNQ (1)
Root page: 329, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 19.88, total dup: 0, max dup: 0
Average key length: 18.13, compression ratio: 0.89
Average prefix length: 0.25, average data length: 15.88
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQD_1000_1200 (260)
Primary pointer page: 298, Index root page: 307
Total formats: 1, used formats: 1
Average record length: 58.77, total records: 3667
Average version length: 72.18, total versions: 683, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.31
Pointer pages: 2, data page slots: 936
Data pages: 376, average fill: 13%
Primary pages: 375, secondary pages: 1, swept pages: 132
Empty pages: 196, full pages: 15
Fill distribution:
0 - 19% = 292
20 - 39% = 44
40 - 59% = 17
60 - 79% = 21
80 - 99% = 2
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1583, depth: 2, leaf buckets: 10, nodes: 3667
Average node length: 7.17, total dup: 3153, max dup: 14
Average key length: 5.19, compression ratio: 7.14
Average prefix length: 33.95, average data length: 3.05
Clustering factor: 590, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 7
40 - 59% = 3
60 - 79% = 0
80 - 99% = 0
XQD_1000_3300 (262)
Primary pointer page: 782, Index root page: 783
Total formats: 1, used formats: 1
Average record length: 71.38, total records: 965057
Average version length: 71.71, total versions: 10898, 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: 9, data page slots: 14568
Data pages: 14568, average fill: 73%
Primary pages: 14568, secondary pages: 0, swept pages: 5
Empty pages: 15, full pages: 11002
Fill distribution:
0 - 19% = 67
20 - 39% = 203
40 - 59% = 861
60 - 79% = 13327
80 - 99% = 110
Index XQD_1000_3300_DOC (1)
Root page: 523194, depth: 3, leaf buckets: 989, nodes: 965078
Average node length: 5.12, total dup: 938415, max dup: 127
Average key length: 2.20, compression ratio: 4.08
Average prefix length: 8.82, average data length: 0.18
Clustering factor: 102600, ratio: 0.11
Fill distribution:
0 - 19% = 18
20 - 39% = 56
40 - 59% = 597
60 - 79% = 37
80 - 99% = 281
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 231428, depth: 3, leaf buckets: 1377, nodes: 965057
Average node length: 6.25, total dup: 842034, max dup: 29
Average key length: 3.33, compression ratio: 11.13
Average prefix length: 35.80, average data length: 1.20
Clustering factor: 183489, ratio: 0.19
Fill distribution:
0 - 19% = 23
20 - 39% = 143
40 - 59% = 941
60 - 79% = 151
80 - 99% = 119
XQD_1200_2000 (261)
Primary pointer page: 777, Index root page: 778
Total formats: 1, used formats: 1
Average record length: 51.32, total records: 56760
Average version length: 71.99, total versions: 6016, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.65
Pointer pages: 3, data page slots: 2536
Data pages: 2304, average fill: 25%
Primary pages: 2303, secondary pages: 1, swept pages: 490
Empty pages: 550, full pages: 106
Fill distribution:
0 - 19% = 1108
20 - 39% = 583
40 - 59% = 367
60 - 79% = 211
80 - 99% = 35
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 681282, depth: 3, leaf buckets: 87, nodes: 44921
Average node length: 6.18, total dup: 38524, max dup: 43
Average key length: 3.72, compression ratio: 9.95
Average prefix length: 35.42, average data length: 1.58
Clustering factor: 5167, ratio: 0.12
Fill distribution:
0 - 19% = 3
20 - 39% = 43
40 - 59% = 31
60 - 79% = 7
80 - 99% = 3
XQD_2000_3300 (263)
Primary pointer page: 786, Index root page: 787
Total formats: 1, used formats: 1
Average record length: 58.17, total records: 2085829
Average version length: 71.44, total versions: 47649, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.34
Pointer pages: 20, data page slots: 32056
Data pages: 32040, average fill: 62%
Primary pages: 32039, secondary pages: 1, swept pages: 583
Empty pages: 650, full pages: 24199
Fill distribution:
0 - 19% = 1185
20 - 39% = 5762
40 - 59% = 3467
60 - 79% = 20757
80 - 99% = 869
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 190304, depth: 3, leaf buckets: 2667, nodes: 1677270
Average node length: 5.63, total dup: 1575296, max dup: 49
Average key length: 2.66, compression ratio: 13.89
Average prefix length: 36.40, average data length: 0.60
Clustering factor: 172843, ratio: 0.10
Fill distribution:
0 - 19% = 13
20 - 39% = 1165
40 - 59% = 1159
60 - 79% = 170
80 - 99% = 160
XQD_2100_3300 (264)
Primary pointer page: 789, Index root page: 790
Total formats: 1, used formats: 1
Average record length: 9.02, total records: 1531530
Average version length: 70.69, total versions: 245, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 15.08
Pointer pages: 10, data page slots: 14944
Data pages: 14864, average fill: 33%
Primary pages: 14863, secondary pages: 1, swept pages: 702
Empty pages: 575, full pages: 14019
Fill distribution:
0 - 19% = 747
20 - 39% = 9926
40 - 59% = 3102
60 - 79% = 1085
80 - 99% = 4
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1684, depth: 2, leaf buckets: 6, nodes: 2089
Average node length: 8.58, total dup: 1782, max dup: 48
Average key length: 5.67, compression ratio: 6.52
Average prefix length: 33.47, average data length: 3.53
Clustering factor: 352, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 4
40 - 59% = 2
60 - 79% = 0
80 - 99% = 0
XQD_3300_3400 (265)
Primary pointer page: 801, Index root page: 802
Total formats: 1, used formats: 1
Average record length: 66.89, total records: 3059394
Average version length: 71.12, total versions: 14984, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.03
Pointer pages: 26, data page slots: 42432
Data pages: 42432, average fill: 75%
Primary pages: 42432, secondary pages: 0, swept pages: 711
Empty pages: 29, full pages: 35430
Fill distribution:
0 - 19% = 90
20 - 39% = 419
40 - 59% = 1709
60 - 79% = 38926
80 - 99% = 1288
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 37222, depth: 3, leaf buckets: 6111, nodes: 2851346
Average node length: 6.88, total dup: 2307217, max dup: 21
Average key length: 3.90, compression ratio: 9.49
Average prefix length: 35.29, average data length: 1.71
Clustering factor: 488443, ratio: 0.17
Fill distribution:
0 - 19% = 4
20 - 39% = 3605
40 - 59% = 2117
60 - 79% = 242
80 - 99% = 143
XQS_1000_1200 (266)
Primary pointer page: 805, Index root page: 806
Total formats: 1, used formats: 1
Average record length: 83.69, total records: 4816859
Average version length: 82.22, total versions: 4056, 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: 46, data page slots: 74008
Data pages: 74008, average fill: 80%
Primary pages: 74008, secondary pages: 0, swept pages: 7424
Empty pages: 12, full pages: 73625
Fill distribution:
0 - 19% = 12
20 - 39% = 9
40 - 59% = 31
60 - 79% = 20653
80 - 99% = 53303
Index XQS_1000_1200_DOC_ID (0)
Root page: 55157, depth: 3, leaf buckets: 5062, nodes: 4816859
Average node length: 5.16, total dup: 4707500, max dup: 128
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 737378, ratio: 0.15
Fill distribution:
0 - 19% = 24
20 - 39% = 90
40 - 59% = 2473
60 - 79% = 2080
80 - 99% = 395
Index XQS_1000_1200_RCV_ID (2)
Root page: 83992, depth: 3, leaf buckets: 5022, nodes: 4816859
Average node length: 5.71, total dup: 4296146, max dup: 49
Average key length: 2.73, compression ratio: 3.30
Average prefix length: 8.38, average data length: 0.62
Clustering factor: 195638, ratio: 0.04
Fill distribution:
0 - 19% = 38
20 - 39% = 144
40 - 59% = 2498
60 - 79% = 294
80 - 99% = 2048
Index XQS_1000_1200_SND_ID (1)
Root page: 48960, depth: 3, leaf buckets: 5613, nodes: 4816859
Average node length: 5.81, total dup: 4214510, max dup: 29
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 797298, ratio: 0.17
Fill distribution:
0 - 19% = 34
20 - 39% = 104
40 - 59% = 2589
60 - 79% = 2277
80 - 99% = 609
XQS_1000_3300 (268)
Primary pointer page: 815, Index root page: 816
Total formats: 1, used formats: 1
Average record length: 83.01, total records: 2668014
Average version length: 82.88, total versions: 15761, 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: 42384
Data pages: 42384, average fill: 78%
Primary pages: 42381, secondary pages: 3, swept pages: 3977
Empty pages: 65, full pages: 38242
Fill distribution:
0 - 19% = 148
20 - 39% = 252
40 - 59% = 956
60 - 79% = 18081
80 - 99% = 22947
Index XQS_1000_3300_DOC_ID (0)
Root page: 76716, depth: 3, leaf buckets: 2864, nodes: 2667971
Average node length: 5.15, total dup: 2605986, max dup: 197
Average key length: 2.18, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 428613, ratio: 0.16
Fill distribution:
0 - 19% = 5
20 - 39% = 53
40 - 59% = 1695
60 - 79% = 825
80 - 99% = 286
Index XQS_1000_3300_RCV_ID (2)
Root page: 110552, depth: 3, leaf buckets: 4409, nodes: 2668020
Average node length: 6.25, total dup: 2180202, max dup: 14
Average key length: 3.27, compression ratio: 2.75
Average prefix length: 7.91, average data length: 1.09
Clustering factor: 238533, ratio: 0.09
Fill distribution:
0 - 19% = 109
20 - 39% = 1752
40 - 59% = 1559
60 - 79% = 621
80 - 99% = 368
Index XQS_1000_3300_SND_ID (1)
Root page: 66178, depth: 3, leaf buckets: 3211, nodes: 2667971
Average node length: 5.81, total dup: 2334164, max dup: 35
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 512015, ratio: 0.19
Fill distribution:
0 - 19% = 9
20 - 39% = 56
40 - 59% = 1885
60 - 79% = 930
80 - 99% = 331
XQS_1200_2000 (267)
Primary pointer page: 810, Index root page: 811
Total formats: 1, used formats: 1
Average record length: 83.47, total records: 5099994
Average version length: 83.80, total versions: 25579, 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: 50, data page slots: 80560
Data pages: 80376, average fill: 79%
Primary pages: 80374, secondary pages: 2, swept pages: 1883
Empty pages: 445, full pages: 74621
Fill distribution:
0 - 19% = 712
20 - 39% = 792
40 - 59% = 1787
60 - 79% = 15983
80 - 99% = 61102
Index XQS_1200_2000_DOC_ID (0)
Root page: 58219, depth: 3, leaf buckets: 5441, nodes: 5099994
Average node length: 5.04, total dup: 5070081, max dup: 701
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 768432, ratio: 0.15
Fill distribution:
0 - 19% = 6
20 - 39% = 286
40 - 59% = 3081
60 - 79% = 1564
80 - 99% = 504
Index XQS_1200_2000_RCV_ID (2)
Root page: 84200, depth: 3, leaf buckets: 6134, nodes: 5099994
Average node length: 5.52, total dup: 4703427, max dup: 49
Average key length: 2.53, compression ratio: 3.56
Average prefix length: 8.55, average data length: 0.45
Clustering factor: 224827, ratio: 0.04
Fill distribution:
0 - 19% = 133
20 - 39% = 1514
40 - 59% = 2422
60 - 79% = 684
80 - 99% = 1381
Index XQS_1200_2000_SND_ID (1)
Root page: 50796, depth: 3, leaf buckets: 6108, nodes: 5099994
Average node length: 5.70, total dup: 4558967, max dup: 88
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 847447, ratio: 0.17
Fill distribution:
0 - 19% = 6
20 - 39% = 232
40 - 59% = 3507
60 - 79% = 1738
80 - 99% = 625
XQS_2000_3300 (269)
Primary pointer page: 821, Index root page: 822
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_DOC_ID (0)
Root page: 823, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_RCV_ID (2)
Root page: 825, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_SND_ID (1)
Root page: 824, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQS_2100_3300 (270)
Primary pointer page: 826, Index root page: 827
Total formats: 1, used formats: 1
Average record length: 83.24, total records: 3459898
Average version length: 83.25, total versions: 16232, 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: 54896
Data pages: 54896, average fill: 78%
Primary pages: 54896, secondary pages: 0, swept pages: 4499
Empty pages: 74, full pages: 49225
Fill distribution:
0 - 19% = 142
20 - 39% = 228
40 - 59% = 1152
60 - 79% = 22507
80 - 99% = 30867
Index XQS_2100_3300_DOC_ID (0)
Root page: 92352, depth: 3, leaf buckets: 3771, nodes: 3459899
Average node length: 5.02, total dup: 3443531, max dup: 1303
Average key length: 2.04, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 670471, ratio: 0.19
Fill distribution:
0 - 19% = 21
20 - 39% = 415
40 - 59% = 2006
60 - 79% = 923
80 - 99% = 406
Index XQS_2100_3300_RCV_ID (2)
Root page: 110525, depth: 3, leaf buckets: 5804, nodes: 3459996
Average node length: 6.26, total dup: 2826081, max dup: 14
Average key length: 3.28, compression ratio: 2.75
Average prefix length: 7.91, average data length: 1.09
Clustering factor: 334943, ratio: 0.10
Fill distribution:
0 - 19% = 200
20 - 39% = 2437
40 - 59% = 1874
60 - 79% = 779
80 - 99% = 514
Index XQS_2100_3300_SND_ID (1)
Root page: 77842, depth: 3, leaf buckets: 4148, nodes: 3459900
Average node length: 5.57, total dup: 3162664, max dup: 73
Average key length: 2.59, compression ratio: 3.47
Average prefix length: 8.49, average data length: 0.51
Clustering factor: 718233, ratio: 0.21
Fill distribution:
0 - 19% = 16
20 - 39% = 433
40 - 59% = 2154
60 - 79% = 1078
80 - 99% = 467
XQS_3300_3400 (271)
Primary pointer page: 831, Index root page: 832
Total formats: 1, used formats: 1
Average record length: 69.00, total records: 612760
Average version length: 68.90, total versions: 4882, 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: 8480
Data pages: 8480, average fill: 77%
Primary pages: 8479, secondary pages: 1, swept pages: 1384
Empty pages: 4, full pages: 8042
Fill distribution:
0 - 19% = 12
20 - 39% = 29
40 - 59% = 81
60 - 79% = 8246
80 - 99% = 112
Index XQS_3300_3400_DOC_ID (0)
Root page: 220576, depth: 3, leaf buckets: 738, nodes: 612760
Average node length: 5.34, total dup: 574882, max dup: 119
Average key length: 2.47, compression ratio: 3.64
Average prefix length: 8.59, average data length: 0.41
Clustering factor: 54889, ratio: 0.09
Fill distribution:
0 - 19% = 2
20 - 39% = 133
40 - 59% = 343
60 - 79% = 194
80 - 99% = 66
Index XQS_3300_3400_SND_ID (1)
Root page: 163039, depth: 3, leaf buckets: 823, nodes: 612760
Average node length: 5.93, total dup: 522204, max dup: 15
Average key length: 3.06, compression ratio: 2.94
Average prefix length: 8.08, average data length: 0.92
Clustering factor: 58173, ratio: 0.09
Fill distribution:
0 - 19% = 1
20 - 39% = 163
40 - 59% = 370
60 - 79% = 223
80 - 99% = 66
ZDOC_DATA (230)
Primary pointer page: 674, Index root page: 675
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZDOC_LIST (229)
Primary pointer page: 672, Index root page: 673
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZINVNT_TURNOVER_LOG (231)
Primary pointer page: 676, Index root page: 677
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPDISTR (234)
Primary pointer page: 682, Index root page: 683
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPDISTR_ID (0)
Root page: 692, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPSTORNED (235)
Primary pointer page: 684, Index root page: 685
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPSTORNED_ID (0)
Root page: 693, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQDISTR (232)
Primary pointer page: 678, Index root page: 679
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_ID (0)
Root page: 686, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Root page: 687, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQSTORNED (233)
Primary pointer page: 680, Index root page: 681
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_DOC_ID (1)
Root page: 689, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_ID (0)
Root page: 688, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_RCV_ID (3)
Root page: 691, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_SND_ID (2)
Root page: 690, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_DEP_DOCS (228)
Primary pointer page: 622, Index root page: 623
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_SHOPPING_CART (227)
Primary pointer page: 620, Index root page: 621
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Z_USED_VIEWS (146)
Primary pointer page: 271, Index root page: 272
Total formats: 1, used formats: 1
Average record length: 29.38, total records: 29
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 99.00, compression ratio: 3.37
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 16%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index Z_USED_VIEWS_UNQ (0)
Root page: 284, depth: 1, leaf buckets: 1, nodes: 29
Average node length: 15.17, total dup: 0, max dup: 0
Average key length: 14.14, compression ratio: 1.44
Average prefix length: 9.17, average data length: 11.17
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Done for 88390 ms, from 11:52:03.40 to 11:53:31.79.
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
VERS_PERCENT |
AGENTS |
50 |
0 |
0.0000 |
BUSINESS_OPS |
19 |
0 |
0.0000 |
DOC_DATA |
2212940 |
3245 |
0.1466 |
DOC_LIST |
676745 |
985 |
0.1455 |
DOC_STATES |
4 |
0 |
0.0000 |
FB_ERRORS |
758 |
0 |
0.0000 |
INVNT_SALDO |
400 |
0 |
0.0000 |
INVNT_TURNOVER_LOG |
3451 |
2686 |
77.8325 |
MONEY_SALDO |
49 |
0 |
0.0000 |
MONEY_TURNOVER_LOG |
71 |
7 |
9.8591 |
OPTYPES |
9 |
0 |
0.0000 |
PDISTR |
499472 |
875 |
0.1751 |
PERF_ESTIMATED |
277128 |
0 |
0.0000 |
PERF_LOG |
12725434 |
0 |
0.0000 |
PSTORNED |
425977 |
864 |
0.2028 |
RULES_FOR_PDISTR |
4 |
0 |
0.0000 |
RULES_FOR_QDISTR |
7 |
0 |
0.0000 |
SEMAPHORES |
4 |
0 |
0.0000 |
SETTINGS |
114 |
0 |
0.0000 |
TRACE_STAT |
2313 |
0 |
0.0000 |
WARES |
400 |
0 |
0.0000 |
WARE_GROUPS |
8 |
0 |
0.0000 |
XQD_1000_1200 |
3667 |
683 |
18.6255 |
XQD_1000_3300 |
965057 |
10898 |
1.1292 |
XQD_1200_2000 |
56760 |
6016 |
10.5990 |
XQD_2000_3300 |
2085829 |
47649 |
2.2844 |
XQD_2100_3300 |
1531530 |
245 |
0.0159 |
XQD_3300_3400 |
3059394 |
14984 |
0.4897 |
XQS_1000_1200 |
4816859 |
4056 |
0.0842 |
XQS_1000_3300 |
2668014 |
15761 |
0.5907 |
XQS_1200_2000 |
5099994 |
25579 |
0.5015 |
XQS_2100_3300 |
3459898 |
16232 |
0.4691 |
XQS_3300_3400 |
612760 |
4882 |
0.7967 |
Z_USED_VIEWS |
29 |
0 |
0.0000 |
Done for 2370 ms, from 11:53:46.54 to 11:53:48.91.
11:53:49.02 Validation started
11:53:49.06 Relation 140 (DOC_LIST)
11:53:49.06 process pointer page 0 of 6
11:53:49.26 process pointer page 1 of 6
11:53:49.77 process pointer page 2 of 6
11:53:50.16 process pointer page 3 of 6
11:53:50.74 process pointer page 4 of 6
11:53:51.30 process pointer page 5 of 6
11:53:51.43 Index 1 (PK_DOC_LIST)
11:53:51.71 Index 2 (DOC_LIST_ID_DESC)
11:53:52.00 Index 3 (FK_DOC_LIST_AGENTS)
11:53:52.28 Relation 140 (DOC_LIST) is ok
11:53:52.28 Relation 141 (DOC_DATA)
11:53:52.28 process pointer page 0 of 15
11:53:52.42 process pointer page 1 of 15
11:53:52.58 process pointer page 2 of 15
11:53:52.72 process pointer page 3 of 15
11:53:52.86 process pointer page 4 of 15
11:53:53.10 process pointer page 5 of 15
11:53:53.44 process pointer page 6 of 15
11:53:54.06 process pointer page 7 of 15
11:53:54.70 process pointer page 8 of 15
11:53:55.42 process pointer page 9 of 15
11:53:56.09 process pointer page 10 of 15
11:53:56.71 process pointer page 11 of 15
11:53:57.29 process pointer page 12 of 15
11:53:57.96 process pointer page 13 of 15
11:53:58.54 process pointer page 14 of 15
11:53:58.98 Index 2 (DOC_DATA_DOC_WARE_UNQ)
11:54:00.10 Index 3 (DOC_DATA_ID_DESC)
11:54:01.02 Index 4 (FK_DOC_DATA_DOC_LIST)
11:54:01.77 Relation 141 (DOC_DATA) is ok
11:54:01.77 Relation 147 (INVNT_SALDO)
11:54:01.77 process pointer page 0 of 1
11:54:01.78 Index 1 (PK_INVNT_SALDO)
11:54:01.78 Warning: Relation has 57 orphan backversions {0 in use}
11:54:01.78 Relation 147 (INVNT_SALDO) is ok
11:54:01.78 Relation 150 (PDISTR)
11:54:01.78 process pointer page 0 of 3
11:54:02.11 process pointer page 1 of 3
11:54:02.71 process pointer page 2 of 3
11:54:02.78 Index 2 (PDISTR_SND_ID)
11:54:02.86 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
11:54:02.95 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
11:54:03.03 Index 5 (PDISTR_AGENT_ID)
11:54:03.11 Relation 150 (PDISTR) is ok
11:54:03.11 Relation 151 (PSTORNED)
11:54:03.11 process pointer page 0 of 4
11:54:03.30 process pointer page 1 of 4
11:54:03.78 process pointer page 2 of 4
11:54:04.33 process pointer page 3 of 4
11:54:04.41 Index 2 (PSTORNED_SND_ID)
11:54:04.55 Index 3 (PSTORNED_RCV_ID)
11:54:04.69 Relation 151 (PSTORNED) is ok
11:54:04.69 Relation 156 (SEMAPHORES)
11:54:04.69 process pointer page 0 of 1
11:54:04.69 Index 1 (PK_SEMAPHORES)
11:54:04.69 Index 2 (SEMAPHORES_TASK_UNQ)
11:54:04.69 Relation 156 (SEMAPHORES) is ok
11:54:04.69 Relation 157 (INVNT_TURNOVER_LOG)
11:54:04.69 process pointer page 0 of 2
11:54:04.70 process pointer page 1 of 2
11:54:04.70 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
11:54:04.70 Relation 157 (INVNT_TURNOVER_LOG) is ok
11:54:04.70 Relation 160 (PERF_ESTIMATED)
11:54:04.70 process pointer page 0 of 2
11:54:05.44 process pointer page 1 of 2
11:54:05.78 Index 1 (PERF_EST_MINUTE_SINCE_START)
11:54:05.86 Relation 160 (PERF_ESTIMATED) is ok
11:54:05.86 Relation 161 (PERF_ISQL_STAT)
11:54:05.86 process pointer page 0 of 1
11:54:05.86 Index 1 (PERF_ISQL_STAT_TRN)
11:54:05.86 Relation 161 (PERF_ISQL_STAT) is ok
11:54:05.86 Relation 162 (TRACE_STAT)
11:54:05.86 process pointer page 0 of 1
11:54:05.87 Relation 162 (TRACE_STAT) is ok
11:54:05.87 Relation 163 (PERF_LOG)
11:54:05.87 process pointer page 0 of 186
11:54:05.95 process pointer page 1 of 186
11:54:06.03 process pointer page 2 of 186
11:54:06.11 process pointer page 3 of 186
11:54:06.20 process pointer page 4 of 186
11:54:06.28 process pointer page 5 of 186
11:54:06.36 process pointer page 6 of 186
11:54:06.45 process pointer page 7 of 186
11:54:06.53 process pointer page 8 of 186
11:54:06.61 process pointer page 9 of 186
11:54:06.68 process pointer page 10 of 186
11:54:06.78 process pointer page 11 of 186
11:54:06.85 process pointer page 12 of 186
11:54:06.93 process pointer page 13 of 186
11:54:07.03 process pointer page 14 of 186
11:54:07.10 process pointer page 15 of 186
11:54:07.18 process pointer page 16 of 186
11:54:07.26 process pointer page 17 of 186
11:54:07.35 process pointer page 18 of 186
11:54:07.43 process pointer page 19 of 186
11:54:07.51 process pointer page 20 of 186
11:54:07.60 process pointer page 21 of 186
11:54:07.68 process pointer page 22 of 186
11:54:07.76 process pointer page 23 of 186
11:54:07.85 process pointer page 24 of 186
11:54:07.93 process pointer page 25 of 186
11:54:08.01 process pointer page 26 of 186
11:54:08.10 process pointer page 27 of 186
11:54:08.18 process pointer page 28 of 186
11:54:08.26 process pointer page 29 of 186
11:54:08.35 process pointer page 30 of 186
11:54:08.43 process pointer page 31 of 186
11:54:08.51 process pointer page 32 of 186
11:54:08.63 process pointer page 33 of 186
11:54:08.93 process pointer page 34 of 186
11:54:09.23 process pointer page 35 of 186
11:54:09.54 process pointer page 36 of 186
11:54:09.85 process pointer page 37 of 186
11:54:10.15 process pointer page 38 of 186
11:54:10.46 process pointer page 39 of 186
11:54:10.75 process pointer page 40 of 186
11:54:11.07 process pointer page 41 of 186
11:54:11.36 process pointer page 42 of 186
11:54:11.68 process pointer page 43 of 186
11:54:11.97 process pointer page 44 of 186
11:54:12.28 process pointer page 45 of 186
11:54:12.58 process pointer page 46 of 186
11:54:12.88 process pointer page 47 of 186
11:54:13.17 process pointer page 48 of 186
11:54:13.48 process pointer page 49 of 186
11:54:13.78 process pointer page 50 of 186
11:54:14.08 process pointer page 51 of 186
11:54:14.37 process pointer page 52 of 186
11:54:14.67 process pointer page 53 of 186
11:54:14.97 process pointer page 54 of 186
11:54:15.28 process pointer page 55 of 186
11:54:15.58 process pointer page 56 of 186
11:54:15.87 process pointer page 57 of 186
11:54:16.17 process pointer page 58 of 186
11:54:16.46 process pointer page 59 of 186
11:54:16.76 process pointer page 60 of 186
11:54:17.06 process pointer page 61 of 186
11:54:17.37 process pointer page 62 of 186
11:54:17.67 process pointer page 63 of 186
11:54:17.96 process pointer page 64 of 186
11:54:18.26 process pointer page 65 of 186
11:54:18.55 process pointer page 66 of 186
11:54:18.90 process pointer page 67 of 186
11:54:19.26 process pointer page 68 of 186
11:54:19.62 process pointer page 69 of 186
11:54:19.97 process pointer page 70 of 186
11:54:20.33 process pointer page 71 of 186
11:54:20.69 process pointer page 72 of 186
11:54:21.05 process pointer page 73 of 186
11:54:21.41 process pointer page 74 of 186
11:54:21.77 process pointer page 75 of 186
11:54:22.14 process pointer page 76 of 186
11:54:22.50 process pointer page 77 of 186
11:54:22.86 process pointer page 78 of 186
11:54:23.22 process pointer page 79 of 186
11:54:23.58 process pointer page 80 of 186
11:54:23.94 process pointer page 81 of 186
11:54:24.30 process pointer page 82 of 186
11:54:24.65 process pointer page 83 of 186
11:54:25.01 process pointer page 84 of 186
11:54:25.39 process pointer page 85 of 186
11:54:25.75 process pointer page 86 of 186
11:54:26.11 process pointer page 87 of 186
11:54:26.45 process pointer page 88 of 186
11:54:26.81 process pointer page 89 of 186
11:54:27.17 process pointer page 90 of 186
11:54:27.51 process pointer page 91 of 186
11:54:27.87 process pointer page 92 of 186
11:54:28.23 process pointer page 93 of 186
11:54:28.59 process pointer page 94 of 186
11:54:28.94 process pointer page 95 of 186
11:54:29.29 process pointer page 96 of 186
11:54:29.65 process pointer page 97 of 186
11:54:30.01 process pointer page 98 of 186
11:54:30.35 process pointer page 99 of 186
11:54:30.71 process pointer page 100 of 186
11:54:31.07 process pointer page 101 of 186
11:54:31.39 process pointer page 102 of 186
11:54:31.74 process pointer page 103 of 186
11:54:32.06 process pointer page 104 of 186
11:54:32.39 process pointer page 105 of 186
11:54:32.74 process pointer page 106 of 186
11:54:33.06 process pointer page 107 of 186
11:54:33.39 process pointer page 108 of 186
11:54:33.72 process pointer page 109 of 186
11:54:34.05 process pointer page 110 of 186
11:54:34.37 process pointer page 111 of 186
11:54:34.70 process pointer page 112 of 186
11:54:35.03 process pointer page 113 of 186
11:54:35.36 process pointer page 114 of 186
11:54:35.68 process pointer page 115 of 186
11:54:36.03 process pointer page 116 of 186
11:54:36.35 process pointer page 117 of 186
11:54:36.68 process pointer page 118 of 186
11:54:37.01 process pointer page 119 of 186
11:54:37.31 process pointer page 120 of 186
11:54:37.60 process pointer page 121 of 186
11:54:37.91 process pointer page 122 of 186
11:54:38.21 process pointer page 123 of 186
11:54:38.51 process pointer page 124 of 186
11:54:38.82 process pointer page 125 of 186
11:54:39.12 process pointer page 126 of 186
11:54:39.33 process pointer page 127 of 186
11:54:39.63 process pointer page 128 of 186
11:54:39.94 process pointer page 129 of 186
11:54:40.24 process pointer page 130 of 186
11:54:40.54 process pointer page 131 of 186
11:54:40.85 process pointer page 132 of 186
11:54:41.14 process pointer page 133 of 186
11:54:41.46 process pointer page 134 of 186
11:54:41.75 process pointer page 135 of 186
11:54:42.08 process pointer page 136 of 186
11:54:42.45 process pointer page 137 of 186
11:54:42.83 process pointer page 138 of 186
11:54:43.19 process pointer page 139 of 186
11:54:43.56 process pointer page 140 of 186
11:54:43.92 process pointer page 141 of 186
11:54:44.29 process pointer page 142 of 186
11:54:44.67 process pointer page 143 of 186
11:54:45.03 process pointer page 144 of 186
11:54:45.40 process pointer page 145 of 186
11:54:45.78 process pointer page 146 of 186
11:54:46.15 process pointer page 147 of 186
11:54:46.53 process pointer page 148 of 186
11:54:46.88 process pointer page 149 of 186
11:54:47.26 process pointer page 150 of 186
11:54:47.62 process pointer page 151 of 186
11:54:47.99 process pointer page 152 of 186
11:54:48.37 process pointer page 153 of 186
11:54:48.74 process pointer page 154 of 186
11:54:49.07 process pointer page 155 of 186
11:54:49.36 process pointer page 156 of 186
11:54:49.68 process pointer page 157 of 186
11:54:49.97 process pointer page 158 of 186
11:54:50.27 process pointer page 159 of 186
11:54:50.58 process pointer page 160 of 186
11:54:50.88 process pointer page 161 of 186
11:54:51.17 process pointer page 162 of 186
11:54:51.47 process pointer page 163 of 186
11:54:51.78 process pointer page 164 of 186
11:54:52.08 process pointer page 165 of 186
11:54:52.39 process pointer page 166 of 186
11:54:52.69 process pointer page 167 of 186
11:54:52.98 process pointer page 168 of 186
11:54:53.30 process pointer page 169 of 186
11:54:53.59 process pointer page 170 of 186
11:54:53.89 process pointer page 171 of 186
11:54:54.19 process pointer page 172 of 186
11:54:54.50 process pointer page 173 of 186
11:54:54.81 process pointer page 174 of 186
11:54:55.12 process pointer page 175 of 186
11:54:55.43 process pointer page 176 of 186
11:54:55.75 process pointer page 177 of 186
11:54:56.07 process pointer page 178 of 186
11:54:56.38 process pointer page 179 of 186
11:54:56.70 process pointer page 180 of 186
11:54:57.01 process pointer page 181 of 186
11:54:57.34 process pointer page 182 of 186
11:54:57.65 process pointer page 183 of 186
11:54:57.96 process pointer page 184 of 186
11:54:58.27 process pointer page 185 of 186
11:54:58.30 Index 1 (PERF_LOG_DTS_BEG_DESC)
11:54:58.72 Warning: Index 1 misses node on page 282211 level 1 at offset 1908
11:55:03.01 Index 2 (PERF_LOG_UNIT)
11:55:09.80 Index 3 (PERF_LOG_TRN_DESC)
11:55:13.51 Index 4 (PERF_LOG_GDSCODE)
11:55:16.70 Relation 163 (PERF_LOG) is ok
11:55:16.70 Relation 167 (V_STOPTEST)
11:55:16.70 Relation 167 (V_STOPTEST) is ok
11:55:16.70 Relation 184 (V_QDISTR_SOURCE)
11:55:16.70 Relation 184 (V_QDISTR_SOURCE) is ok
11:55:16.70 Relation 185 (V_QSTORNED_SOURCE)
11:55:16.70 Relation 185 (V_QSTORNED_SOURCE) is ok
11:55:16.70 Relation 260 (XQD_1000_1200)
11:55:16.70 process pointer page 0 of 2
11:55:16.73 process pointer page 1 of 2
11:55:16.73 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
11:55:16.73 Relation 260 (XQD_1000_1200) is ok
11:55:16.73 Relation 261 (XQD_1200_2000)
11:55:16.73 process pointer page 0 of 3
11:55:16.88 process pointer page 1 of 3
11:55:16.96 process pointer page 2 of 3
11:55:16.96 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
11:55:16.98 Relation 261 (XQD_1200_2000) is ok
11:55:16.98 Relation 262 (XQD_1000_3300)
11:55:16.98 process pointer page 0 of 9
11:55:17.51 process pointer page 1 of 9
11:55:18.01 process pointer page 2 of 9
11:55:18.49 process pointer page 3 of 9
11:55:18.97 process pointer page 4 of 9
11:55:19.46 process pointer page 5 of 9
11:55:19.88 process pointer page 6 of 9
11:55:20.39 process pointer page 7 of 9
11:55:20.88 process pointer page 8 of 9
11:55:21.25 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
11:55:21.63 Index 2 (XQD_1000_3300_DOC)
11:55:21.92 Relation 262 (XQD_1000_3300) is ok
11:55:21.92 Relation 263 (XQD_2000_3300)
11:55:21.92 process pointer page 0 of 20
11:55:22.33 process pointer page 1 of 20
11:55:22.67 process pointer page 2 of 20
11:55:23.05 process pointer page 3 of 20
11:55:23.42 process pointer page 4 of 20
11:55:23.73 process pointer page 5 of 20
11:55:24.04 process pointer page 6 of 20
11:55:24.42 process pointer page 7 of 20
11:55:24.78 process pointer page 8 of 20
11:55:25.14 process pointer page 9 of 20
11:55:25.54 process pointer page 10 of 20
11:55:25.95 process pointer page 11 of 20
11:55:26.32 process pointer page 12 of 20
11:55:26.73 process pointer page 13 of 20
11:55:27.16 process pointer page 14 of 20
11:55:27.60 process pointer page 15 of 20
11:55:28.07 process pointer page 16 of 20
11:55:28.46 process pointer page 17 of 20
11:55:28.88 process pointer page 18 of 20
11:55:29.32 process pointer page 19 of 20
11:55:29.61 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
11:55:30.25 Relation 263 (XQD_2000_3300) is ok
11:55:30.25 Relation 264 (XQD_2100_3300)
11:55:30.25 process pointer page 0 of 10
11:55:30.33 process pointer page 1 of 10
11:55:30.39 process pointer page 2 of 10
11:55:30.46 process pointer page 3 of 10
11:55:30.52 process pointer page 4 of 10
11:55:30.60 process pointer page 5 of 10
11:55:30.66 process pointer page 6 of 10
11:55:30.72 process pointer page 7 of 10
11:55:30.78 process pointer page 8 of 10
11:55:30.85 process pointer page 9 of 10
11:55:30.86 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
11:55:30.86 Relation 264 (XQD_2100_3300) is ok
11:55:30.86 Relation 265 (XQD_3300_3400)
11:55:30.86 process pointer page 0 of 26
11:55:31.25 process pointer page 1 of 26
11:55:31.64 process pointer page 2 of 26
11:55:32.05 process pointer page 3 of 26
11:55:32.42 process pointer page 4 of 26
11:55:32.75 process pointer page 5 of 26
11:55:33.15 process pointer page 6 of 26
11:55:33.53 process pointer page 7 of 26
11:55:33.90 process pointer page 8 of 26
11:55:34.21 process pointer page 9 of 26
11:55:34.57 process pointer page 10 of 26
11:55:35.09 process pointer page 11 of 26
11:55:35.60 process pointer page 12 of 26
11:55:36.10 process pointer page 13 of 26
11:55:36.62 process pointer page 14 of 26
11:55:37.16 process pointer page 15 of 26
11:55:37.72 process pointer page 16 of 26
11:55:38.30 process pointer page 17 of 26
11:55:38.83 process pointer page 18 of 26
11:55:39.33 process pointer page 19 of 26
11:55:39.82 process pointer page 20 of 26
11:55:40.27 process pointer page 21 of 26
11:55:40.78 process pointer page 22 of 26
11:55:41.28 process pointer page 23 of 26
11:55:41.75 process pointer page 24 of 26
11:55:42.19 process pointer page 25 of 26
11:55:42.67 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
11:55:43.92 Relation 265 (XQD_3300_3400) is ok
11:55:43.92 Relation 266 (XQS_1000_1200)
11:55:43.92 process pointer page 0 of 46
11:55:44.03 process pointer page 1 of 46
11:55:44.12 process pointer page 2 of 46
11:55:44.21 process pointer page 3 of 46
11:55:44.32 process pointer page 4 of 46
11:55:44.42 process pointer page 5 of 46
11:55:44.53 process pointer page 6 of 46
11:55:44.62 process pointer page 7 of 46
11:55:44.73 process pointer page 8 of 46
11:55:44.82 process pointer page 9 of 46
11:55:44.92 process pointer page 10 of 46
11:55:45.03 process pointer page 11 of 46
11:55:45.12 process pointer page 12 of 46
11:55:45.23 process pointer page 13 of 46
11:55:45.38 process pointer page 14 of 46
11:55:45.49 process pointer page 15 of 46
11:55:45.62 process pointer page 16 of 46
11:55:45.74 process pointer page 17 of 46
11:55:46.18 process pointer page 18 of 46
11:55:46.63 process pointer page 19 of 46
11:55:47.08 process pointer page 20 of 46
11:55:47.52 process pointer page 21 of 46
11:55:47.97 process pointer page 22 of 46
11:55:48.43 process pointer page 23 of 46
11:55:48.94 process pointer page 24 of 46
11:55:49.47 process pointer page 25 of 46
11:55:50.00 process pointer page 26 of 46
11:55:50.52 process pointer page 27 of 46
11:55:51.05 process pointer page 28 of 46
11:55:51.56 process pointer page 29 of 46
11:55:52.08 process pointer page 30 of 46
11:55:52.56 process pointer page 31 of 46
11:55:53.06 process pointer page 32 of 46
11:55:53.54 process pointer page 33 of 46
11:55:54.00 process pointer page 34 of 46
11:55:54.43 process pointer page 35 of 46
11:55:54.88 process pointer page 36 of 46
11:55:55.37 process pointer page 37 of 46
11:55:55.91 process pointer page 38 of 46
11:55:56.46 process pointer page 39 of 46
11:55:56.99 process pointer page 40 of 46
11:55:57.44 process pointer page 41 of 46
11:55:57.88 process pointer page 42 of 46
11:55:58.33 process pointer page 43 of 46
11:55:58.78 process pointer page 44 of 46
11:55:59.27 process pointer page 45 of 46
11:55:59.42 Index 1 (XQS_1000_1200_DOC_ID)
11:56:00.95 Index 2 (XQS_1000_1200_SND_ID)
11:56:02.51 Index 3 (XQS_1000_1200_RCV_ID)
11:56:04.88 Relation 266 (XQS_1000_1200) is ok
11:56:04.88 Relation 267 (XQS_1200_2000)
11:56:04.88 process pointer page 0 of 50
11:56:05.04 process pointer page 1 of 50
11:56:05.13 process pointer page 2 of 50
11:56:05.26 process pointer page 3 of 50
11:56:05.38 process pointer page 4 of 50
11:56:05.49 process pointer page 5 of 50
11:56:05.62 process pointer page 6 of 50
11:56:05.73 process pointer page 7 of 50
11:56:05.85 process pointer page 8 of 50
11:56:05.98 process pointer page 9 of 50
11:56:06.09 process pointer page 10 of 50
11:56:06.20 process pointer page 11 of 50
11:56:06.32 process pointer page 12 of 50
11:56:06.48 process pointer page 13 of 50
11:56:06.68 process pointer page 14 of 50
11:56:06.93 process pointer page 15 of 50
11:56:07.21 process pointer page 16 of 50
11:56:07.54 process pointer page 17 of 50
11:56:07.86 process pointer page 18 of 50
11:56:08.35 process pointer page 19 of 50
11:56:08.82 process pointer page 20 of 50
11:56:08.86 Error: Data page 301569 {sequence 32833} marked as secondary but contains primary record versions
11:56:09.27 process pointer page 21 of 50
11:56:09.74 process pointer page 22 of 50
11:56:10.19 process pointer page 23 of 50
11:56:10.97 process pointer page 24 of 50
11:56:11.81 process pointer page 25 of 50
11:56:12.65 process pointer page 26 of 50
11:56:13.53 process pointer page 27 of 50
11:56:14.32 process pointer page 28 of 50
11:56:15.15 process pointer page 29 of 50
11:56:15.91 process pointer page 30 of 50
11:56:16.73 process pointer page 31 of 50
11:56:17.58 process pointer page 32 of 50
11:56:18.41 process pointer page 33 of 50
11:56:19.24 process pointer page 34 of 50
11:56:20.08 process pointer page 35 of 50
11:56:20.86 process pointer page 36 of 50
11:56:21.65 process pointer page 37 of 50
11:56:22.50 process pointer page 38 of 50
11:56:23.34 process pointer page 39 of 50
11:56:24.26 process pointer page 40 of 50
11:56:25.10 process pointer page 41 of 50
11:56:25.98 process pointer page 42 of 50
11:56:26.82 process pointer page 43 of 50
11:56:27.63 process pointer page 44 of 50
11:56:28.44 process pointer page 45 of 50
11:56:29.27 process pointer page 46 of 50
11:56:30.02 process pointer page 47 of 50
11:56:30.87 process pointer page 48 of 50
11:56:31.67 process pointer page 49 of 50
11:56:31.89 Index 1 (XQS_1200_2000_DOC_ID)
11:56:35.01 Index 2 (XQS_1200_2000_SND_ID)
11:56:38.25 Index 3 (XQS_1200_2000_RCV_ID)
11:56:41.22 Relation 267 (XQS_1200_2000) : 1 ERRORS found
11:56:41.22 Relation 268 (XQS_1000_3300)
11:56:41.22 process pointer page 0 of 26
11:56:41.90 process pointer page 1 of 26
11:56:42.53 process pointer page 2 of 26
11:56:43.18 process pointer page 3 of 26
11:56:43.93 process pointer page 4 of 26
11:56:44.60 process pointer page 5 of 26
11:56:44.93 Error: Data page 95903 {sequence 8983} marked as secondary but contains primary record versions
11:56:45.29 process pointer page 6 of 26
11:56:45.96 process pointer page 7 of 26
11:56:46.65 process pointer page 8 of 26
11:56:47.29 process pointer page 9 of 26
11:56:47.97 process pointer page 10 of 26
11:56:48.67 process pointer page 11 of 26
11:56:49.00 Warning: Pointer page 226005 {sequence 11} bits {0x08 secondary} are not consistent with data page 259407 {sequence 18703} state {0x00 }
11:56:49.49 process pointer page 12 of 26
11:56:50.36 process pointer page 13 of 26
11:56:51.25 process pointer page 14 of 26
11:56:52.12 process pointer page 15 of 26
11:56:53.04 process pointer page 16 of 26
11:56:53.96 process pointer page 17 of 26
11:56:54.87 process pointer page 18 of 26
11:56:55.76 process pointer page 19 of 26
11:56:56.65 process pointer page 20 of 26
11:56:57.50 process pointer page 21 of 26
11:56:58.36 process pointer page 22 of 26
11:56:59.25 process pointer page 23 of 26
11:57:00.11 process pointer page 24 of 26
11:57:00.84 process pointer page 25 of 26
11:57:01.50 Index 1 (XQS_1000_3300_DOC_ID)
11:57:03.26 Index 2 (XQS_1000_3300_SND_ID)
11:57:05.09 Index 3 (XQS_1000_3300_RCV_ID)
11:57:06.99 Relation 268 (XQS_1000_3300) : 1 ERRORS found
11:57:06.99 Relation 269 (XQS_2000_3300)
11:57:06.99 process pointer page 0 of 1
11:57:06.99 Index 1 (XQS_2000_3300_DOC_ID)
11:57:06.99 Index 2 (XQS_2000_3300_SND_ID)
11:57:06.99 Index 3 (XQS_2000_3300_RCV_ID)
11:57:06.99 Relation 269 (XQS_2000_3300) is ok
11:57:06.99 Relation 270 (XQS_2100_3300)
11:57:06.99 process pointer page 0 of 34
11:57:07.63 process pointer page 1 of 34
11:57:08.22 process pointer page 2 of 34
11:57:08.84 process pointer page 3 of 34
11:57:09.58 process pointer page 4 of 34
11:57:10.22 process pointer page 5 of 34
11:57:10.87 process pointer page 6 of 34
11:57:11.51 process pointer page 7 of 34
11:57:12.17 process pointer page 8 of 34
11:57:12.79 process pointer page 9 of 34
11:57:13.46 process pointer page 10 of 34
11:57:14.12 process pointer page 11 of 34
11:57:14.77 process pointer page 12 of 34
11:57:15.44 process pointer page 13 of 34
11:57:16.08 process pointer page 14 of 34
11:57:16.79 process pointer page 15 of 34
11:57:17.64 process pointer page 16 of 34
11:57:18.50 process pointer page 17 of 34
11:57:19.34 process pointer page 18 of 34
11:57:20.20 process pointer page 19 of 34
11:57:21.09 process pointer page 20 of 34
11:57:21.98 process pointer page 21 of 34
11:57:22.85 process pointer page 22 of 34
11:57:23.74 process pointer page 23 of 34
11:57:24.62 process pointer page 24 of 34
11:57:25.47 process pointer page 25 of 34
11:57:26.33 process pointer page 26 of 34
11:57:27.16 process pointer page 27 of 34
11:57:27.97 process pointer page 28 of 34
11:57:28.84 process pointer page 29 of 34
11:57:29.72 process pointer page 30 of 34
11:57:30.54 process pointer page 31 of 34
11:57:31.29 process pointer page 32 of 34
11:57:32.04 process pointer page 33 of 34
11:57:32.48 Index 1 (XQS_2100_3300_DOC_ID)
11:57:34.66 Index 2 (XQS_2100_3300_SND_ID)
11:57:37.03 Index 3 (XQS_2100_3300_RCV_ID)
11:57:39.50 Relation 270 (XQS_2100_3300) is ok
11:57:39.50 Relation 271 (XQS_3300_3400)
11:57:39.50 process pointer page 0 of 6
11:57:40.17 process pointer page 1 of 6
11:57:40.84 process pointer page 2 of 6
11:57:41.51 process pointer page 3 of 6
11:57:42.20 process pointer page 4 of 6
11:57:43.07 process pointer page 5 of 6
11:57:43.24 Index 1 (XQS_3300_3400_DOC_ID)
11:57:43.60 Index 2 (XQS_3300_3400_SND_ID)
11:57:44.01 Relation 271 (XQS_3300_3400) is ok
11:57:44.01 Validation finished
Done for 235140 ms, from 11:53:48.95 to 11:57:44.09.
Differences between old and current firebird.log
11:57:46.08. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG: 284 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2017-03-14 11:57 9140 oltp40_fb_log_when_test_finished.log
End of gathering firebird.log AFTER test finish.
+++ Start of comparison +++
Comparing files E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
Resync Failed. Files are too different.
***** E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Tue Mar 14 08:38:49 2017
7: INET/inet_error: read errno = 10054, server host = localhost, address = ::1/3400
8:
9:
10: WIN-2BE1UI8LGDL Tue Mar 14 08:38:49 2017
11: INET/inet_error: read errno = 10054, server host = localhost, address = ::1/3400
12:
13:
14: WIN-2BE1UI8LGDL Tue Mar 14 08:38:49 2017
15: INET/inet_error: read errno = 10054, server host = localhost, address = ::1/3400
16:
17:
18: WIN-2BE1UI8LGDL Tue Mar 14 08:38:49 2017
19: INET/inet_error: read errno = 10054, server host = localhost, address = ::1/3400
20:
21:
22: WIN-2BE1UI8LGDL Tue Mar 14 08:38:49 2017
23: INET/inet_error: read errno = 10054, server host = localhost, address = ::1/3400
24:
25:
26: WIN-2BE1UI8LGDL Tue Mar 14 08:38:49 2017
27: INET/inet_error: read errno = 10054, server host = localhost, address = ::1/3400
28:
29:
30: WIN-2BE1UI8LGDL Tue Mar 14 08:38:49 2017
31: INET/inet_error: read errno = 10054, server host = localhost, address = ::1/3400
32:
33:
34: WIN-2BE1UI8LGDL Tue Mar 14 08:38:49 2017
35: INET/inet_error: read errno = 10054, server host = localhost, address = ::1/3400
36:
37:
38: WIN-2BE1UI8LGDL Tue Mar 14 08:38:49 2017
39: INET/inet_error: read errno = 10054, server host = localhost, address = ::1/3400
40:
41:
42: WIN-2BE1UI8LGDL Tue Mar 14 08:38:49 2017
43: INET/inet_error: read errno = 10054, server host = localhost, address = ::1/3400
44:
45:
46: WIN-2BE1UI8LGDL Tue Mar 14 08:38:49 2017
47: INET/inet_error: read errno = 10054, server host = localhost, address = ::1/3400
48:
49:
50: WIN-2BE1UI8LGDL Tue Mar 14 08:38:49 2017
51: INET/inet_error: read errno = 10054, server host = localhost, address = ::1/3400
52:
53:
54: WIN-2BE1UI8LGDL Tue Mar 14 08:38:49 2017
55: INET/inet_error: read errno = 10054, server host = localhost, address = ::1/3400
56:
57:
58: WIN-2BE1UI8LGDL Tue Mar 14 08:38:49 2017
59: INET/inet_error: read errno = 10054, server host = localhost, address = ::1/3400
60:
61:
62: WIN-2BE1UI8LGDL Tue Mar 14 08:38:49 2017
63: INET/inet_error: read errno = 10054, server host = localhost, address = ::1/3400
64:
65:
66: WIN-2BE1UI8LGDL Tue Mar 14 08:38:49 2017
67: INET/inet_error: read errno = 10054, server host = localhost, address = ::1/3400
68:
69:
70: WIN-2BE1UI8LGDL Tue Mar 14 08:38:49 2017
71: INET/inet_error: read errno = 10054, server host = localhost, address = ::1/3400
72:
73:
74: WIN-2BE1UI8LGDL Tue Mar 14 08:38:49 2017
75: INET/inet_error: read errno = 10054, server host = localhost, address = ::1/3400
76:
77:
78: WIN-2BE1UI8LGDL Tue Mar 14 08:38:49 2017
79: INET/inet_error: read errno = 10054, server host = localhost, address = ::1/3400
80:
81:
82: WIN-2BE1UI8LGDL Tue Mar 14 08:38:49 2017
83: INET/inet_error: read errno = 10054, server host = localhost, address = ::1/3400
84:
85:
86: WIN-2BE1UI8LGDL Tue Mar 14 08:38:49 2017
87: INET/inet_error: read errno = 10054, server host = localhost, address = ::1/3400
88:
89:
90: WIN-2BE1UI8LGDL Tue Mar 14 08:38:49 2017
91: INET/inet_error: read errno = 10054, server host = localhost, address = ::1/3400
92:
93:
94: WIN-2BE1UI8LGDL Tue Mar 14 08:38:49 2017
95: INET/inet_error: read errno = 10054, server host = localhost, address = ::1/3400
96:
97:
98: WIN-2BE1UI8LGDL Tue Mar 14 08:38:49 2017
99: INET/inet_error: read errno = 10054, server host = localhost, address = ::1/3400
100:
101:
102: WIN-2BE1UI8LGDL Tue Mar 14 08:38:49 2017
103: INET/inet_error: read errno = 10054, server host = localhost, address = ::1/3400
104:
*****
+++ End of comparison +++
Remove 395 logs of every ISQL session if there were no serious errors.
Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp40\oltp40_*.*:
ERRORS_CHECKING_RESULT |
NO_SEVERE_ERRORS_FOUND |
ISQL logs are removed because no severe errors occured during test.
2017-03-14 11:57:57.05 - end of report, text file: e:\temp\logs.oltp40\oltp40.report.txt, html: e:\temp\logs.oltp40\oltp40.report.html