Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2016-05-22 10:58:25.15.
Server version: WI-T4.0.0.202 Firebird 4.0 Unstable
Server implementation: Firebird/Windows/AMD/Intel/x64
FB_ARCHITECTURE |
DB_NAME |
FORCED_WRITES |
SWEEP_INT |
PAGE_BUFFERS |
PAGE_SIZE |
SuperServer 4.0.0 |
D:\OLTP-EMUL\OLTP40-SMALL.FDB |
ON |
0 |
786432 |
8192 |
Test configuration settings
File: E:\OLTP-EMUL\src\oltp40_config.win
PARAM_NAME |
PARAM_VALUE |
fbc |
E:\FB40.TMPINSTANCE |
dbnm |
D:\OLTP-EMUL\oltp40-small.fdb |
host |
localhost |
port |
3400 |
usr |
SYSDBA |
pwd |
masterkey |
tmpdir |
e:\temp\logs.oltp40 |
working_mode |
small_03 |
warm_time |
10 |
test_time |
180 |
idle_time |
0 |
use_mtee |
0 |
is_embed |
0 |
remove_isql_logs |
if_no_severe_errors |
no_auto_undo |
1 |
detailed_info |
0 |
mon_unit_perf |
0 |
trc_unit_perf |
1 |
init_buff |
32768 |
create_with_fw |
sync |
create_with_sweep |
0 |
wait_if_not_exists |
0 |
wait_after_create |
0 |
init_docs |
0 |
wait_for_copy |
0 |
create_with_debug_objects |
1 |
create_with_split_heavy_tabs |
1 |
create_with_separate_qdistr_idx |
0 |
create_with_compound_columns_order |
most_selective_first |
make_html |
1 |
run_db_statistics |
1 |
run_db_validation |
1 |
file_name_with_test_params |
regular |
file_name_this_host_info |
ak40 |
upload_report |
1 |
FINISH_STATE |
DTS_END |
FB_GDSCODE |
FB_MNEMONA |
STACK |
IP |
TRN_ID |
ATT_ID |
EXC_UNIT |
NORMAL: TEST_TIME EXPIRED. |
2016-05-22 10:56:00.0820 |
-1 |
<null> |
|
::1/65143 |
341273 |
5026 |
2 |
CATEGORY |
SETTING |
VAL |
COMMON |
TRACED_UNITS |
,, |
COMMON |
HALT_TEST_ON_ERRORS |
,CK, |
COMMON |
LOG_PK_VIOLATION |
0 |
COMMON |
QMISM_VERIFY_BITSET |
1 |
COMMON |
RECALC_IDX_MIN_INTERVAL |
15 |
COMMON |
ENABLE_RESERVES_WHEN_ADD_INVOICE |
1 |
COMMON |
ORDER_FOR_OUR_FIRM_PERCENT |
25 |
COMMON |
ENABLE_FILL_PHRASES |
0 |
COMMON |
RANDOM_SEEK_VIA_ROWS_LIMIT |
0 |
COMMON |
C_INVOICE_MIN_PURCHASE |
1000 |
COMMON |
C_INVOICE_MAX_PURCHASE |
2000 |
COMMON |
C_INVOICE_MIN_PROFIT_PRC |
35 |
COMMON |
C_INVOICE_MAX_PROFIT_PRC |
80 |
COMMON |
C_MIN_COST_TO_BE_SPLITTED |
1000 |
COMMON |
C_ROWS_TO_MULTIPLY |
10 |
COMMON |
C_PAYMENT_FROM_CLIENT_MIN_TOTAL |
1000 |
COMMON |
C_PAYMENT_FROM_CLIENT_MAX_TOTAL |
5000 |
COMMON |
C_PAYMENT_TO_SUPPLIER_MIN_TOTAL |
2000 |
COMMON |
C_PAYMENT_TO_SUPPLIER_MAX_TOTAL |
15000 |
COMMON |
BUILD_WITH_SPLIT_HEAVY_TABS |
1 |
COMMON |
BUILD_WITH_SEPAR_QDISTR_IDX |
0 |
COMMON |
BUILD_WITH_QD_COMPOUND_ORDR |
MOST_SELECTIVE_FIRST |
COMMON |
ENABLE_MON_QUERY |
0 |
SMALL_03 |
C_WARES_MAX_ID |
400 |
SMALL_03 |
C_CUSTOMER_DOC_MAX_ROWS |
10 |
SMALL_03 |
C_SUPPLIER_DOC_MAX_ROWS |
50 |
SMALL_03 |
C_CUSTOMER_DOC_MAX_QTY |
15 |
SMALL_03 |
C_SUPPLIER_DOC_MAX_QTY |
50 |
SMALL_03 |
C_NUMBER_OF_AGENTS |
50 |
TAB_NAME |
IDX_NAME |
IDX_KEY |
XQD_1000_1200 |
XQD_1000_1200_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_1000_3300 |
XQD_1000_3300_DOC |
DOC_ID |
XQD_1000_3300 |
XQD_1000_3300_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_1200_2000 |
XQD_1200_2000_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_2000_3300 |
XQD_2000_3300_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_2100_3300 |
XQD_2100_3300_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_3300_3400 |
XQD_3300_3400_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
Performance reports
ACTION |
AVG_TIMES_PER_MINUTE |
AVG_ELAPSED_MS |
SUCCESSFUL_TIMES_DONE |
JOB_BEG |
JOB_END |
*** OVERALL *** for 180 minutes: |
5110.16 |
6886 |
919829 |
2016-05-22 07:56 |
2016-05-22 10:56 |
customer order: creation |
396.12 |
1076 |
71301 |
2016-05-22 07:56 |
2016-05-22 10:56 |
customer order: refuse |
31.04 |
75 |
5556 |
2016-05-22 07:56 |
2016-05-22 10:56 |
order to supplier: creation |
101.65 |
7793 |
18297 |
2016-05-22 07:56 |
2016-05-22 10:56 |
order to supplier: removal |
2.32 |
74030 |
416 |
2016-05-22 07:56 |
2016-05-22 10:56 |
invoice (draft): creation |
102.74 |
12043 |
18493 |
2016-05-22 07:56 |
2016-05-22 10:56 |
invoice (draft): removal |
35.15 |
2464 |
6291 |
2016-05-22 07:56 |
2016-05-22 10:56 |
invoice accept: apply |
62.02 |
21133 |
11164 |
2016-05-22 07:56 |
2016-05-22 10:56 |
invoice accept: cancel |
15.69 |
4759 |
2808 |
2016-05-22 07:56 |
2016-05-22 10:56 |
customer reserve: creation |
3025.25 |
365 |
544545 |
2016-05-22 07:56 |
2016-05-22 10:56 |
customer reserve: removal |
803.81 |
121 |
143882 |
2016-05-22 07:56 |
2016-05-22 10:56 |
realization accept: apply |
183.39 |
337 |
33010 |
2016-05-22 07:56 |
2016-05-22 10:56 |
realization accept: cancel |
52.32 |
229 |
9365 |
2016-05-22 07:56 |
2016-05-22 10:56 |
payment from customer: creation |
132.63 |
348 |
23741 |
2016-05-22 07:56 |
2016-05-22 10:56 |
payment from customer: removal |
12.86 |
101 |
2302 |
2016-05-22 07:56 |
2016-05-22 10:56 |
payment to supplier: creation |
108.42 |
775 |
19516 |
2016-05-22 07:56 |
2016-05-22 10:56 |
payment to supplier: removal |
7.45 |
155 |
1333 |
2016-05-22 07:56 |
2016-05-22 10:56 |
service: total inventory turnovers |
19.50 |
1584 |
3491 |
2016-05-22 07:56 |
2016-05-22 10:56 |
service: total monetary turnovers |
24.06 |
85 |
4307 |
2016-05-22 07:56 |
2016-05-22 10:56 |
service: refresh index statistics |
0.07 |
3353 |
11 |
2016-05-22 07:56 |
2016-05-22 10:56 |
Done for 36790 ms, from 11:00:08.99 to 11:00:45.78.
ACTION |
ITRV_NO |
CNT_OK_PER_MINUTE |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
ITRV_BEG |
ITRV_END |
interval # 1, overall |
1 |
3903 |
74682 |
70250 |
4432 |
5.93 |
07:56:01 |
08:14:01 |
interval # 2, overall |
2 |
5161 |
99118 |
92891 |
6227 |
6.28 |
08:14:02 |
08:32:02 |
interval # 3, overall |
3 |
5517 |
105523 |
99304 |
6219 |
5.89 |
08:32:03 |
08:50:03 |
interval # 4, overall |
4 |
5340 |
101929 |
96115 |
5814 |
5.70 |
08:50:04 |
09:08:04 |
interval # 5, overall |
5 |
5333 |
100060 |
95989 |
4071 |
4.07 |
09:08:05 |
09:26:05 |
interval # 6, overall |
6 |
5018 |
93003 |
90322 |
2681 |
2.88 |
09:26:06 |
09:44:06 |
interval # 7, overall |
7 |
5639 |
107064 |
101506 |
5558 |
5.19 |
09:44:07 |
10:02:07 |
interval # 8, overall |
8 |
4758 |
91408 |
85639 |
5769 |
6.31 |
10:02:08 |
10:20:08 |
interval # 9, overall |
9 |
5173 |
98351 |
93109 |
5242 |
5.33 |
10:20:09 |
10:38:09 |
interval # 10, overall |
10 |
5261 |
99320 |
94704 |
4616 |
4.65 |
10:38:10 |
10:56:10 |
Done for 73550 ms, from 11:02:21.17 to 11:03:34.72.
TEST_PHASE |
MINUTE_SINCE_TEST_START |
AVG_ESTIMATED |
MIN_TO_AVG_RATIO |
MAX_TO_AVG_RATIO |
ROWS_AGGREGATED |
DISTINCT_ATTACHMENTS |
WARM_TIME |
1 |
6355.87 |
0.6294 |
1.4267 |
2664 |
100 |
WARM_TIME |
2 |
5888.66 |
0.7702 |
1.1682 |
2832 |
100 |
WARM_TIME |
3 |
5030.65 |
0.9117 |
1.1121 |
2351 |
90 |
WARM_TIME |
4 |
4620.48 |
0.9082 |
1.0867 |
1985 |
91 |
WARM_TIME |
5 |
4397.05 |
0.9136 |
1.0750 |
1725 |
86 |
WARM_TIME |
6 |
4235.09 |
0.9301 |
1.0826 |
1850 |
93 |
WARM_TIME |
7 |
4210.24 |
0.9335 |
1.0744 |
1743 |
96 |
WARM_TIME |
8 |
4203.09 |
0.9417 |
1.0521 |
1763 |
96 |
WARM_TIME |
9 |
4133.80 |
0.9509 |
1.0600 |
1586 |
95 |
WARM_TIME |
10 |
4172.15 |
0.9452 |
1.0526 |
1674 |
96 |
TEST_TIME |
11 |
4170.61 |
0.9573 |
1.0403 |
1684 |
96 |
TEST_TIME |
12 |
4130.68 |
0.9628 |
1.0416 |
1434 |
94 |
TEST_TIME |
13 |
4102.40 |
0.9681 |
1.0251 |
1318 |
91 |
TEST_TIME |
14 |
4026.87 |
0.9698 |
1.0307 |
1381 |
92 |
TEST_TIME |
15 |
4018.49 |
0.9640 |
1.0296 |
1462 |
98 |
TEST_TIME |
16 |
3990.91 |
0.9719 |
1.0277 |
1361 |
94 |
TEST_TIME |
17 |
3964.50 |
0.9737 |
1.0287 |
1351 |
92 |
TEST_TIME |
18 |
3957.06 |
0.9734 |
1.0254 |
1365 |
97 |
TEST_TIME |
19 |
3920.02 |
0.9806 |
1.0215 |
1163 |
93 |
TEST_TIME |
20 |
3883.12 |
0.9797 |
1.0245 |
1341 |
98 |
TEST_TIME |
21 |
3867.98 |
0.9795 |
1.0191 |
1214 |
93 |
TEST_TIME |
22 |
3821.95 |
0.9845 |
1.0180 |
1187 |
88 |
TEST_TIME |
23 |
3796.45 |
0.9803 |
1.0241 |
1188 |
91 |
TEST_TIME |
24 |
3814.59 |
0.9768 |
1.0176 |
1222 |
94 |
TEST_TIME |
25 |
3837.17 |
0.9711 |
1.0234 |
1750 |
96 |
TEST_TIME |
26 |
3885.85 |
0.9717 |
1.0281 |
1750 |
96 |
TEST_TIME |
27 |
3944.25 |
0.9753 |
1.0225 |
1715 |
94 |
TEST_TIME |
28 |
3985.22 |
0.9758 |
1.0255 |
1738 |
96 |
TEST_TIME |
29 |
4034.76 |
0.9779 |
1.0229 |
1607 |
97 |
TEST_TIME |
30 |
4059.04 |
0.9829 |
1.0180 |
1448 |
93 |
TEST_TIME |
31 |
4072.19 |
0.9820 |
1.0167 |
1366 |
94 |
TEST_TIME |
32 |
4105.33 |
0.9770 |
1.0217 |
1525 |
95 |
TEST_TIME |
33 |
4154.85 |
0.9789 |
1.0160 |
1680 |
97 |
TEST_TIME |
34 |
4167.94 |
0.9831 |
1.0131 |
1455 |
95 |
TEST_TIME |
35 |
4181.29 |
0.9811 |
1.0164 |
1432 |
93 |
TEST_TIME |
36 |
4199.12 |
0.9840 |
1.0155 |
1434 |
95 |
TEST_TIME |
37 |
4209.41 |
0.9857 |
1.0133 |
1270 |
96 |
TEST_TIME |
38 |
4207.82 |
0.9870 |
1.0136 |
1202 |
95 |
TEST_TIME |
39 |
4220.74 |
0.9846 |
1.0148 |
1462 |
95 |
TEST_TIME |
40 |
4248.17 |
0.9830 |
1.0170 |
1629 |
98 |
TEST_TIME |
41 |
4300.17 |
0.9802 |
1.0184 |
1768 |
96 |
TEST_TIME |
42 |
4350.53 |
0.9826 |
1.0165 |
1835 |
96 |
TEST_TIME |
43 |
4387.94 |
0.9844 |
1.0149 |
1817 |
94 |
TEST_TIME |
44 |
4420.30 |
0.9846 |
1.0152 |
1642 |
96 |
TEST_TIME |
45 |
4429.28 |
0.9906 |
1.0112 |
1196 |
89 |
TEST_TIME |
46 |
4436.40 |
0.9877 |
1.0126 |
1318 |
93 |
TEST_TIME |
47 |
4462.85 |
0.9852 |
1.0137 |
1482 |
95 |
TEST_TIME |
48 |
4488.73 |
0.9869 |
1.0125 |
1429 |
96 |
TEST_TIME |
49 |
4499.08 |
0.9895 |
1.0109 |
1325 |
96 |
TEST_TIME |
50 |
4515.29 |
0.9871 |
1.0120 |
1559 |
96 |
TEST_TIME |
51 |
4525.38 |
0.9900 |
1.0100 |
1370 |
96 |
TEST_TIME |
52 |
4533.35 |
0.9888 |
1.0116 |
1408 |
95 |
TEST_TIME |
53 |
4550.53 |
0.9888 |
1.0111 |
1348 |
94 |
TEST_TIME |
54 |
4556.23 |
0.9912 |
1.0073 |
1398 |
90 |
TEST_TIME |
55 |
4560.83 |
0.9880 |
1.0138 |
1749 |
98 |
TEST_TIME |
56 |
4605.33 |
0.9861 |
1.0128 |
1430 |
99 |
TEST_TIME |
57 |
4643.89 |
0.9869 |
1.0131 |
1725 |
98 |
TEST_TIME |
58 |
4670.35 |
0.9900 |
1.0101 |
1717 |
95 |
TEST_TIME |
59 |
4689.26 |
0.9890 |
1.0103 |
1702 |
96 |
TEST_TIME |
60 |
4707.71 |
0.9895 |
1.0108 |
1579 |
93 |
TEST_TIME |
61 |
4719.73 |
0.9917 |
1.0089 |
1537 |
91 |
TEST_TIME |
62 |
4731.84 |
0.9901 |
1.0083 |
1433 |
92 |
TEST_TIME |
63 |
4736.17 |
0.9913 |
1.0085 |
1565 |
93 |
TEST_TIME |
64 |
4739.04 |
0.9921 |
1.0074 |
1510 |
92 |
TEST_TIME |
65 |
4742.27 |
0.9912 |
1.0092 |
1395 |
92 |
TEST_TIME |
66 |
4745.57 |
0.9932 |
1.0075 |
1365 |
95 |
TEST_TIME |
67 |
4743.70 |
0.9929 |
1.0073 |
1334 |
92 |
TEST_TIME |
68 |
4748.02 |
0.9916 |
1.0076 |
1097 |
93 |
TEST_TIME |
69 |
4753.88 |
0.9918 |
1.0078 |
1265 |
94 |
TEST_TIME |
70 |
4765.43 |
0.9910 |
1.0092 |
1530 |
97 |
TEST_TIME |
71 |
4785.88 |
0.9908 |
1.0094 |
1734 |
96 |
TEST_TIME |
72 |
4792.64 |
0.9939 |
1.0080 |
1401 |
98 |
TEST_TIME |
73 |
4798.27 |
0.9931 |
1.0083 |
1305 |
93 |
TEST_TIME |
74 |
4815.77 |
0.9910 |
1.0060 |
1255 |
94 |
TEST_TIME |
75 |
4816.97 |
0.9926 |
1.0076 |
1271 |
93 |
TEST_TIME |
76 |
4824.60 |
0.9928 |
1.0062 |
1350 |
94 |
TEST_TIME |
77 |
4826.21 |
0.9928 |
1.0090 |
1253 |
94 |
TEST_TIME |
78 |
4842.03 |
0.9928 |
1.0065 |
1251 |
92 |
TEST_TIME |
79 |
4841.17 |
0.9939 |
1.0064 |
1300 |
91 |
TEST_TIME |
80 |
4843.13 |
0.9935 |
1.0056 |
1279 |
91 |
TEST_TIME |
81 |
4847.88 |
0.9922 |
1.0056 |
1276 |
91 |
TEST_TIME |
82 |
4844.98 |
0.9940 |
1.0045 |
1257 |
90 |
TEST_TIME |
83 |
4847.15 |
0.9919 |
1.0078 |
1167 |
94 |
TEST_TIME |
84 |
4852.90 |
0.9946 |
1.0060 |
1246 |
94 |
TEST_TIME |
85 |
4859.41 |
0.9928 |
1.0070 |
1560 |
94 |
TEST_TIME |
86 |
4877.28 |
0.9916 |
1.0083 |
1464 |
96 |
TEST_TIME |
87 |
4894.22 |
0.9933 |
1.0056 |
1437 |
92 |
TEST_TIME |
88 |
4892.88 |
0.9944 |
1.0082 |
1373 |
92 |
TEST_TIME |
89 |
4904.96 |
0.9944 |
1.0052 |
1299 |
93 |
TEST_TIME |
90 |
4922.86 |
0.9905 |
1.0076 |
1382 |
94 |
TEST_TIME |
91 |
4930.31 |
0.9950 |
1.0058 |
1390 |
94 |
TEST_TIME |
92 |
4928.26 |
0.9953 |
1.0045 |
1348 |
90 |
TEST_TIME |
93 |
4924.14 |
0.9945 |
1.0069 |
1209 |
91 |
TEST_TIME |
94 |
4928.90 |
0.9952 |
1.0039 |
1186 |
93 |
TEST_TIME |
95 |
4923.06 |
0.9946 |
1.0060 |
1156 |
89 |
TEST_TIME |
96 |
4929.03 |
0.9943 |
1.0054 |
1209 |
91 |
TEST_TIME |
97 |
4933.11 |
0.9942 |
1.0060 |
1201 |
91 |
TEST_TIME |
98 |
4934.08 |
0.9956 |
1.0051 |
1211 |
90 |
TEST_TIME |
99 |
4941.11 |
0.9935 |
1.0053 |
1283 |
93 |
TEST_TIME |
100 |
4942.33 |
0.9950 |
1.0046 |
1469 |
94 |
TEST_TIME |
101 |
4942.78 |
0.9946 |
1.0065 |
1546 |
92 |
TEST_TIME |
102 |
4947.35 |
0.9957 |
1.0045 |
1452 |
93 |
TEST_TIME |
103 |
4947.08 |
0.9948 |
1.0041 |
1387 |
91 |
TEST_TIME |
104 |
4952.49 |
0.9933 |
1.0060 |
1318 |
92 |
TEST_TIME |
105 |
4954.99 |
0.9959 |
1.0047 |
1237 |
94 |
TEST_TIME |
106 |
4954.53 |
0.9953 |
1.0040 |
1276 |
92 |
TEST_TIME |
107 |
4958.98 |
0.9937 |
1.0051 |
1244 |
91 |
TEST_TIME |
108 |
4961.27 |
0.9953 |
1.0046 |
1229 |
89 |
TEST_TIME |
109 |
4956.62 |
0.9963 |
1.0039 |
1114 |
89 |
TEST_TIME |
110 |
4949.65 |
0.9962 |
1.0038 |
1132 |
86 |
TEST_TIME |
111 |
4947.18 |
0.9952 |
1.0031 |
1247 |
91 |
TEST_TIME |
112 |
4951.49 |
0.9933 |
1.0059 |
1075 |
90 |
TEST_TIME |
113 |
4958.30 |
0.9956 |
1.0047 |
1055 |
93 |
TEST_TIME |
114 |
4953.04 |
0.9970 |
1.0022 |
1125 |
91 |
TEST_TIME |
115 |
4936.60 |
0.9968 |
1.0027 |
987 |
74 |
TEST_TIME |
116 |
4938.38 |
0.9937 |
1.0059 |
1146 |
93 |
TEST_TIME |
117 |
4952.34 |
0.9945 |
1.0044 |
1239 |
98 |
TEST_TIME |
118 |
4956.91 |
0.9950 |
1.0052 |
1525 |
94 |
TEST_TIME |
119 |
4967.81 |
0.9945 |
1.0052 |
1422 |
95 |
TEST_TIME |
120 |
4969.86 |
0.9964 |
1.0044 |
1433 |
95 |
TEST_TIME |
121 |
4972.45 |
0.9956 |
1.0042 |
1318 |
93 |
TEST_TIME |
122 |
4973.55 |
0.9957 |
1.0043 |
1217 |
93 |
TEST_TIME |
123 |
4969.36 |
0.9970 |
1.0045 |
1290 |
91 |
TEST_TIME |
124 |
4974.37 |
0.9954 |
1.0040 |
1359 |
90 |
TEST_TIME |
125 |
4983.41 |
0.9942 |
1.0067 |
1356 |
95 |
TEST_TIME |
126 |
5000.39 |
0.9953 |
1.0036 |
1193 |
94 |
TEST_TIME |
127 |
5003.61 |
0.9951 |
1.0042 |
1162 |
96 |
TEST_TIME |
128 |
4998.85 |
0.9973 |
1.0031 |
1221 |
90 |
TEST_TIME |
129 |
4996.71 |
0.9957 |
1.0032 |
1191 |
90 |
TEST_TIME |
130 |
4999.33 |
0.9949 |
1.0046 |
1579 |
92 |
TEST_TIME |
131 |
5003.33 |
0.9962 |
1.0051 |
1494 |
91 |
TEST_TIME |
132 |
5009.30 |
0.9963 |
1.0036 |
1411 |
93 |
TEST_TIME |
133 |
5010.88 |
0.9958 |
1.0042 |
1363 |
92 |
TEST_TIME |
134 |
5021.35 |
0.9946 |
1.0048 |
1396 |
95 |
TEST_TIME |
135 |
5023.52 |
0.9970 |
1.0036 |
1196 |
92 |
TEST_TIME |
136 |
5028.61 |
0.9952 |
1.0055 |
1234 |
91 |
TEST_TIME |
137 |
5041.90 |
0.9955 |
1.0037 |
1187 |
88 |
TEST_TIME |
138 |
5040.78 |
0.9967 |
1.0034 |
1169 |
90 |
TEST_TIME |
139 |
5041.00 |
0.9961 |
1.0039 |
1124 |
92 |
TEST_TIME |
140 |
5048.70 |
0.9952 |
1.0041 |
1250 |
92 |
TEST_TIME |
141 |
5048.67 |
0.9970 |
1.0027 |
1220 |
90 |
TEST_TIME |
142 |
5048.52 |
0.9957 |
1.0040 |
1172 |
92 |
TEST_TIME |
143 |
5057.48 |
0.9952 |
1.0033 |
1159 |
91 |
TEST_TIME |
144 |
5052.89 |
0.9972 |
1.0022 |
1079 |
94 |
TEST_TIME |
145 |
5045.10 |
0.9968 |
1.0036 |
1250 |
89 |
TEST_TIME |
146 |
5047.38 |
0.9963 |
1.0037 |
1314 |
90 |
TEST_TIME |
147 |
5051.63 |
0.9961 |
1.0031 |
1174 |
92 |
TEST_TIME |
148 |
5042.89 |
0.9980 |
1.0017 |
1032 |
80 |
TEST_TIME |
149 |
5031.87 |
0.9972 |
1.0031 |
1121 |
85 |
TEST_TIME |
150 |
5027.78 |
0.9972 |
1.0029 |
1277 |
93 |
TEST_TIME |
151 |
5022.65 |
0.9973 |
1.0028 |
1155 |
96 |
TEST_TIME |
152 |
5022.61 |
0.9962 |
1.0029 |
1147 |
96 |
TEST_TIME |
153 |
5017.56 |
0.9974 |
1.0025 |
1128 |
92 |
TEST_TIME |
154 |
5011.82 |
0.9972 |
1.0026 |
1110 |
92 |
TEST_TIME |
155 |
5007.06 |
0.9971 |
1.0038 |
1157 |
91 |
TEST_TIME |
156 |
5009.49 |
0.9969 |
1.0028 |
1157 |
90 |
TEST_TIME |
157 |
5005.83 |
0.9971 |
1.0022 |
1137 |
89 |
TEST_TIME |
158 |
4997.98 |
0.9974 |
1.0021 |
1101 |
88 |
TEST_TIME |
159 |
4991.46 |
0.9971 |
1.0034 |
1100 |
92 |
TEST_TIME |
160 |
4992.22 |
0.9969 |
1.0030 |
1134 |
90 |
TEST_TIME |
161 |
4993.32 |
0.9966 |
1.0045 |
1183 |
92 |
TEST_TIME |
162 |
5010.38 |
0.9949 |
1.0032 |
1186 |
95 |
TEST_TIME |
163 |
5017.94 |
0.9955 |
1.0033 |
1349 |
95 |
TEST_TIME |
164 |
5015.64 |
0.9977 |
1.0029 |
1215 |
92 |
TEST_TIME |
165 |
5017.23 |
0.9965 |
1.0030 |
1368 |
90 |
TEST_TIME |
166 |
5015.53 |
0.9972 |
1.0022 |
1213 |
86 |
TEST_TIME |
167 |
5014.85 |
0.9963 |
1.0033 |
1161 |
90 |
TEST_TIME |
168 |
5016.54 |
0.9970 |
1.0033 |
1152 |
90 |
TEST_TIME |
169 |
5020.76 |
0.9966 |
1.0025 |
1046 |
89 |
TEST_TIME |
170 |
5021.48 |
0.9965 |
1.0027 |
1062 |
88 |
TEST_TIME |
171 |
5021.01 |
0.9969 |
1.0021 |
1111 |
93 |
TEST_TIME |
172 |
5015.17 |
0.9974 |
1.0033 |
1195 |
93 |
TEST_TIME |
173 |
5016.67 |
0.9972 |
1.0026 |
1235 |
91 |
TEST_TIME |
174 |
5014.96 |
0.9972 |
1.0028 |
1106 |
87 |
TEST_TIME |
175 |
5017.43 |
0.9966 |
1.0030 |
1203 |
83 |
TEST_TIME |
176 |
5024.38 |
0.9960 |
1.0039 |
1312 |
88 |
TEST_TIME |
177 |
5031.58 |
0.9968 |
1.0039 |
1406 |
92 |
TEST_TIME |
178 |
5038.18 |
0.9970 |
1.0034 |
1239 |
92 |
TEST_TIME |
179 |
5042.12 |
0.9970 |
1.0035 |
1336 |
94 |
TEST_TIME |
180 |
5054.80 |
0.9954 |
1.0037 |
1263 |
94 |
TEST_TIME |
181 |
5058.83 |
0.9974 |
1.0021 |
1193 |
91 |
TEST_TIME |
182 |
5051.66 |
0.9980 |
1.0021 |
1228 |
87 |
TEST_TIME |
183 |
5051.13 |
0.9967 |
1.0026 |
1136 |
88 |
TEST_TIME |
184 |
5049.00 |
0.9976 |
1.0021 |
1145 |
89 |
TEST_TIME |
185 |
5056.97 |
0.9951 |
1.0031 |
1230 |
91 |
TEST_TIME |
186 |
5056.97 |
0.9977 |
1.0020 |
1009 |
87 |
TEST_TIME |
187 |
5059.47 |
0.9961 |
1.0025 |
1076 |
92 |
TEST_TIME |
188 |
5056.86 |
0.9977 |
1.0026 |
1004 |
87 |
TEST_TIME |
189 |
5058.31 |
0.9970 |
1.0026 |
1067 |
91 |
TEST_TIME |
190 |
5048.27 |
0.9993 |
1.0015 |
200 |
100 |
Done for 8690 ms, from 11:03:37.06 to 11:03:45.75.
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 |
1740 |
4723 |
5277 |
<null> |
4683 |
2810 |
6597 |
3571 |
5124 |
4145 |
3359 |
2994 |
11449 |
4909 |
17858 |
3008 |
356711 |
206318 |
<null> |
07:56:01 |
08:14:01 |
fetches per second |
2 |
1926 |
4531 |
4730 |
<null> |
5202 |
4497 |
5404 |
4348 |
6714 |
<null> |
3818 |
3649 |
18107 |
<null> |
23630 |
3300 |
327001 |
203114 |
<null> |
08:14:02 |
08:32:02 |
fetches per second |
3 |
1909 |
7021 |
3827 |
<null> |
4027 |
2734 |
4720 |
4515 |
5056 |
3251 |
2845 |
3610 |
14457 |
3331 |
14876 |
3079 |
310634 |
180765 |
<null> |
08:32:03 |
08:50:03 |
fetches per second |
4 |
1822 |
6028 |
4975 |
3782 |
4813 |
3232 |
6326 |
<null> |
6331 |
3634 |
5021 |
3855 |
16061 |
5635 |
22321 |
3577 |
365858 |
268145 |
<null> |
08:50:04 |
09:08:04 |
fetches per second |
5 |
1719 |
5114 |
5008 |
3343 |
5650 |
<null> |
6659 |
3029 |
6232 |
4519 |
3470 |
3656 |
21747 |
3337 |
29497 |
2202 |
451448 |
177766 |
<null> |
09:08:05 |
09:26:05 |
fetches per second |
6 |
1705 |
7785 |
6150 |
<null> |
7343 |
2930 |
6626 |
4170 |
7980 |
4116 |
4288 |
3050 |
33450 |
3249 |
30163 |
<null> |
394199 |
394922 |
<null> |
09:26:06 |
09:44:06 |
fetches per second |
7 |
1863 |
5363 |
4312 |
4024 |
5870 |
<null> |
5416 |
4057 |
<null> |
3900 |
5391 |
2284 |
17639 |
2883 |
17543 |
<null> |
369309 |
273303 |
<null> |
09:44:07 |
10:02:07 |
fetches per second |
8 |
1654 |
6007 |
7039 |
3970 |
7352 |
4290 |
7687 |
<null> |
8599 |
4023 |
5443 |
4333 |
26025 |
3280 |
30285 |
3715 |
463814 |
319158 |
<null> |
10:02:08 |
10:20:08 |
fetches per second |
9 |
1741 |
4743 |
6877 |
<null> |
6791 |
3443 |
6367 |
3140 |
4118 |
4767 |
5776 |
2632 |
33545 |
3731 |
20181 |
<null> |
423110 |
326554 |
<null> |
10:20:09 |
10:38:09 |
fetches per second |
10 |
1743 |
3950 |
5704 |
4371 |
5818 |
3631 |
5009 |
4054 |
5946 |
3595 |
7120 |
3072 |
21610 |
3352 |
21679 |
3459 |
508154 |
237147 |
<null> |
10:38:10 |
10:56:10 |
marks per second |
1 |
309 |
455 |
266 |
<null> |
245 |
415 |
354 |
388 |
340 |
528 |
411 |
372 |
481 |
482 |
469 |
294 |
1100 |
290 |
<null> |
07:56:01 |
08:14:01 |
marks per second |
2 |
333 |
455 |
283 |
<null> |
297 |
462 |
438 |
491 |
420 |
<null> |
452 |
448 |
1177 |
<null> |
534 |
372 |
1529 |
520 |
<null> |
08:14:02 |
08:32:02 |
marks per second |
3 |
331 |
707 |
280 |
<null> |
328 |
429 |
376 |
512 |
447 |
425 |
465 |
398 |
531 |
369 |
593 |
355 |
12140 |
414 |
<null> |
08:32:03 |
08:50:03 |
marks per second |
4 |
315 |
575 |
272 |
511 |
299 |
543 |
414 |
<null> |
390 |
435 |
558 |
415 |
482 |
579 |
541 |
455 |
1164 |
607 |
<null> |
08:50:04 |
09:08:04 |
marks per second |
5 |
296 |
521 |
238 |
561 |
265 |
<null> |
408 |
378 |
355 |
544 |
389 |
401 |
424 |
447 |
504 |
338 |
1073 |
361 |
<null> |
09:08:05 |
09:26:05 |
marks per second |
6 |
299 |
678 |
265 |
<null> |
254 |
440 |
423 |
460 |
457 |
516 |
404 |
345 |
381 |
348 |
480 |
<null> |
1028 |
351 |
<null> |
09:26:06 |
09:44:06 |
marks per second |
7 |
312 |
530 |
271 |
493 |
399 |
<null> |
384 |
488 |
<null> |
449 |
398 |
292 |
463 |
320 |
434 |
<null> |
1300 |
692 |
<null> |
09:44:07 |
10:02:07 |
marks per second |
8 |
280 |
554 |
249 |
512 |
247 |
546 |
382 |
<null> |
449 |
379 |
342 |
467 |
418 |
388 |
425 |
423 |
1005 |
509 |
<null> |
10:02:08 |
10:20:08 |
marks per second |
9 |
297 |
461 |
245 |
<null> |
296 |
392 |
379 |
358 |
298 |
512 |
379 |
269 |
435 |
479 |
489 |
<null> |
909 |
427 |
<null> |
10:20:09 |
10:38:09 |
marks per second |
10 |
298 |
419 |
243 |
517 |
258 |
754 |
409 |
461 |
370 |
447 |
457 |
359 |
415 |
390 |
432 |
337 |
691 |
419 |
<null> |
10:38:10 |
10:56:10 |
reads/fetches*100 |
1 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
07:56:01 |
08:14:01 |
reads/fetches*100 |
2 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
<null> |
08:14:02 |
08:32:02 |
reads/fetches*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
08:32:03 |
08:50:03 |
reads/fetches*100 |
4 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
08:50:04 |
09:08:04 |
reads/fetches*100 |
5 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
09:08:05 |
09:26:05 |
reads/fetches*100 |
6 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
09:26:06 |
09:44:06 |
reads/fetches*100 |
7 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
09:44:07 |
10:02:07 |
reads/fetches*100 |
8 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
10:02:08 |
10:20:08 |
reads/fetches*100 |
9 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
10:20:09 |
10:38:09 |
reads/fetches*100 |
10 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
10:38:10 |
10:56:10 |
writes/marks*100 |
1 |
1 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
3 |
0 |
<null> |
07:56:01 |
08:14:01 |
writes/marks*100 |
2 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
4 |
0 |
<null> |
08:14:02 |
08:32:02 |
writes/marks*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
4 |
0 |
<null> |
08:32:03 |
08:50:03 |
writes/marks*100 |
4 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
3 |
0 |
<null> |
08:50:04 |
09:08:04 |
writes/marks*100 |
5 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
4 |
0 |
<null> |
09:08:05 |
09:26:05 |
writes/marks*100 |
6 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
4 |
0 |
<null> |
09:26:06 |
09:44:06 |
writes/marks*100 |
7 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
3 |
0 |
<null> |
09:44:07 |
10:02:07 |
writes/marks*100 |
8 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
1 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
3 |
0 |
<null> |
10:02:08 |
10:20:08 |
writes/marks*100 |
9 |
1 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
<null> |
3 |
3 |
<null> |
10:20:09 |
10:38:09 |
writes/marks*100 |
10 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
2 |
0 |
0 |
0 |
0 |
4 |
0 |
<null> |
10:38:10 |
10:56:10 |
Done for 8610 ms, from 11:03:46.53 to 11:03:55.14.
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 |
1549043 |
1507460 |
41583 |
2.68 |
0 |
18268 |
28 |
41583 |
2016-05-22 07:56 |
2016-05-22 10:56 |
doc_list_biud |
1549427 |
1507457 |
41970 |
2.70 |
0 |
9053 |
36 |
41970 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_add_invoice_to_stock |
17168 |
11164 |
6004 |
34.97 |
250 |
149248 |
21133 |
6004 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_cancel_adding_invoice |
3398 |
2808 |
590 |
17.36 |
124 |
104930 |
4759 |
590 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_cancel_client_order |
5846 |
5556 |
290 |
4.96 |
15 |
265 |
75 |
290 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_cancel_customer_reserve |
181526 |
143882 |
37644 |
20.73 |
0 |
2574 |
121 |
37644 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_cancel_pay_from_customer |
2334 |
2302 |
32 |
1.37 |
15 |
1295 |
101 |
32 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_cancel_pay_to_supplier |
1373 |
1333 |
40 |
2.91 |
0 |
811 |
155 |
40 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_cancel_supplier_invoice |
7512 |
6291 |
1221 |
16.25 |
15 |
8518 |
2464 |
1221 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_cancel_supplier_order |
1399 |
416 |
983 |
70.26 |
46 |
402354 |
74030 |
983 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_cancel_write_off |
12293 |
9365 |
2928 |
23.81 |
0 |
7456 |
229 |
2928 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_client_order |
71301 |
71301 |
0 |
0.00 |
47 |
4125 |
1076 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_customer_reserve |
544545 |
544545 |
0 |
0.00 |
0 |
6555 |
365 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_fill_shopping_cart |
108091 |
108091 |
0 |
0.00 |
0 |
18159 |
257 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_fill_shopping_cart_clo_res |
544545 |
544545 |
0 |
0.00 |
0 |
249 |
1 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_get_clo_for_invoice |
11164 |
11164 |
0 |
0.00 |
0 |
7956 |
1084 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_kill_cost_storno |
19097 |
15810 |
3287 |
17.21 |
0 |
7176 |
86 |
3287 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_kill_qstorno_ret_qs2qd |
382565 |
303837 |
78728 |
20.57 |
0 |
8424 |
103 |
78728 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_kill_qty_storno |
254351 |
212494 |
41857 |
16.45 |
0 |
9053 |
253 |
41857 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_lock_selected_doc |
70520 |
61445 |
9075 |
12.86 |
0 |
69 |
3 |
9075 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_make_cost_storno |
87431 |
87431 |
0 |
0.00 |
0 |
18128 |
277 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_multiply_rows_for_pdistr |
87431 |
87431 |
0 |
0.00 |
0 |
608 |
154 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_multiply_rows_for_qdistr |
71305 |
71305 |
0 |
0.00 |
0 |
3541 |
803 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_pay_from_customer |
23741 |
23741 |
0 |
0.00 |
47 |
10401 |
348 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_pay_to_supplier |
19516 |
19516 |
0 |
0.00 |
109 |
9859 |
775 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_payment_common |
43257 |
43257 |
0 |
0.00 |
0 |
5913 |
31 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_qd_handle_on_cancel_clo |
5845 |
5556 |
289 |
4.94 |
0 |
234 |
51 |
289 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_qd_handle_on_invoice_upd_sts |
14388 |
13974 |
414 |
2.87 |
0 |
9053 |
1227 |
414 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_qd_handle_on_reserve_upd_sts |
33012 |
33010 |
2 |
0.00 |
0 |
1950 |
129 |
2 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_reserve_write_off |
33907 |
33010 |
897 |
2.64 |
47 |
18393 |
337 |
897 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_supplier_invoice |
18493 |
18493 |
0 |
0.00 |
94 |
45275 |
12043 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
sp_supplier_order |
18297 |
18297 |
0 |
0.00 |
109 |
26484 |
7793 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
srv_find_qd_qs_mism |
878079 |
836557 |
41522 |
4.72 |
0 |
577 |
1 |
41522 |
2016-05-22 07:56 |
2016-05-22 10:56 |
srv_make_invnt_saldo |
3491 |
3491 |
0 |
0.00 |
249 |
69790 |
1584 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
srv_make_money_saldo |
4307 |
4307 |
0 |
0.00 |
15 |
6365 |
85 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
srv_recalc_idx_stat |
11 |
11 |
0 |
0.00 |
2590 |
4120 |
3353 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-abend:sp_add_invoice_to_stock |
6004 |
6004 |
0 |
0.00 |
46 |
484 |
149 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-abend:sp_cancel_adding_invoice |
442 |
442 |
0 |
0.00 |
62 |
3026 |
1140 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-abend:sp_cancel_client_order |
290 |
290 |
0 |
0.00 |
109 |
422 |
235 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-abend:sp_cancel_customer_reserve |
69 |
69 |
0 |
0.00 |
78 |
255 |
154 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-abend:sp_cancel_pay_from_customer |
32 |
32 |
0 |
0.00 |
124 |
390 |
233 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-abend:sp_cancel_pay_to_supplier |
40 |
40 |
0 |
0.00 |
132 |
344 |
231 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-abend:sp_cancel_supplier_invoice |
483 |
483 |
0 |
0.00 |
62 |
281 |
149 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-abend:sp_cancel_supplier_order |
5328 |
5328 |
0 |
0.00 |
0 |
3167 |
1600 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-abend:sp_cancel_write_off |
75 |
75 |
0 |
0.00 |
78 |
297 |
149 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-abend:sp_reserve_write_off |
897 |
897 |
0 |
0.00 |
62 |
359 |
151 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-norm:sp_add_invoice_to_stock |
11185 |
11185 |
0 |
0.00 |
405 |
46912 |
11352 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-norm:sp_cancel_adding_invoice |
1134 |
1134 |
0 |
0.00 |
250 |
36997 |
9645 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-norm:sp_cancel_client_order |
5556 |
5556 |
0 |
0.00 |
125 |
608 |
265 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-norm:sp_cancel_customer_reserve |
2315 |
2315 |
0 |
0.00 |
32 |
640 |
295 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-norm:sp_cancel_pay_from_customer |
2302 |
2302 |
0 |
0.00 |
78 |
468 |
205 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-norm:sp_cancel_pay_to_supplier |
1333 |
1333 |
0 |
0.00 |
78 |
468 |
207 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-norm:sp_cancel_supplier_invoice |
926 |
926 |
0 |
0.00 |
125 |
655 |
265 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-norm:sp_cancel_supplier_order |
416 |
416 |
0 |
0.00 |
234 |
369142 |
51549 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-norm:sp_cancel_write_off |
3291 |
3291 |
0 |
0.00 |
140 |
608 |
293 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-norm:sp_client_order |
71307 |
71307 |
0 |
0.00 |
78 |
827 |
355 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-norm:sp_customer_reserve |
3252 |
3252 |
0 |
0.00 |
62 |
608 |
195 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-norm:sp_pay_from_customer |
23741 |
23741 |
0 |
0.00 |
94 |
624 |
236 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-norm:sp_pay_to_supplier |
19518 |
19518 |
0 |
0.00 |
62 |
671 |
238 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-norm:sp_reserve_write_off |
33010 |
33010 |
0 |
0.00 |
125 |
764 |
326 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-norm:sp_supplier_invoice |
18513 |
18513 |
0 |
0.00 |
0 |
764 |
356 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-norm:sp_supplier_order |
18315 |
18315 |
0 |
0.00 |
156 |
749 |
357 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-norm:srv_make_invnt_saldo |
3492 |
3492 |
0 |
0.00 |
0 |
171 |
30 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-norm:srv_make_money_saldo |
4307 |
4307 |
0 |
0.00 |
0 |
203 |
31 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
t$perf-norm:srv_recalc_idx_stat |
11 |
11 |
0 |
0.00 |
1030 |
1466 |
1228 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
v_add_invoice_to_stock |
34336 |
22328 |
12008 |
34.97 |
0 |
110 |
6 |
12008 |
2016-05-22 07:56 |
2016-05-22 10:56 |
v_all_customers |
107176 |
107176 |
0 |
0.00 |
0 |
140 |
5 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
v_all_suppliers |
74646 |
74646 |
0 |
0.00 |
0 |
125 |
6 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
v_all_wares |
142602 |
142602 |
0 |
0.00 |
0 |
141 |
9 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
v_cancel_adding_invoice |
2668 |
2264 |
404 |
15.14 |
0 |
375 |
61 |
404 |
2016-05-22 07:56 |
2016-05-22 10:56 |
v_cancel_client_order |
11692 |
11112 |
580 |
4.96 |
0 |
62 |
4 |
580 |
2016-05-22 07:56 |
2016-05-22 10:56 |
v_cancel_customer_prepayment |
4668 |
4604 |
64 |
1.37 |
0 |
125 |
5 |
64 |
2016-05-22 07:56 |
2016-05-22 10:56 |
v_cancel_customer_reserve |
4768 |
4630 |
138 |
2.89 |
0 |
109 |
6 |
138 |
2016-05-22 07:56 |
2016-05-22 10:56 |
v_cancel_payment_to_supplier |
2746 |
2666 |
80 |
2.91 |
0 |
63 |
6 |
80 |
2016-05-22 07:56 |
2016-05-22 10:56 |
v_cancel_supplier_invoice |
2818 |
1852 |
966 |
34.27 |
0 |
93 |
7 |
966 |
2016-05-22 07:56 |
2016-05-22 10:56 |
v_cancel_supplier_order |
2798 |
832 |
1966 |
70.26 |
0 |
46 |
6 |
1966 |
2016-05-22 07:56 |
2016-05-22 10:56 |
v_cancel_write_off |
6732 |
6582 |
150 |
2.22 |
0 |
453 |
36 |
150 |
2016-05-22 07:56 |
2016-05-22 10:56 |
v_max_id_clo_ord |
18297 |
18297 |
0 |
0.00 |
0 |
1558 |
19 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
v_max_id_clo_res |
3252 |
3252 |
0 |
0.00 |
0 |
280 |
22 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
v_max_id_ord_sup |
18493 |
18493 |
0 |
0.00 |
0 |
999 |
18 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
v_max_non_paid_invoice |
18983 |
18983 |
0 |
0.00 |
0 |
202 |
8 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
v_max_non_paid_realizn |
23741 |
23741 |
0 |
0.00 |
0 |
110 |
6 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
v_min_id_clo_ord |
18297 |
18297 |
0 |
0.00 |
0 |
1404 |
13 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
v_min_id_clo_res |
3252 |
3252 |
0 |
0.00 |
0 |
983 |
11 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
v_min_id_ord_sup |
18493 |
18493 |
0 |
0.00 |
0 |
655 |
14 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
v_min_non_paid_invoice |
19516 |
19516 |
0 |
0.00 |
0 |
5897 |
19 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
v_min_non_paid_realizn |
23741 |
23741 |
0 |
0.00 |
0 |
468 |
5 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
v_our_firm |
35426 |
35426 |
0 |
0.00 |
0 |
109 |
5 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
v_reserve_write_off |
67814 |
66020 |
1794 |
2.64 |
0 |
125 |
5 |
1794 |
2016-05-22 07:56 |
2016-05-22 10:56 |
x_lock_depdocs_on_canc_invoice |
12292 |
8173 |
4119 |
33.50 |
0 |
1045 |
8 |
4119 |
2016-05-22 07:56 |
2016-05-22 10:56 |
x_lock_depdocs_on_canc_sup_ord |
1396 |
416 |
980 |
70.20 |
0 |
109 |
5 |
980 |
2016-05-22 07:56 |
2016-05-22 10:56 |
x_make_qstorno_1000_1200 |
18298 |
18298 |
0 |
0.00 |
63 |
25158 |
7123 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
x_make_qstorno_1200_2000 |
18494 |
18494 |
0 |
0.00 |
62 |
44339 |
11419 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
x_make_qstorno_2100_3300 |
544545 |
544545 |
0 |
0.00 |
0 |
6540 |
362 |
0 |
2016-05-22 07:56 |
2016-05-22 10:56 |
Done for 135280 ms, from 11:06:03.26 to 11:08:18.54.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
DTS_BEG |
DTS_END |
deadlock |
145 |
sp_kill_cost_storno |
335544336 |
2016-05-22 07:56 |
2016-05-22 10:50 |
deadlock |
16 |
sp_kill_qstorno_ret_qs2qd |
335544336 |
2016-05-22 07:58 |
2016-05-22 10:55 |
deadlock |
121 |
sp_lock_selected_doc |
335544336 |
2016-05-22 07:56 |
2016-05-22 10:55 |
deadlock |
289 |
sp_qd_handle_on_cancel_clo |
335544336 |
2016-05-22 07:56 |
2016-05-22 10:55 |
deadlock |
57 |
sp_qd_handle_on_invoice_upd_sts |
335544336 |
2016-05-22 07:56 |
2016-05-22 10:54 |
deadlock |
2 |
sp_qd_handle_on_reserve_upd_sts |
335544336 |
2016-05-22 08:33 |
2016-05-22 08:33 |
concurrent_transaction |
7431 |
sp_lock_selected_doc |
335544878 |
2016-05-22 07:56 |
2016-05-22 10:56 |
concurrent_transaction |
485 |
x_lock_depdocs_on_canc_invoice |
335544878 |
2016-05-22 07:56 |
2016-05-22 10:53 |
concurrent_transaction |
527 |
x_lock_depdocs_on_canc_sup_ord |
335544878 |
2016-05-22 07:56 |
2016-05-22 10:55 |
Done for 4290 ms, from 11:08:23.03 to 11:08:27.32.
MON$DATABASE_NAME D:\OLTP-EMUL\OLTP40-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 342051
MON$OLDEST_ACTIVE 342052
MON$OLDEST_SNAPSHOT 342052
MON$NEXT_TRANSACTION 342052
MON$PAGE_BUFFERS 786432
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2015-12-11 13:07:49.8140
MON$PAGES 730368
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-T4.0.0.202 Firebird 4.0 Unstable
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.202 Firebird 4.0 Unstable"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T4.0.0.202 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P13"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T4.0.0.202 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P13"
on disk structure version 12.0
Database "D:\OLTP-EMUL\OLTP40-SMALL.FDB"
Database header page information:
Flags 0
Generation 342375
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 342053
Oldest active 342054
Oldest snapshot 342054
Next transaction 342055
Sequence number 0
Next attachment ID 5180
Implementation HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Dec 11, 2015 13:07:49
Attributes force write
Variable header data:
Sweep interval: 0
*END*
Database file sequence:
File D:\OLTP-EMUL\OLTP40-SMALL.FDB is the only file
Analyzing database pages ...
AGENTS (154)
Primary pointer page: 311, Index root page: 312
Total formats: 1, used formats: 1
Average record length: 34.24, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 344.00, compression ratio: 10.05
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_ID_DESC (2)
Root page: 322, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_OUR_FIRM (4)
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 48
Average key length: 2.04, compression ratio: 0.50
Average prefix length: 0.96, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_SUPPLIER (3)
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 45
Average key length: 2.04, compression ratio: 0.53
Average prefix length: 1.02, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_NAME_UNQ (1)
Root page: 321, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.92, total dup: 0, max dup: 0
Average key length: 16.60, compression ratio: 0.92
Average prefix length: 1.34, average data length: 13.92
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_AGENTS (0)
Root page: 320, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BUSINESS_OPS (158)
Primary pointer page: 332, Index root page: 333
Total formats: 1, used formats: 1
Average record length: 103.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 996.00, compression ratio: 9.67
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 28%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BO_UNIT_UNQ (1)
Root page: 336, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 18.00, total dup: 0, max dup: 0
Average key length: 16.95, compression ratio: 1.25
Average prefix length: 7.21, average data length: 14.00
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BUSINESS_OPS_RND_WGTH (2)
Root page: 337, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 4.05, total dup: 7, max dup: 3
Average key length: 3.00, compression ratio: 0.75
Average prefix length: 1.42, average data length: 0.84
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$1 (0)
Root page: 335, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 5.26, total dup: 0, max dup: 0
Average key length: 4.21, compression ratio: 0.64
Average prefix length: 1.05, average data length: 1.63
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DOC_DATA (141)
Primary pointer page: 251, Index root page: 252
Total formats: 1, used formats: 1
Average record length: 46.37, total records: 1725410
Average version length: 47.82, total versions: 28563, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.38
Pointer pages: 12, data page slots: 18888
Data pages: 18888, average fill: 72%
Primary pages: 18888, secondary pages: 0, swept pages: 5772
Empty pages: 7, full pages: 13327
Fill distribution:
0 - 19% = 8
20 - 39% = 3
40 - 59% = 51
60 - 79% = 18822
80 - 99% = 4
Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 19783, depth: 3, leaf buckets: 7929, nodes: 1725410
Average node length: 19.99, total dup: 0, max dup: 0
Average key length: 17.04, compression ratio: 1.58
Average prefix length: 12.95, average data length: 14.05
Clustering factor: 686540, ratio: 0.40
Fill distribution:
0 - 19% = 261
20 - 39% = 538
40 - 59% = 4878
60 - 79% = 1591
80 - 99% = 661
Index DOC_DATA_ID_DESC (2)
Root page: 46992, depth: 3, leaf buckets: 5820, nodes: 1725410
Average node length: 11.65, 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: 638957, ratio: 0.37
Fill distribution:
0 - 19% = 0
20 - 39% = 1778
40 - 59% = 4041
60 - 79% = 1
80 - 99% = 0
Index FK_DOC_DATA_DOC_LIST (3)
Root page: 152718, depth: 3, leaf buckets: 3172, nodes: 1725410
Average node length: 7.17, total dup: 1172398, max dup: 49
Average key length: 4.23, compression ratio: 2.13
Average prefix length: 7.09, average data length: 1.91
Clustering factor: 643963, ratio: 0.37
Fill distribution:
0 - 19% = 69
20 - 39% = 503
40 - 59% = 2313
60 - 79% = 79
80 - 99% = 208
DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 59.26, total records: 602875
Average version length: 60.87, total versions: 14718, max versions: 4
Average fragment length: 7.66, total fragments: 50, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.62
Pointer pages: 5, data page slots: 7688
Data pages: 7688, average fill: 75%
Primary pages: 7685, secondary pages: 3, swept pages: 2267
Empty pages: 0, full pages: 6592
Fill distribution:
0 - 19% = 4
20 - 39% = 10
40 - 59% = 16
60 - 79% = 7296
80 - 99% = 362
Index DOC_LIST_ID_DESC (1)
Root page: 233711, depth: 3, leaf buckets: 2170, nodes: 602875
Average node length: 11.77, total dup: 0, max dup: 0
Average key length: 8.91, compression ratio: 1.01
Average prefix length: 3.09, average data length: 5.91
Clustering factor: 178215, ratio: 0.30
Fill distribution:
0 - 19% = 0
20 - 39% = 1068
40 - 59% = 1099
60 - 79% = 3
80 - 99% = 0
Index FK_DOC_LIST_AGENTS (2)
Root page: 2964, depth: 2, leaf buckets: 723, nodes: 602875
Average node length: 4.87, total dup: 602825, max dup: 45847
Average key length: 2.01, compression ratio: 4.47
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 283061, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 668
60 - 79% = 30
80 - 99% = 25
Index PK_DOC_LIST (0)
Root page: 248488, depth: 3, leaf buckets: 2137, nodes: 602875
Average node length: 11.77, total dup: 0, max dup: 0
Average key length: 8.91, compression ratio: 1.01
Average prefix length: 3.09, average data length: 5.91
Clustering factor: 178215, ratio: 0.30
Fill distribution:
0 - 19% = 58
20 - 39% = 1020
40 - 59% = 976
60 - 79% = 10
80 - 99% = 73
DOC_STATES (153)
Primary pointer page: 309, Index root page: 310
Total formats: 1, used formats: 1
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 650.00, compression ratio: 9.63
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_MCODE_UNQ (1)
Root page: 318, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 17.75, total dup: 0, max dup: 0
Average key length: 16.50, compression ratio: 1.08
Average prefix length: 4.00, average data length: 13.75
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_NAME_UNQ (2)
Root page: 319, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 33.25, total dup: 0, max dup: 0
Average key length: 32.00, compression ratio: 0.99
Average prefix length: 2.50, average data length: 29.25
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_DOC_STATES (0)
Root page: 317, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 4.75, total dup: 0, max dup: 0
Average key length: 3.50, compression ratio: 0.86
Average prefix length: 1.50, average data length: 1.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
FB_ERRORS (159)
Primary pointer page: 338, Index root page: 339
Total formats: 1, used formats: 1
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 148.00, compression ratio: 1.86
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 56%
Primary pages: 16, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 11
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7
Index FB_ERRORS_GDS_CODE (0)
Root page: 340, depth: 1, leaf buckets: 1, nodes: 758
Average node length: 4.24, total dup: 0, max dup: 0
Average key length: 3.04, compression ratio: 1.64
Average prefix length: 3.97, average data length: 1.03
Clustering factor: 353, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
INVNT_SALDO (147)
Primary pointer page: 269, Index root page: 270
Total formats: 1, used formats: 1
Average record length: 64.28, total records: 400
Average version length: 14.80, total versions: 905272, max versions: 2392
Average fragment length: 17.61, total fragments: 393, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.62
Pointer pages: 3, data page slots: 4664
Data pages: 4664, average fill: 78%
Primary pages: 9, secondary pages: 4655, swept pages: 0
Empty pages: 5, full pages: 4657
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 0
60 - 79% = 3336
80 - 99% = 1322
Index PK_INVNT_SALDO (0)
Root page: 281, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 262, ratio: 0.66
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
INVNT_TURNOVER_LOG (157)
Primary pointer page: 330, Index root page: 331
Total formats: 1, used formats: 1
Average record length: 2.46, total records: 139330
Average version length: 71.12, total versions: 134520, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 39.03
Pointer pages: 4, data page slots: 6136
Data pages: 3669, average fill: 51%
Primary pages: 3669, secondary pages: 0, swept pages: 213
Empty pages: 241, full pages: 1580
Fill distribution:
0 - 19% = 988
20 - 39% = 593
40 - 59% = 350
60 - 79% = 609
80 - 99% = 1129
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 132706, depth: 3, leaf buckets: 453, nodes: 139330
Average node length: 14.13, total dup: 7789, max dup: 3
Average key length: 11.32, compression ratio: 2.39
Average prefix length: 18.62, average data length: 8.38
Clustering factor: 120737, ratio: 0.87
Fill distribution:
0 - 19% = 3
20 - 39% = 89
40 - 59% = 183
60 - 79% = 169
80 - 99% = 9
MONEY_SALDO (143)
Primary pointer page: 261, Index root page: 262
Total formats: 1, used formats: 1
Average record length: 15.10, total records: 49
Average version length: 9.01, total versions: 52403, max versions: 4078
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 2.12
Pointer pages: 1, data page slots: 184
Data pages: 184, average fill: 91%
Primary pages: 4, secondary pages: 180, swept pages: 0
Empty pages: 3, full pages: 180
Fill distribution:
0 - 19% = 3
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 180
Index PK_MONEY_SALDO (0)
Root page: 272, depth: 1, leaf buckets: 1, nodes: 49
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MONEY_TURNOVER_LOG (142)
Primary pointer page: 259, Index root page: 260
Total formats: 1, used formats: 1
Average record length: 0.73, total records: 5429
Average version length: 45.46, total versions: 5345, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 87.96
Pointer pages: 1, data page slots: 192
Data pages: 127, average fill: 45%
Primary pages: 127, secondary pages: 0, swept pages: 8
Empty pages: 8, full pages: 52
Fill distribution:
0 - 19% = 62
20 - 39% = 5
40 - 59% = 2
60 - 79% = 14
80 - 99% = 44
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 106827, depth: 2, leaf buckets: 7, nodes: 5429
Average node length: 4.15, total dup: 5344, max dup: 1006
Average key length: 2.20, compression ratio: 8.66
Average prefix length: 18.82, average data length: 0.18
Clustering factor: 2178, ratio: 0.40
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 4
60 - 79% = 1
80 - 99% = 0
MON_LOG (164)
Primary pointer page: 352, Index root page: 353
Total formats: 2, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_DTS (4)
Root page: 363, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_GDSCODE (2)
Root page: 361, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_ROWSET_DESC (1)
Root page: 360, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_UNIT (3)
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG (0)
Root page: 359, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG_TABLE_STATS (165)
Primary pointer page: 364, Index root page: 365
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_DTS (4)
Root page: 370, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_GDSCODE (2)
Root page: 368, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_ROWSET (1)
Root page: 367, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_TN_UNIT (3)
Root page: 369, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG_TABLE_STATS (0)
Root page: 366, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
OPTYPES (138)
Primary pointer page: 239, Index root page: 240
Total formats: 1, used formats: 1
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 5.54
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 9%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OPTYPES_MCODE_UNQ (1)
Root page: 242, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 8.56, total dup: 0, max dup: 0
Average key length: 6.89, compression ratio: 0.73
Average prefix length: 0.44, average data length: 4.56
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_OPTYPES (0)
Root page: 241, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 6.11, total dup: 0, max dup: 0
Average key length: 5.00, compression ratio: 0.60
Average prefix length: 0.89, average data length: 2.11
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PDISTR (150)
Primary pointer page: 293, Index root page: 294
Total formats: 1, used formats: 1
Average record length: 22.30, total records: 608760
Average version length: 42.80, total versions: 34064, max versions: 70
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 2.87
Pointer pages: 3, data page slots: 4408
Data pages: 4408, average fill: 73%
Primary pages: 4397, secondary pages: 11, swept pages: 1183
Empty pages: 5, full pages: 3112
Fill distribution:
0 - 19% = 9
20 - 39% = 31
40 - 59% = 417
60 - 79% = 3170
80 - 99% = 781
Index PDISTR_AGENT_ID (4)
Root page: 3600, depth: 2, leaf buckets: 291, nodes: 274501
Average node length: 4.76, total dup: 274452, max dup: 12839
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 39521, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 31
40 - 59% = 173
60 - 79% = 70
80 - 99% = 16
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4281, depth: 2, leaf buckets: 321, nodes: 274501
Average node length: 5.76, total dup: 246294, max dup: 40
Average key length: 3.01, compression ratio: 7.31
Average prefix length: 21.09, average data length: 0.91
Clustering factor: 45446, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 35
40 - 59% = 121
60 - 79% = 116
80 - 99% = 49
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3974, depth: 2, leaf buckets: 323, nodes: 274501
Average node length: 5.76, total dup: 246294, max dup: 40
Average key length: 3.01, compression ratio: 7.31
Average prefix length: 21.09, average data length: 0.91
Clustering factor: 45802, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 37
40 - 59% = 122
60 - 79% = 107
80 - 99% = 57
Index PDISTR_SND_ID (1)
Root page: 4313, depth: 2, leaf buckets: 329, nodes: 274501
Average node length: 5.53, total dup: 246294, max dup: 40
Average key length: 2.78, compression ratio: 3.24
Average prefix length: 8.32, average data length: 0.68
Clustering factor: 45868, ratio: 0.17
Fill distribution:
0 - 19% = 4
20 - 39% = 46
40 - 59% = 144
60 - 79% = 96
80 - 99% = 39
PERF_ESTIMATED (160)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 27.89, total records: 258895
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 1.15
Pointer pages: 2, data page slots: 2248
Data pages: 2248, average fill: 63%
Primary pages: 2248, secondary pages: 0, swept pages: 0
Empty pages: 34, full pages: 2209
Fill distribution:
0 - 19% = 38
20 - 39% = 0
40 - 59% = 1
60 - 79% = 2209
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 65175, depth: 2, leaf buckets: 202, nodes: 258895
Average node length: 4.50, total dup: 258704, max dup: 2831
Average key length: 2.00, compression ratio: 1.28
Average prefix length: 2.56, average data length: 0.00
Clustering factor: 62579, ratio: 0.24
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 41
60 - 79% = 102
80 - 99% = 58
PERF_ISQL_STAT (161)
Primary pointer page: 344, Index root page: 345
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PERF_ISQL_STAT_TRN (0)
Root page: 346, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PERF_LOG (162)
Primary pointer page: 348, Index root page: 349
Total formats: 2, used formats: 2
Average record length: 147.62, total records: 9293359
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: 1439.99, compression ratio: 9.75
Pointer pages: 133, data page slots: 215992
Data pages: 215992, average fill: 87%
Primary pages: 215992, secondary pages: 0, swept pages: 3
Empty pages: 6, full pages: 215985
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 215986
Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 59394, depth: 3, leaf buckets: 9457, nodes: 9293359
Average node length: 5.59, total dup: 8127932, max dup: 56
Average key length: 2.24, compression ratio: 3.56
Average prefix length: 7.80, average data length: 0.19
Clustering factor: 6193868, ratio: 0.67
Fill distribution:
0 - 19% = 15
20 - 39% = 0
40 - 59% = 3462
60 - 79% = 3751
80 - 99% = 2229
Index PERF_LOG_GDSCODE (3)
Root page: 144765, depth: 3, leaf buckets: 10031, nodes: 9293359
Average node length: 4.39, total dup: 9293354, max dup: 8921460
Average key length: 1.04, compression ratio: 0.19
Average prefix length: 0.20, average data length: 0.00
Clustering factor: 357773, ratio: 0.04
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 10001
60 - 79% = 0
80 - 99% = 29
Index PERF_LOG_TRN_DESC (2)
Root page: 43359, depth: 3, leaf buckets: 10325, nodes: 9293359
Average node length: 5.59, total dup: 8989551, max dup: 16047
Average key length: 2.24, compression ratio: 4.02
Average prefix length: 8.79, average data length: 0.21
Clustering factor: 4728331, ratio: 0.51
Fill distribution:
0 - 19% = 8
20 - 39% = 5
40 - 59% = 6088
60 - 79% = 2355
80 - 99% = 1869
Index PERF_LOG_UNIT (1)
Root page: 65474, depth: 3, leaf buckets: 11011, nodes: 9293359
Average node length: 5.49, total dup: 9205841, max dup: 1401500
Average key length: 2.14, compression ratio: 17.60
Average prefix length: 37.51, average data length: 0.13
Clustering factor: 5621313, ratio: 0.60
Fill distribution:
0 - 19% = 21
20 - 39% = 1
40 - 59% = 8855
60 - 79% = 709
80 - 99% = 1425
PHRASES (145)
Primary pointer page: 265, Index root page: 266
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_ID_DESC (3)
Root page: 279, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_NAME (2)
Root page: 278, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_UNQ (1)
Root page: 277, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_PHRASES (0)
Root page: 276, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PSTORNED (151)
Primary pointer page: 301, Index root page: 302
Total formats: 1, used formats: 1
Average record length: 53.56, total records: 334083
Average version length: 55.83, total versions: 9107, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.49
Pointer pages: 3, data page slots: 4048
Data pages: 4048, average fill: 74%
Primary pages: 4048, secondary pages: 0, swept pages: 1725
Empty pages: 5, full pages: 3395
Fill distribution:
0 - 19% = 10
20 - 39% = 9
40 - 59% = 110
60 - 79% = 3873
80 - 99% = 46
Index PSTORNED_RCV_ID (2)
Root page: 2296, depth: 2, leaf buckets: 424, nodes: 334083
Average node length: 5.93, total dup: 279194, max dup: 599
Average key length: 3.21, compression ratio: 2.80
Average prefix length: 7.95, average data length: 1.05
Clustering factor: 35909, ratio: 0.11
Fill distribution:
0 - 19% = 4
20 - 39% = 17
40 - 59% = 245
60 - 79% = 115
80 - 99% = 43
Index PSTORNED_SND_ID (1)
Root page: 2211, depth: 2, leaf buckets: 351, nodes: 334083
Average node length: 5.55, total dup: 297753, max dup: 269
Average key length: 2.83, compression ratio: 3.18
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 69982, ratio: 0.21
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 143
60 - 79% = 150
80 - 99% = 56
RULES_FOR_PDISTR (152)
Primary pointer page: 303, Index root page: 304
Total formats: 1, used formats: 1
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 336.00, compression ratio: 18.67
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 2%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_PDISTR_UNQ (0)
Root page: 308, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 11.50, total dup: 0, max dup: 0
Average key length: 10.25, compression ratio: 0.88
Average prefix length: 1.50, average data length: 7.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RULES_FOR_QDISTR (139)
Primary pointer page: 243, Index root page: 244
Total formats: 1, used formats: 1
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 332.00, compression ratio: 10.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_RCVOP (1)
Root page: 246, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 5.29, total dup: 2, max dup: 2
Average key length: 4.14, compression ratio: 0.72
Average prefix length: 1.43, average data length: 1.57
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_UNQ (0)
Root page: 245, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 10.14, total dup: 0, max dup: 0
Average key length: 8.86, compression ratio: 0.94
Average prefix length: 2.14, average data length: 6.14
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SEMAPHORES (156)
Primary pointer page: 315, Index root page: 316
Total formats: 1, used formats: 1
Average record length: 34.25, total records: 4
Average version length: 9.00, total versions: 8447, max versions: 4640
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: 32
Data pages: 32, average fill: 84%
Primary pages: 3, secondary pages: 29, swept pages: 0
Empty pages: 2, full pages: 29
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 29
Index PK_SEMAPHORES (0)
Root page: 327, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 12.50, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.50, average data length: 8.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SEMAPHORES_TASK_UNQ (1)
Root page: 328, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 22.50, total dup: 0, max dup: 0
Average key length: 21.00, compression ratio: 1.07
Average prefix length: 4.00, average data length: 18.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SETTINGS (137)
Primary pointer page: 236, Index root page: 237
Total formats: 1, used formats: 1
Average record length: 98.32, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1347.00, compression ratio: 13.70
Pointer pages: 1, data page slots: 2
Data pages: 2, average fill: 81%
Primary pages: 2, secondary pages: 0, swept pages: 2
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1
Index SETTINGS_MODE_CODE (0)
Root page: 238, depth: 1, leaf buckets: 1, nodes: 114
Average node length: 27.07, total dup: 0, max dup: 0
Average key length: 26.06, compression ratio: 1.70
Average prefix length: 21.23, average data length: 23.07
Clustering factor: 6, ratio: 0.05
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$RAND$CALLS (136)
Primary pointer page: 234, Index root page: 235
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$SOURCE (135)
Primary pointer page: 232, Index root page: 233
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$DEP_DOCS (129)
Primary pointer page: 198, Index root page: 199
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_DEP_DOCS_UNQ (0)
Root page: 200, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$IDX_RECALC (132)
Primary pointer page: 207, Index root page: 224
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0)
Root page: 226, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG (133)
Primary pointer page: 227, Index root page: 228
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG_TABLE_STATS (134)
Primary pointer page: 230, Index root page: 231
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_LOG (163)
Primary pointer page: 350, Index root page: 351
Total formats: 2, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Root page: 358, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_MON (131)
Primary pointer page: 205, Index root page: 206
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$RESULT_SET (130)
Primary pointer page: 201, Index root page: 202
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_DOC (1)
Root page: 204, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_WARE_DOC (0)
Root page: 203, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$SHOPPING_CART (128)
Primary pointer page: 193, Index root page: 194
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_SHOPCART_UNQ (0)
Root page: 197, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRACE_STAT (276)
Primary pointer page: 557, Index root page: 68921
Total formats: 1, used formats: 1
Average record length: 54.27, total records: 2758
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.51
Pointer pages: 1, data page slots: 40
Data pages: 40, average fill: 60%
Primary pages: 40, secondary pages: 0, swept pages: 0
Empty pages: 7, full pages: 32
Fill distribution:
0 - 19% = 8
20 - 39% = 0
40 - 59% = 0
60 - 79% = 32
80 - 99% = 0
WARES (144)
Primary pointer page: 263, Index root page: 264
Total formats: 1, used formats: 1
Average record length: 77.53, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 448.00, compression ratio: 5.78
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 77%
Primary pages: 6, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2
Index FK_WARES_WARE_GROUPS (3)
Root page: 374, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 64
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 48, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARES (0)
Root page: 273, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 328, ratio: 0.82
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_ID_DESC (2)
Root page: 275, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 328, ratio: 0.82
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_NUMB_UNQ (1)
Root page: 504, depth: 2, leaf buckets: 3, nodes: 400
Average node length: 52.95, total dup: 0, max dup: 0
Average key length: 51.92, compression ratio: 0.99
Average prefix length: 2.65, average data length: 48.95
Clustering factor: 334, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 2
WARE_GROUPS (155)
Primary pointer page: 313, Index root page: 314
Total formats: 1, used formats: 1
Average record length: 32.13, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 352.00, compression ratio: 10.96
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 5%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARE_GROUPS (0)
Root page: 325, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 11.25, total dup: 0, max dup: 0
Average key length: 10.13, compression ratio: 0.89
Average prefix length: 1.75, average data length: 7.25
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index WARE_GROUPS_NAME_UNQ (1)
Root page: 326, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 19.88, total dup: 0, max dup: 0
Average key length: 18.13, compression ratio: 0.89
Average prefix length: 0.25, average data length: 15.88
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQD_1000_1200 (259)
Primary pointer page: 254, Index root page: 284
Total formats: 1, used formats: 1
Average record length: 1.47, total records: 161378
Average version length: 72.17, total versions: 158096, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 92.62
Pointer pages: 6, data page slots: 6720
Data pages: 3215, average fill: 66%
Primary pages: 3213, secondary pages: 2, swept pages: 274
Empty pages: 671, full pages: 2155
Fill distribution:
0 - 19% = 797
20 - 39% = 129
40 - 59% = 108
60 - 79% = 69
80 - 99% = 2112
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 128391, depth: 3, leaf buckets: 664, nodes: 161378
Average node length: 6.10, total dup: 140954, max dup: 25
Average key length: 3.35, compression ratio: 11.03
Average prefix length: 35.77, average data length: 1.23
Clustering factor: 26593, ratio: 0.16
Fill distribution:
0 - 19% = 279
20 - 39% = 361
40 - 59% = 23
60 - 79% = 1
80 - 99% = 0
XQD_1000_3300 (261)
Primary pointer page: 708, Index root page: 709
Total formats: 1, used formats: 1
Average record length: 71.12, total records: 1328927
Average version length: 71.47, total versions: 19347, 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: 14, data page slots: 21544
Data pages: 21544, average fill: 68%
Primary pages: 21544, secondary pages: 0, swept pages: 16080
Empty pages: 7, full pages: 10677
Fill distribution:
0 - 19% = 72
20 - 39% = 569
40 - 59% = 3394
60 - 79% = 17206
80 - 99% = 303
Index XQD_1000_3300_DOC (1)
Root page: 200269, depth: 3, leaf buckets: 1718, nodes: 1328927
Average node length: 5.15, total dup: 1294989, max dup: 122
Average key length: 2.19, compression ratio: 4.10
Average prefix length: 8.83, average data length: 0.17
Clustering factor: 286672, ratio: 0.22
Fill distribution:
0 - 19% = 22
20 - 39% = 109
40 - 59% = 1468
60 - 79% = 109
80 - 99% = 10
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 124526, depth: 3, leaf buckets: 2094, nodes: 1328927
Average node length: 6.29, total dup: 1160213, max dup: 29
Average key length: 3.33, compression ratio: 11.11
Average prefix length: 35.80, average data length: 1.20
Clustering factor: 358295, ratio: 0.27
Fill distribution:
0 - 19% = 33
20 - 39% = 172
40 - 59% = 1615
60 - 79% = 181
80 - 99% = 93
XQD_1200_2000 (260)
Primary pointer page: 705, Index root page: 706
Total formats: 1, used formats: 1
Average record length: 6.41, total records: 336121
Average version length: 72.06, total versions: 256673, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 21.20
Pointer pages: 10, data page slots: 15080
Data pages: 12480, average fill: 31%
Primary pages: 12478, secondary pages: 2, swept pages: 7114
Empty pages: 4080, full pages: 3343
Fill distribution:
0 - 19% = 7812
20 - 39% = 334
40 - 59% = 519
60 - 79% = 877
80 - 99% = 2938
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 128312, depth: 3, leaf buckets: 463, nodes: 279526
Average node length: 5.91, total dup: 250928, max dup: 97
Average key length: 3.12, compression ratio: 11.85
Average prefix length: 35.98, average data length: 1.02
Clustering factor: 51006, ratio: 0.18
Fill distribution:
0 - 19% = 7
20 - 39% = 151
40 - 59% = 251
60 - 79% = 51
80 - 99% = 3
XQD_2000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 53.43, total records: 2008868
Average version length: 71.82, total versions: 97796, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.55
Pointer pages: 22, data page slots: 34472
Data pages: 34400, average fill: 55%
Primary pages: 34400, secondary pages: 0, swept pages: 26472
Empty pages: 148, full pages: 6558
Fill distribution:
0 - 19% = 1131
20 - 39% = 5470
40 - 59% = 13454
60 - 79% = 12463
80 - 99% = 1882
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 111621, depth: 3, leaf buckets: 2512, nodes: 1524247
Average node length: 5.65, total dup: 1430836, max dup: 99
Average key length: 2.67, compression ratio: 13.83
Average prefix length: 36.39, average data length: 0.61
Clustering factor: 472803, ratio: 0.31
Fill distribution:
0 - 19% = 32
20 - 39% = 1406
40 - 59% = 634
60 - 79% = 324
80 - 99% = 116
XQD_2100_3300 (263)
Primary pointer page: 734, Index root page: 735
Total formats: 1, used formats: 1
Average record length: 9.00, total records: 3423874
Average version length: 69.65, total versions: 2323, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 15.11
Pointer pages: 13, data page slots: 21136
Data pages: 21120, average fill: 52%
Primary pages: 21119, secondary pages: 1, swept pages: 6211
Empty pages: 21, full pages: 19511
Fill distribution:
0 - 19% = 76
20 - 39% = 6399
40 - 59% = 5277
60 - 79% = 9340
80 - 99% = 28
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1530, depth: 2, leaf buckets: 10, nodes: 2585
Average node length: 10.89, total dup: 1820, max dup: 16
Average key length: 7.88, compression ratio: 4.69
Average prefix length: 31.41, average data length: 5.59
Clustering factor: 629, ratio: 0.24
Fill distribution:
0 - 19% = 0
20 - 39% = 6
40 - 59% = 3
60 - 79% = 1
80 - 99% = 0
XQD_3300_3400 (264)
Primary pointer page: 737, Index root page: 738
Total formats: 1, used formats: 1
Average record length: 65.66, total records: 2360438
Average version length: 70.97, total versions: 54995, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.07
Pointer pages: 22, data page slots: 34336
Data pages: 34336, average fill: 72%
Primary pages: 34336, secondary pages: 0, swept pages: 23681
Empty pages: 20, full pages: 19501
Fill distribution:
0 - 19% = 57
20 - 39% = 166
40 - 59% = 2547
60 - 79% = 30237
80 - 99% = 1329
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 41262, depth: 3, leaf buckets: 4811, nodes: 2207701
Average node length: 6.98, total dup: 1766248, max dup: 29
Average key length: 4.01, compression ratio: 9.23
Average prefix length: 35.19, average data length: 1.81
Clustering factor: 616806, ratio: 0.28
Fill distribution:
0 - 19% = 5
20 - 39% = 3026
40 - 59% = 1376
60 - 79% = 222
80 - 99% = 182
XQS_1000_1200 (265)
Primary pointer page: 740, Index root page: 741
Total formats: 1, used formats: 1
Average record length: 83.26, total records: 3842888
Average version length: 83.55, total versions: 19713, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 37, data page slots: 59968
Data pages: 59968, average fill: 79%
Primary pages: 59968, secondary pages: 0, swept pages: 29675
Empty pages: 7, full pages: 57332
Fill distribution:
0 - 19% = 8
20 - 39% = 4
40 - 59% = 71
60 - 79% = 29450
80 - 99% = 30435
Index XQS_1000_1200_DOC_ID (0)
Root page: 54649, depth: 3, leaf buckets: 3737, nodes: 3842888
Average node length: 5.16, total dup: 3753891, max dup: 126
Average key length: 2.18, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 900439, ratio: 0.23
Fill distribution:
0 - 19% = 7
20 - 39% = 43
40 - 59% = 1384
60 - 79% = 1537
80 - 99% = 766
Index XQS_1000_1200_RCV_ID (2)
Root page: 78654, depth: 3, leaf buckets: 5089, nodes: 3842888
Average node length: 5.65, total dup: 3468358, max dup: 49
Average key length: 2.67, compression ratio: 3.37
Average prefix length: 8.43, average data length: 0.57
Clustering factor: 614852, ratio: 0.16
Fill distribution:
0 - 19% = 37
20 - 39% = 131
40 - 59% = 4032
60 - 79% = 418
80 - 99% = 471
Index XQS_1000_1200_SND_ID (1)
Root page: 48486, depth: 3, leaf buckets: 4208, nodes: 3842888
Average node length: 5.80, total dup: 3361366, max dup: 29
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.31, average data length: 0.69
Clustering factor: 951195, ratio: 0.25
Fill distribution:
0 - 19% = 4
20 - 39% = 80
40 - 59% = 1691
60 - 79% = 1444
80 - 99% = 989
XQS_1000_3300 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 77.69, total records: 1668994
Average version length: 83.21, total versions: 99328, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.75
Pointer pages: 17, data page slots: 26240
Data pages: 26240, average fill: 79%
Primary pages: 26240, secondary pages: 0, swept pages: 8341
Empty pages: 4, full pages: 24159
Fill distribution:
0 - 19% = 19
20 - 39% = 36
40 - 59% = 332
60 - 79% = 12531
80 - 99% = 13322
Index XQS_1000_3300_DOC_ID (0)
Root page: 75516, depth: 3, leaf buckets: 1771, nodes: 1668994
Average node length: 5.13, total dup: 1631133, max dup: 221
Average key length: 2.18, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 350621, ratio: 0.21
Fill distribution:
0 - 19% = 1
20 - 39% = 31
40 - 59% = 987
60 - 79% = 593
80 - 99% = 159
Index XQS_1000_3300_RCV_ID (2)
Root page: 96526, depth: 3, leaf buckets: 3125, nodes: 1668994
Average node length: 6.29, total dup: 1353741, max dup: 14
Average key length: 3.34, compression ratio: 2.70
Average prefix length: 7.85, average data length: 1.15
Clustering factor: 259429, ratio: 0.16
Fill distribution:
0 - 19% = 47
20 - 39% = 1480
40 - 59% = 1338
60 - 79% = 226
80 - 99% = 34
Index XQS_1000_3300_SND_ID (1)
Root page: 65477, depth: 3, leaf buckets: 1973, nodes: 1668994
Average node length: 5.76, total dup: 1469493, max dup: 49
Average key length: 2.80, compression ratio: 3.21
Average prefix length: 8.31, average data length: 0.69
Clustering factor: 379085, ratio: 0.23
Fill distribution:
0 - 19% = 5
20 - 39% = 29
40 - 59% = 1083
60 - 79% = 651
80 - 99% = 205
XQS_1200_2000 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 77.85, total records: 4370486
Average version length: 85.48, total versions: 311478, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.75
Pointer pages: 43, data page slots: 69704
Data pages: 69704, average fill: 79%
Primary pages: 69704, secondary pages: 0, swept pages: 15681
Empty pages: 6, full pages: 61846
Fill distribution:
0 - 19% = 23
20 - 39% = 183
40 - 59% = 1456
60 - 79% = 30643
80 - 99% = 37399
Index XQS_1200_2000_DOC_ID (0)
Root page: 57323, depth: 3, leaf buckets: 4742, nodes: 4370486
Average node length: 5.04, total dup: 4346480, max dup: 640
Average key length: 2.05, compression ratio: 4.39
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 1211378, ratio: 0.28
Fill distribution:
0 - 19% = 5
20 - 39% = 272
40 - 59% = 2780
60 - 79% = 1339
80 - 99% = 346
Index XQS_1200_2000_RCV_ID (2)
Root page: 78658, depth: 3, leaf buckets: 6062, nodes: 4370486
Average node length: 5.49, total dup: 4052957, max dup: 49
Average key length: 2.51, compression ratio: 3.59
Average prefix length: 8.57, average data length: 0.43
Clustering factor: 971054, ratio: 0.22
Fill distribution:
0 - 19% = 34
20 - 39% = 1920
40 - 59% = 3055
60 - 79% = 502
80 - 99% = 551
Index XQS_1200_2000_SND_ID (1)
Root page: 49624, depth: 3, leaf buckets: 5276, nodes: 4370486
Average node length: 5.60, total dup: 3980790, max dup: 118
Average key length: 2.61, compression ratio: 3.44
Average prefix length: 8.48, average data length: 0.52
Clustering factor: 1283939, ratio: 0.29
Fill distribution:
0 - 19% = 8
20 - 39% = 224
40 - 59% = 3239
60 - 79% = 1405
80 - 99% = 400
XQS_2000_3300 (268)
Primary pointer page: 757, Index root page: 758
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_DOC_ID (0)
Root page: 760, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_RCV_ID (2)
Root page: 762, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_SND_ID (1)
Root page: 761, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQS_2100_3300 (269)
Primary pointer page: 763, Index root page: 764
Total formats: 1, used formats: 1
Average record length: 78.88, total records: 2785355
Average version length: 84.45, total versions: 153060, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.72
Pointer pages: 28, data page slots: 44152
Data pages: 44152, average fill: 79%
Primary pages: 44152, secondary pages: 0, swept pages: 12188
Empty pages: 5, full pages: 40171
Fill distribution:
0 - 19% = 18
20 - 39% = 59
40 - 59% = 467
60 - 79% = 21442
80 - 99% = 22166
Index XQS_2100_3300_DOC_ID (0)
Root page: 90081, depth: 3, leaf buckets: 2985, nodes: 2785355
Average node length: 5.02, total dup: 2771720, max dup: 1820
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 730977, ratio: 0.26
Fill distribution:
0 - 19% = 17
20 - 39% = 334
40 - 59% = 1459
60 - 79% = 810
80 - 99% = 365
Index XQS_2100_3300_RCV_ID (2)
Root page: 91333, depth: 3, leaf buckets: 5441, nodes: 2785355
Average node length: 6.32, total dup: 2252984, max dup: 14
Average key length: 3.35, compression ratio: 2.69
Average prefix length: 7.84, average data length: 1.16
Clustering factor: 589130, ratio: 0.21
Fill distribution:
0 - 19% = 209
20 - 39% = 2612
40 - 59% = 2308
60 - 79% = 249
80 - 99% = 63
Index XQS_2100_3300_SND_ID (1)
Root page: 78028, depth: 3, leaf buckets: 3191, nodes: 2785355
Average node length: 5.53, total dup: 2565751, max dup: 134
Average key length: 2.55, compression ratio: 3.52
Average prefix length: 8.53, average data length: 0.47
Clustering factor: 766443, ratio: 0.28
Fill distribution:
0 - 19% = 3
20 - 39% = 243
40 - 59% = 1517
60 - 79% = 1024
80 - 99% = 404
XQS_3300_3400 (270)
Primary pointer page: 776, Index root page: 777
Total formats: 1, used formats: 1
Average record length: 66.91, total records: 496032
Average version length: 69.81, total versions: 16443, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.03
Pointer pages: 5, data page slots: 6856
Data pages: 6856, average fill: 77%
Primary pages: 6856, secondary pages: 0, swept pages: 3704
Empty pages: 5, full pages: 6527
Fill distribution:
0 - 19% = 11
20 - 39% = 20
40 - 59% = 62
60 - 79% = 6306
80 - 99% = 457
Index XQS_3300_3400_DOC_ID (0)
Root page: 537275, depth: 3, leaf buckets: 565, nodes: 496032
Average node length: 5.38, total dup: 461396, max dup: 137
Average key length: 2.54, compression ratio: 3.55
Average prefix length: 8.53, average data length: 0.47
Clustering factor: 46788, ratio: 0.09
Fill distribution:
0 - 19% = 2
20 - 39% = 60
40 - 59% = 262
60 - 79% = 183
80 - 99% = 58
Index XQS_3300_3400_SND_ID (1)
Root page: 388960, depth: 3, leaf buckets: 617, nodes: 496032
Average node length: 5.94, total dup: 421488, max dup: 29
Average key length: 3.10, compression ratio: 2.90
Average prefix length: 8.05, average data length: 0.95
Clustering factor: 52248, ratio: 0.11
Fill distribution:
0 - 19% = 0
20 - 39% = 67
40 - 59% = 282
60 - 79% = 190
80 - 99% = 78
ZDOC_DATA (229)
Primary pointer page: 632, Index root page: 633
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZDOC_LIST (228)
Primary pointer page: 630, Index root page: 631
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZINVNT_TURNOVER_LOG (230)
Primary pointer page: 634, Index root page: 635
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPDISTR (233)
Primary pointer page: 640, Index root page: 641
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPDISTR_ID (0)
Root page: 650, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPSTORNED (234)
Primary pointer page: 642, Index root page: 643
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPSTORNED_ID (0)
Root page: 651, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQDISTR (231)
Primary pointer page: 636, Index root page: 637
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_ID (0)
Root page: 644, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Root page: 645, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQSTORNED (232)
Primary pointer page: 638, Index root page: 639
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_DOC_ID (1)
Root page: 647, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_ID (0)
Root page: 646, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_RCV_ID (3)
Root page: 649, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_SND_ID (2)
Root page: 648, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_DEP_DOCS (227)
Primary pointer page: 628, Index root page: 629
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_SHOPPING_CART (226)
Primary pointer page: 625, Index root page: 626
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Z_USED_VIEWS (146)
Primary pointer page: 267, Index root page: 268
Total formats: 1, used formats: 1
Average record length: 29.38, total records: 29
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 99.00, compression ratio: 3.37
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 16%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index Z_USED_VIEWS_UNQ (0)
Root page: 280, depth: 1, leaf buckets: 1, nodes: 29
Average node length: 15.17, total dup: 0, max dup: 0
Average key length: 14.14, compression ratio: 1.44
Average prefix length: 9.17, average data length: 11.17
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Done for 56690 ms, from 11:08:27.64 to 11:09:24.33.
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
VERS_PERCENT |
AGENTS |
50 |
0 |
0.0000 |
BUSINESS_OPS |
19 |
0 |
0.0000 |
DOC_DATA |
1725410 |
28563 |
1.6554 |
DOC_LIST |
602875 |
14718 |
2.4413 |
DOC_STATES |
4 |
0 |
0.0000 |
FB_ERRORS |
758 |
0 |
0.0000 |
INVNT_SALDO |
400 |
905272 |
226318.0000 |
INVNT_TURNOVER_LOG |
139330 |
134520 |
96.5477 |
MONEY_SALDO |
49 |
52403 |
106944.8979 |
MONEY_TURNOVER_LOG |
5429 |
5345 |
98.4527 |
OPTYPES |
9 |
0 |
0.0000 |
PDISTR |
608760 |
34064 |
5.5956 |
PERF_ESTIMATED |
258895 |
0 |
0.0000 |
PERF_LOG |
9293359 |
0 |
0.0000 |
PSTORNED |
334083 |
9107 |
2.7259 |
RULES_FOR_PDISTR |
4 |
0 |
0.0000 |
RULES_FOR_QDISTR |
7 |
0 |
0.0000 |
SEMAPHORES |
4 |
8447 |
211175.0000 |
SETTINGS |
114 |
0 |
0.0000 |
TRACE_STAT |
2758 |
0 |
0.0000 |
WARES |
400 |
0 |
0.0000 |
WARE_GROUPS |
8 |
0 |
0.0000 |
XQD_1000_1200 |
161378 |
158096 |
97.9662 |
XQD_1000_3300 |
1328927 |
19347 |
1.4558 |
XQD_1200_2000 |
336121 |
256673 |
76.3632 |
XQD_2000_3300 |
2008868 |
97796 |
4.8682 |
XQD_2100_3300 |
3423874 |
2323 |
0.0678 |
XQD_3300_3400 |
2360438 |
54995 |
2.3298 |
XQS_1000_1200 |
3842888 |
19713 |
0.5129 |
XQS_1000_3300 |
1668994 |
99328 |
5.9513 |
XQS_1200_2000 |
4370486 |
311478 |
7.1268 |
XQS_2100_3300 |
2785355 |
153060 |
5.4951 |
XQS_3300_3400 |
496032 |
16443 |
3.3149 |
Z_USED_VIEWS |
29 |
0 |
0.0000 |
Done for 2080 ms, from 11:09:34.84 to 11:09:36.92.
11:09:37.01 Validation started
11:09:37.03 Relation 140 (DOC_LIST)
11:09:37.03 process pointer page 0 of 5
11:09:37.11 process pointer page 1 of 5
11:09:37.20 process pointer page 2 of 5
11:09:37.25 process pointer page 3 of 5
11:09:37.31 process pointer page 4 of 5
11:09:37.34 Index 1 (PK_DOC_LIST)
11:09:37.51 Index 2 (DOC_LIST_ID_DESC)
11:09:37.73 Index 3 (FK_DOC_LIST_AGENTS)
11:09:37.85 Relation 140 (DOC_LIST) is ok
11:09:37.85 Relation 141 (DOC_DATA)
11:09:37.85 process pointer page 0 of 12
11:09:37.95 process pointer page 1 of 12
11:09:37.99 process pointer page 2 of 12
11:09:38.02 process pointer page 3 of 12
11:09:38.06 process pointer page 4 of 12
11:09:38.10 process pointer page 5 of 12
11:09:38.13 process pointer page 6 of 12
11:09:38.16 process pointer page 7 of 12
11:09:38.19 process pointer page 8 of 12
11:09:38.22 process pointer page 9 of 12
11:09:38.26 process pointer page 10 of 12
11:09:38.36 process pointer page 11 of 12
11:09:38.37 Index 2 (DOC_DATA_DOC_WARE_UNQ)
11:09:38.78 Index 3 (DOC_DATA_ID_DESC)
11:09:39.14 Index 4 (FK_DOC_DATA_DOC_LIST)
11:09:39.50 Relation 141 (DOC_DATA) is ok
11:09:39.50 Relation 147 (INVNT_SALDO)
11:09:39.50 process pointer page 0 of 3
11:09:40.89 process pointer page 1 of 3
11:09:40.89 process pointer page 2 of 3
11:09:40.90 Index 1 (PK_INVNT_SALDO)
11:09:40.90 Relation 147 (INVNT_SALDO) is ok
11:09:40.90 Relation 150 (PDISTR)
11:09:40.90 process pointer page 0 of 3
11:09:40.95 process pointer page 1 of 3
11:09:40.96 process pointer page 2 of 3
11:09:40.99 Index 2 (PDISTR_SND_ID)
11:09:41.03 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
11:09:41.04 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
11:09:41.07 Index 5 (PDISTR_AGENT_ID)
11:09:41.10 Relation 150 (PDISTR) is ok
11:09:41.10 Relation 151 (PSTORNED)
11:09:41.10 process pointer page 0 of 3
11:09:41.12 process pointer page 1 of 3
11:09:41.15 process pointer page 2 of 3
11:09:41.17 Index 2 (PSTORNED_SND_ID)
11:09:41.21 Index 3 (PSTORNED_RCV_ID)
11:09:41.28 Relation 151 (PSTORNED) is ok
11:09:41.28 Relation 156 (SEMAPHORES)
11:09:41.28 process pointer page 0 of 1
11:09:41.28 Index 1 (PK_SEMAPHORES)
11:09:41.28 Index 2 (SEMAPHORES_TASK_UNQ)
11:09:41.28 Relation 156 (SEMAPHORES) is ok
11:09:41.28 Relation 157 (INVNT_TURNOVER_LOG)
11:09:41.28 process pointer page 0 of 4
11:09:41.32 process pointer page 1 of 4
11:09:41.37 process pointer page 2 of 4
11:09:41.38 process pointer page 3 of 4
11:09:41.40 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
11:09:41.43 Relation 157 (INVNT_TURNOVER_LOG) is ok
11:09:41.43 Relation 160 (PERF_ESTIMATED)
11:09:41.43 process pointer page 0 of 2
11:09:41.45 process pointer page 1 of 2
11:09:41.45 Index 1 (PERF_EST_MINUTE_SINCE_START)
11:09:41.48 Relation 160 (PERF_ESTIMATED) is ok
11:09:41.48 Relation 161 (PERF_ISQL_STAT)
11:09:41.48 process pointer page 0 of 1
11:09:41.48 Index 1 (PERF_ISQL_STAT_TRN)
11:09:41.48 Relation 161 (PERF_ISQL_STAT) is ok
11:09:41.48 Relation 162 (PERF_LOG)
11:09:41.48 process pointer page 0 of 133
11:09:41.51 process pointer page 1 of 133
11:09:41.52 process pointer page 2 of 133
11:09:41.56 process pointer page 3 of 133
11:09:41.57 process pointer page 4 of 133
11:09:41.60 process pointer page 5 of 133
11:09:41.62 process pointer page 6 of 133
11:09:41.68 process pointer page 7 of 133
11:09:41.71 process pointer page 8 of 133
11:09:41.74 process pointer page 9 of 133
11:09:41.77 process pointer page 10 of 133
11:09:41.81 process pointer page 11 of 133
11:09:41.84 process pointer page 12 of 133
11:09:41.87 process pointer page 13 of 133
11:09:41.88 process pointer page 14 of 133
11:09:41.95 process pointer page 15 of 133
11:09:41.99 process pointer page 16 of 133
11:09:42.04 process pointer page 17 of 133
11:09:42.06 process pointer page 18 of 133
11:09:42.07 process pointer page 19 of 133
11:09:42.09 process pointer page 20 of 133
11:09:42.10 process pointer page 21 of 133
11:09:42.12 process pointer page 22 of 133
11:09:42.13 process pointer page 23 of 133
11:09:42.15 process pointer page 24 of 133
11:09:42.16 process pointer page 25 of 133
11:09:42.18 process pointer page 26 of 133
11:09:42.20 process pointer page 27 of 133
11:09:42.21 process pointer page 28 of 133
11:09:42.21 process pointer page 29 of 133
11:09:42.23 process pointer page 30 of 133
11:09:42.24 process pointer page 31 of 133
11:09:42.26 process pointer page 32 of 133
11:09:42.27 process pointer page 33 of 133
11:09:42.29 process pointer page 34 of 133
11:09:42.29 process pointer page 35 of 133
11:09:42.30 process pointer page 36 of 133
11:09:42.32 process pointer page 37 of 133
11:09:42.34 process pointer page 38 of 133
11:09:42.35 process pointer page 39 of 133
11:09:42.37 process pointer page 40 of 133
11:09:42.37 process pointer page 41 of 133
11:09:42.38 process pointer page 42 of 133
11:09:42.41 process pointer page 43 of 133
11:09:42.46 process pointer page 44 of 133
11:09:42.49 process pointer page 45 of 133
11:09:42.51 process pointer page 46 of 133
11:09:42.52 process pointer page 47 of 133
11:09:42.54 process pointer page 48 of 133
11:09:42.55 process pointer page 49 of 133
11:09:42.57 process pointer page 50 of 133
11:09:42.59 process pointer page 51 of 133
11:09:42.60 process pointer page 52 of 133
11:09:42.62 process pointer page 53 of 133
11:09:42.63 process pointer page 54 of 133
11:09:42.65 process pointer page 55 of 133
11:09:42.66 process pointer page 56 of 133
11:09:42.68 process pointer page 57 of 133
11:09:42.68 process pointer page 58 of 133
11:09:42.69 process pointer page 59 of 133
11:09:42.71 process pointer page 60 of 133
11:09:42.73 process pointer page 61 of 133
11:09:42.74 process pointer page 62 of 133
11:09:42.76 process pointer page 63 of 133
11:09:42.76 process pointer page 64 of 133
11:09:42.77 process pointer page 65 of 133
11:09:42.79 process pointer page 66 of 133
11:09:42.80 process pointer page 67 of 133
11:09:42.82 process pointer page 68 of 133
11:09:42.84 process pointer page 69 of 133
11:09:42.87 process pointer page 70 of 133
11:09:42.90 process pointer page 71 of 133
11:09:42.91 process pointer page 72 of 133
11:09:42.93 process pointer page 73 of 133
11:09:42.94 process pointer page 74 of 133
11:09:42.96 process pointer page 75 of 133
11:09:42.99 process pointer page 76 of 133
11:09:43.01 process pointer page 77 of 133
11:09:43.02 process pointer page 78 of 133
11:09:43.04 process pointer page 79 of 133
11:09:43.05 process pointer page 80 of 133
11:09:43.07 process pointer page 81 of 133
11:09:43.08 process pointer page 82 of 133
11:09:43.10 process pointer page 83 of 133
11:09:43.12 process pointer page 84 of 133
11:09:43.13 process pointer page 85 of 133
11:09:43.15 process pointer page 86 of 133
11:09:43.16 process pointer page 87 of 133
11:09:43.18 process pointer page 88 of 133
11:09:43.18 process pointer page 89 of 133
11:09:43.19 process pointer page 90 of 133
11:09:43.21 process pointer page 91 of 133
11:09:43.23 process pointer page 92 of 133
11:09:43.24 process pointer page 93 of 133
11:09:43.26 process pointer page 94 of 133
11:09:43.26 process pointer page 95 of 133
11:09:43.27 process pointer page 96 of 133
11:09:43.29 process pointer page 97 of 133
11:09:43.30 process pointer page 98 of 133
11:09:43.32 process pointer page 99 of 133
11:09:43.32 process pointer page 100 of 133
11:09:43.33 process pointer page 101 of 133
11:09:43.35 process pointer page 102 of 133
11:09:43.37 process pointer page 103 of 133
11:09:43.37 process pointer page 104 of 133
11:09:43.38 process pointer page 105 of 133
11:09:43.40 process pointer page 106 of 133
11:09:43.40 process pointer page 107 of 133
11:09:43.41 process pointer page 108 of 133
11:09:43.43 process pointer page 109 of 133
11:09:43.44 process pointer page 110 of 133
11:09:43.44 process pointer page 111 of 133
11:09:43.46 process pointer page 112 of 133
11:09:43.47 process pointer page 113 of 133
11:09:43.49 process pointer page 114 of 133
11:09:43.49 process pointer page 115 of 133
11:09:43.51 process pointer page 116 of 133
11:09:43.52 process pointer page 117 of 133
11:09:43.54 process pointer page 118 of 133
11:09:43.54 process pointer page 119 of 133
11:09:43.55 process pointer page 120 of 133
11:09:43.57 process pointer page 121 of 133
11:09:43.57 process pointer page 122 of 133
11:09:43.58 process pointer page 123 of 133
11:09:43.60 process pointer page 124 of 133
11:09:43.62 process pointer page 125 of 133
11:09:43.62 process pointer page 126 of 133
11:09:43.63 process pointer page 127 of 133
11:09:43.65 process pointer page 128 of 133
11:09:43.66 process pointer page 129 of 133
11:09:43.66 process pointer page 130 of 133
11:09:43.68 process pointer page 131 of 133
11:09:43.69 process pointer page 132 of 133
11:09:43.69 Index 1 (PERF_LOG_DTS_BEG_DESC)
11:09:44.94 Index 2 (PERF_LOG_UNIT)
11:09:47.55 Index 3 (PERF_LOG_TRN_DESC)
11:09:49.15 Index 4 (PERF_LOG_GDSCODE)
11:09:50.17 Relation 162 (PERF_LOG) is ok
11:09:50.17 Relation 166 (V_STOPTEST)
11:09:50.17 Relation 166 (V_STOPTEST) is ok
11:09:50.17 Relation 183 (V_QDISTR_SOURCE)
11:09:50.17 Relation 183 (V_QDISTR_SOURCE) is ok
11:09:50.17 Relation 184 (V_QSTORNED_SOURCE)
11:09:50.17 Relation 184 (V_QSTORNED_SOURCE) is ok
11:09:50.17 Relation 259 (XQD_1000_1200)
11:09:50.18 process pointer page 0 of 6
11:09:50.26 process pointer page 1 of 6
11:09:50.31 process pointer page 2 of 6
11:09:50.35 process pointer page 3 of 6
11:09:50.39 process pointer page 4 of 6
11:09:50.39 process pointer page 5 of 6
11:09:50.40 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
11:09:50.42 Relation 259 (XQD_1000_1200) is ok
11:09:50.42 Relation 260 (XQD_1200_2000)
11:09:50.42 process pointer page 0 of 10
11:09:50.51 process pointer page 1 of 10
11:09:50.56 process pointer page 2 of 10
11:09:50.59 process pointer page 3 of 10
11:09:50.60 process pointer page 4 of 10
11:09:50.62 process pointer page 5 of 10
11:09:50.65 process pointer page 6 of 10
11:09:50.68 process pointer page 7 of 10
11:09:50.70 process pointer page 8 of 10
11:09:50.71 process pointer page 9 of 10
11:09:50.71 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
11:09:50.73 Relation 260 (XQD_1200_2000) is ok
11:09:50.73 Relation 261 (XQD_1000_3300)
11:09:50.73 process pointer page 0 of 14
11:09:50.76 process pointer page 1 of 14
11:09:50.78 process pointer page 2 of 14
11:09:50.81 process pointer page 3 of 14
11:09:50.84 process pointer page 4 of 14
11:09:50.85 process pointer page 5 of 14
11:09:50.88 process pointer page 6 of 14
11:09:50.90 process pointer page 7 of 14
11:09:50.93 process pointer page 8 of 14
11:09:50.95 process pointer page 9 of 14
11:09:50.98 process pointer page 10 of 14
11:09:50.99 process pointer page 11 of 14
11:09:51.03 process pointer page 12 of 14
11:09:51.04 process pointer page 13 of 14
11:09:51.06 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
11:09:51.51 Index 2 (XQD_1000_3300_DOC)
11:09:51.84 Relation 261 (XQD_1000_3300) is ok
11:09:51.84 Relation 262 (XQD_2000_3300)
11:09:51.84 process pointer page 0 of 22
11:09:51.87 process pointer page 1 of 22
11:09:51.90 process pointer page 2 of 22
11:09:51.95 process pointer page 3 of 22
11:09:51.96 process pointer page 4 of 22
11:09:51.99 process pointer page 5 of 22
11:09:52.02 process pointer page 6 of 22
11:09:52.05 process pointer page 7 of 22
11:09:52.13 process pointer page 8 of 22
11:09:52.18 process pointer page 9 of 22
11:09:52.21 process pointer page 10 of 22
11:09:52.24 process pointer page 11 of 22
11:09:52.26 process pointer page 12 of 22
11:09:52.30 process pointer page 13 of 22
11:09:52.34 process pointer page 14 of 22
11:09:52.35 process pointer page 15 of 22
11:09:52.38 process pointer page 16 of 22
11:09:52.41 process pointer page 17 of 22
11:09:52.44 process pointer page 18 of 22
11:09:52.46 process pointer page 19 of 22
11:09:52.49 process pointer page 20 of 22
11:09:52.51 process pointer page 21 of 22
11:09:52.51 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
11:09:52.69 Relation 262 (XQD_2000_3300) is ok
11:09:52.69 Relation 263 (XQD_2100_3300)
11:09:52.69 process pointer page 0 of 13
11:09:52.71 process pointer page 1 of 13
11:09:52.73 process pointer page 2 of 13
11:09:52.76 process pointer page 3 of 13
11:09:52.77 process pointer page 4 of 13
11:09:52.79 process pointer page 5 of 13
11:09:52.80 process pointer page 6 of 13
11:09:52.83 process pointer page 7 of 13
11:09:52.85 process pointer page 8 of 13
11:09:52.87 process pointer page 9 of 13
11:09:52.88 process pointer page 10 of 13
11:09:52.91 process pointer page 11 of 13
11:09:52.93 process pointer page 12 of 13
11:09:52.94 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
11:09:52.94 Relation 263 (XQD_2100_3300) is ok
11:09:52.94 Relation 264 (XQD_3300_3400)
11:09:52.94 process pointer page 0 of 22
11:09:52.98 process pointer page 1 of 22
11:09:53.01 process pointer page 2 of 22
11:09:53.02 process pointer page 3 of 22
11:09:53.05 process pointer page 4 of 22
11:09:53.07 process pointer page 5 of 22
11:09:53.10 process pointer page 6 of 22
11:09:53.13 process pointer page 7 of 22
11:09:53.16 process pointer page 8 of 22
11:09:53.21 process pointer page 9 of 22
11:09:53.22 process pointer page 10 of 22
11:09:53.26 process pointer page 11 of 22
11:09:53.27 process pointer page 12 of 22
11:09:53.30 process pointer page 13 of 22
11:09:53.33 process pointer page 14 of 22
11:09:53.35 process pointer page 15 of 22
11:09:53.38 process pointer page 16 of 22
11:09:53.40 process pointer page 17 of 22
11:09:53.43 process pointer page 18 of 22
11:09:53.44 process pointer page 19 of 22
11:09:53.47 process pointer page 20 of 22
11:09:53.49 process pointer page 21 of 22
11:09:53.49 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
11:09:53.77 Relation 264 (XQD_3300_3400) is ok
11:09:53.77 Relation 265 (XQS_1000_1200)
11:09:53.77 process pointer page 0 of 37
11:09:53.80 process pointer page 1 of 37
11:09:53.82 process pointer page 2 of 37
11:09:53.85 process pointer page 3 of 37
11:09:53.86 process pointer page 4 of 37
11:09:53.90 process pointer page 5 of 37
11:09:53.91 process pointer page 6 of 37
11:09:53.94 process pointer page 7 of 37
11:09:53.97 process pointer page 8 of 37
11:09:54.02 process pointer page 9 of 37
11:09:54.07 process pointer page 10 of 37
11:09:54.10 process pointer page 11 of 37
11:09:54.13 process pointer page 12 of 37
11:09:54.18 process pointer page 13 of 37
11:09:54.21 process pointer page 14 of 37
11:09:54.24 process pointer page 15 of 37
11:09:54.29 process pointer page 16 of 37
11:09:54.36 process pointer page 17 of 37
11:09:54.39 process pointer page 18 of 37
11:09:54.43 process pointer page 19 of 37
11:09:54.46 process pointer page 20 of 37
11:09:54.49 process pointer page 21 of 37
11:09:54.52 process pointer page 22 of 37
11:09:54.55 process pointer page 23 of 37
11:09:54.58 process pointer page 24 of 37
11:09:54.61 process pointer page 25 of 37
11:09:54.63 process pointer page 26 of 37
11:09:54.66 process pointer page 27 of 37
11:09:54.68 process pointer page 28 of 37
11:09:54.71 process pointer page 29 of 37
11:09:54.74 process pointer page 30 of 37
11:09:54.75 process pointer page 31 of 37
11:09:54.78 process pointer page 32 of 37
11:09:54.80 process pointer page 33 of 37
11:09:54.83 process pointer page 34 of 37
11:09:54.85 process pointer page 35 of 37
11:09:54.88 process pointer page 36 of 37
11:09:54.89 Index 1 (XQS_1000_1200_DOC_ID)
11:09:55.38 Index 2 (XQS_1000_1200_SND_ID)
11:09:55.88 Index 3 (XQS_1000_1200_RCV_ID)
11:09:56.45 Relation 265 (XQS_1000_1200) is ok
11:09:56.45 Relation 266 (XQS_1200_2000)
11:09:56.45 process pointer page 0 of 43
11:09:56.49 process pointer page 1 of 43
11:09:56.52 process pointer page 2 of 43
11:09:56.55 process pointer page 3 of 43
11:09:56.58 process pointer page 4 of 43
11:09:56.59 process pointer page 5 of 43
11:09:56.63 process pointer page 6 of 43
11:09:56.66 process pointer page 7 of 43
11:09:56.69 process pointer page 8 of 43
11:09:56.70 process pointer page 9 of 43
11:09:56.73 process pointer page 10 of 43
11:09:56.75 process pointer page 11 of 43
11:09:56.78 process pointer page 12 of 43
11:09:56.81 process pointer page 13 of 43
11:09:56.83 process pointer page 14 of 43
11:09:56.86 process pointer page 15 of 43
11:09:56.88 process pointer page 16 of 43
11:09:56.91 process pointer page 17 of 43
11:09:56.94 process pointer page 18 of 43
11:09:56.97 process pointer page 19 of 43
11:09:57.00 process pointer page 20 of 43
11:09:57.02 process pointer page 21 of 43
11:09:57.05 process pointer page 22 of 43
11:09:57.08 process pointer page 23 of 43
11:09:57.11 process pointer page 24 of 43
11:09:57.12 process pointer page 25 of 43
11:09:57.16 process pointer page 26 of 43
11:09:57.19 process pointer page 27 of 43
11:09:57.22 process pointer page 28 of 43
11:09:57.23 process pointer page 29 of 43
11:09:57.27 process pointer page 30 of 43
11:09:57.30 process pointer page 31 of 43
11:09:57.33 process pointer page 32 of 43
11:09:57.36 process pointer page 33 of 43
11:09:57.39 process pointer page 34 of 43
11:09:57.42 process pointer page 35 of 43
11:09:57.45 process pointer page 36 of 43
11:09:57.48 process pointer page 37 of 43
11:09:57.51 process pointer page 38 of 43
11:09:57.55 process pointer page 39 of 43
11:09:57.56 process pointer page 40 of 43
11:09:57.59 process pointer page 41 of 43
11:09:57.62 process pointer page 42 of 43
11:09:57.64 Index 1 (XQS_1200_2000_DOC_ID)
11:09:58.45 Index 2 (XQS_1200_2000_SND_ID)
11:09:59.39 Index 3 (XQS_1200_2000_RCV_ID)
11:09:59.85 Relation 266 (XQS_1200_2000) is ok
11:09:59.85 Relation 267 (XQS_1000_3300)
11:09:59.85 process pointer page 0 of 17
11:09:59.87 process pointer page 1 of 17
11:09:59.90 process pointer page 2 of 17
11:09:59.95 process pointer page 3 of 17
11:10:00.01 process pointer page 4 of 17
11:10:00.04 process pointer page 5 of 17
11:10:00.09 process pointer page 6 of 17
11:10:00.12 process pointer page 7 of 17
11:10:00.18 process pointer page 8 of 17
11:10:00.24 process pointer page 9 of 17
11:10:00.29 process pointer page 10 of 17
11:10:00.32 process pointer page 11 of 17
11:10:00.37 process pointer page 12 of 17
11:10:00.40 process pointer page 13 of 17
11:10:00.45 process pointer page 14 of 17
11:10:00.56 process pointer page 15 of 17
11:10:00.59 process pointer page 16 of 17
11:10:00.59 Index 1 (XQS_1000_3300_DOC_ID)
11:10:00.87 Index 2 (XQS_1000_3300_SND_ID)
11:10:01.21 Index 3 (XQS_1000_3300_RCV_ID)
11:10:01.52 Relation 267 (XQS_1000_3300) is ok
11:10:01.52 Relation 268 (XQS_2000_3300)
11:10:01.52 process pointer page 0 of 1
11:10:01.52 Index 1 (XQS_2000_3300_DOC_ID)
11:10:01.52 Index 2 (XQS_2000_3300_SND_ID)
11:10:01.52 Index 3 (XQS_2000_3300_RCV_ID)
11:10:01.52 Relation 268 (XQS_2000_3300) is ok
11:10:01.52 Relation 269 (XQS_2100_3300)
11:10:01.52 process pointer page 0 of 28
11:10:01.56 process pointer page 1 of 28
11:10:01.59 process pointer page 2 of 28
11:10:01.62 process pointer page 3 of 28
11:10:01.65 process pointer page 4 of 28
11:10:01.68 process pointer page 5 of 28
11:10:01.71 process pointer page 6 of 28
11:10:01.74 process pointer page 7 of 28
11:10:01.76 process pointer page 8 of 28
11:10:01.79 process pointer page 9 of 28
11:10:01.82 process pointer page 10 of 28
11:10:01.84 process pointer page 11 of 28
11:10:01.87 process pointer page 12 of 28
11:10:01.90 process pointer page 13 of 28
11:10:01.91 process pointer page 14 of 28
11:10:01.95 process pointer page 15 of 28
11:10:01.98 process pointer page 16 of 28
11:10:02.02 process pointer page 17 of 28
11:10:02.07 process pointer page 18 of 28
11:10:02.10 process pointer page 19 of 28
11:10:02.13 process pointer page 20 of 28
11:10:02.16 process pointer page 21 of 28
11:10:02.19 process pointer page 22 of 28
11:10:02.23 process pointer page 23 of 28
11:10:02.26 process pointer page 24 of 28
11:10:02.29 process pointer page 25 of 28
11:10:02.32 process pointer page 26 of 28
11:10:02.35 process pointer page 27 of 28
11:10:02.35 Index 1 (XQS_2100_3300_DOC_ID)
11:10:02.74 Index 2 (XQS_2100_3300_SND_ID)
11:10:03.32 Index 3 (XQS_2100_3300_RCV_ID)
11:10:03.85 Relation 269 (XQS_2100_3300) is ok
11:10:03.85 Relation 270 (XQS_3300_3400)
11:10:03.85 process pointer page 0 of 5
11:10:03.91 process pointer page 1 of 5
11:10:03.94 process pointer page 2 of 5
11:10:03.97 process pointer page 3 of 5
11:10:04.04 process pointer page 4 of 5
11:10:04.05 Index 1 (XQS_3300_3400_DOC_ID)
11:10:04.13 Index 2 (XQS_3300_3400_SND_ID)
11:10:04.19 Relation 270 (XQS_3300_3400) is ok
11:10:04.19 Relation 276 (TRACE_STAT)
11:10:04.19 process pointer page 0 of 1
11:10:04.19 Relation 276 (TRACE_STAT) is ok
11:10:04.19 Validation finished
Done for 27270 ms, from 11:09:36.95 to 11:10:04.22.
Differences between old and current firebird.log
11:10:05.24. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2016-05-22 11:10 509 oltp40_fb_log_when_test_finished.log
End of gathering firebird.log AFTER test finish.
+++ Start of comparison +++
***** E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Sun May 22 11:09:37 2016
7: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Sun May 22 11:10:04 2016
12: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++
Remove 302 logs of every ISQL session if there were no serious errors.
Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp40\oltp40_*.*:
ERRORS_CHECKING_RESULT |
NO_SEVERE_ERRORS_FOUND |
ISQL logs are removed because no severe errors occured during test.
2016-05-22 11:10:10.55 - end of report, text file: e:\temp\logs.oltp40\oltp40.report.txt, html: e:\temp\logs.oltp40\oltp40.report.html