ACTION |
AVG_TIMES_PER_MINUTE |
AVG_ELAPSED_MS |
SUCCESSFUL_TIMES_DONE |
JOB_BEG |
JOB_END |
*** OVERALL *** for 180 minutes: |
5183.64 |
4361 |
933055 |
2017-08-24 03:46 |
2017-08-24 06:46 |
customer order: creation |
394.06 |
594 |
70931 |
2017-08-24 03:46 |
2017-08-24 06:46 |
customer order: refuse |
31.85 |
308 |
5733 |
2017-08-24 03:46 |
2017-08-24 06:46 |
order to supplier: creation |
100.09 |
2609 |
18017 |
2017-08-24 03:46 |
2017-08-24 06:46 |
order to supplier: removal |
2.62 |
26388 |
471 |
2017-08-24 03:46 |
2017-08-24 06:46 |
invoice (draft): creation |
101.72 |
3938 |
18310 |
2017-08-24 03:46 |
2017-08-24 06:46 |
invoice (draft): removal |
38.82 |
543 |
6988 |
2017-08-24 03:46 |
2017-08-24 06:46 |
invoice accept: apply |
57.63 |
15138 |
10373 |
2017-08-24 03:46 |
2017-08-24 06:46 |
invoice accept: cancel |
16.42 |
3310 |
2955 |
2017-08-24 03:46 |
2017-08-24 06:46 |
customer reserve: creation |
2980.58 |
245 |
536505 |
2017-08-24 03:46 |
2017-08-24 06:46 |
customer reserve: removal |
916.20 |
86 |
164916 |
2017-08-24 03:46 |
2017-08-24 06:46 |
realization accept: apply |
181.20 |
690 |
32616 |
2017-08-24 03:46 |
2017-08-24 06:46 |
realization accept: cancel |
78.42 |
212 |
14115 |
2017-08-24 03:46 |
2017-08-24 06:46 |
payment from customer: creation |
131.98 |
1027 |
23756 |
2017-08-24 03:46 |
2017-08-24 06:46 |
payment from customer: removal |
11.85 |
177 |
2133 |
2017-08-24 03:46 |
2017-08-24 06:46 |
payment to supplier: creation |
109.27 |
1647 |
19669 |
2017-08-24 03:46 |
2017-08-24 06:46 |
payment to supplier: removal |
7.71 |
177 |
1387 |
2017-08-24 03:46 |
2017-08-24 06:46 |
service: total inventory turnovers |
7.55 |
4040 |
1359 |
2017-08-24 03:46 |
2017-08-24 06:46 |
service: total monetary turnovers |
15.61 |
78 |
2809 |
2017-08-24 03:46 |
2017-08-24 06:46 |
service: refresh index statistics |
0.07 |
21656 |
12 |
2017-08-24 03:46 |
2017-08-24 06:46 |
Done for 64470 ms, from 6:50:56.95 to 6:52:01.42.
ACTION |
ITRV_NO |
CNT_OK_PER_MINUTE |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
ITRV_BEG |
ITRV_END |
interval # 1, overall |
1 |
3535 |
75852 |
63631 |
12221 |
16.11 |
03:46:44 |
04:04:44 |
interval # 2, overall |
2 |
4760 |
97290 |
85673 |
11617 |
11.94 |
04:04:45 |
04:22:45 |
interval # 3, overall |
3 |
5033 |
99469 |
90587 |
8882 |
8.93 |
04:22:46 |
04:40:46 |
interval # 4, overall |
4 |
5084 |
99582 |
91505 |
8077 |
8.11 |
04:40:47 |
04:58:47 |
interval # 5, overall |
5 |
5236 |
103685 |
94246 |
9439 |
9.10 |
04:58:48 |
05:16:48 |
interval # 6, overall |
6 |
5923 |
116908 |
106616 |
10292 |
8.80 |
05:16:49 |
05:34:49 |
interval # 7, overall |
7 |
5596 |
111039 |
100730 |
10309 |
9.28 |
05:34:50 |
05:52:50 |
interval # 8, overall |
8 |
5201 |
105334 |
93610 |
11724 |
11.13 |
05:52:51 |
06:10:51 |
interval # 9, overall |
9 |
5787 |
123571 |
104169 |
19402 |
15.70 |
06:10:52 |
06:28:52 |
interval # 10, overall |
10 |
5683 |
118593 |
102288 |
16305 |
13.75 |
06:28:53 |
06:46:53 |
Done for 175550 ms, from 6:55:05.28 to 6:58:00.83.
TEST_PHASE |
MINUTE_SINCE_TEST_START |
AVG_ESTIMATED |
MIN_TO_AVG_RATIO |
MAX_TO_AVG_RATIO |
ROWS_AGGREGATED |
DISTINCT_ATTACHMENTS |
TEST_TIME |
1 |
2724.24 |
0.3333 |
1.6944 |
1542 |
40 |
TEST_TIME |
2 |
3182.66 |
0.7267 |
1.2876 |
1553 |
41 |
TEST_TIME |
3 |
3197.80 |
0.8543 |
1.1694 |
1100 |
100 |
TEST_TIME |
4 |
3158.71 |
0.8909 |
1.1112 |
1185 |
100 |
TEST_TIME |
5 |
3155.83 |
0.8901 |
1.0873 |
1351 |
100 |
TEST_TIME |
6 |
3142.40 |
0.9110 |
1.0915 |
1466 |
100 |
TEST_TIME |
7 |
3187.46 |
0.9224 |
1.0678 |
1364 |
100 |
TEST_TIME |
8 |
3252.22 |
0.9161 |
1.0744 |
1574 |
100 |
TEST_TIME |
9 |
3327.54 |
0.9335 |
1.0434 |
1744 |
100 |
TEST_TIME |
10 |
3186.95 |
0.9806 |
1.0222 |
1220 |
76 |
TEST_TIME |
11 |
3082.19 |
0.9809 |
1.0540 |
832 |
97 |
TEST_TIME |
12 |
3135.82 |
0.9497 |
1.0494 |
1424 |
100 |
TEST_TIME |
13 |
3200.59 |
0.9491 |
1.0348 |
1635 |
100 |
TEST_TIME |
14 |
3205.93 |
0.9593 |
1.0289 |
1627 |
100 |
TEST_TIME |
15 |
3182.22 |
0.9675 |
1.0551 |
1494 |
98 |
TEST_TIME |
16 |
3292.73 |
0.9560 |
1.0346 |
1902 |
100 |
TEST_TIME |
17 |
3317.40 |
0.9706 |
1.0523 |
1872 |
98 |
TEST_TIME |
18 |
3473.54 |
0.9585 |
1.0434 |
1694 |
100 |
TEST_TIME |
19 |
3571.65 |
0.9614 |
1.0456 |
1839 |
100 |
TEST_TIME |
20 |
3684.69 |
0.9631 |
1.0395 |
1568 |
100 |
TEST_TIME |
21 |
3762.44 |
0.9695 |
1.0298 |
1598 |
100 |
TEST_TIME |
22 |
3762.73 |
0.9829 |
1.0218 |
1690 |
96 |
TEST_TIME |
23 |
3814.95 |
0.9640 |
1.0323 |
1279 |
99 |
TEST_TIME |
24 |
3862.89 |
0.9771 |
1.0197 |
1089 |
100 |
TEST_TIME |
25 |
3874.78 |
0.9759 |
1.0245 |
1522 |
100 |
TEST_TIME |
26 |
3918.07 |
0.9742 |
1.0111 |
1366 |
99 |
TEST_TIME |
27 |
3847.01 |
0.9916 |
1.0120 |
1114 |
86 |
TEST_TIME |
28 |
3822.44 |
0.9832 |
1.0156 |
1122 |
89 |
TEST_TIME |
29 |
3836.82 |
0.9769 |
1.0215 |
1013 |
100 |
TEST_TIME |
30 |
3886.32 |
0.9749 |
1.0228 |
1527 |
100 |
TEST_TIME |
31 |
3920.11 |
0.9817 |
1.0138 |
1755 |
99 |
TEST_TIME |
32 |
3889.21 |
0.9899 |
1.0133 |
1546 |
90 |
TEST_TIME |
33 |
3918.81 |
0.9752 |
1.0163 |
1475 |
99 |
TEST_TIME |
34 |
3984.02 |
0.9703 |
1.0230 |
1515 |
100 |
TEST_TIME |
35 |
4056.75 |
0.9774 |
1.0236 |
1608 |
100 |
TEST_TIME |
36 |
4103.14 |
0.9840 |
1.0166 |
1662 |
100 |
TEST_TIME |
37 |
4104.27 |
0.9889 |
1.0203 |
1495 |
100 |
TEST_TIME |
38 |
4110.69 |
0.9920 |
1.0090 |
1458 |
97 |
TEST_TIME |
39 |
4100.88 |
0.9855 |
1.0256 |
1047 |
100 |
TEST_TIME |
40 |
4133.21 |
0.9921 |
1.0080 |
1385 |
100 |
TEST_TIME |
41 |
4146.15 |
0.9803 |
1.0140 |
1277 |
100 |
TEST_TIME |
42 |
4157.19 |
0.9873 |
1.0148 |
1229 |
100 |
TEST_TIME |
43 |
4183.82 |
0.9849 |
1.0145 |
1360 |
100 |
TEST_TIME |
44 |
4198.96 |
0.9882 |
1.0115 |
1221 |
100 |
TEST_TIME |
45 |
4202.52 |
0.9881 |
1.0085 |
1703 |
100 |
TEST_TIME |
46 |
4208.74 |
0.9853 |
1.0209 |
1501 |
99 |
TEST_TIME |
47 |
4254.14 |
0.9885 |
1.0111 |
1784 |
99 |
TEST_TIME |
48 |
4262.88 |
0.9881 |
1.0208 |
1278 |
100 |
TEST_TIME |
49 |
4285.41 |
0.9947 |
1.0071 |
1593 |
96 |
TEST_TIME |
50 |
4303.69 |
0.9827 |
1.0150 |
1473 |
100 |
TEST_TIME |
51 |
4346.18 |
0.9853 |
1.0140 |
1425 |
100 |
TEST_TIME |
52 |
4374.81 |
0.9880 |
1.0097 |
1468 |
100 |
TEST_TIME |
53 |
4409.55 |
0.9828 |
1.0121 |
1233 |
100 |
TEST_TIME |
54 |
4405.17 |
0.9944 |
1.0063 |
1395 |
100 |
TEST_TIME |
55 |
4411.36 |
0.9867 |
1.0113 |
1222 |
100 |
TEST_TIME |
56 |
4419.59 |
0.9914 |
1.0096 |
1104 |
98 |
TEST_TIME |
57 |
4428.92 |
0.9898 |
1.0091 |
1178 |
100 |
TEST_TIME |
58 |
4433.84 |
0.9949 |
1.0049 |
1114 |
100 |
TEST_TIME |
59 |
4430.14 |
0.9887 |
1.0051 |
1023 |
100 |
TEST_TIME |
60 |
4439.88 |
0.9891 |
1.0097 |
1505 |
99 |
TEST_TIME |
61 |
4435.30 |
0.9941 |
1.0070 |
1524 |
95 |
TEST_TIME |
62 |
4468.66 |
0.9833 |
1.0059 |
1287 |
100 |
TEST_TIME |
63 |
4477.70 |
0.9879 |
1.0062 |
1743 |
100 |
TEST_TIME |
64 |
4471.73 |
0.9918 |
1.0098 |
1580 |
94 |
TEST_TIME |
65 |
4534.14 |
0.9864 |
1.0074 |
1273 |
100 |
TEST_TIME |
66 |
4537.57 |
0.9914 |
1.0055 |
1454 |
100 |
TEST_TIME |
67 |
4536.25 |
0.9908 |
1.0073 |
1345 |
99 |
TEST_TIME |
68 |
4531.58 |
0.9935 |
1.0067 |
1425 |
94 |
TEST_TIME |
69 |
4552.18 |
0.9876 |
1.0045 |
1334 |
98 |
TEST_TIME |
70 |
4534.28 |
0.9941 |
1.0081 |
1283 |
98 |
TEST_TIME |
71 |
4555.04 |
0.9939 |
1.0121 |
1162 |
99 |
TEST_TIME |
72 |
4571.14 |
0.9946 |
1.0107 |
1095 |
99 |
TEST_TIME |
73 |
4580.65 |
0.9948 |
1.0055 |
1280 |
100 |
TEST_TIME |
74 |
4588.49 |
0.9905 |
1.0048 |
1267 |
100 |
TEST_TIME |
75 |
4604.98 |
0.9878 |
1.0075 |
1789 |
100 |
TEST_TIME |
76 |
4615.39 |
0.9920 |
1.0073 |
1897 |
98 |
TEST_TIME |
77 |
4651.28 |
0.9865 |
1.0082 |
1420 |
99 |
TEST_TIME |
78 |
4670.02 |
0.9912 |
1.0050 |
1320 |
100 |
TEST_TIME |
79 |
4675.07 |
0.9914 |
1.0059 |
1631 |
98 |
TEST_TIME |
80 |
4671.04 |
0.9942 |
1.0067 |
1564 |
97 |
TEST_TIME |
81 |
4680.88 |
0.9922 |
1.0074 |
1355 |
98 |
TEST_TIME |
82 |
4688.31 |
0.9936 |
1.0069 |
1402 |
98 |
TEST_TIME |
83 |
4690.87 |
0.9942 |
1.0059 |
1246 |
100 |
TEST_TIME |
84 |
4686.44 |
0.9949 |
1.0042 |
1110 |
99 |
TEST_TIME |
85 |
4685.33 |
0.9926 |
1.0113 |
968 |
100 |
TEST_TIME |
86 |
4703.68 |
0.9957 |
1.0030 |
1162 |
100 |
TEST_TIME |
87 |
4686.44 |
0.9951 |
1.0113 |
1061 |
98 |
TEST_TIME |
88 |
4708.99 |
0.9951 |
1.0033 |
1174 |
99 |
TEST_TIME |
89 |
4705.01 |
0.9928 |
1.0080 |
1134 |
100 |
TEST_TIME |
90 |
4715.05 |
0.9947 |
1.0061 |
1341 |
100 |
TEST_TIME |
91 |
4715.48 |
0.9949 |
1.0053 |
1959 |
99 |
TEST_TIME |
92 |
4722.72 |
0.9929 |
1.0050 |
1490 |
96 |
TEST_TIME |
93 |
4725.93 |
0.9935 |
1.0089 |
1298 |
91 |
TEST_TIME |
94 |
4747.67 |
0.9936 |
1.0067 |
1270 |
99 |
TEST_TIME |
95 |
4776.89 |
0.9900 |
1.0071 |
1156 |
100 |
TEST_TIME |
96 |
4801.96 |
0.9914 |
1.0072 |
1365 |
100 |
TEST_TIME |
97 |
4799.68 |
0.9973 |
1.0038 |
1507 |
97 |
TEST_TIME |
98 |
4796.89 |
0.9941 |
1.0058 |
1391 |
97 |
TEST_TIME |
99 |
4803.13 |
0.9944 |
1.0076 |
1350 |
95 |
TEST_TIME |
100 |
4816.87 |
0.9946 |
1.0082 |
944 |
99 |
TEST_TIME |
101 |
4832.73 |
0.9950 |
1.0031 |
1126 |
100 |
TEST_TIME |
102 |
4827.17 |
0.9944 |
1.0077 |
1024 |
100 |
TEST_TIME |
103 |
4828.28 |
0.9977 |
1.0026 |
1054 |
96 |
TEST_TIME |
104 |
4817.80 |
0.9951 |
1.0086 |
937 |
99 |
TEST_TIME |
105 |
4836.34 |
0.9952 |
1.0073 |
1430 |
100 |
TEST_TIME |
106 |
4866.06 |
0.9917 |
1.0074 |
1379 |
100 |
TEST_TIME |
107 |
4894.15 |
0.9923 |
1.0069 |
1296 |
100 |
TEST_TIME |
108 |
4895.65 |
0.9972 |
1.0088 |
1571 |
98 |
TEST_TIME |
109 |
4913.76 |
0.9959 |
1.0032 |
1446 |
99 |
TEST_TIME |
110 |
4918.43 |
0.9931 |
1.0051 |
1274 |
98 |
TEST_TIME |
111 |
4911.66 |
0.9974 |
1.0027 |
1344 |
89 |
TEST_TIME |
112 |
4905.04 |
0.9951 |
1.0053 |
1157 |
96 |
TEST_TIME |
113 |
4905.79 |
0.9962 |
1.0033 |
1073 |
91 |
TEST_TIME |
114 |
4911.28 |
0.9934 |
1.0031 |
984 |
98 |
TEST_TIME |
115 |
4909.17 |
0.9948 |
1.0022 |
1143 |
100 |
TEST_TIME |
116 |
4894.63 |
0.9965 |
1.0027 |
1193 |
97 |
TEST_TIME |
117 |
4884.34 |
0.9962 |
1.0082 |
1032 |
99 |
TEST_TIME |
118 |
4899.80 |
0.9965 |
1.0052 |
1078 |
99 |
TEST_TIME |
119 |
4913.58 |
0.9940 |
1.0046 |
978 |
100 |
TEST_TIME |
120 |
4923.35 |
0.9942 |
1.0072 |
1437 |
100 |
TEST_TIME |
121 |
4943.29 |
0.9952 |
1.0053 |
1620 |
100 |
TEST_TIME |
122 |
4959.65 |
0.9937 |
1.0059 |
1579 |
100 |
TEST_TIME |
123 |
4988.08 |
0.9923 |
1.0036 |
1546 |
100 |
TEST_TIME |
124 |
4980.62 |
0.9970 |
1.0041 |
1426 |
97 |
TEST_TIME |
125 |
4991.59 |
0.9939 |
1.0027 |
1493 |
96 |
TEST_TIME |
126 |
4993.90 |
0.9943 |
1.0059 |
1236 |
100 |
TEST_TIME |
127 |
5000.66 |
0.9967 |
1.0023 |
1402 |
97 |
TEST_TIME |
128 |
5010.96 |
0.9924 |
1.0058 |
979 |
100 |
TEST_TIME |
129 |
5023.03 |
0.9956 |
1.0041 |
1152 |
98 |
TEST_TIME |
130 |
5019.95 |
0.9972 |
1.0036 |
1196 |
98 |
TEST_TIME |
131 |
5025.00 |
0.9968 |
1.0043 |
1129 |
100 |
TEST_TIME |
132 |
5022.01 |
0.9973 |
1.0021 |
1240 |
97 |
TEST_TIME |
133 |
5012.22 |
0.9965 |
1.0058 |
1048 |
99 |
TEST_TIME |
134 |
5010.18 |
0.9987 |
1.0019 |
1002 |
95 |
TEST_TIME |
135 |
4994.40 |
0.9976 |
1.0026 |
1223 |
92 |
TEST_TIME |
136 |
5001.65 |
0.9938 |
1.0062 |
1523 |
100 |
TEST_TIME |
137 |
5013.53 |
0.9965 |
1.0026 |
1523 |
99 |
TEST_TIME |
138 |
5006.00 |
0.9969 |
1.0038 |
1501 |
95 |
TEST_TIME |
139 |
5007.01 |
0.9964 |
1.0031 |
1462 |
90 |
TEST_TIME |
140 |
5019.66 |
0.9934 |
1.0026 |
1134 |
98 |
TEST_TIME |
141 |
5014.48 |
0.9966 |
1.0042 |
1395 |
99 |
TEST_TIME |
142 |
5009.50 |
0.9982 |
1.0020 |
1409 |
96 |
TEST_TIME |
143 |
5001.28 |
0.9967 |
1.0072 |
977 |
99 |
TEST_TIME |
144 |
5031.62 |
0.9941 |
1.0039 |
1065 |
100 |
TEST_TIME |
145 |
5032.91 |
0.9970 |
1.0018 |
1169 |
98 |
TEST_TIME |
146 |
5049.53 |
0.9916 |
1.0043 |
897 |
100 |
TEST_TIME |
147 |
5054.54 |
0.9965 |
1.0051 |
1154 |
100 |
TEST_TIME |
148 |
5060.09 |
0.9972 |
1.0025 |
1132 |
97 |
TEST_TIME |
149 |
5066.73 |
0.9945 |
1.0016 |
1029 |
100 |
TEST_TIME |
150 |
5052.01 |
0.9978 |
1.0046 |
1123 |
99 |
TEST_TIME |
151 |
5054.28 |
0.9975 |
1.0033 |
1619 |
95 |
TEST_TIME |
152 |
5068.81 |
0.9938 |
1.0048 |
1049 |
100 |
TEST_TIME |
153 |
5078.91 |
0.9963 |
1.0048 |
1126 |
100 |
TEST_TIME |
154 |
5091.04 |
0.9960 |
1.0035 |
1145 |
100 |
TEST_TIME |
155 |
5093.39 |
0.9967 |
1.0021 |
1290 |
97 |
TEST_TIME |
156 |
5088.63 |
0.9966 |
1.0043 |
1174 |
99 |
TEST_TIME |
157 |
5092.49 |
0.9971 |
1.0035 |
1108 |
100 |
TEST_TIME |
158 |
5094.98 |
0.9967 |
1.0043 |
1208 |
100 |
TEST_TIME |
159 |
5099.72 |
0.9970 |
1.0043 |
1052 |
100 |
TEST_TIME |
160 |
5114.40 |
0.9952 |
1.0021 |
1125 |
100 |
TEST_TIME |
161 |
5108.96 |
0.9970 |
1.0032 |
1149 |
99 |
TEST_TIME |
162 |
5104.59 |
0.9979 |
1.0047 |
1068 |
96 |
TEST_TIME |
163 |
5110.84 |
0.9973 |
1.0021 |
963 |
100 |
TEST_TIME |
164 |
5104.56 |
0.9973 |
1.0018 |
1148 |
100 |
TEST_TIME |
165 |
5108.96 |
0.9949 |
1.0034 |
1165 |
100 |
TEST_TIME |
166 |
5111.48 |
0.9969 |
1.0045 |
1487 |
100 |
TEST_TIME |
167 |
5133.13 |
0.9943 |
1.0032 |
1526 |
100 |
TEST_TIME |
168 |
5132.97 |
0.9973 |
1.0025 |
1559 |
95 |
TEST_TIME |
169 |
5141.45 |
0.9949 |
1.0056 |
1220 |
99 |
TEST_TIME |
170 |
5162.73 |
0.9955 |
1.0033 |
1390 |
100 |
TEST_TIME |
171 |
5172.56 |
0.9955 |
1.0039 |
1285 |
100 |
TEST_TIME |
172 |
5173.04 |
0.9980 |
1.0025 |
1396 |
97 |
TEST_TIME |
173 |
5173.30 |
0.9966 |
1.0037 |
964 |
96 |
TEST_TIME |
174 |
5176.15 |
0.9974 |
1.0024 |
592 |
100 |
TEST_TIME |
175 |
5177.33 |
0.9965 |
1.0024 |
900 |
100 |
TEST_TIME |
176 |
5172.98 |
0.9975 |
1.0026 |
979 |
100 |
TEST_TIME |
177 |
5172.54 |
0.9972 |
1.0034 |
942 |
100 |
TEST_TIME |
178 |
5171.43 |
0.9980 |
1.0013 |
947 |
100 |
TEST_TIME |
179 |
5166.54 |
0.9967 |
1.0041 |
817 |
100 |
TEST_TIME |
180 |
5169.58 |
0.9981 |
1.0027 |
990 |
100 |
Done for 9640 ms, from 6:58:01.74 to 6:58:11.38.
TRACED_DATA |
ITRV_NO |
SP_CLIENT_ORDER |
SP_CANCEL_CLIENT_ORDER |
SP_SUPPLIER_ORDER |
SP_CANCEL_SUPPLIER_ORDER |
SP_SUPPLIER_INVOICE |
SP_CANCEL_SUPPLIER_INVOICE |
SP_ADD_INVOICE_TO_STOCK |
SP_CANCEL_ADDING_INVOICE |
SP_CUSTOMER_RESERVE |
SP_CANCEL_CUSTOMER_RESERVE |
SP_RESERVE_WRITE_OFF |
SP_CANCEL_WRITE_OFF |
SP_PAY_FROM_CUSTOMER |
SP_CANCEL_PAY_FROM_CUSTOMER |
SP_PAY_TO_SUPPLIER |
SP_CANCEL_PAY_TO_SUPPLIER |
SRV_MAKE_INVNT_SALDO |
SRV_MAKE_MONEY_SALDO |
SRV_RECALC_IDX_STAT |
ITRV_BEG |
ITRV_END |
fetches per second |
1 |
48630 |
27317 |
52566 |
<null> |
29068 |
141745 |
59498 |
46574 |
53026 |
31550 |
54782 |
73190 |
58927 |
62880 |
66754 |
<null> |
28934 |
26578 |
<null> |
03:46:44 |
04:04:44 |
fetches per second |
2 |
26184 |
36731 |
14048 |
<null> |
22508 |
<null> |
47468 |
<null> |
66408 |
32405 |
26447 |
32773 |
56825 |
117654 |
48554 |
27864 |
104887 |
<null> |
<null> |
04:04:45 |
04:22:45 |
fetches per second |
3 |
24892 |
28483 |
8885 |
<null> |
26271 |
<null> |
19812 |
<null> |
3543 |
<null> |
32854 |
8900 |
31977 |
118125 |
43412 |
7697 |
53193 |
137214 |
<null> |
04:22:46 |
04:40:46 |
fetches per second |
4 |
4016 |
2745 |
6661 |
<null> |
10483 |
<null> |
17875 |
2899 |
4086 |
45273 |
3502 |
2138 |
20183 |
5888 |
5918 |
<null> |
31197 |
<null> |
<null> |
04:40:47 |
04:58:47 |
fetches per second |
5 |
3082 |
3796 |
14302 |
<null> |
14901 |
3098 |
7184 |
67288 |
54742 |
3702 |
15343 |
10904 |
3488 |
19534 |
40877 |
<null> |
16896 |
56454 |
<null> |
04:58:48 |
05:16:48 |
fetches per second |
6 |
10904 |
7004 |
36040 |
<null> |
33076 |
<null> |
17437 |
<null> |
136842 |
<null> |
21394 |
27802 |
34463 |
5875 |
16323 |
1590 |
30779 |
34121 |
<null> |
05:16:49 |
05:34:49 |
fetches per second |
7 |
13127 |
40076 |
8224 |
5921 |
7747 |
<null> |
21463 |
35327 |
14843 |
43512 |
21684 |
2126 |
16845 |
762 |
55654 |
<null> |
8787 |
12074 |
<null> |
05:34:50 |
05:52:50 |
fetches per second |
8 |
8707 |
4257 |
4088 |
<null> |
9233 |
3800 |
12562 |
5668 |
5557 |
4089 |
9608 |
801 |
5337 |
7043 |
48474 |
6316 |
166362 |
143462 |
<null> |
05:52:51 |
06:10:51 |
fetches per second |
9 |
19523 |
4347 |
25530 |
<null> |
25187 |
160515 |
25449 |
2294 |
21650 |
6281 |
35484 |
16356 |
18548 |
7865 |
53166 |
15687 |
<null> |
217105 |
<null> |
06:10:52 |
06:28:52 |
fetches per second |
10 |
16442 |
69213 |
30969 |
104924 |
21075 |
<null> |
46004 |
5382 |
108572 |
<null> |
19750 |
6732 |
53416 |
<null> |
75657 |
1075 |
8873 |
67614 |
<null> |
06:28:53 |
06:46:53 |
marks per second |
1 |
10359 |
3607 |
10655 |
<null> |
6392 |
33000 |
6720 |
8091 |
6497 |
5347 |
8562 |
10965 |
4336 |
7521 |
3547 |
<null> |
875 |
730 |
<null> |
03:46:44 |
04:04:44 |
marks per second |
2 |
5410 |
4338 |
2816 |
<null> |
5021 |
<null> |
7127 |
<null> |
9826 |
4923 |
4371 |
6865 |
3294 |
16536 |
1428 |
4265 |
20013 |
<null> |
<null> |
04:04:45 |
04:22:45 |
marks per second |
3 |
5328 |
3321 |
1905 |
<null> |
5549 |
<null> |
2728 |
<null> |
578 |
<null> |
2696 |
1548 |
2456 |
23375 |
1056 |
990 |
5164 |
4553 |
<null> |
04:22:46 |
04:40:46 |
marks per second |
4 |
841 |
345 |
1293 |
<null> |
1851 |
<null> |
2214 |
413 |
604 |
7967 |
548 |
360 |
956 |
868 |
137 |
<null> |
1118 |
<null> |
<null> |
04:40:47 |
04:58:47 |
marks per second |
5 |
637 |
518 |
2634 |
<null> |
3182 |
689 |
730 |
9010 |
9342 |
536 |
1991 |
1217 |
156 |
2782 |
642 |
<null> |
437 |
1319 |
<null> |
04:58:48 |
05:16:48 |
marks per second |
6 |
2381 |
950 |
7332 |
<null> |
6337 |
<null> |
1848 |
<null> |
10736 |
<null> |
2122 |
4285 |
2606 |
973 |
951 |
230 |
1022 |
387 |
<null> |
05:16:49 |
05:34:49 |
marks per second |
7 |
2623 |
4726 |
1662 |
955 |
1655 |
<null> |
2400 |
5599 |
2081 |
7011 |
3541 |
354 |
706 |
114 |
2566 |
<null> |
371 |
234 |
<null> |
05:34:50 |
05:52:50 |
marks per second |
8 |
1679 |
530 |
538 |
<null> |
1370 |
950 |
1144 |
805 |
406 |
624 |
1083 |
124 |
156 |
1174 |
3303 |
880 |
3563 |
745 |
<null> |
05:52:51 |
06:10:51 |
marks per second |
9 |
3861 |
603 |
4993 |
<null> |
4964 |
43015 |
2608 |
334 |
3186 |
1014 |
2842 |
2349 |
860 |
1175 |
2624 |
3092 |
<null> |
8581 |
<null> |
06:10:52 |
06:28:52 |
marks per second |
10 |
3310 |
8744 |
6224 |
25714 |
4726 |
<null> |
5531 |
747 |
16464 |
<null> |
1607 |
1103 |
2124 |
<null> |
4352 |
176 |
1149 |
3090 |
<null> |
06:28:53 |
06:46:53 |
reads/fetches*100 |
1 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
03:46:44 |
04:04:44 |
reads/fetches*100 |
2 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
04:04:45 |
04:22:45 |
reads/fetches*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:22:46 |
04:40:46 |
reads/fetches*100 |
4 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
<null> |
04:40:47 |
04:58:47 |
reads/fetches*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
04:58:48 |
05:16:48 |
reads/fetches*100 |
6 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:16:49 |
05:34:49 |
reads/fetches*100 |
7 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
05:34:50 |
05:52:50 |
reads/fetches*100 |
8 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:52:51 |
06:10:51 |
reads/fetches*100 |
9 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
06:10:52 |
06:28:52 |
reads/fetches*100 |
10 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
<null> |
06:28:53 |
06:46:53 |
writes/marks*100 |
1 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
03:46:44 |
04:04:44 |
writes/marks*100 |
2 |
0 |
1 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
<null> |
<null> |
04:04:45 |
04:22:45 |
writes/marks*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
1 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
3 |
0 |
<null> |
04:22:46 |
04:40:46 |
writes/marks*100 |
4 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
1 |
0 |
<null> |
3 |
<null> |
<null> |
04:40:47 |
04:58:47 |
writes/marks*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
<null> |
8 |
0 |
<null> |
04:58:48 |
05:16:48 |
writes/marks*100 |
6 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
3 |
0 |
<null> |
05:16:49 |
05:34:49 |
writes/marks*100 |
7 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
<null> |
3 |
0 |
<null> |
05:34:50 |
05:52:50 |
writes/marks*100 |
8 |
1 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
5 |
0 |
<null> |
05:52:51 |
06:10:51 |
writes/marks*100 |
9 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
06:10:52 |
06:28:52 |
writes/marks*100 |
10 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
2 |
0 |
<null> |
06:28:53 |
06:46:53 |
Done for 8240 ms, from 6:58:12.36 to 6:58:20.60.
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 |
1619268 |
1511180 |
108088 |
6.67 |
0 |
9812 |
72 |
108088 |
2017-08-24 03:46 |
2017-08-24 06:46 |
doc_list_biud |
1619644 |
1511180 |
108464 |
6.69 |
0 |
6896 |
21 |
108464 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_add_invoice_to_stock |
17048 |
10373 |
6675 |
39.15 |
15 |
155595 |
15138 |
6675 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_cancel_adding_invoice |
3808 |
2955 |
853 |
22.40 |
0 |
81713 |
3310 |
853 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_cancel_client_order |
5842 |
5733 |
109 |
1.86 |
0 |
4274 |
308 |
109 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_cancel_customer_reserve |
263623 |
164916 |
98707 |
37.44 |
0 |
4431 |
86 |
98707 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_cancel_pay_from_customer |
2144 |
2133 |
11 |
0.51 |
0 |
3229 |
177 |
11 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_cancel_pay_to_supplier |
1388 |
1387 |
1 |
0.07 |
0 |
2777 |
177 |
1 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_cancel_supplier_invoice |
8868 |
6988 |
1880 |
21.19 |
0 |
7442 |
543 |
1880 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_cancel_supplier_order |
1386 |
471 |
915 |
66.01 |
15 |
225093 |
26388 |
915 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_cancel_write_off |
21761 |
14115 |
7646 |
35.13 |
0 |
3931 |
212 |
7646 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_client_order |
70931 |
70931 |
0 |
0.00 |
0 |
5288 |
594 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_customer_reserve |
536505 |
536505 |
0 |
0.00 |
0 |
11388 |
245 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_fill_shopping_cart |
107497 |
107258 |
239 |
0.22 |
0 |
4259 |
115 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_fill_shopping_cart_clo_res |
536505 |
536505 |
0 |
0.00 |
0 |
3666 |
17 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_get_clo_for_invoice |
10373 |
10373 |
0 |
0.00 |
0 |
6614 |
388 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_kill_cost_storno |
28742 |
20590 |
8152 |
28.36 |
0 |
2637 |
27 |
8152 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_kill_qstorno_ret_qs2qd |
557601 |
351406 |
206195 |
36.97 |
0 |
6848 |
34 |
206195 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_kill_qty_storno |
346552 |
238167 |
108385 |
31.27 |
0 |
6880 |
98 |
108385 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_lock_selected_doc |
70055 |
60268 |
9787 |
13.97 |
0 |
1825 |
9 |
9787 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_make_cost_storno |
86414 |
86414 |
0 |
0.00 |
0 |
9375 |
683 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_multiply_rows_for_pdistr |
86414 |
86414 |
0 |
0.00 |
0 |
3120 |
77 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_multiply_rows_for_qdistr |
70931 |
70931 |
0 |
0.00 |
0 |
3916 |
197 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_pay_from_customer |
23756 |
23756 |
0 |
0.00 |
0 |
8330 |
1027 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_pay_to_supplier |
19669 |
19669 |
0 |
0.00 |
0 |
10983 |
1647 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_payment_common |
43425 |
43425 |
0 |
0.00 |
0 |
2200 |
78 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_qd_handle_on_cancel_clo |
5836 |
5733 |
103 |
1.76 |
0 |
4009 |
140 |
103 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_qd_handle_on_invoice_upd_sts |
14024 |
13328 |
696 |
4.96 |
0 |
5351 |
425 |
696 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_qd_handle_on_reserve_upd_sts |
32616 |
32616 |
0 |
0.00 |
0 |
2402 |
72 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_reserve_write_off |
33848 |
32616 |
1232 |
3.63 |
0 |
9859 |
690 |
1232 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_supplier_invoice |
18399 |
18310 |
89 |
0.48 |
0 |
34882 |
3938 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
sp_supplier_order |
18167 |
18017 |
150 |
0.82 |
0 |
13479 |
2609 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
srv_find_qd_qs_mism |
959321 |
851201 |
108120 |
11.27 |
0 |
4617 |
34 |
108120 |
2017-08-24 03:46 |
2017-08-24 06:46 |
srv_make_invnt_saldo |
1359 |
1359 |
0 |
0.00 |
16 |
118732 |
4040 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
srv_make_money_saldo |
2809 |
2809 |
0 |
0.00 |
0 |
2059 |
78 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
1826 |
46737 |
21656 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-abend:sp_add_invoice_to_stock |
6675 |
6675 |
0 |
0.00 |
0 |
2277 |
121 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-abend:sp_cancel_adding_invoice |
598 |
598 |
0 |
0.00 |
0 |
2902 |
207 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-abend:sp_cancel_client_order |
109 |
109 |
0 |
0.00 |
0 |
874 |
93 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-abend:sp_cancel_customer_reserve |
75 |
75 |
0 |
0.00 |
0 |
546 |
88 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-abend:sp_cancel_pay_from_customer |
11 |
11 |
0 |
0.00 |
0 |
858 |
140 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-abend:sp_cancel_pay_to_supplier |
1 |
1 |
0 |
0.00 |
140 |
140 |
140 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-abend:sp_cancel_supplier_invoice |
527 |
527 |
0 |
0.00 |
0 |
1700 |
123 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-abend:sp_cancel_supplier_order |
12484 |
12484 |
0 |
0.00 |
0 |
4275 |
133 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-abend:sp_cancel_write_off |
27 |
27 |
0 |
0.00 |
0 |
1326 |
140 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-abend:sp_reserve_write_off |
1232 |
1232 |
0 |
0.00 |
0 |
2308 |
98 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-abend:sp_supplier_invoice |
89 |
89 |
0 |
0.00 |
0 |
1701 |
144 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-abend:sp_supplier_order |
150 |
150 |
0 |
0.00 |
0 |
2542 |
135 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-norm:sp_add_invoice_to_stock |
10373 |
10373 |
0 |
0.00 |
0 |
13744 |
710 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-norm:sp_cancel_adding_invoice |
1120 |
1120 |
0 |
0.00 |
0 |
12262 |
878 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-norm:sp_cancel_client_order |
5733 |
5733 |
0 |
0.00 |
0 |
2621 |
91 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-norm:sp_cancel_customer_reserve |
2277 |
2277 |
0 |
0.00 |
0 |
2137 |
93 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-norm:sp_cancel_pay_from_customer |
2133 |
2133 |
0 |
0.00 |
0 |
1731 |
76 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-norm:sp_cancel_pay_to_supplier |
1387 |
1387 |
0 |
0.00 |
0 |
1826 |
68 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-norm:sp_cancel_supplier_invoice |
843 |
843 |
0 |
0.00 |
0 |
1857 |
96 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-norm:sp_cancel_supplier_order |
471 |
471 |
0 |
0.00 |
0 |
37986 |
1889 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-norm:sp_cancel_write_off |
3315 |
3315 |
0 |
0.00 |
0 |
2340 |
90 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-norm:sp_client_order |
70931 |
70931 |
0 |
0.00 |
0 |
4524 |
103 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-norm:sp_customer_reserve |
3407 |
3407 |
0 |
0.00 |
0 |
2481 |
73 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-norm:sp_pay_from_customer |
23756 |
23756 |
0 |
0.00 |
0 |
2715 |
90 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-norm:sp_pay_to_supplier |
19669 |
19669 |
0 |
0.00 |
0 |
2543 |
94 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-norm:sp_reserve_write_off |
32616 |
32616 |
0 |
0.00 |
0 |
4633 |
99 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-norm:sp_supplier_invoice |
18310 |
18310 |
0 |
0.00 |
0 |
4649 |
96 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-norm:sp_supplier_order |
18017 |
18017 |
0 |
0.00 |
0 |
3385 |
100 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-norm:srv_make_invnt_saldo |
1359 |
1359 |
0 |
0.00 |
0 |
967 |
35 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-norm:srv_make_money_saldo |
2809 |
2809 |
0 |
0.00 |
0 |
905 |
36 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
t$perf-norm:srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
0 |
890 |
195 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
v_add_invoice_to_stock |
34096 |
20746 |
13350 |
39.15 |
0 |
1856 |
21 |
13350 |
2017-08-24 03:46 |
2017-08-24 06:46 |
v_all_customers |
106472 |
106472 |
0 |
0.00 |
0 |
1342 |
7 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
v_all_suppliers |
73132 |
72654 |
478 |
0.65 |
0 |
1357 |
7 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
v_all_wares |
141862 |
141862 |
0 |
0.00 |
0 |
998 |
5 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
v_cancel_adding_invoice |
2670 |
2240 |
430 |
16.10 |
0 |
3510 |
165 |
430 |
2017-08-24 03:46 |
2017-08-24 06:46 |
v_cancel_client_order |
11684 |
11466 |
218 |
1.86 |
0 |
1404 |
8 |
218 |
2017-08-24 03:46 |
2017-08-24 06:46 |
v_cancel_customer_prepayment |
4288 |
4266 |
22 |
0.51 |
0 |
1170 |
10 |
22 |
2017-08-24 03:46 |
2017-08-24 06:46 |
v_cancel_customer_reserve |
4704 |
4554 |
150 |
3.18 |
0 |
1202 |
12 |
150 |
2017-08-24 03:46 |
2017-08-24 06:46 |
v_cancel_payment_to_supplier |
2776 |
2774 |
2 |
0.07 |
0 |
874 |
13 |
2 |
2017-08-24 03:46 |
2017-08-24 06:46 |
v_cancel_supplier_invoice |
2740 |
1686 |
1054 |
38.46 |
0 |
1076 |
20 |
1054 |
2017-08-24 03:46 |
2017-08-24 06:46 |
v_cancel_supplier_order |
2772 |
942 |
1830 |
66.01 |
0 |
546 |
10 |
1830 |
2017-08-24 03:46 |
2017-08-24 06:46 |
v_cancel_write_off |
6684 |
6630 |
54 |
0.80 |
0 |
2824 |
107 |
54 |
2017-08-24 03:46 |
2017-08-24 06:46 |
v_max_id_clo_ord |
18167 |
18017 |
150 |
0.82 |
0 |
718 |
7 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
v_max_id_clo_res |
3407 |
3407 |
0 |
0.00 |
0 |
1046 |
21 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
v_max_id_ord_sup |
18399 |
18310 |
89 |
0.48 |
0 |
874 |
7 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
v_max_non_paid_invoice |
19669 |
19669 |
0 |
0.00 |
0 |
1700 |
7 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
v_max_non_paid_realizn |
23756 |
23756 |
0 |
0.00 |
0 |
1310 |
8 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
v_min_id_clo_ord |
18167 |
18017 |
150 |
0.82 |
0 |
1232 |
9 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
v_min_id_clo_res |
3407 |
3407 |
0 |
0.00 |
0 |
2324 |
11 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
v_min_id_ord_sup |
18399 |
18310 |
89 |
0.48 |
0 |
1763 |
10 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
v_min_non_paid_invoice |
19669 |
19669 |
0 |
0.00 |
0 |
1919 |
13 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
v_min_non_paid_realizn |
23756 |
23756 |
0 |
0.00 |
0 |
1701 |
12 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
v_our_firm |
35390 |
35390 |
0 |
0.00 |
0 |
1217 |
7 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
v_reserve_write_off |
67696 |
65232 |
2464 |
3.63 |
0 |
1888 |
10 |
2464 |
2017-08-24 03:46 |
2017-08-24 06:46 |
x_lock_depdocs_on_canc_invoice |
16329 |
9100 |
7229 |
44.27 |
0 |
2465 |
38 |
7229 |
2017-08-24 03:46 |
2017-08-24 06:46 |
x_lock_depdocs_on_canc_sup_ord |
1385 |
471 |
914 |
65.99 |
0 |
2247 |
84 |
914 |
2017-08-24 03:46 |
2017-08-24 06:46 |
x_make_qstorno_1000_1200 |
18167 |
18017 |
150 |
0.82 |
0 |
12932 |
2354 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
x_make_qstorno_1200_2000 |
18399 |
18310 |
89 |
0.48 |
0 |
34757 |
3675 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
x_make_qstorno_2100_3300 |
536505 |
536505 |
0 |
0.00 |
0 |
11372 |
207 |
0 |
2017-08-24 03:46 |
2017-08-24 06:46 |
Done for 301110 ms, from 7:02:48.11 to 7:07:49.22.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
DTS_BEG |
DTS_END |
deadlock |
75 |
sp_kill_cost_storno |
335544336 |
2017-08-24 03:47 |
2017-08-24 06:43 |
deadlock |
70 |
sp_kill_qstorno_ret_qs2qd |
335544336 |
2017-08-24 03:48 |
2017-08-24 06:45 |
deadlock |
8557 |
sp_lock_selected_doc |
335544336 |
2017-08-24 03:46 |
2017-08-24 06:46 |
deadlock |
103 |
sp_qd_handle_on_cancel_clo |
335544336 |
2017-08-24 03:50 |
2017-08-24 06:41 |
deadlock |
151 |
sp_qd_handle_on_invoice_upd_sts |
335544336 |
2017-08-24 03:47 |
2017-08-24 06:46 |
deadlock |
572 |
x_lock_depdocs_on_canc_invoice |
335544336 |
2017-08-24 03:46 |
2017-08-24 06:46 |
deadlock |
252 |
x_lock_depdocs_on_canc_sup_ord |
335544336 |
2017-08-24 03:52 |
2017-08-24 06:41 |
user_exc |
150 |
x_make_qstorno_1000_1200 |
335544517 |
2017-08-24 03:47 |
2017-08-24 06:45 |
user_exc |
89 |
x_make_qstorno_1200_2000 |
335544517 |
2017-08-24 03:46 |
2017-08-24 06:38 |
Done for 7910 ms, from 7:07:53.66 to 7:08:01.57.
MON$DATABASE_NAME D:\OLTP-EMUL\OLTP30-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 395561
MON$OLDEST_ACTIVE 395562
MON$OLDEST_SNAPSHOT 395562
MON$NEXT_TRANSACTION 395562
MON$PAGE_BUFFERS 786432
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2017-01-11 15:12:20.4040
MON$PAGES 721536
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-V3.0.3.32798 Firebird 3.0
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.3.32798 Firebird 3.0"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.3.32798 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.3.32798 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
on disk structure version 12.0
Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB"
Database header page information:
Flags 0
Generation 395734
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 395563
Oldest active 395564
Oldest snapshot 395564
Next transaction 395565
Sequence number 0
Next attachment ID 9399
Implementation HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jan 11, 2017 15:12:20
Attributes force write
Variable header data:
Sweep interval: 0
*END*
Database file sequence:
File D:\OLTP-EMUL\OLTP30-SMALL.FDB is the only file
Analyzing database pages ...
AGENTS (154)
Primary pointer page: 311, Index root page: 312
Total formats: 1, used formats: 1
Average record length: 33.58, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 344.00, compression ratio: 10.24
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_ID_DESC (2)
Root page: 322, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_OUR_FIRM (4)
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 48
Average key length: 2.04, compression ratio: 0.50
Average prefix length: 0.96, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_SUPPLIER (3)
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 44
Average key length: 2.04, compression ratio: 0.54
Average prefix length: 1.04, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_NAME_UNQ (1)
Root page: 321, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.16, total dup: 0, max dup: 0
Average key length: 15.86, compression ratio: 0.92
Average prefix length: 1.44, average data length: 13.16
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_AGENTS (0)
Root page: 320, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BUSINESS_OPS (158)
Primary pointer page: 332, Index root page: 333
Total formats: 1, used formats: 1
Average record length: 107.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1236.00, compression ratio: 11.55
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 29%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BO_UNIT_UNQ (1)
Root page: 336, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 18.00, total dup: 0, max dup: 0
Average key length: 16.95, compression ratio: 1.25
Average prefix length: 7.21, average data length: 14.00
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BUSINESS_OPS_RND_WGTH (2)
Root page: 337, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 4.05, total dup: 7, max dup: 3
Average key length: 3.00, compression ratio: 0.75
Average prefix length: 1.42, average data length: 0.84
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$1 (0)
Root page: 335, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 5.26, total dup: 0, max dup: 0
Average key length: 4.21, compression ratio: 0.64
Average prefix length: 1.05, average data length: 1.63
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DOC_DATA (141)
Primary pointer page: 251, Index root page: 252
Total formats: 1, used formats: 1
Average record length: 47.02, total records: 1951856
Average version length: 47.63, total versions: 1793, 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: 13, data page slots: 21064
Data pages: 21064, average fill: 73%
Primary pages: 21064, secondary pages: 0, swept pages: 12758
Empty pages: 3, full pages: 19173
Fill distribution:
0 - 19% = 4
20 - 39% = 1
40 - 59% = 50
60 - 79% = 21008
80 - 99% = 1
Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26189, depth: 3, leaf buckets: 9414, nodes: 1951856
Average node length: 19.26, total dup: 0, max dup: 0
Average key length: 16.31, compression ratio: 1.66
Average prefix length: 13.69, average data length: 13.31
Clustering factor: 426933, ratio: 0.22
Fill distribution:
0 - 19% = 614
20 - 39% = 2080
40 - 59% = 4524
60 - 79% = 762
80 - 99% = 1434
Index DOC_DATA_ID_DESC (2)
Root page: 45719, depth: 3, leaf buckets: 7021, nodes: 1951856
Average node length: 11.66, total dup: 0, max dup: 0
Average key length: 8.71, compression ratio: 1.03
Average prefix length: 3.29, average data length: 5.71
Clustering factor: 401410, ratio: 0.21
Fill distribution:
0 - 19% = 1
20 - 39% = 3346
40 - 59% = 3618
60 - 79% = 49
80 - 99% = 7
Index FK_DOC_DATA_DOC_LIST (3)
Root page: 169058, depth: 3, leaf buckets: 3404, nodes: 1951856
Average node length: 6.79, total dup: 1431242, max dup: 49
Average key length: 3.84, compression ratio: 2.34
Average prefix length: 7.43, average data length: 1.57
Clustering factor: 391915, ratio: 0.20
Fill distribution:
0 - 19% = 132
20 - 39% = 1198
40 - 59% = 1372
60 - 79% = 152
80 - 99% = 550
DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 60.27, total records: 580945
Average version length: 35.84, total versions: 752, max versions: 3
Average fragment length: 51.50, total fragments: 2, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 5, data page slots: 7344
Data pages: 7344, average fill: 75%
Primary pages: 7342, secondary pages: 2, swept pages: 6710
Empty pages: 7, full pages: 6899
Fill distribution:
0 - 19% = 10
20 - 39% = 3
40 - 59% = 15
60 - 79% = 7305
80 - 99% = 11
Index DOC_LIST_ID_DESC (1)
Root page: 253893, depth: 3, leaf buckets: 2171, nodes: 580945
Average node length: 11.70, total dup: 0, max dup: 0
Average key length: 8.84, compression ratio: 1.02
Average prefix length: 3.15, average data length: 5.85
Clustering factor: 140983, ratio: 0.24
Fill distribution:
0 - 19% = 0
20 - 39% = 1301
40 - 59% = 847
60 - 79% = 21
80 - 99% = 2
Index FK_DOC_LIST_AGENTS (2)
Root page: 2807, depth: 2, leaf buckets: 604, nodes: 580945
Average node length: 4.86, total dup: 580895, max dup: 43437
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 262900, ratio: 0.45
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 516
60 - 79% = 67
80 - 99% = 20
Index PK_DOC_LIST (0)
Root page: 317533, depth: 3, leaf buckets: 1768, nodes: 580945
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.84, compression ratio: 1.02
Average prefix length: 3.15, average data length: 5.85
Clustering factor: 140983, ratio: 0.24
Fill distribution:
0 - 19% = 121
20 - 39% = 690
40 - 59% = 505
60 - 79% = 170
80 - 99% = 282
DOC_STATES (153)
Primary pointer page: 309, Index root page: 310
Total formats: 1, used formats: 1
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 650.00, compression ratio: 9.63
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_MCODE_UNQ (1)
Root page: 318, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 17.75, total dup: 0, max dup: 0
Average key length: 16.50, compression ratio: 1.08
Average prefix length: 4.00, average data length: 13.75
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_NAME_UNQ (2)
Root page: 319, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 33.25, total dup: 0, max dup: 0
Average key length: 32.00, compression ratio: 0.99
Average prefix length: 2.50, average data length: 29.25
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_DOC_STATES (0)
Root page: 317, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 4.75, total dup: 0, max dup: 0
Average key length: 3.50, compression ratio: 0.86
Average prefix length: 1.50, average data length: 1.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
FB_ERRORS (159)
Primary pointer page: 338, Index root page: 339
Total formats: 1, used formats: 1
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 148.00, compression ratio: 1.86
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 56%
Primary pages: 16, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 11
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7
Index FB_ERRORS_GDS_CODE (0)
Root page: 340, depth: 1, leaf buckets: 1, nodes: 758
Average node length: 4.24, total dup: 0, max dup: 0
Average key length: 3.04, compression ratio: 1.64
Average prefix length: 3.97, average data length: 1.03
Clustering factor: 353, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
INVNT_SALDO (147)
Primary pointer page: 270, Index root page: 271
Total formats: 1, used formats: 1
Average record length: 63.99, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 17.21, total fragments: 358, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.63
Pointer pages: 1, data page slots: 96
Data pages: 28, average fill: 23%
Primary pages: 4, secondary pages: 24, swept pages: 4
Empty pages: 13, full pages: 3
Fill distribution:
0 - 19% = 16
20 - 39% = 6
40 - 59% = 2
60 - 79% = 1
80 - 99% = 3
Index PK_INVNT_SALDO (0)
Root page: 282, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 292, ratio: 0.73
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
INVNT_TURNOVER_LOG (157)
Primary pointer page: 330, Index root page: 331
Total formats: 1, used formats: 1
Average record length: 22.58, total records: 7952
Average version length: 70.54, total versions: 5433, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 4.25
Pointer pages: 1, data page slots: 536
Data pages: 376, average fill: 29%
Primary pages: 375, secondary pages: 1, swept pages: 105
Empty pages: 84, full pages: 40
Fill distribution:
0 - 19% = 182
20 - 39% = 76
40 - 59% = 54
60 - 79% = 57
80 - 99% = 7
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1845, depth: 2, leaf buckets: 33, nodes: 7952
Average node length: 13.92, total dup: 725, max dup: 1
Average key length: 11.94, compression ratio: 2.26
Average prefix length: 17.96, average data length: 9.04
Clustering factor: 5632, ratio: 0.71
Fill distribution:
0 - 19% = 1
20 - 39% = 18
40 - 59% = 10
60 - 79% = 1
80 - 99% = 3
MONEY_SALDO (143)
Primary pointer page: 262, Index root page: 263
Total formats: 1, used formats: 1
Average record length: 14.86, total records: 49
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 2.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 19%
Primary pages: 1, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MONEY_SALDO (0)
Root page: 273, depth: 1, leaf buckets: 1, nodes: 49
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MONEY_TURNOVER_LOG (142)
Primary pointer page: 260, Index root page: 261
Total formats: 1, used formats: 1
Average record length: 7.50, total records: 278
Average version length: 46.68, total versions: 233, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 8.53
Pointer pages: 1, data page slots: 24
Data pages: 24, average fill: 13%
Primary pages: 22, secondary pages: 2, swept pages: 8
Empty pages: 12, full pages: 1
Fill distribution:
0 - 19% = 18
20 - 39% = 3
40 - 59% = 1
60 - 79% = 2
80 - 99% = 0
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 225656, depth: 2, leaf buckets: 1, nodes: 278
Average node length: 6.44, total dup: 217, max dup: 30
Average key length: 5.11, compression ratio: 3.72
Average prefix length: 16.11, average data length: 2.89
Clustering factor: 160, ratio: 0.58
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG (165)
Primary pointer page: 354, Index root page: 355
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_DTS (4)
Root page: 365, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_GDSCODE (2)
Root page: 363, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_ROWSET_DESC (1)
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_UNIT (3)
Root page: 364, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG (0)
Root page: 361, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG_TABLE_STATS (166)
Primary pointer page: 366, Index root page: 367
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_DTS (4)
Root page: 373, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_GDSCODE (2)
Root page: 371, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_ROWSET (1)
Root page: 370, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_TN_UNIT (3)
Root page: 372, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG_TABLE_STATS (0)
Root page: 369, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
OPTYPES (138)
Primary pointer page: 239, Index root page: 240
Total formats: 1, used formats: 1
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 5.54
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 9%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OPTYPES_MCODE_UNQ (1)
Root page: 242, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 8.56, total dup: 0, max dup: 0
Average key length: 6.89, compression ratio: 0.73
Average prefix length: 0.44, average data length: 4.56
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_OPTYPES (0)
Root page: 241, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 6.11, total dup: 0, max dup: 0
Average key length: 5.00, compression ratio: 0.60
Average prefix length: 0.89, average data length: 2.11
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PDISTR (150)
Primary pointer page: 293, Index root page: 294
Total formats: 1, used formats: 1
Average record length: 42.21, total records: 209398
Average version length: 30.52, total versions: 2323, max versions: 9
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.52
Pointer pages: 2, data page slots: 2240
Data pages: 2240, average fill: 69%
Primary pages: 2237, secondary pages: 3, swept pages: 1725
Empty pages: 8, full pages: 880
Fill distribution:
0 - 19% = 11
20 - 39% = 16
40 - 59% = 75
60 - 79% = 2132
80 - 99% = 6
Index PDISTR_AGENT_ID (4)
Root page: 5420, depth: 2, leaf buckets: 187, nodes: 209398
Average node length: 4.50, total dup: 209349, max dup: 9184
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 38340, ratio: 0.18
Fill distribution:
0 - 19% = 0
20 - 39% = 16
40 - 59% = 75
60 - 79% = 63
80 - 99% = 33
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4740, depth: 2, leaf buckets: 231, nodes: 209398
Average node length: 5.45, total dup: 188898, max dup: 49
Average key length: 2.95, compression ratio: 7.45
Average prefix length: 21.14, average data length: 0.86
Clustering factor: 50446, ratio: 0.24
Fill distribution:
0 - 19% = 0
20 - 39% = 25
40 - 59% = 92
60 - 79% = 69
80 - 99% = 45
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 4730, depth: 2, leaf buckets: 232, nodes: 209398
Average node length: 5.45, total dup: 188898, max dup: 49
Average key length: 2.95, compression ratio: 7.45
Average prefix length: 21.14, average data length: 0.86
Clustering factor: 50463, ratio: 0.24
Fill distribution:
0 - 19% = 1
20 - 39% = 28
40 - 59% = 85
60 - 79% = 80
80 - 99% = 38
Index PDISTR_SND_ID (1)
Root page: 4894, depth: 2, leaf buckets: 244, nodes: 209398
Average node length: 5.24, total dup: 188898, max dup: 49
Average key length: 2.74, compression ratio: 3.28
Average prefix length: 8.35, average data length: 0.65
Clustering factor: 50474, ratio: 0.24
Fill distribution:
0 - 19% = 0
20 - 39% = 37
40 - 59% = 118
60 - 79% = 70
80 - 99% = 19
PERF_ESTIMATED (160)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 27.97, total records: 236418
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: 2024
Data pages: 2024, average fill: 64%
Primary pages: 2024, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 2019
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 1
60 - 79% = 2019
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 711900, depth: 2, leaf buckets: 185, nodes: 236418
Average node length: 4.46, total dup: 236237, max dup: 1958
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.58, average data length: 0.00
Clustering factor: 22730, ratio: 0.10
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 51
60 - 79% = 81
80 - 99% = 52
PERF_ISQL_STAT (161)
Primary pointer page: 344, Index root page: 345
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PERF_ISQL_STAT_TRN (0)
Root page: 346, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PERF_LOG (163)
Primary pointer page: 350, Index root page: 351
Total formats: 1, used formats: 1
Average record length: 151.48, total records: 10141738
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.20
Pointer pages: 148, data page slots: 240320
Data pages: 240320, average fill: 87%
Primary pages: 240320, secondary pages: 0, swept pages: 3
Empty pages: 5, full pages: 240314
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 240315
Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 64458, depth: 3, leaf buckets: 11205, nodes: 10141738
Average node length: 5.61, total dup: 9292756, max dup: 147
Average key length: 2.20, compression ratio: 3.63
Average prefix length: 7.85, average data length: 0.15
Clustering factor: 4095090, ratio: 0.40
Fill distribution:
0 - 19% = 8
20 - 39% = 0
40 - 59% = 6004
60 - 79% = 3438
80 - 99% = 1755
Index PERF_LOG_GDSCODE (3)
Root page: 163628, depth: 3, leaf buckets: 9867, nodes: 10141738
Average node length: 4.49, total dup: 10141734, max dup: 9336291
Average key length: 1.08, compression ratio: 0.37
Average prefix length: 0.40, average data length: 0.00
Clustering factor: 297471, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 9863
60 - 79% = 1
80 - 99% = 2
Index PERF_LOG_TRN_DESC (2)
Root page: 43655, depth: 3, leaf buckets: 12094, nodes: 10141738
Average node length: 5.65, total dup: 9808193, max dup: 22307
Average key length: 2.24, compression ratio: 4.01
Average prefix length: 8.79, average data length: 0.21
Clustering factor: 877261, ratio: 0.09
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 8779
60 - 79% = 1803
80 - 99% = 1509
Index PERF_LOG_UNIT (1)
Root page: 77766, depth: 3, leaf buckets: 12082, nodes: 10141738
Average node length: 5.49, total dup: 10110664, max dup: 1277493
Average key length: 2.08, compression ratio: 18.19
Average prefix length: 37.70, average data length: 0.07
Clustering factor: 5978472, ratio: 0.59
Fill distribution:
0 - 19% = 16
20 - 39% = 3
40 - 59% = 10228
60 - 79% = 586
80 - 99% = 1249
PHRASES (145)
Primary pointer page: 266, Index root page: 267
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_ID_DESC (3)
Root page: 280, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_NAME (2)
Root page: 279, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_UNQ (1)
Root page: 278, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_PHRASES (0)
Root page: 277, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PSTORNED (151)
Primary pointer page: 301, Index root page: 302
Total formats: 1, used formats: 1
Average record length: 54.91, total records: 393389
Average version length: 55.02, total versions: 550, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.46
Pointer pages: 3, data page slots: 4656
Data pages: 4656, average fill: 75%
Primary pages: 4656, secondary pages: 0, swept pages: 3483
Empty pages: 7, full pages: 4479
Fill distribution:
0 - 19% = 7
20 - 39% = 0
40 - 59% = 11
60 - 79% = 4635
80 - 99% = 3
Index PSTORNED_RCV_ID (2)
Root page: 660503, depth: 3, leaf buckets: 536, nodes: 393389
Average node length: 5.96, total dup: 328213, max dup: 425
Average key length: 3.20, compression ratio: 2.81
Average prefix length: 7.96, average data length: 1.04
Clustering factor: 51597, ratio: 0.13
Fill distribution:
0 - 19% = 15
20 - 39% = 24
40 - 59% = 362
60 - 79% = 100
80 - 99% = 35
Index PSTORNED_SND_ID (1)
Root page: 2157, depth: 2, leaf buckets: 423, nodes: 393389
Average node length: 5.57, total dup: 350746, max dup: 114
Average key length: 2.82, compression ratio: 3.20
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 97063, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 7
40 - 59% = 187
60 - 79% = 150
80 - 99% = 78
RULES_FOR_PDISTR (152)
Primary pointer page: 303, Index root page: 304
Total formats: 1, used formats: 1
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 336.00, compression ratio: 18.67
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 2%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_PDISTR_UNQ (0)
Root page: 308, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 11.50, total dup: 0, max dup: 0
Average key length: 10.25, compression ratio: 0.88
Average prefix length: 1.50, average data length: 7.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RULES_FOR_QDISTR (139)
Primary pointer page: 243, Index root page: 244
Total formats: 1, used formats: 1
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 332.00, compression ratio: 10.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_RCVOP (1)
Root page: 246, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 5.29, total dup: 2, max dup: 2
Average key length: 4.14, compression ratio: 0.72
Average prefix length: 1.43, average data length: 1.57
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_UNQ (0)
Root page: 245, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 10.14, total dup: 0, max dup: 0
Average key length: 8.86, compression ratio: 0.94
Average prefix length: 2.14, average data length: 6.14
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SEMAPHORES (156)
Primary pointer page: 315, Index root page: 316
Total formats: 1, used formats: 1
Average record length: 34.25, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 338.00, compression ratio: 9.87
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 3%
Primary pages: 1, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_SEMAPHORES (0)
Root page: 327, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 12.50, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.50, average data length: 8.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SEMAPHORES_TASK_UNQ (1)
Root page: 328, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 22.50, total dup: 0, max dup: 0
Average key length: 21.00, compression ratio: 1.07
Average prefix length: 4.00, average data length: 18.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SETTINGS (137)
Primary pointer page: 236, Index root page: 237
Total formats: 1, used formats: 1
Average record length: 98.31, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1347.00, compression ratio: 13.70
Pointer pages: 1, data page slots: 2
Data pages: 2, average fill: 80%
Primary pages: 2, secondary pages: 0, swept pages: 2
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1
Index SETTINGS_MODE_CODE (0)
Root page: 238, depth: 1, leaf buckets: 1, nodes: 114
Average node length: 27.11, total dup: 0, max dup: 0
Average key length: 26.10, compression ratio: 1.70
Average prefix length: 21.18, average data length: 23.11
Clustering factor: 6, ratio: 0.05
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$RAND$CALLS (136)
Primary pointer page: 234, Index root page: 235
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$SOURCE (135)
Primary pointer page: 232, Index root page: 233
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$DEP_DOCS (129)
Primary pointer page: 198, Index root page: 199
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_DEP_DOCS_UNQ (0)
Root page: 200, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$IDX_RECALC (132)
Primary pointer page: 207, Index root page: 224
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0)
Root page: 226, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG (133)
Primary pointer page: 227, Index root page: 228
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG_TABLE_STATS (134)
Primary pointer page: 230, Index root page: 231
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_LOG (164)
Primary pointer page: 352, Index root page: 353
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Root page: 360, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_MON (131)
Primary pointer page: 205, Index root page: 206
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$RESULT_SET (130)
Primary pointer page: 201, Index root page: 202
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_DOC (1)
Root page: 204, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_WARE_DOC (0)
Root page: 203, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$SHOPPING_CART (128)
Primary pointer page: 193, Index root page: 194
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_SHOPCART_UNQ (0)
Root page: 197, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRACE_STAT (162)
Primary pointer page: 347, Index root page: 348
Total formats: 1, used formats: 1
Average record length: 58.00, total records: 2099
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.48
Pointer pages: 1, data page slots: 32
Data pages: 32, average fill: 60%
Primary pages: 32, secondary pages: 0, swept pages: 0
Empty pages: 6, full pages: 25
Fill distribution:
0 - 19% = 6
20 - 39% = 1
40 - 59% = 0
60 - 79% = 25
80 - 99% = 0
WARES (144)
Primary pointer page: 264, Index root page: 265
Total formats: 1, used formats: 1
Average record length: 78.23, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 448.00, compression ratio: 5.73
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 78%
Primary pages: 6, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2
Index FK_WARES_WARE_GROUPS (3)
Root page: 377, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 67
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 48, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARES (0)
Root page: 274, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 335, ratio: 0.84
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_ID_DESC (2)
Root page: 276, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 335, ratio: 0.84
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_NUMB_UNQ (1)
Root page: 507, depth: 2, leaf buckets: 4, nodes: 400
Average node length: 52.86, total dup: 0, max dup: 0
Average key length: 51.84, compression ratio: 1.00
Average prefix length: 2.73, average data length: 48.86
Clustering factor: 334, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3
80 - 99% = 0
WARE_GROUPS (155)
Primary pointer page: 313, Index root page: 314
Total formats: 1, used formats: 1
Average record length: 32.13, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 352.00, compression ratio: 10.96
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 5%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARE_GROUPS (0)
Root page: 325, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 11.25, total dup: 0, max dup: 0
Average key length: 10.13, compression ratio: 0.89
Average prefix length: 1.75, average data length: 7.25
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index WARE_GROUPS_NAME_UNQ (1)
Root page: 326, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 19.88, total dup: 0, max dup: 0
Average key length: 18.13, compression ratio: 0.89
Average prefix length: 0.25, average data length: 15.88
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQD_1000_1200 (260)
Primary pointer page: 292, Index root page: 295
Total formats: 1, used formats: 1
Average record length: 37.42, total records: 9479
Average version length: 72.03, total versions: 4568, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 3.63
Pointer pages: 2, data page slots: 528
Data pages: 504, average fill: 25%
Primary pages: 503, secondary pages: 1, swept pages: 261
Empty pages: 146, full pages: 42
Fill distribution:
0 - 19% = 260
20 - 39% = 122
40 - 59% = 64
60 - 79% = 51
80 - 99% = 7
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1346, depth: 2, leaf buckets: 23, nodes: 9479
Average node length: 6.37, total dup: 8148, max dup: 14
Average key length: 4.38, compression ratio: 8.45
Average prefix length: 34.76, average data length: 2.24
Clustering factor: 1551, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 19
40 - 59% = 3
60 - 79% = 0
80 - 99% = 1
XQD_1000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 71.71, total records: 948975
Average version length: 71.33, total versions: 6115, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.90
Pointer pages: 9, data page slots: 13984
Data pages: 13984, average fill: 75%
Primary pages: 13984, secondary pages: 0, swept pages: 8958
Empty pages: 8, full pages: 11399
Fill distribution:
0 - 19% = 18
20 - 39% = 64
40 - 59% = 413
60 - 79% = 13446
80 - 99% = 43
Index XQD_1000_3300_DOC (1)
Root page: 363710, depth: 3, leaf buckets: 1081, nodes: 948975
Average node length: 5.12, total dup: 923924, max dup: 126
Average key length: 2.19, compression ratio: 4.10
Average prefix length: 8.83, average data length: 0.17
Clustering factor: 118309, ratio: 0.12
Fill distribution:
0 - 19% = 18
20 - 39% = 96
40 - 59% = 753
60 - 79% = 38
80 - 99% = 176
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 224282, depth: 3, leaf buckets: 1359, nodes: 948975
Average node length: 6.24, total dup: 828703, max dup: 19
Average key length: 3.32, compression ratio: 11.15
Average prefix length: 35.81, average data length: 1.19
Clustering factor: 192543, ratio: 0.20
Fill distribution:
0 - 19% = 26
20 - 39% = 156
40 - 59% = 913
60 - 79% = 135
80 - 99% = 129
XQD_1200_2000 (261)
Primary pointer page: 718, Index root page: 719
Total formats: 1, used formats: 1
Average record length: 30.45, total records: 39248
Average version length: 71.55, total versions: 22666, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 4.47
Pointer pages: 3, data page slots: 1840
Data pages: 1344, average fill: 38%
Primary pages: 1342, secondary pages: 2, swept pages: 380
Empty pages: 207, full pages: 203
Fill distribution:
0 - 19% = 427
20 - 39% = 294
40 - 59% = 299
60 - 79% = 265
80 - 99% = 59
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1095, depth: 2, leaf buckets: 75, nodes: 39248
Average node length: 5.73, total dup: 34539, max dup: 49
Average key length: 3.54, compression ratio: 10.46
Average prefix length: 35.58, average data length: 1.42
Clustering factor: 4681, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 48
40 - 59% = 22
60 - 79% = 3
80 - 99% = 1
XQD_2000_3300 (263)
Primary pointer page: 735, Index root page: 736
Total formats: 1, used formats: 1
Average record length: 70.59, total records: 1406287
Average version length: 71.51, total versions: 31102, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.93
Pointer pages: 13, data page slots: 20864
Data pages: 20864, average fill: 74%
Primary pages: 20863, secondary pages: 1, swept pages: 10830
Empty pages: 86, full pages: 17327
Fill distribution:
0 - 19% = 171
20 - 39% = 261
40 - 59% = 956
60 - 79% = 18818
80 - 99% = 658
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 201754, depth: 3, leaf buckets: 2143, nodes: 1406287
Average node length: 5.57, total dup: 1326655, max dup: 49
Average key length: 2.62, compression ratio: 14.11
Average prefix length: 36.43, average data length: 0.57
Clustering factor: 182097, ratio: 0.13
Fill distribution:
0 - 19% = 12
20 - 39% = 924
40 - 59% = 860
60 - 79% = 210
80 - 99% = 137
XQD_2100_3300 (264)
Primary pointer page: 738, Index root page: 739
Total formats: 1, used formats: 1
Average record length: 3.27, total records: 6727
Average version length: 70.07, total versions: 6420, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 41.60
Pointer pages: 3, data page slots: 880
Data pages: 664, average fill: 15%
Primary pages: 663, secondary pages: 1, swept pages: 347
Empty pages: 359, full pages: 26
Fill distribution:
0 - 19% = 484
20 - 39% = 85
40 - 59% = 51
60 - 79% = 31
80 - 99% = 13
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1215, depth: 2, leaf buckets: 16, nodes: 6727
Average node length: 8.27, total dup: 4889, max dup: 49
Average key length: 6.30, compression ratio: 5.87
Average prefix length: 32.97, average data length: 4.03
Clustering factor: 1376, ratio: 0.20
Fill distribution:
0 - 19% = 1
20 - 39% = 5
40 - 59% = 8
60 - 79% = 2
80 - 99% = 0
XQD_3300_3400 (265)
Primary pointer page: 741, Index root page: 742
Total formats: 1, used formats: 1
Average record length: 71.18, total records: 2464287
Average version length: 70.78, total versions: 9238, 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: 22, data page slots: 34944
Data pages: 34944, average fill: 77%
Primary pages: 34944, secondary pages: 0, swept pages: 26175
Empty pages: 14, full pages: 32906
Fill distribution:
0 - 19% = 27
20 - 39% = 36
40 - 59% = 248
60 - 79% = 34375
80 - 99% = 258
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 40476, depth: 3, leaf buckets: 4991, nodes: 2464287
Average node length: 6.84, total dup: 2003723, max dup: 23
Average key length: 3.87, compression ratio: 9.56
Average prefix length: 35.31, average data length: 1.69
Clustering factor: 473261, ratio: 0.19
Fill distribution:
0 - 19% = 7
20 - 39% = 2658
40 - 59% = 1909
60 - 79% = 224
80 - 99% = 193
XQS_1000_1200 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 83.45, total records: 4287768
Average version length: 83.72, total versions: 1547, 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: 41, data page slots: 65752
Data pages: 65752, average fill: 80%
Primary pages: 65752, secondary pages: 0, swept pages: 24510
Empty pages: 7, full pages: 65488
Fill distribution:
0 - 19% = 12
20 - 39% = 3
40 - 59% = 21
60 - 79% = 19562
80 - 99% = 46154
Index XQS_1000_1200_DOC_ID (0)
Root page: 54645, depth: 3, leaf buckets: 4385, nodes: 4287768
Average node length: 5.15, total dup: 4189984, max dup: 126
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 685145, ratio: 0.16
Fill distribution:
0 - 19% = 22
20 - 39% = 62
40 - 59% = 1982
60 - 79% = 1759
80 - 99% = 560
Index XQS_1000_1200_RCV_ID (2)
Root page: 82607, depth: 3, leaf buckets: 4813, nodes: 4287768
Average node length: 5.70, total dup: 3838307, max dup: 49
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 233219, ratio: 0.05
Fill distribution:
0 - 19% = 46
20 - 39% = 183
40 - 59% = 2889
60 - 79% = 202
80 - 99% = 1493
Index XQS_1000_1200_SND_ID (1)
Root page: 47515, depth: 3, leaf buckets: 4891, nodes: 4287768
Average node length: 5.81, total dup: 3751250, max dup: 28
Average key length: 2.83, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 737839, ratio: 0.17
Fill distribution:
0 - 19% = 28
20 - 39% = 70
40 - 59% = 2188
60 - 79% = 1856
80 - 99% = 749
XQS_1000_3300 (268)
Primary pointer page: 755, Index root page: 756
Total formats: 1, used formats: 1
Average record length: 82.83, total records: 2288792
Average version length: 83.03, total versions: 7072, 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: 22, data page slots: 35592
Data pages: 35592, average fill: 79%
Primary pages: 35592, secondary pages: 0, swept pages: 26017
Empty pages: 12, full pages: 34237
Fill distribution:
0 - 19% = 21
20 - 39% = 43
40 - 59% = 240
60 - 79% = 14819
80 - 99% = 20469
Index XQS_1000_3300_DOC_ID (0)
Root page: 73800, depth: 3, leaf buckets: 2446, nodes: 2288792
Average node length: 5.15, total dup: 2235163, max dup: 199
Average key length: 2.18, compression ratio: 4.13
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 340127, ratio: 0.15
Fill distribution:
0 - 19% = 5
20 - 39% = 38
40 - 59% = 1454
60 - 79% = 701
80 - 99% = 248
Index XQS_1000_3300_RCV_ID (2)
Root page: 109107, depth: 3, leaf buckets: 3864, nodes: 2288792
Average node length: 6.19, total dup: 1888162, max dup: 14
Average key length: 3.22, compression ratio: 2.79
Average prefix length: 7.95, average data length: 1.05
Clustering factor: 224653, ratio: 0.10
Fill distribution:
0 - 19% = 96
20 - 39% = 1616
40 - 59% = 1443
60 - 79% = 457
80 - 99% = 252
Index XQS_1000_3300_SND_ID (1)
Root page: 63881, depth: 3, leaf buckets: 2798, nodes: 2288792
Average node length: 5.81, total dup: 2001868, max dup: 29
Average key length: 2.84, compression ratio: 3.16
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 411188, ratio: 0.18
Fill distribution:
0 - 19% = 24
20 - 39% = 36
40 - 59% = 1711
60 - 79% = 745
80 - 99% = 282
XQS_1200_2000 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 83.35, total records: 4528309
Average version length: 85.62, total versions: 14686, 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: 43, data page slots: 70104
Data pages: 70088, average fill: 80%
Primary pages: 70088, secondary pages: 0, swept pages: 20865
Empty pages: 161, full pages: 68023
Fill distribution:
0 - 19% = 202
20 - 39% = 166
40 - 59% = 532
60 - 79% = 16778
80 - 99% = 52410
Index XQS_1200_2000_DOC_ID (0)
Root page: 57493, depth: 3, leaf buckets: 4823, nodes: 4528309
Average node length: 5.04, total dup: 4501801, max dup: 686
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 678567, ratio: 0.15
Fill distribution:
0 - 19% = 3
20 - 39% = 235
40 - 59% = 2781
60 - 79% = 1366
80 - 99% = 438
Index XQS_1200_2000_RCV_ID (2)
Root page: 83243, depth: 3, leaf buckets: 5525, nodes: 4528309
Average node length: 5.54, total dup: 4167040, max dup: 49
Average key length: 2.55, compression ratio: 3.53
Average prefix length: 8.53, average data length: 0.47
Clustering factor: 258012, ratio: 0.06
Fill distribution:
0 - 19% = 62
20 - 39% = 1667
40 - 59% = 2017
60 - 79% = 484
80 - 99% = 1295
Index XQS_1200_2000_SND_ID (1)
Root page: 49462, depth: 3, leaf buckets: 5425, nodes: 4528309
Average node length: 5.69, total dup: 4062328, max dup: 89
Average key length: 2.70, compression ratio: 3.33
Average prefix length: 8.40, average data length: 0.60
Clustering factor: 755034, ratio: 0.17
Fill distribution:
0 - 19% = 6
20 - 39% = 226
40 - 59% = 3152
60 - 79% = 1520
80 - 99% = 521
XQS_2000_3300 (269)
Primary pointer page: 761, Index root page: 762
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_DOC_ID (0)
Root page: 763, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_RCV_ID (2)
Root page: 765, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_SND_ID (1)
Root page: 764, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQS_2100_3300 (270)
Primary pointer page: 767, Index root page: 776
Total formats: 1, used formats: 1
Average record length: 83.15, total records: 3145900
Average version length: 83.85, total versions: 7769, 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: 31, data page slots: 49024
Data pages: 49024, average fill: 79%
Primary pages: 49024, secondary pages: 0, swept pages: 36052
Empty pages: 20, full pages: 47063
Fill distribution:
0 - 19% = 29
20 - 39% = 53
40 - 59% = 266
60 - 79% = 20076
80 - 99% = 28600
Index XQS_2100_3300_DOC_ID (0)
Root page: 89055, depth: 3, leaf buckets: 3379, nodes: 3145900
Average node length: 5.03, total dup: 3129963, max dup: 1266
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 661549, ratio: 0.21
Fill distribution:
0 - 19% = 18
20 - 39% = 295
40 - 59% = 1822
60 - 79% = 840
80 - 99% = 404
Index XQS_2100_3300_RCV_ID (2)
Root page: 109104, depth: 3, leaf buckets: 5463, nodes: 3145900
Average node length: 6.21, total dup: 2589165, max dup: 14
Average key length: 3.24, compression ratio: 2.78
Average prefix length: 7.94, average data length: 1.06
Clustering factor: 357941, ratio: 0.11
Fill distribution:
0 - 19% = 170
20 - 39% = 2523
40 - 59% = 1778
60 - 79% = 602
80 - 99% = 390
Index XQS_2100_3300_SND_ID (1)
Root page: 77230, depth: 3, leaf buckets: 3651, nodes: 3145900
Average node length: 5.61, total dup: 2862293, max dup: 55
Average key length: 2.63, compression ratio: 3.42
Average prefix length: 8.46, average data length: 0.54
Clustering factor: 700581, ratio: 0.22
Fill distribution:
0 - 19% = 10
20 - 39% = 254
40 - 59% = 1807
60 - 79% = 1088
80 - 99% = 492
XQS_3300_3400 (271)
Primary pointer page: 780, Index root page: 781
Total formats: 1, used formats: 1
Average record length: 69.15, total records: 685091
Average version length: 69.26, total versions: 2009, 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: 9376
Data pages: 9376, average fill: 77%
Primary pages: 9376, secondary pages: 0, swept pages: 7053
Empty pages: 2, full pages: 9218
Fill distribution:
0 - 19% = 2
20 - 39% = 9
40 - 59% = 23
60 - 79% = 9295
80 - 99% = 47
Index XQS_3300_3400_DOC_ID (0)
Root page: 179133, depth: 3, leaf buckets: 810, nodes: 685091
Average node length: 5.27, total dup: 650767, max dup: 118
Average key length: 2.38, compression ratio: 3.77
Average prefix length: 8.67, average data length: 0.33
Clustering factor: 52517, ratio: 0.08
Fill distribution:
0 - 19% = 3
20 - 39% = 181
40 - 59% = 315
60 - 79% = 229
80 - 99% = 82
Index XQS_3300_3400_SND_ID (1)
Root page: 150306, depth: 3, leaf buckets: 896, nodes: 685091
Average node length: 5.90, total dup: 588228, max dup: 14
Average key length: 3.02, compression ratio: 2.98
Average prefix length: 8.12, average data length: 0.88
Clustering factor: 56957, ratio: 0.08
Fill distribution:
0 - 19% = 1
20 - 39% = 183
40 - 59% = 351
60 - 79% = 254
80 - 99% = 107
ZDOC_DATA (230)
Primary pointer page: 644, Index root page: 645
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZDOC_LIST (229)
Primary pointer page: 642, Index root page: 643
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZINVNT_TURNOVER_LOG (231)
Primary pointer page: 646, Index root page: 647
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPDISTR (234)
Primary pointer page: 652, Index root page: 653
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPDISTR_ID (0)
Root page: 662, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPSTORNED (235)
Primary pointer page: 654, Index root page: 655
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPSTORNED_ID (0)
Root page: 663, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQDISTR (232)
Primary pointer page: 648, Index root page: 649
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_ID (0)
Root page: 656, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Root page: 657, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQSTORNED (233)
Primary pointer page: 650, Index root page: 651
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_DOC_ID (1)
Root page: 659, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_ID (0)
Root page: 658, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_RCV_ID (3)
Root page: 661, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_SND_ID (2)
Root page: 660, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_DEP_DOCS (228)
Primary pointer page: 640, Index root page: 641
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_SHOPPING_CART (227)
Primary pointer page: 614, Index root page: 615
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Z_USED_VIEWS (146)
Primary pointer page: 268, Index root page: 269
Total formats: 1, used formats: 1
Average record length: 29.38, total records: 29
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 99.00, compression ratio: 3.37
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 16%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index Z_USED_VIEWS_UNQ (0)
Root page: 281, depth: 1, leaf buckets: 1, nodes: 29
Average node length: 15.17, total dup: 0, max dup: 0
Average key length: 14.14, compression ratio: 1.44
Average prefix length: 9.17, average data length: 11.17
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Done for 74460 ms, from 7:08:01.96 to 7:09:16.42.
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
VERS_PERCENT |
AGENTS |
50 |
0 |
0.0000 |
BUSINESS_OPS |
19 |
0 |
0.0000 |
DOC_DATA |
1951856 |
1793 |
0.0918 |
DOC_LIST |
580945 |
752 |
0.1294 |
DOC_STATES |
4 |
0 |
0.0000 |
FB_ERRORS |
758 |
0 |
0.0000 |
INVNT_SALDO |
400 |
0 |
0.0000 |
INVNT_TURNOVER_LOG |
7952 |
5433 |
68.3224 |
MONEY_SALDO |
49 |
0 |
0.0000 |
MONEY_TURNOVER_LOG |
278 |
233 |
83.8129 |
OPTYPES |
9 |
0 |
0.0000 |
PDISTR |
209398 |
2323 |
1.1093 |
PERF_ESTIMATED |
236418 |
0 |
0.0000 |
PERF_LOG |
10141738 |
0 |
0.0000 |
PSTORNED |
393389 |
550 |
0.1398 |
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 |
2099 |
0 |
0.0000 |
WARES |
400 |
0 |
0.0000 |
WARE_GROUPS |
8 |
0 |
0.0000 |
XQD_1000_1200 |
9479 |
4568 |
48.1907 |
XQD_1000_3300 |
948975 |
6115 |
0.6443 |
XQD_1200_2000 |
39248 |
22666 |
57.7507 |
XQD_2000_3300 |
1406287 |
31102 |
2.2116 |
XQD_2100_3300 |
6727 |
6420 |
95.4363 |
XQD_3300_3400 |
2464287 |
9238 |
0.3748 |
XQS_1000_1200 |
4287768 |
1547 |
0.0360 |
XQS_1000_3300 |
2288792 |
7072 |
0.3089 |
XQS_1200_2000 |
4528309 |
14686 |
0.3243 |
XQS_2100_3300 |
3145900 |
7769 |
0.2469 |
XQS_3300_3400 |
685091 |
2009 |
0.2932 |
Z_USED_VIEWS |
29 |
0 |
0.0000 |
Done for 1420 ms, from 7:09:29.20 to 7:09:30.62.
07:09:30.70 Validation started
07:09:30.73 Relation 140 (DOC_LIST)
07:09:30.73 process pointer page 0 of 5
07:09:30.82 process pointer page 1 of 5
07:09:30.92 process pointer page 2 of 5
07:09:31.01 process pointer page 3 of 5
07:09:31.09 process pointer page 4 of 5
07:09:31.10 Index 1 (PK_DOC_LIST)
07:09:31.21 Index 2 (DOC_LIST_ID_DESC)
07:09:31.31 Index 3 (FK_DOC_LIST_AGENTS)
07:09:31.38 Relation 140 (DOC_LIST) is ok
07:09:31.38 Relation 141 (DOC_DATA)
07:09:31.38 process pointer page 0 of 13
07:09:31.41 process pointer page 1 of 13
07:09:31.45 process pointer page 2 of 13
07:09:31.46 process pointer page 3 of 13
07:09:31.51 process pointer page 4 of 13
07:09:31.59 process pointer page 5 of 13
07:09:31.68 process pointer page 6 of 13
07:09:31.77 process pointer page 7 of 13
07:09:31.87 process pointer page 8 of 13
07:09:31.94 process pointer page 9 of 13
07:09:32.04 process pointer page 10 of 13
07:09:32.13 process pointer page 11 of 13
07:09:32.21 process pointer page 12 of 13
07:09:32.30 Index 2 (DOC_DATA_DOC_WARE_UNQ)
07:09:32.96 Index 3 (DOC_DATA_ID_DESC)
07:09:33.60 Index 4 (FK_DOC_DATA_DOC_LIST)
07:09:34.19 Relation 141 (DOC_DATA) is ok
07:09:34.19 Relation 147 (INVNT_SALDO)
07:09:34.19 process pointer page 0 of 1
07:09:34.19 Index 1 (PK_INVNT_SALDO)
07:09:34.19 Relation 147 (INVNT_SALDO) is ok
07:09:34.19 Relation 150 (PDISTR)
07:09:34.19 process pointer page 0 of 2
07:09:34.28 process pointer page 1 of 2
07:09:34.32 Index 2 (PDISTR_SND_ID)
07:09:34.39 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
07:09:34.44 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
07:09:34.47 Index 5 (PDISTR_AGENT_ID)
07:09:34.50 Relation 150 (PDISTR) is ok
07:09:34.50 Relation 151 (PSTORNED)
07:09:34.50 process pointer page 0 of 3
07:09:34.53 process pointer page 1 of 3
07:09:34.57 process pointer page 2 of 3
07:09:34.60 Index 2 (PSTORNED_SND_ID)
07:09:34.64 Index 3 (PSTORNED_RCV_ID)
07:09:34.67 Relation 151 (PSTORNED) is ok
07:09:34.67 Relation 156 (SEMAPHORES)
07:09:34.67 process pointer page 0 of 1
07:09:34.67 Index 1 (PK_SEMAPHORES)
07:09:34.67 Index 2 (SEMAPHORES_TASK_UNQ)
07:09:34.67 Relation 156 (SEMAPHORES) is ok
07:09:34.67 Relation 157 (INVNT_TURNOVER_LOG)
07:09:34.67 process pointer page 0 of 1
07:09:34.69 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
07:09:34.69 Relation 157 (INVNT_TURNOVER_LOG) is ok
07:09:34.69 Relation 160 (PERF_ESTIMATED)
07:09:34.69 process pointer page 0 of 2
07:09:34.72 process pointer page 1 of 2
07:09:34.72 Index 1 (PERF_EST_MINUTE_SINCE_START)
07:09:34.74 Relation 160 (PERF_ESTIMATED) is ok
07:09:34.74 Relation 161 (PERF_ISQL_STAT)
07:09:34.74 process pointer page 0 of 1
07:09:34.74 Index 1 (PERF_ISQL_STAT_TRN)
07:09:34.74 Relation 161 (PERF_ISQL_STAT) is ok
07:09:34.74 Relation 162 (TRACE_STAT)
07:09:34.74 process pointer page 0 of 1
07:09:34.74 Relation 162 (TRACE_STAT) is ok
07:09:34.74 Relation 163 (PERF_LOG)
07:09:34.74 process pointer page 0 of 148
07:09:34.77 process pointer page 1 of 148
07:09:34.80 process pointer page 2 of 148
07:09:34.82 process pointer page 3 of 148
07:09:34.85 process pointer page 4 of 148
07:09:34.86 process pointer page 5 of 148
07:09:34.89 process pointer page 6 of 148
07:09:34.92 process pointer page 7 of 148
07:09:34.99 process pointer page 8 of 148
07:09:35.08 process pointer page 9 of 148
07:09:35.11 process pointer page 10 of 148
07:09:35.14 process pointer page 11 of 148
07:09:35.17 process pointer page 12 of 148
07:09:35.25 process pointer page 13 of 148
07:09:35.35 process pointer page 14 of 148
07:09:35.42 process pointer page 15 of 148
07:09:35.50 process pointer page 16 of 148
07:09:35.55 process pointer page 17 of 148
07:09:35.58 process pointer page 18 of 148
07:09:35.61 process pointer page 19 of 148
07:09:35.64 process pointer page 20 of 148
07:09:35.67 process pointer page 21 of 148
07:09:35.70 process pointer page 22 of 148
07:09:35.75 process pointer page 23 of 148
07:09:35.83 process pointer page 24 of 148
07:09:35.91 process pointer page 25 of 148
07:09:35.99 process pointer page 26 of 148
07:09:36.06 process pointer page 27 of 148
07:09:36.11 process pointer page 28 of 148
07:09:36.14 process pointer page 29 of 148
07:09:36.17 process pointer page 30 of 148
07:09:36.22 process pointer page 31 of 148
07:09:36.27 process pointer page 32 of 148
07:09:36.36 process pointer page 33 of 148
07:09:36.44 process pointer page 34 of 148
07:09:36.50 process pointer page 35 of 148
07:09:36.53 process pointer page 36 of 148
07:09:36.59 process pointer page 37 of 148
07:09:36.62 process pointer page 38 of 148
07:09:36.66 process pointer page 39 of 148
07:09:36.69 process pointer page 40 of 148
07:09:36.72 process pointer page 41 of 148
07:09:36.75 process pointer page 42 of 148
07:09:36.78 process pointer page 43 of 148
07:09:36.81 process pointer page 44 of 148
07:09:36.84 process pointer page 45 of 148
07:09:36.87 process pointer page 46 of 148
07:09:36.89 process pointer page 47 of 148
07:09:36.92 process pointer page 48 of 148
07:09:36.95 process pointer page 49 of 148
07:09:36.97 process pointer page 50 of 148
07:09:37.00 process pointer page 51 of 148
07:09:37.01 process pointer page 52 of 148
07:09:37.05 process pointer page 53 of 148
07:09:37.06 process pointer page 54 of 148
07:09:37.09 process pointer page 55 of 148
07:09:37.11 process pointer page 56 of 148
07:09:37.14 process pointer page 57 of 148
07:09:37.17 process pointer page 58 of 148
07:09:37.22 process pointer page 59 of 148
07:09:37.30 process pointer page 60 of 148
07:09:37.37 process pointer page 61 of 148
07:09:37.45 process pointer page 62 of 148
07:09:37.53 process pointer page 63 of 148
07:09:37.58 process pointer page 64 of 148
07:09:37.61 process pointer page 65 of 148
07:09:37.64 process pointer page 66 of 148
07:09:37.67 process pointer page 67 of 148
07:09:37.70 process pointer page 68 of 148
07:09:37.73 process pointer page 69 of 148
07:09:37.76 process pointer page 70 of 148
07:09:37.81 process pointer page 71 of 148
07:09:37.86 process pointer page 72 of 148
07:09:37.89 process pointer page 73 of 148
07:09:37.98 process pointer page 74 of 148
07:09:38.06 process pointer page 75 of 148
07:09:38.14 process pointer page 76 of 148
07:09:38.22 process pointer page 77 of 148
07:09:38.29 process pointer page 78 of 148
07:09:38.39 process pointer page 79 of 148
07:09:38.47 process pointer page 80 of 148
07:09:38.54 process pointer page 81 of 148
07:09:38.62 process pointer page 82 of 148
07:09:38.65 process pointer page 83 of 148
07:09:38.68 process pointer page 84 of 148
07:09:38.73 process pointer page 85 of 148
07:09:38.78 process pointer page 86 of 148
07:09:38.86 process pointer page 87 of 148
07:09:38.93 process pointer page 88 of 148
07:09:39.01 process pointer page 89 of 148
07:09:39.11 process pointer page 90 of 148
07:09:39.17 process pointer page 91 of 148
07:09:39.26 process pointer page 92 of 148
07:09:39.34 process pointer page 93 of 148
07:09:39.37 process pointer page 94 of 148
07:09:39.40 process pointer page 95 of 148
07:09:39.43 process pointer page 96 of 148
07:09:39.46 process pointer page 97 of 148
07:09:39.51 process pointer page 98 of 148
07:09:39.59 process pointer page 99 of 148
07:09:39.67 process pointer page 100 of 148
07:09:39.70 process pointer page 101 of 148
07:09:39.74 process pointer page 102 of 148
07:09:39.82 process pointer page 103 of 148
07:09:39.89 process pointer page 104 of 148
07:09:39.92 process pointer page 105 of 148
07:09:39.95 process pointer page 106 of 148
07:09:39.98 process pointer page 107 of 148
07:09:40.06 process pointer page 108 of 148
07:09:40.13 process pointer page 109 of 148
07:09:40.21 process pointer page 110 of 148
07:09:40.29 process pointer page 111 of 148
07:09:40.38 process pointer page 112 of 148
07:09:40.45 process pointer page 113 of 148
07:09:40.48 process pointer page 114 of 148
07:09:40.56 process pointer page 115 of 148
07:09:40.63 process pointer page 116 of 148
07:09:40.70 process pointer page 117 of 148
07:09:40.73 process pointer page 118 of 148
07:09:40.81 process pointer page 119 of 148
07:09:40.88 process pointer page 120 of 148
07:09:40.95 process pointer page 121 of 148
07:09:40.98 process pointer page 122 of 148
07:09:41.06 process pointer page 123 of 148
07:09:41.13 process pointer page 124 of 148
07:09:41.21 process pointer page 125 of 148
07:09:41.30 process pointer page 126 of 148
07:09:41.38 process pointer page 127 of 148
07:09:41.46 process pointer page 128 of 148
07:09:41.51 process pointer page 129 of 148
07:09:41.54 process pointer page 130 of 148
07:09:41.57 process pointer page 131 of 148
07:09:41.60 process pointer page 132 of 148
07:09:41.63 process pointer page 133 of 148
07:09:41.66 process pointer page 134 of 148
07:09:41.69 process pointer page 135 of 148
07:09:41.71 process pointer page 136 of 148
07:09:41.74 process pointer page 137 of 148
07:09:41.77 process pointer page 138 of 148
07:09:41.80 process pointer page 139 of 148
07:09:41.82 process pointer page 140 of 148
07:09:41.85 process pointer page 141 of 148
07:09:41.88 process pointer page 142 of 148
07:09:41.90 process pointer page 143 of 148
07:09:41.93 process pointer page 144 of 148
07:09:41.94 process pointer page 145 of 148
07:09:41.98 process pointer page 146 of 148
07:09:41.99 process pointer page 147 of 148
07:09:42.01 Index 1 (PERF_LOG_DTS_BEG_DESC)
07:09:44.07 Index 2 (PERF_LOG_UNIT)
07:09:48.12 Index 3 (PERF_LOG_TRN_DESC)
07:09:49.25 Index 4 (PERF_LOG_GDSCODE)
07:09:50.57 Relation 163 (PERF_LOG) is ok
07:09:50.57 Relation 167 (V_STOPTEST)
07:09:50.57 Relation 167 (V_STOPTEST) is ok
07:09:50.57 Relation 184 (V_QDISTR_SOURCE)
07:09:50.57 Relation 184 (V_QDISTR_SOURCE) is ok
07:09:50.57 Relation 185 (V_QSTORNED_SOURCE)
07:09:50.57 Relation 185 (V_QSTORNED_SOURCE) is ok
07:09:50.57 Relation 260 (XQD_1000_1200)
07:09:50.57 process pointer page 0 of 2
07:09:50.60 process pointer page 1 of 2
07:09:50.60 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
07:09:50.62 Relation 260 (XQD_1000_1200) is ok
07:09:50.62 Relation 261 (XQD_1200_2000)
07:09:50.62 process pointer page 0 of 3
07:09:50.70 process pointer page 1 of 3
07:09:50.70 process pointer page 2 of 3
07:09:50.70 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
07:09:50.71 Relation 261 (XQD_1200_2000) is ok
07:09:50.71 Relation 262 (XQD_1000_3300)
07:09:50.71 process pointer page 0 of 9
07:09:50.76 process pointer page 1 of 9
07:09:50.82 process pointer page 2 of 9
07:09:50.90 process pointer page 3 of 9
07:09:50.96 process pointer page 4 of 9
07:09:50.99 process pointer page 5 of 9
07:09:51.02 process pointer page 6 of 9
07:09:51.05 process pointer page 7 of 9
07:09:51.10 process pointer page 8 of 9
07:09:51.12 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
07:09:51.46 Index 2 (XQD_1000_3300_DOC)
07:09:51.59 Relation 262 (XQD_1000_3300) is ok
07:09:51.59 Relation 263 (XQD_2000_3300)
07:09:51.59 process pointer page 0 of 13
07:09:51.62 process pointer page 1 of 13
07:09:51.65 process pointer page 2 of 13
07:09:51.68 process pointer page 3 of 13
07:09:51.71 process pointer page 4 of 13
07:09:51.76 process pointer page 5 of 13
07:09:51.83 process pointer page 6 of 13
07:09:51.87 process pointer page 7 of 13
07:09:51.91 process pointer page 8 of 13
07:09:52.01 process pointer page 9 of 13
07:09:52.10 process pointer page 10 of 13
07:09:52.19 process pointer page 11 of 13
07:09:52.27 process pointer page 12 of 13
07:09:52.30 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
07:09:52.66 Relation 263 (XQD_2000_3300) is ok
07:09:52.66 Relation 264 (XQD_2100_3300)
07:09:52.66 process pointer page 0 of 3
07:09:52.69 process pointer page 1 of 3
07:09:52.69 process pointer page 2 of 3
07:09:52.69 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
07:09:52.69 Relation 264 (XQD_2100_3300) is ok
07:09:52.69 Relation 265 (XQD_3300_3400)
07:09:52.69 process pointer page 0 of 22
07:09:52.72 process pointer page 1 of 22
07:09:52.76 process pointer page 2 of 22
07:09:52.80 process pointer page 3 of 22
07:09:52.90 process pointer page 4 of 22
07:09:52.99 process pointer page 5 of 22
07:09:53.02 process pointer page 6 of 22
07:09:53.05 process pointer page 7 of 22
07:09:53.08 process pointer page 8 of 22
07:09:53.11 process pointer page 9 of 22
07:09:53.15 process pointer page 10 of 22
07:09:53.18 process pointer page 11 of 22
07:09:53.21 process pointer page 12 of 22
07:09:53.24 process pointer page 13 of 22
07:09:53.27 process pointer page 14 of 22
07:09:53.30 process pointer page 15 of 22
07:09:53.32 process pointer page 16 of 22
07:09:53.39 process pointer page 17 of 22
07:09:53.46 process pointer page 18 of 22
07:09:53.49 process pointer page 19 of 22
07:09:53.52 process pointer page 20 of 22
07:09:53.55 process pointer page 21 of 22
07:09:53.57 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
07:09:53.88 Relation 265 (XQD_3300_3400) is ok
07:09:53.88 Relation 266 (XQS_1000_1200)
07:09:53.88 process pointer page 0 of 41
07:09:53.89 process pointer page 1 of 41
07:09:53.93 process pointer page 2 of 41
07:09:53.94 process pointer page 3 of 41
07:09:53.97 process pointer page 4 of 41
07:09:54.00 process pointer page 5 of 41
07:09:54.02 process pointer page 6 of 41
07:09:54.05 process pointer page 7 of 41
07:09:54.08 process pointer page 8 of 41
07:09:54.10 process pointer page 9 of 41
07:09:54.14 process pointer page 10 of 41
07:09:54.24 process pointer page 11 of 41
07:09:54.33 process pointer page 12 of 41
07:09:54.41 process pointer page 13 of 41
07:09:54.50 process pointer page 14 of 41
07:09:54.60 process pointer page 15 of 41
07:09:54.63 process pointer page 16 of 41
07:09:54.67 process pointer page 17 of 41
07:09:54.71 process pointer page 18 of 41
07:09:54.77 process pointer page 19 of 41
07:09:54.85 process pointer page 20 of 41
07:09:54.89 process pointer page 21 of 41
07:09:54.97 process pointer page 22 of 41
07:09:55.06 process pointer page 23 of 41
07:09:55.11 process pointer page 24 of 41
07:09:55.14 process pointer page 25 of 41
07:09:55.17 process pointer page 26 of 41
07:09:55.28 process pointer page 27 of 41
07:09:55.36 process pointer page 28 of 41
07:09:55.45 process pointer page 29 of 41
07:09:55.53 process pointer page 30 of 41
07:09:55.63 process pointer page 31 of 41
07:09:55.67 process pointer page 32 of 41
07:09:55.70 process pointer page 33 of 41
07:09:55.73 process pointer page 34 of 41
07:09:55.77 process pointer page 35 of 41
07:09:55.80 process pointer page 36 of 41
07:09:55.84 process pointer page 37 of 41
07:09:55.88 process pointer page 38 of 41
07:09:55.91 process pointer page 39 of 41
07:09:55.94 process pointer page 40 of 41
07:09:55.95 Index 1 (XQS_1000_1200_DOC_ID)
07:09:56.83 Index 2 (XQS_1000_1200_SND_ID)
07:09:57.75 Index 3 (XQS_1000_1200_RCV_ID)
07:09:58.29 Relation 266 (XQS_1000_1200) is ok
07:09:58.29 Relation 267 (XQS_1200_2000)
07:09:58.29 process pointer page 0 of 43
07:09:58.32 process pointer page 1 of 43
07:09:58.36 process pointer page 2 of 43
07:09:58.39 process pointer page 3 of 43
07:09:58.42 process pointer page 4 of 43
07:09:58.45 process pointer page 5 of 43
07:09:58.48 process pointer page 6 of 43
07:09:58.51 process pointer page 7 of 43
07:09:58.53 process pointer page 8 of 43
07:09:58.56 process pointer page 9 of 43
07:09:58.59 process pointer page 10 of 43
07:09:58.61 process pointer page 11 of 43
07:09:58.64 process pointer page 12 of 43
07:09:58.67 process pointer page 13 of 43
07:09:58.70 process pointer page 14 of 43
07:09:58.73 process pointer page 15 of 43
07:09:58.75 process pointer page 16 of 43
07:09:58.78 process pointer page 17 of 43
07:09:58.81 process pointer page 18 of 43
07:09:58.82 process pointer page 19 of 43
07:09:58.85 process pointer page 20 of 43
07:09:58.90 process pointer page 21 of 43
07:09:58.95 process pointer page 22 of 43
07:09:59.04 process pointer page 23 of 43
07:09:59.12 process pointer page 24 of 43
07:09:59.20 process pointer page 25 of 43
07:09:59.23 process pointer page 26 of 43
07:09:59.34 process pointer page 27 of 43
07:09:59.43 process pointer page 28 of 43
07:09:59.54 process pointer page 29 of 43
07:09:59.63 process pointer page 30 of 43
07:09:59.67 process pointer page 31 of 43
07:09:59.73 process pointer page 32 of 43
07:09:59.76 process pointer page 33 of 43
07:09:59.81 process pointer page 34 of 43
07:09:59.84 process pointer page 35 of 43
07:09:59.87 process pointer page 36 of 43
07:09:59.90 process pointer page 37 of 43
07:09:59.93 process pointer page 38 of 43
07:09:59.96 process pointer page 39 of 43
07:09:59.99 process pointer page 40 of 43
07:10:00.02 process pointer page 41 of 43
07:10:00.10 process pointer page 42 of 43
07:10:00.15 Index 1 (XQS_1200_2000_DOC_ID)
07:10:01.19 Index 2 (XQS_1200_2000_SND_ID)
07:10:02.02 Index 3 (XQS_1200_2000_RCV_ID)
07:10:03.04 Relation 267 (XQS_1200_2000) is ok
07:10:03.04 Relation 268 (XQS_1000_3300)
07:10:03.05 process pointer page 0 of 22
07:10:03.14 process pointer page 1 of 22
07:10:03.25 process pointer page 2 of 22
07:10:03.36 process pointer page 3 of 22
07:10:03.44 process pointer page 4 of 22
07:10:03.49 process pointer page 5 of 22
07:10:03.52 process pointer page 6 of 22
07:10:03.57 process pointer page 7 of 22
07:10:03.64 process pointer page 8 of 22
07:10:03.68 process pointer page 9 of 22
07:10:03.77 process pointer page 10 of 22
07:10:03.88 process pointer page 11 of 22
07:10:03.97 process pointer page 12 of 22
07:10:04.05 process pointer page 13 of 22
07:10:04.08 process pointer page 14 of 22
07:10:04.17 process pointer page 15 of 22
07:10:04.28 process pointer page 16 of 22
07:10:04.38 process pointer page 17 of 22
07:10:04.46 process pointer page 18 of 22
07:10:04.50 process pointer page 19 of 22
07:10:04.56 process pointer page 20 of 22
07:10:04.61 process pointer page 21 of 22
07:10:04.69 Index 1 (XQS_1000_3300_DOC_ID)
07:10:05.24 Index 2 (XQS_1000_3300_SND_ID)
07:10:05.84 Index 3 (XQS_1000_3300_RCV_ID)
07:10:06.44 Relation 268 (XQS_1000_3300) is ok
07:10:06.44 Relation 269 (XQS_2000_3300)
07:10:06.45 process pointer page 0 of 1
07:10:06.45 Index 1 (XQS_2000_3300_DOC_ID)
07:10:06.45 Index 2 (XQS_2000_3300_SND_ID)
07:10:06.45 Index 3 (XQS_2000_3300_RCV_ID)
07:10:06.45 Relation 269 (XQS_2000_3300) is ok
07:10:06.45 Relation 270 (XQS_2100_3300)
07:10:06.45 process pointer page 0 of 31
07:10:06.55 process pointer page 1 of 31
07:10:06.65 process pointer page 2 of 31
07:10:06.76 process pointer page 3 of 31
07:10:06.86 process pointer page 4 of 31
07:10:06.97 process pointer page 5 of 31
07:10:07.04 process pointer page 6 of 31
07:10:07.09 process pointer page 7 of 31
07:10:07.20 process pointer page 8 of 31
07:10:07.31 process pointer page 9 of 31
07:10:07.40 process pointer page 10 of 31
07:10:07.51 process pointer page 11 of 31
07:10:07.59 process pointer page 12 of 31
07:10:07.64 process pointer page 13 of 31
07:10:07.75 process pointer page 14 of 31
07:10:07.86 process pointer page 15 of 31
07:10:07.95 process pointer page 16 of 31
07:10:08.01 process pointer page 17 of 31
07:10:08.06 process pointer page 18 of 31
07:10:08.09 process pointer page 19 of 31
07:10:08.14 process pointer page 20 of 31
07:10:08.17 process pointer page 21 of 31
07:10:08.20 process pointer page 22 of 31
07:10:08.25 process pointer page 23 of 31
07:10:08.34 process pointer page 24 of 31
07:10:08.45 process pointer page 25 of 31
07:10:08.54 process pointer page 26 of 31
07:10:08.57 process pointer page 27 of 31
07:10:08.62 process pointer page 28 of 31
07:10:08.70 process pointer page 29 of 31
07:10:08.90 process pointer page 30 of 31
07:10:08.90 Index 1 (XQS_2100_3300_DOC_ID)
07:10:10.26 Index 2 (XQS_2100_3300_SND_ID)
07:10:11.38 Index 3 (XQS_2100_3300_RCV_ID)
07:10:13.52 Relation 270 (XQS_2100_3300) is ok
07:10:13.52 Relation 271 (XQS_3300_3400)
07:10:13.52 process pointer page 0 of 6
07:10:14.02 process pointer page 1 of 6
07:10:14.52 process pointer page 2 of 6
07:10:15.00 process pointer page 3 of 6
07:10:15.48 process pointer page 4 of 6
07:10:15.91 process pointer page 5 of 6
07:10:16.26 Index 1 (XQS_3300_3400_DOC_ID)
07:10:16.62 Index 2 (XQS_3300_3400_SND_ID)
07:10:17.04 Relation 271 (XQS_3300_3400) is ok
07:10:17.06 Validation finished
Done for 46540 ms, from 7:09:30.63 to 7:10:17.17.
Differences between old and current firebird.log
7:10:18.21. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2017-08-24 07:10 471 oltp30_fb_log_when_test_finished.log
End of gathering firebird.log AFTER test finish.
+++ Start of comparison +++
Comparing files E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Thu Aug 24 07:09:30 2017
7: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Thu Aug 24 07:10:17 2017
12: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++
Remove 401 logs of every ISQL session if there were no serious errors.
Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp30\oltp30_*.*:
ERRORS_CHECKING_RESULT |
NO_SEVERE_ERRORS_FOUND |
ISQL logs are removed because no severe errors occured during test.
2017-08-24 7:10:25.00 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html