Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2016-11-19 6:58:10.99.
Server version: WI-V3.0.2.32630 Firebird 3.0
Server implementation: Firebird/Windows/AMD/Intel/x64
FB_ARCHITECTURE |
DB_NAME |
FORCED_WRITES |
SWEEP_INT |
PAGE_BUFFERS |
PAGE_SIZE |
SuperServer 3.0.2 |
D:\OLTP-EMUL\OLTP30-SMALL.FDB |
ON |
0 |
786432 |
8192 |
Test configuration settings
File: E:\OLTP-EMUL\src\oltp30_config.win
PARAM_NAME |
PARAM_VALUE |
fbc |
E:\FB30.TMPINSTANCE |
dbnm |
D:\OLTP-EMUL\oltp30-small.fdb |
host |
localhost |
port |
3333 |
usr |
SYSDBA |
pwd |
masterkey |
tmpdir |
e:\temp\logs.oltp30 |
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 |
ak30 |
upload_report |
1 |
max_snapshots_to_store |
180 |
replace_instance |
1 |
FINISH_STATE |
DTS_END |
FB_GDSCODE |
FB_MNEMONA |
STACK |
IP |
TRN_ID |
ATT_ID |
EXC_UNIT |
NORMAL: TEST_TIME EXPIRED. |
2016-11-19 06:56:00.5650 |
-1 |
<null> |
|
::1/50109 |
345967 |
5003 |
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: |
5313.27 |
7089 |
956388 |
2016-11-19 03:56 |
2016-11-19 06:56 |
customer order: creation |
411.97 |
1033 |
74154 |
2016-11-19 03:56 |
2016-11-19 06:56 |
customer order: refuse |
32.30 |
78 |
5781 |
2016-11-19 03:56 |
2016-11-19 06:56 |
order to supplier: creation |
106.44 |
7287 |
19159 |
2016-11-19 03:56 |
2016-11-19 06:56 |
order to supplier: removal |
2.26 |
78722 |
407 |
2016-11-19 03:56 |
2016-11-19 06:56 |
invoice (draft): creation |
104.24 |
11299 |
18763 |
2016-11-19 03:56 |
2016-11-19 06:56 |
invoice (draft): removal |
34.10 |
2393 |
6138 |
2016-11-19 03:56 |
2016-11-19 06:56 |
invoice accept: apply |
65.05 |
21874 |
11709 |
2016-11-19 03:56 |
2016-11-19 06:56 |
invoice accept: cancel |
16.17 |
5083 |
2894 |
2016-11-19 03:56 |
2016-11-19 06:56 |
customer reserve: creation |
3171.11 |
373 |
570800 |
2016-11-19 03:56 |
2016-11-19 06:56 |
customer reserve: removal |
817.58 |
144 |
146346 |
2016-11-19 03:56 |
2016-11-19 06:56 |
realization accept: apply |
188.40 |
328 |
33912 |
2016-11-19 03:56 |
2016-11-19 06:56 |
realization accept: cancel |
52.74 |
223 |
9441 |
2016-11-19 03:56 |
2016-11-19 06:56 |
payment from customer: creation |
136.93 |
323 |
24648 |
2016-11-19 03:56 |
2016-11-19 06:56 |
payment from customer: removal |
13.26 |
100 |
2374 |
2016-11-19 03:56 |
2016-11-19 06:56 |
payment to supplier: creation |
112.57 |
683 |
20263 |
2016-11-19 03:56 |
2016-11-19 06:56 |
payment to supplier: removal |
7.83 |
143 |
1401 |
2016-11-19 03:56 |
2016-11-19 06:56 |
service: total inventory turnovers |
20.76 |
1403 |
3736 |
2016-11-19 03:56 |
2016-11-19 06:56 |
service: total monetary turnovers |
24.86 |
64 |
4450 |
2016-11-19 03:56 |
2016-11-19 06:56 |
service: refresh index statistics |
0.07 |
3134 |
12 |
2016-11-19 03:56 |
2016-11-19 06:56 |
Done for 35930 ms, from 6:59:03.14 to 6:59:39.07.
ACTION |
ITRV_NO |
CNT_OK_PER_MINUTE |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
ITRV_BEG |
ITRV_END |
interval # 1, overall |
1 |
3764 |
72722 |
67747 |
4975 |
6.84 |
03:56:01 |
04:14:01 |
interval # 2, overall |
2 |
5352 |
102227 |
96327 |
5900 |
5.77 |
04:14:02 |
04:32:02 |
interval # 3, overall |
3 |
5604 |
105035 |
100864 |
4171 |
3.97 |
04:32:03 |
04:50:03 |
interval # 4, overall |
4 |
5778 |
110746 |
103996 |
6750 |
6.10 |
04:50:04 |
05:08:04 |
interval # 5, overall |
5 |
5319 |
102793 |
95740 |
7053 |
6.86 |
05:08:05 |
05:26:05 |
interval # 6, overall |
6 |
5223 |
99931 |
94013 |
5918 |
5.92 |
05:26:06 |
05:44:06 |
interval # 7, overall |
7 |
5280 |
101765 |
95036 |
6729 |
6.61 |
05:44:07 |
06:02:07 |
interval # 8, overall |
8 |
5380 |
104622 |
96848 |
7774 |
7.43 |
06:02:08 |
06:20:08 |
interval # 9, overall |
9 |
5918 |
110118 |
106531 |
3587 |
3.26 |
06:20:09 |
06:38:09 |
interval # 10, overall |
10 |
5516 |
104755 |
99286 |
5469 |
5.22 |
06:38:10 |
06:56:10 |
Done for 150630 ms, from 7:02:08.13 to 7:04:38.76.
TEST_PHASE |
MINUTE_SINCE_TEST_START |
AVG_ESTIMATED |
MIN_TO_AVG_RATIO |
MAX_TO_AVG_RATIO |
ROWS_AGGREGATED |
DISTINCT_ATTACHMENTS |
WARM_TIME |
1 |
6012.81 |
0.7342 |
1.2724 |
3109 |
100 |
WARM_TIME |
2 |
4388.08 |
0.8719 |
1.1215 |
2021 |
71 |
WARM_TIME |
3 |
3597.58 |
0.9120 |
1.0913 |
1490 |
60 |
WARM_TIME |
4 |
3134.88 |
0.9393 |
1.0545 |
1165 |
45 |
WARM_TIME |
5 |
2812.76 |
0.9403 |
1.0586 |
1154 |
44 |
WARM_TIME |
6 |
2595.04 |
0.9562 |
1.0509 |
1037 |
48 |
WARM_TIME |
7 |
2493.84 |
0.9376 |
1.0651 |
1182 |
56 |
WARM_TIME |
8 |
2456.62 |
0.9461 |
1.0545 |
1296 |
60 |
WARM_TIME |
9 |
2415.50 |
0.9534 |
1.0571 |
1195 |
65 |
WARM_TIME |
10 |
2409.93 |
0.9537 |
1.0499 |
1185 |
62 |
TEST_TIME |
11 |
2434.64 |
0.9448 |
1.0552 |
1204 |
70 |
TEST_TIME |
12 |
2534.61 |
0.9291 |
1.0602 |
1482 |
86 |
TEST_TIME |
13 |
2622.96 |
0.9457 |
1.0500 |
1667 |
91 |
TEST_TIME |
14 |
2687.48 |
0.9516 |
1.0507 |
1492 |
93 |
TEST_TIME |
15 |
2743.69 |
0.9606 |
1.0431 |
1547 |
96 |
TEST_TIME |
16 |
2787.26 |
0.9626 |
1.0289 |
1531 |
95 |
TEST_TIME |
17 |
2823.67 |
0.9559 |
1.0442 |
1426 |
95 |
TEST_TIME |
18 |
2879.42 |
0.9671 |
1.0375 |
1515 |
97 |
TEST_TIME |
19 |
2951.84 |
0.9588 |
1.0410 |
1862 |
98 |
TEST_TIME |
20 |
3031.24 |
0.9630 |
1.0362 |
1681 |
98 |
TEST_TIME |
21 |
3075.57 |
0.9726 |
1.0308 |
1619 |
96 |
TEST_TIME |
22 |
3140.90 |
0.9635 |
1.0322 |
1644 |
95 |
TEST_TIME |
23 |
3195.29 |
0.9705 |
1.0247 |
1321 |
96 |
TEST_TIME |
24 |
3213.30 |
0.9765 |
1.0238 |
1417 |
92 |
TEST_TIME |
25 |
3235.97 |
0.9760 |
1.0258 |
1428 |
97 |
TEST_TIME |
26 |
3283.33 |
0.9722 |
1.0275 |
1527 |
97 |
TEST_TIME |
27 |
3326.90 |
0.9765 |
1.0238 |
1498 |
98 |
TEST_TIME |
28 |
3353.83 |
0.9794 |
1.0285 |
1723 |
99 |
TEST_TIME |
29 |
3404.02 |
0.9784 |
1.0199 |
1453 |
96 |
TEST_TIME |
30 |
3449.83 |
0.9728 |
1.0262 |
1622 |
96 |
TEST_TIME |
31 |
3504.27 |
0.9777 |
1.0270 |
1604 |
97 |
TEST_TIME |
32 |
3538.96 |
0.9852 |
1.0181 |
1331 |
94 |
TEST_TIME |
33 |
3597.81 |
0.9711 |
1.0294 |
1886 |
96 |
TEST_TIME |
34 |
3681.16 |
0.9765 |
1.0297 |
1957 |
99 |
TEST_TIME |
35 |
3773.03 |
0.9763 |
1.0224 |
1963 |
94 |
TEST_TIME |
36 |
3830.23 |
0.9792 |
1.0224 |
1785 |
92 |
TEST_TIME |
37 |
3864.50 |
0.9860 |
1.0134 |
1364 |
93 |
TEST_TIME |
38 |
3869.44 |
0.9855 |
1.0140 |
1204 |
84 |
TEST_TIME |
39 |
3916.56 |
0.9761 |
1.0181 |
1635 |
96 |
TEST_TIME |
40 |
3960.42 |
0.9820 |
1.0178 |
1597 |
95 |
TEST_TIME |
41 |
4013.12 |
0.9800 |
1.0133 |
1450 |
96 |
TEST_TIME |
42 |
4042.83 |
0.9819 |
1.0159 |
1531 |
95 |
TEST_TIME |
43 |
4069.65 |
0.9857 |
1.0148 |
1379 |
97 |
TEST_TIME |
44 |
4086.64 |
0.9876 |
1.0133 |
1341 |
99 |
TEST_TIME |
45 |
4106.46 |
0.9860 |
1.0138 |
1299 |
95 |
TEST_TIME |
46 |
4117.40 |
0.9892 |
1.0117 |
1322 |
95 |
TEST_TIME |
47 |
4132.55 |
0.9866 |
1.0128 |
1421 |
93 |
TEST_TIME |
48 |
4163.63 |
0.9843 |
1.0148 |
1672 |
98 |
TEST_TIME |
49 |
4194.18 |
0.9868 |
1.0126 |
1634 |
95 |
TEST_TIME |
50 |
4239.61 |
0.9817 |
1.0161 |
1535 |
97 |
TEST_TIME |
51 |
4286.57 |
0.9854 |
1.0168 |
1658 |
95 |
TEST_TIME |
52 |
4330.02 |
0.9873 |
1.0145 |
1574 |
95 |
TEST_TIME |
53 |
4364.32 |
0.9876 |
1.0123 |
1509 |
93 |
TEST_TIME |
54 |
4394.51 |
0.9867 |
1.0109 |
1520 |
95 |
TEST_TIME |
55 |
4419.66 |
0.9868 |
1.0121 |
1555 |
97 |
TEST_TIME |
56 |
4443.26 |
0.9887 |
1.0112 |
1391 |
95 |
TEST_TIME |
57 |
4457.46 |
0.9903 |
1.0083 |
1509 |
95 |
TEST_TIME |
58 |
4461.07 |
0.9901 |
1.0138 |
1439 |
97 |
TEST_TIME |
59 |
4485.71 |
0.9912 |
1.0097 |
1197 |
96 |
TEST_TIME |
60 |
4497.84 |
0.9902 |
1.0110 |
1174 |
95 |
TEST_TIME |
61 |
4511.23 |
0.9915 |
1.0073 |
1178 |
94 |
TEST_TIME |
62 |
4512.44 |
0.9908 |
1.0104 |
1217 |
96 |
TEST_TIME |
63 |
4518.59 |
0.9930 |
1.0060 |
1357 |
91 |
TEST_TIME |
64 |
4533.01 |
0.9872 |
1.0138 |
1823 |
98 |
TEST_TIME |
65 |
4570.59 |
0.9900 |
1.0111 |
1875 |
97 |
TEST_TIME |
66 |
4592.67 |
0.9910 |
1.0119 |
1574 |
95 |
TEST_TIME |
67 |
4618.63 |
0.9912 |
1.0108 |
1569 |
92 |
TEST_TIME |
68 |
4636.26 |
0.9923 |
1.0088 |
1583 |
92 |
TEST_TIME |
69 |
4662.29 |
0.9886 |
1.0128 |
1530 |
95 |
TEST_TIME |
70 |
4690.17 |
0.9924 |
1.0087 |
1451 |
98 |
TEST_TIME |
71 |
4709.97 |
0.9903 |
1.0093 |
1396 |
97 |
TEST_TIME |
72 |
4724.90 |
0.9922 |
1.0072 |
1439 |
91 |
TEST_TIME |
73 |
4724.03 |
0.9936 |
1.0060 |
1351 |
94 |
TEST_TIME |
74 |
4723.88 |
0.9924 |
1.0095 |
1224 |
94 |
TEST_TIME |
75 |
4742.49 |
0.9921 |
1.0073 |
1351 |
96 |
TEST_TIME |
76 |
4740.58 |
0.9945 |
1.0055 |
1206 |
91 |
TEST_TIME |
77 |
4741.40 |
0.9924 |
1.0069 |
1375 |
97 |
TEST_TIME |
78 |
4743.45 |
0.9935 |
1.0063 |
1725 |
95 |
TEST_TIME |
79 |
4760.57 |
0.9900 |
1.0084 |
1754 |
95 |
TEST_TIME |
80 |
4776.49 |
0.9924 |
1.0083 |
1586 |
96 |
TEST_TIME |
81 |
4790.24 |
0.9930 |
1.0077 |
1529 |
92 |
TEST_TIME |
82 |
4800.04 |
0.9934 |
1.0086 |
1478 |
96 |
TEST_TIME |
83 |
4815.38 |
0.9933 |
1.0065 |
1362 |
97 |
TEST_TIME |
84 |
4818.40 |
0.9939 |
1.0065 |
1455 |
93 |
TEST_TIME |
85 |
4821.08 |
0.9942 |
1.0061 |
1435 |
93 |
TEST_TIME |
86 |
4825.92 |
0.9935 |
1.0059 |
1407 |
92 |
TEST_TIME |
87 |
4825.43 |
0.9944 |
1.0046 |
1307 |
91 |
TEST_TIME |
88 |
4827.16 |
0.9928 |
1.0070 |
1290 |
94 |
TEST_TIME |
89 |
4832.33 |
0.9946 |
1.0060 |
1193 |
94 |
TEST_TIME |
90 |
4829.31 |
0.9954 |
1.0053 |
1275 |
93 |
TEST_TIME |
91 |
4831.00 |
0.9939 |
1.0058 |
1219 |
95 |
TEST_TIME |
92 |
4827.61 |
0.9958 |
1.0035 |
1112 |
93 |
TEST_TIME |
93 |
4826.04 |
0.9931 |
1.0071 |
1626 |
90 |
TEST_TIME |
94 |
4842.04 |
0.9931 |
1.0078 |
1547 |
93 |
TEST_TIME |
95 |
4857.96 |
0.9939 |
1.0062 |
1618 |
91 |
TEST_TIME |
96 |
4868.93 |
0.9935 |
1.0064 |
1521 |
94 |
TEST_TIME |
97 |
4862.87 |
0.9972 |
1.0039 |
1293 |
87 |
TEST_TIME |
98 |
4856.11 |
0.9951 |
1.0054 |
1468 |
92 |
TEST_TIME |
99 |
4858.34 |
0.9948 |
1.0063 |
1376 |
95 |
TEST_TIME |
100 |
4863.92 |
0.9951 |
1.0043 |
1314 |
93 |
TEST_TIME |
101 |
4862.16 |
0.9947 |
1.0049 |
1158 |
92 |
TEST_TIME |
102 |
4862.58 |
0.9950 |
1.0047 |
1156 |
89 |
TEST_TIME |
103 |
4863.81 |
0.9947 |
1.0059 |
1149 |
93 |
TEST_TIME |
104 |
4876.46 |
0.9936 |
1.0060 |
1151 |
96 |
TEST_TIME |
105 |
4883.60 |
0.9950 |
1.0051 |
1002 |
90 |
TEST_TIME |
106 |
4885.03 |
0.9953 |
1.0038 |
1232 |
96 |
TEST_TIME |
107 |
4876.46 |
0.9962 |
1.0034 |
1170 |
88 |
TEST_TIME |
108 |
4874.17 |
0.9945 |
1.0038 |
1395 |
88 |
TEST_TIME |
109 |
4871.52 |
0.9952 |
1.0043 |
1453 |
91 |
TEST_TIME |
110 |
4872.92 |
0.9949 |
1.0060 |
1248 |
90 |
TEST_TIME |
111 |
4886.48 |
0.9942 |
1.0043 |
1295 |
90 |
TEST_TIME |
112 |
4884.50 |
0.9958 |
1.0047 |
1253 |
90 |
TEST_TIME |
113 |
4899.79 |
0.9927 |
1.0067 |
1406 |
93 |
TEST_TIME |
114 |
4913.81 |
0.9950 |
1.0041 |
1370 |
93 |
TEST_TIME |
115 |
4909.85 |
0.9961 |
1.0053 |
1316 |
89 |
TEST_TIME |
116 |
4919.99 |
0.9946 |
1.0043 |
1279 |
92 |
TEST_TIME |
117 |
4921.53 |
0.9954 |
1.0048 |
1237 |
91 |
TEST_TIME |
118 |
4918.38 |
0.9970 |
1.0034 |
1090 |
82 |
TEST_TIME |
119 |
4919.29 |
0.9948 |
1.0047 |
1081 |
89 |
TEST_TIME |
120 |
4931.43 |
0.9938 |
1.0062 |
1082 |
89 |
TEST_TIME |
121 |
4944.28 |
0.9953 |
1.0040 |
1110 |
90 |
TEST_TIME |
122 |
4941.67 |
0.9963 |
1.0027 |
1239 |
87 |
TEST_TIME |
123 |
4933.35 |
0.9962 |
1.0045 |
1143 |
88 |
TEST_TIME |
124 |
4940.83 |
0.9949 |
1.0042 |
1372 |
91 |
TEST_TIME |
125 |
4938.20 |
0.9967 |
1.0043 |
1375 |
94 |
TEST_TIME |
126 |
4945.50 |
0.9949 |
1.0052 |
1319 |
89 |
TEST_TIME |
127 |
4951.54 |
0.9961 |
1.0035 |
1397 |
91 |
TEST_TIME |
128 |
4957.55 |
0.9945 |
1.0053 |
1315 |
91 |
TEST_TIME |
129 |
4964.78 |
0.9961 |
1.0040 |
1250 |
89 |
TEST_TIME |
130 |
4962.02 |
0.9968 |
1.0031 |
1261 |
83 |
TEST_TIME |
131 |
4959.65 |
0.9959 |
1.0040 |
1301 |
85 |
TEST_TIME |
132 |
4963.58 |
0.9956 |
1.0052 |
1176 |
91 |
TEST_TIME |
133 |
4971.80 |
0.9959 |
1.0032 |
1193 |
92 |
TEST_TIME |
134 |
4968.11 |
0.9965 |
1.0039 |
1104 |
92 |
TEST_TIME |
135 |
4968.85 |
0.9964 |
1.0037 |
1190 |
96 |
TEST_TIME |
136 |
4965.73 |
0.9970 |
1.0031 |
1169 |
90 |
TEST_TIME |
137 |
4959.63 |
0.9970 |
1.0025 |
1045 |
88 |
TEST_TIME |
138 |
4957.62 |
0.9956 |
1.0049 |
1347 |
92 |
TEST_TIME |
139 |
4976.82 |
0.9938 |
1.0042 |
1141 |
90 |
TEST_TIME |
140 |
4987.01 |
0.9950 |
1.0039 |
1403 |
95 |
TEST_TIME |
141 |
4994.61 |
0.9953 |
1.0042 |
1369 |
94 |
TEST_TIME |
142 |
4997.13 |
0.9967 |
1.0047 |
1214 |
92 |
TEST_TIME |
143 |
5003.45 |
0.9964 |
1.0033 |
1183 |
92 |
TEST_TIME |
144 |
5002.59 |
0.9965 |
1.0044 |
1244 |
90 |
TEST_TIME |
145 |
5006.88 |
0.9966 |
1.0028 |
1217 |
89 |
TEST_TIME |
146 |
5002.49 |
0.9968 |
1.0032 |
1156 |
87 |
TEST_TIME |
147 |
5012.52 |
0.9944 |
1.0043 |
1187 |
93 |
TEST_TIME |
148 |
5022.75 |
0.9955 |
1.0036 |
1210 |
95 |
TEST_TIME |
149 |
5029.70 |
0.9955 |
1.0034 |
1239 |
96 |
TEST_TIME |
150 |
5026.83 |
0.9973 |
1.0026 |
1085 |
92 |
TEST_TIME |
151 |
5021.22 |
0.9971 |
1.0027 |
1105 |
92 |
TEST_TIME |
152 |
5015.70 |
0.9972 |
1.0033 |
1174 |
90 |
TEST_TIME |
153 |
5023.70 |
0.9952 |
1.0047 |
1419 |
96 |
TEST_TIME |
154 |
5036.12 |
0.9957 |
1.0043 |
1442 |
95 |
TEST_TIME |
155 |
5053.29 |
0.9944 |
1.0031 |
1353 |
98 |
TEST_TIME |
156 |
5053.21 |
0.9966 |
1.0032 |
1331 |
93 |
TEST_TIME |
157 |
5057.06 |
0.9960 |
1.0041 |
1397 |
91 |
TEST_TIME |
158 |
5058.55 |
0.9974 |
1.0028 |
1364 |
92 |
TEST_TIME |
159 |
5059.16 |
0.9963 |
1.0034 |
1336 |
93 |
TEST_TIME |
160 |
5060.76 |
0.9969 |
1.0029 |
1390 |
92 |
TEST_TIME |
161 |
5064.24 |
0.9960 |
1.0027 |
1399 |
93 |
TEST_TIME |
162 |
5063.95 |
0.9966 |
1.0026 |
1287 |
90 |
TEST_TIME |
163 |
5061.11 |
0.9970 |
1.0025 |
1324 |
90 |
TEST_TIME |
164 |
5057.79 |
0.9971 |
1.0028 |
1233 |
86 |
TEST_TIME |
165 |
5064.72 |
0.9953 |
1.0032 |
1116 |
93 |
TEST_TIME |
166 |
5067.59 |
0.9966 |
1.0029 |
1028 |
90 |
TEST_TIME |
167 |
5068.23 |
0.9967 |
1.0031 |
1148 |
88 |
TEST_TIME |
168 |
5069.47 |
0.9969 |
1.0042 |
1344 |
89 |
TEST_TIME |
169 |
5079.55 |
0.9962 |
1.0035 |
1377 |
90 |
TEST_TIME |
170 |
5084.91 |
0.9965 |
1.0028 |
1415 |
91 |
TEST_TIME |
171 |
5085.00 |
0.9969 |
1.0028 |
1291 |
88 |
TEST_TIME |
172 |
5090.94 |
0.9959 |
1.0036 |
1396 |
93 |
TEST_TIME |
173 |
5096.77 |
0.9966 |
1.0035 |
1135 |
91 |
TEST_TIME |
174 |
5107.52 |
0.9957 |
1.0034 |
1164 |
89 |
TEST_TIME |
175 |
5120.01 |
0.9952 |
1.0042 |
1142 |
94 |
TEST_TIME |
176 |
5130.82 |
0.9964 |
1.0029 |
1283 |
94 |
TEST_TIME |
177 |
5131.12 |
0.9971 |
1.0027 |
1282 |
92 |
TEST_TIME |
178 |
5131.83 |
0.9970 |
1.0028 |
1050 |
96 |
TEST_TIME |
179 |
5129.55 |
0.9976 |
1.0020 |
1290 |
91 |
TEST_TIME |
180 |
5124.30 |
0.9975 |
1.0025 |
1268 |
89 |
TEST_TIME |
181 |
5121.86 |
0.9975 |
1.0031 |
1268 |
90 |
TEST_TIME |
182 |
5120.66 |
0.9978 |
1.0027 |
1086 |
89 |
TEST_TIME |
183 |
5124.05 |
0.9966 |
1.0026 |
1408 |
89 |
TEST_TIME |
184 |
5127.93 |
0.9964 |
1.0045 |
1364 |
86 |
TEST_TIME |
185 |
5142.06 |
0.9963 |
1.0044 |
1414 |
92 |
TEST_TIME |
186 |
5148.58 |
0.9977 |
1.0021 |
1250 |
92 |
TEST_TIME |
187 |
5145.13 |
0.9974 |
1.0023 |
1317 |
89 |
TEST_TIME |
188 |
5154.66 |
0.9951 |
1.0037 |
1421 |
94 |
TEST_TIME |
189 |
5158.55 |
0.9976 |
1.0025 |
1194 |
86 |
TEST_TIME |
190 |
5147.96 |
0.9993 |
1.0036 |
110 |
100 |
Done for 11870 ms, from 7:04:40.06 to 7:04:51.93.
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 |
1967 |
6477 |
6155 |
<null> |
6135 |
3677 |
11787 |
<null> |
15979 |
3432 |
4635 |
5068 |
16390 |
4019 |
42595 |
2783 |
224995 |
335632 |
<null> |
03:56:01 |
04:14:01 |
fetches per second |
2 |
2109 |
7043 |
3803 |
4694 |
4096 |
4064 |
10801 |
4595 |
6769 |
5033 |
4162 |
3816 |
21235 |
2939 |
31052 |
3199 |
244780 |
144184 |
<null> |
04:14:02 |
04:32:02 |
fetches per second |
3 |
2117 |
5808 |
4993 |
<null> |
5340 |
3618 |
11235 |
6401 |
10547 |
2630 |
6380 |
4107 |
27542 |
4584 |
40024 |
3782 |
416389 |
265109 |
<null> |
04:32:03 |
04:50:03 |
fetches per second |
4 |
2073 |
6182 |
4532 |
3401 |
4730 |
<null> |
11097 |
5618 |
23500 |
3482 |
5315 |
3670 |
37601 |
<null> |
32074 |
<null> |
316526 |
271407 |
<null> |
04:50:04 |
05:08:04 |
fetches per second |
5 |
1880 |
6809 |
5718 |
<null> |
5665 |
3225 |
13455 |
4950 |
33974 |
3127 |
5355 |
4202 |
42824 |
4344 |
30177 |
4173 |
412532 |
308687 |
<null> |
05:08:05 |
05:26:05 |
fetches per second |
6 |
1864 |
5164 |
5430 |
5942 |
7094 |
2618 |
14073 |
<null> |
27130 |
3861 |
11411 |
3499 |
39383 |
3578 |
41674 |
3394 |
367791 |
288826 |
<null> |
05:26:06 |
05:44:06 |
fetches per second |
7 |
1780 |
5476 |
5202 |
<null> |
6335 |
<null> |
14229 |
5281 |
12123 |
4616 |
11460 |
2646 |
28127 |
3055 |
27930 |
3762 |
658145 |
299192 |
<null> |
05:44:07 |
06:02:07 |
fetches per second |
8 |
1745 |
7935 |
6128 |
<null> |
6716 |
<null> |
13974 |
<null> |
40289 |
3896 |
11360 |
2869 |
34426 |
3635 |
40938 |
2852 |
<null> |
317282 |
<null> |
06:02:08 |
06:20:08 |
fetches per second |
9 |
2034 |
6523 |
4985 |
<null> |
6671 |
<null> |
15458 |
<null> |
20157 |
3272 |
4799 |
3573 |
44200 |
3321 |
22132 |
3462 |
370745 |
315197 |
<null> |
06:20:09 |
06:38:09 |
fetches per second |
10 |
1961 |
5778 |
4551 |
<null> |
5455 |
4405 |
11966 |
5547 |
9393 |
4104 |
5818 |
3030 |
42838 |
4124 |
29802 |
<null> |
399659 |
252899 |
<null> |
06:38:10 |
06:56:10 |
marks per second |
1 |
320 |
572 |
266 |
<null> |
275 |
532 |
372 |
<null> |
1216 |
422 |
464 |
820 |
447 |
383 |
367 |
321 |
1297 |
708 |
<null> |
03:56:01 |
04:14:01 |
marks per second |
2 |
346 |
636 |
282 |
603 |
307 |
603 |
414 |
445 |
405 |
465 |
484 |
417 |
531 |
312 |
537 |
364 |
1605 |
1462 |
<null> |
04:14:02 |
04:32:02 |
marks per second |
3 |
331 |
528 |
272 |
<null> |
323 |
578 |
376 |
685 |
406 |
377 |
440 |
400 |
444 |
423 |
703 |
348 |
1331 |
1272 |
<null> |
04:32:03 |
04:50:03 |
marks per second |
4 |
330 |
568 |
300 |
460 |
305 |
<null> |
467 |
489 |
573 |
414 |
476 |
383 |
456 |
<null> |
502 |
<null> |
1236 |
569 |
<null> |
04:50:04 |
05:08:04 |
marks per second |
5 |
311 |
640 |
273 |
<null> |
283 |
519 |
434 |
467 |
470 |
363 |
422 |
449 |
399 |
420 |
467 |
479 |
1147 |
677 |
<null> |
05:08:05 |
05:26:05 |
marks per second |
6 |
309 |
481 |
258 |
557 |
318 |
427 |
348 |
<null> |
3812 |
430 |
429 |
361 |
384 |
371 |
454 |
412 |
1351 |
453 |
<null> |
05:26:06 |
05:44:06 |
marks per second |
7 |
291 |
507 |
262 |
<null> |
322 |
<null> |
470 |
461 |
443 |
480 |
402 |
304 |
406 |
278 |
354 |
394 |
874 |
406 |
<null> |
05:44:07 |
06:02:07 |
marks per second |
8 |
277 |
753 |
271 |
<null> |
266 |
<null> |
349 |
<null> |
357 |
376 |
446 |
320 |
329 |
355 |
360 |
400 |
<null> |
624 |
<null> |
06:02:08 |
06:20:08 |
marks per second |
9 |
335 |
614 |
264 |
<null> |
327 |
<null> |
455 |
<null> |
350 |
358 |
405 |
338 |
562 |
377 |
390 |
382 |
1179 |
618 |
<null> |
06:20:09 |
06:38:09 |
marks per second |
10 |
312 |
524 |
263 |
<null> |
370 |
677 |
385 |
488 |
303 |
450 |
404 |
321 |
405 |
390 |
375 |
<null> |
1052 |
674 |
<null> |
06:38:10 |
06:56:10 |
reads/fetches*100 |
1 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
03:56:01 |
04:14:01 |
reads/fetches*100 |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:14:02 |
04: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> |
04:32:03 |
04:50:03 |
reads/fetches*100 |
4 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
<null> |
04:50:04 |
05:08:04 |
reads/fetches*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:08:05 |
05:26:05 |
reads/fetches*100 |
6 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:26:06 |
05:44:06 |
reads/fetches*100 |
7 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:44:07 |
06:02:07 |
reads/fetches*100 |
8 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
06:02:08 |
06:20:08 |
reads/fetches*100 |
9 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
06:20:09 |
06:38:09 |
reads/fetches*100 |
10 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
06:38:10 |
06:56:10 |
writes/marks*100 |
1 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
4 |
0 |
<null> |
03:56:01 |
04:14:01 |
writes/marks*100 |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
4 |
0 |
<null> |
04:14:02 |
04:32:02 |
writes/marks*100 |
3 |
1 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
4 |
0 |
<null> |
04:32:03 |
04:50:03 |
writes/marks*100 |
4 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
3 |
0 |
<null> |
04:50:04 |
05:08:04 |
writes/marks*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
3 |
0 |
<null> |
05:08:05 |
05:26:05 |
writes/marks*100 |
6 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
1 |
0 |
0 |
0 |
0 |
1 |
0 |
1 |
6 |
0 |
<null> |
05:26:06 |
05:44:06 |
writes/marks*100 |
7 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
4 |
1 |
<null> |
05:44:07 |
06:02:07 |
writes/marks*100 |
8 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
<null> |
0 |
<null> |
06:02:08 |
06:20:08 |
writes/marks*100 |
9 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
3 |
0 |
<null> |
06:20:09 |
06:38:09 |
writes/marks*100 |
10 |
0 |
0 |
0 |
<null> |
0 |
3 |
0 |
0 |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
4 |
0 |
<null> |
06:38:10 |
06:56:10 |
Done for 9830 ms, from 7:04:52.77 to 7:05:02.60.
UNIT |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
OK_MIN_MS |
OK_MAX_MS |
OK_AVG_MS |
CNT_LK_CONFL |
JOB_BEG |
JOB_END |
doc_list_aiud |
1620289 |
1571274 |
49015 |
3.02 |
0 |
15506 |
26 |
49015 |
2016-11-19 03:56 |
2016-11-19 06:56 |
doc_list_biud |
1620691 |
1571273 |
49418 |
3.04 |
0 |
9048 |
43 |
49418 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_add_invoice_to_stock |
17888 |
11709 |
6179 |
34.54 |
110 |
139749 |
21874 |
6179 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_cancel_adding_invoice |
3520 |
2894 |
626 |
17.78 |
15 |
149200 |
5083 |
626 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_cancel_client_order |
6086 |
5781 |
305 |
5.01 |
0 |
671 |
78 |
305 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_cancel_customer_reserve |
190959 |
146346 |
44613 |
23.36 |
0 |
3354 |
144 |
44613 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_cancel_pay_from_customer |
2393 |
2374 |
19 |
0.79 |
0 |
1373 |
100 |
19 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_cancel_pay_to_supplier |
1427 |
1401 |
26 |
1.82 |
0 |
843 |
143 |
26 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_cancel_supplier_invoice |
7291 |
6138 |
1153 |
15.81 |
15 |
9063 |
2393 |
1153 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_cancel_supplier_order |
1346 |
407 |
939 |
69.76 |
62 |
482701 |
78722 |
939 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_cancel_write_off |
12948 |
9441 |
3507 |
27.08 |
0 |
3198 |
223 |
3507 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_client_order |
74154 |
74154 |
0 |
0.00 |
15 |
4368 |
1033 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_customer_reserve |
570800 |
570800 |
0 |
0.00 |
0 |
26598 |
373 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_fill_shopping_cart |
112076 |
112076 |
0 |
0.00 |
0 |
15251 |
224 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_fill_shopping_cart_clo_res |
570800 |
570800 |
0 |
0.00 |
0 |
702 |
1 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_get_clo_for_invoice |
11709 |
11709 |
0 |
0.00 |
0 |
9267 |
1039 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_kill_cost_storno |
19952 |
16110 |
3842 |
19.25 |
0 |
5476 |
75 |
3842 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_kill_qstorno_ret_qs2qd |
401796 |
308678 |
93118 |
23.17 |
0 |
9048 |
109 |
93118 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_kill_qty_storno |
265954 |
216628 |
49326 |
18.54 |
0 |
9048 |
305 |
49326 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_lock_selected_doc |
72896 |
63575 |
9321 |
12.78 |
0 |
172 |
3 |
9321 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_make_cost_storno |
90532 |
90532 |
0 |
0.00 |
0 |
15116 |
253 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_multiply_rows_for_pdistr |
90532 |
90532 |
0 |
0.00 |
0 |
1092 |
146 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_multiply_rows_for_qdistr |
74154 |
74154 |
0 |
0.00 |
0 |
3681 |
765 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_pay_from_customer |
24648 |
24648 |
0 |
0.00 |
47 |
5148 |
323 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_pay_to_supplier |
20263 |
20263 |
0 |
0.00 |
31 |
9469 |
683 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_payment_common |
44911 |
44911 |
0 |
0.00 |
0 |
7707 |
37 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_qd_handle_on_cancel_clo |
6086 |
5781 |
305 |
5.01 |
0 |
468 |
53 |
305 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_qd_handle_on_invoice_upd_sts |
15044 |
14603 |
441 |
2.93 |
0 |
8939 |
1835 |
441 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_qd_handle_on_reserve_upd_sts |
33912 |
33912 |
0 |
0.00 |
0 |
1997 |
124 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_reserve_write_off |
34871 |
33912 |
959 |
2.75 |
15 |
8128 |
328 |
959 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_supplier_invoice |
18763 |
18763 |
0 |
0.00 |
78 |
45287 |
11299 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
sp_supplier_order |
19159 |
19159 |
0 |
0.00 |
94 |
25038 |
7287 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
srv_find_qd_qs_mism |
918593 |
869631 |
48962 |
5.33 |
0 |
2730 |
2 |
48962 |
2016-11-19 03:56 |
2016-11-19 06:56 |
srv_make_invnt_saldo |
3736 |
3736 |
0 |
0.00 |
202 |
23448 |
1403 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
srv_make_money_saldo |
4450 |
4450 |
0 |
0.00 |
0 |
6271 |
64 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
1919 |
3994 |
3134 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-abend:sp_add_invoice_to_stock |
6179 |
6179 |
0 |
0.00 |
0 |
499 |
140 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-abend:sp_cancel_adding_invoice |
534 |
534 |
0 |
0.00 |
46 |
2964 |
1084 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-abend:sp_cancel_client_order |
305 |
305 |
0 |
0.00 |
62 |
499 |
224 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-abend:sp_cancel_customer_reserve |
72 |
72 |
0 |
0.00 |
62 |
374 |
144 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-abend:sp_cancel_pay_from_customer |
19 |
19 |
0 |
0.00 |
140 |
281 |
204 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-abend:sp_cancel_pay_to_supplier |
26 |
26 |
0 |
0.00 |
156 |
374 |
239 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-abend:sp_cancel_supplier_invoice |
516 |
516 |
0 |
0.00 |
15 |
359 |
142 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-abend:sp_cancel_supplier_order |
6044 |
6044 |
0 |
0.00 |
0 |
3026 |
1459 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-abend:sp_cancel_write_off |
76 |
76 |
0 |
0.00 |
0 |
312 |
144 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-abend:sp_reserve_write_off |
959 |
959 |
0 |
0.00 |
47 |
390 |
139 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-norm:sp_add_invoice_to_stock |
11773 |
11773 |
0 |
0.00 |
0 |
49717 |
10328 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-norm:sp_cancel_adding_invoice |
1174 |
1174 |
0 |
0.00 |
125 |
35193 |
8537 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-norm:sp_cancel_client_order |
5781 |
5781 |
0 |
0.00 |
0 |
780 |
250 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-norm:sp_cancel_customer_reserve |
2419 |
2419 |
0 |
0.00 |
0 |
655 |
275 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-norm:sp_cancel_pay_from_customer |
2374 |
2374 |
0 |
0.00 |
0 |
546 |
194 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-norm:sp_cancel_pay_to_supplier |
1401 |
1401 |
0 |
0.00 |
0 |
515 |
191 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-norm:sp_cancel_supplier_invoice |
982 |
982 |
0 |
0.00 |
15 |
593 |
247 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-norm:sp_cancel_supplier_order |
407 |
407 |
0 |
0.00 |
202 |
363185 |
47112 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-norm:sp_cancel_write_off |
3416 |
3416 |
0 |
0.00 |
0 |
624 |
277 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-norm:sp_client_order |
74160 |
74160 |
0 |
0.00 |
0 |
1170 |
330 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-norm:sp_customer_reserve |
3467 |
3467 |
0 |
0.00 |
0 |
639 |
179 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-norm:sp_pay_from_customer |
24648 |
24648 |
0 |
0.00 |
0 |
764 |
222 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-norm:sp_pay_to_supplier |
20265 |
20265 |
0 |
0.00 |
0 |
796 |
222 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-norm:sp_reserve_write_off |
33912 |
33912 |
0 |
0.00 |
0 |
796 |
304 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-norm:sp_supplier_invoice |
18772 |
18772 |
0 |
0.00 |
0 |
1061 |
332 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-norm:sp_supplier_order |
19168 |
19168 |
0 |
0.00 |
0 |
1014 |
331 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-norm:srv_make_invnt_saldo |
3736 |
3736 |
0 |
0.00 |
0 |
250 |
27 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-norm:srv_make_money_saldo |
4450 |
4450 |
0 |
0.00 |
0 |
328 |
29 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
t$perf-norm:srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
842 |
1638 |
1190 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
v_add_invoice_to_stock |
35776 |
23418 |
12358 |
34.54 |
0 |
218 |
5 |
12358 |
2016-11-19 03:56 |
2016-11-19 06:56 |
v_all_customers |
111338 |
111338 |
0 |
0.00 |
0 |
125 |
5 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
v_all_suppliers |
77380 |
77380 |
0 |
0.00 |
0 |
125 |
6 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
v_all_wares |
148308 |
148308 |
0 |
0.00 |
0 |
203 |
9 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
v_cancel_adding_invoice |
2808 |
2348 |
460 |
16.38 |
0 |
920 |
61 |
460 |
2016-11-19 03:56 |
2016-11-19 06:56 |
v_cancel_client_order |
12172 |
11562 |
610 |
5.01 |
0 |
94 |
4 |
610 |
2016-11-19 03:56 |
2016-11-19 06:56 |
v_cancel_customer_prepayment |
4786 |
4748 |
38 |
0.79 |
0 |
94 |
5 |
38 |
2016-11-19 03:56 |
2016-11-19 06:56 |
v_cancel_customer_reserve |
4982 |
4838 |
144 |
2.89 |
0 |
219 |
6 |
144 |
2016-11-19 03:56 |
2016-11-19 06:56 |
v_cancel_payment_to_supplier |
2854 |
2802 |
52 |
1.82 |
0 |
109 |
5 |
52 |
2016-11-19 03:56 |
2016-11-19 06:56 |
v_cancel_supplier_invoice |
2996 |
1964 |
1032 |
34.44 |
0 |
141 |
7 |
1032 |
2016-11-19 03:56 |
2016-11-19 06:56 |
v_cancel_supplier_order |
2692 |
814 |
1878 |
69.76 |
0 |
124 |
6 |
1878 |
2016-11-19 03:56 |
2016-11-19 06:56 |
v_cancel_write_off |
6984 |
6832 |
152 |
2.17 |
0 |
1248 |
32 |
152 |
2016-11-19 03:56 |
2016-11-19 06:56 |
v_max_id_clo_ord |
19159 |
19159 |
0 |
0.00 |
0 |
1045 |
17 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
v_max_id_clo_res |
3466 |
3466 |
0 |
0.00 |
0 |
218 |
21 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
v_max_id_ord_sup |
18763 |
18763 |
0 |
0.00 |
0 |
593 |
16 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
v_max_non_paid_invoice |
19495 |
19495 |
0 |
0.00 |
0 |
2761 |
8 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
v_max_non_paid_realizn |
24648 |
24648 |
0 |
0.00 |
0 |
140 |
6 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
v_min_id_clo_ord |
19159 |
19159 |
0 |
0.00 |
0 |
904 |
15 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
v_min_id_clo_res |
3466 |
3466 |
0 |
0.00 |
0 |
1404 |
12 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
v_min_id_ord_sup |
18763 |
18763 |
0 |
0.00 |
0 |
749 |
12 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
v_min_non_paid_invoice |
20263 |
20263 |
0 |
0.00 |
0 |
7629 |
32 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
v_min_non_paid_realizn |
24648 |
24648 |
0 |
0.00 |
0 |
967 |
5 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
v_our_firm |
36970 |
36970 |
0 |
0.00 |
0 |
125 |
5 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
v_reserve_write_off |
69742 |
67824 |
1918 |
2.75 |
0 |
188 |
5 |
1918 |
2016-11-19 03:56 |
2016-11-19 06:56 |
x_lock_depdocs_on_canc_invoice |
12210 |
8050 |
4160 |
34.07 |
0 |
827 |
11 |
4160 |
2016-11-19 03:56 |
2016-11-19 06:56 |
x_lock_depdocs_on_canc_sup_ord |
1342 |
407 |
935 |
69.67 |
0 |
94 |
5 |
935 |
2016-11-19 03:56 |
2016-11-19 06:56 |
x_make_qstorno_1000_1200 |
19161 |
19161 |
0 |
0.00 |
47 |
20359 |
6703 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
x_make_qstorno_1200_2000 |
18763 |
18763 |
0 |
0.00 |
47 |
42588 |
10774 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
x_make_qstorno_2100_3300 |
570800 |
570800 |
0 |
0.00 |
0 |
26551 |
370 |
0 |
2016-11-19 03:56 |
2016-11-19 06:56 |
Done for 282940 ms, from 7:09:43.12 to 7:14:26.06.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
DTS_BEG |
DTS_END |
deadlock |
137 |
sp_kill_cost_storno |
335544336 |
2016-11-19 03:56 |
2016-11-19 06:55 |
deadlock |
7 |
sp_kill_qstorno_ret_qs2qd |
335544336 |
2016-11-19 04:45 |
2016-11-19 06:49 |
deadlock |
80 |
sp_lock_selected_doc |
335544336 |
2016-11-19 04:00 |
2016-11-19 06:55 |
deadlock |
305 |
sp_qd_handle_on_cancel_clo |
335544336 |
2016-11-19 03:57 |
2016-11-19 06:55 |
deadlock |
76 |
sp_qd_handle_on_invoice_upd_sts |
335544336 |
2016-11-19 03:57 |
2016-11-19 06:33 |
concurrent_transaction |
7762 |
sp_lock_selected_doc |
335544878 |
2016-11-19 03:56 |
2016-11-19 06:56 |
concurrent_transaction |
462 |
x_lock_depdocs_on_canc_invoice |
335544878 |
2016-11-19 03:56 |
2016-11-19 06:55 |
concurrent_transaction |
491 |
x_lock_depdocs_on_canc_sup_ord |
335544878 |
2016-11-19 03:56 |
2016-11-19 06:55 |
Done for 8940 ms, from 7:14:33.05 to 7:14:41.99.
MON$DATABASE_NAME D:\OLTP-EMUL\OLTP30-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 346799
MON$OLDEST_ACTIVE 346800
MON$OLDEST_SNAPSHOT 346800
MON$NEXT_TRANSACTION 346800
MON$PAGE_BUFFERS 786432
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2015-12-11 13:07:49.8140
MON$PAGES 713984
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-V3.0.2.32630 Firebird 3.0
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.2.32630 Firebird 3.0"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.2.32630 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P14"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.2.32630 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P14"
on disk structure version 12.0
Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB"
Database header page information:
Flags 0
Generation 347178
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 346801
Oldest active 346802
Oldest snapshot 346802
Next transaction 346803
Sequence number 0
Next attachment ID 5187
Implementation HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Dec 11, 2015 13:07:49
Attributes force write
Variable header data:
Sweep interval: 0
*END*
Database file sequence:
File D:\OLTP-EMUL\OLTP30-SMALL.FDB is the only file
Analyzing database pages ...
AGENTS (154)
Primary pointer page: 311, Index root page: 312
Total formats: 1, used formats: 1
Average record length: 34.24, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 344.00, compression ratio: 10.05
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_ID_DESC (2)
Root page: 322, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_OUR_FIRM (4)
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 48
Average key length: 2.04, compression ratio: 0.50
Average prefix length: 0.96, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_SUPPLIER (3)
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 45
Average key length: 2.04, compression ratio: 0.53
Average prefix length: 1.02, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_NAME_UNQ (1)
Root page: 321, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.92, total dup: 0, max dup: 0
Average key length: 16.60, compression ratio: 0.92
Average prefix length: 1.34, average data length: 13.92
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_AGENTS (0)
Root page: 320, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BUSINESS_OPS (158)
Primary pointer page: 332, Index root page: 333
Total formats: 1, used formats: 1
Average record length: 103.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 996.00, compression ratio: 9.67
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 28%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BO_UNIT_UNQ (1)
Root page: 336, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 18.00, total dup: 0, max dup: 0
Average key length: 16.95, compression ratio: 1.25
Average prefix length: 7.21, average data length: 14.00
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BUSINESS_OPS_RND_WGTH (2)
Root page: 337, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 4.05, total dup: 7, max dup: 3
Average key length: 3.00, compression ratio: 0.75
Average prefix length: 1.42, average data length: 0.84
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$1 (0)
Root page: 335, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 5.26, total dup: 0, max dup: 0
Average key length: 4.21, compression ratio: 0.64
Average prefix length: 1.05, average data length: 1.63
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DOC_DATA (141)
Primary pointer page: 251, Index root page: 252
Total formats: 1, used formats: 1
Average record length: 47.17, total records: 1737844
Average version length: 47.65, total versions: 5144, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.36
Pointer pages: 12, data page slots: 19200
Data pages: 19200, average fill: 72%
Primary pages: 19200, secondary pages: 0, swept pages: 14161
Empty pages: 5, full pages: 10023
Fill distribution:
0 - 19% = 5
20 - 39% = 1
40 - 59% = 52
60 - 79% = 19142
80 - 99% = 0
Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 19783, depth: 3, leaf buckets: 7920, nodes: 1737844
Average node length: 20.00, total dup: 0, max dup: 0
Average key length: 17.05, compression ratio: 1.58
Average prefix length: 12.94, average data length: 14.06
Clustering factor: 701976, ratio: 0.40
Fill distribution:
0 - 19% = 248
20 - 39% = 369
40 - 59% = 5101
60 - 79% = 1542
80 - 99% = 660
Index DOC_DATA_ID_DESC (2)
Root page: 46992, depth: 3, leaf buckets: 6120, nodes: 1737844
Average node length: 11.61, total dup: 0, max dup: 0
Average key length: 8.67, compression ratio: 1.04
Average prefix length: 3.33, average data length: 5.67
Clustering factor: 645926, ratio: 0.37
Fill distribution:
0 - 19% = 0
20 - 39% = 2753
40 - 59% = 3365
60 - 79% = 1
80 - 99% = 1
Index FK_DOC_DATA_DOC_LIST (3)
Root page: 163149, depth: 3, leaf buckets: 3209, nodes: 1737844
Average node length: 7.18, total dup: 1179988, max dup: 49
Average key length: 4.23, compression ratio: 2.13
Average prefix length: 7.09, average data length: 1.91
Clustering factor: 658664, ratio: 0.38
Fill distribution:
0 - 19% = 67
20 - 39% = 500
40 - 59% = 2344
60 - 79% = 90
80 - 99% = 208
DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 60.15, total records: 609859
Average version length: 36.45, total versions: 2527, max versions: 3
Average fragment length: 7.10, total fragments: 72, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.60
Pointer pages: 5, data page slots: 7912
Data pages: 7912, average fill: 73%
Primary pages: 7902, secondary pages: 10, swept pages: 7295
Empty pages: 0, full pages: 5247
Fill distribution:
0 - 19% = 11
20 - 39% = 9
40 - 59% = 50
60 - 79% = 7802
80 - 99% = 40
Index DOC_LIST_ID_DESC (1)
Root page: 229035, depth: 3, leaf buckets: 2292, nodes: 609859
Average node length: 11.78, total dup: 0, max dup: 0
Average key length: 8.91, compression ratio: 1.01
Average prefix length: 3.08, average data length: 5.92
Clustering factor: 182527, ratio: 0.30
Fill distribution:
0 - 19% = 0
20 - 39% = 1358
40 - 59% = 931
60 - 79% = 3
80 - 99% = 0
Index FK_DOC_LIST_AGENTS (2)
Root page: 2964, depth: 2, leaf buckets: 667, nodes: 609859
Average node length: 4.87, total dup: 609809, max dup: 45652
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 289368, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 600
60 - 79% = 47
80 - 99% = 20
Index PK_DOC_LIST (0)
Root page: 250630, depth: 3, leaf buckets: 2170, nodes: 609859
Average node length: 11.78, total dup: 0, max dup: 0
Average key length: 8.91, compression ratio: 1.01
Average prefix length: 3.08, average data length: 5.92
Clustering factor: 182527, ratio: 0.30
Fill distribution:
0 - 19% = 59
20 - 39% = 1037
40 - 59% = 997
60 - 79% = 3
80 - 99% = 74
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: 63.40, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 16.92, total fragments: 394, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.64
Pointer pages: 3, data page slots: 1566
Data pages: 20, average fill: 34%
Primary pages: 6, secondary pages: 14, swept pages: 4
Empty pages: 3, full pages: 3
Fill distribution:
0 - 19% = 10
20 - 39% = 4
40 - 59% = 2
60 - 79% = 1
80 - 99% = 3
Index PK_INVNT_SALDO (0)
Root page: 281, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 262, ratio: 0.66
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
INVNT_TURNOVER_LOG (157)
Primary pointer page: 330, Index root page: 331
Total formats: 1, used formats: 1
Average record length: 52.15, total records: 11233
Average version length: 71.32, total versions: 2986, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.84
Pointer pages: 4, data page slots: 4776
Data pages: 1473, average fill: 12%
Primary pages: 1473, secondary pages: 0, swept pages: 1102
Empty pages: 89, full pages: 3
Fill distribution:
0 - 19% = 1245
20 - 39% = 200
40 - 59% = 24
60 - 79% = 4
80 - 99% = 0
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 997, depth: 2, leaf buckets: 49, nodes: 11233
Average node length: 14.46, total dup: 1246, max dup: 1
Average key length: 11.50, compression ratio: 2.35
Average prefix length: 18.39, average data length: 8.61
Clustering factor: 8935, ratio: 0.80
Fill distribution:
0 - 19% = 1
20 - 39% = 21
40 - 59% = 23
60 - 79% = 3
80 - 99% = 1
MONEY_SALDO (143)
Primary pointer page: 261, Index root page: 262
Total formats: 1, used formats: 1
Average record length: 15.04, total records: 49
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 2.13
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 20%
Primary pages: 1, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MONEY_SALDO (0)
Root page: 272, depth: 1, leaf buckets: 1, nodes: 49
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MONEY_TURNOVER_LOG (142)
Primary pointer page: 259, Index root page: 260
Total formats: 1, used formats: 1
Average record length: 47.60, total records: 196
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: 64.00, compression ratio: 1.34
Pointer pages: 1, data page slots: 112
Data pages: 62, average fill: 6%
Primary pages: 62, secondary pages: 0, swept pages: 57
Empty pages: 22, full pages: 0
Fill distribution:
0 - 19% = 61
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 96750, depth: 2, leaf buckets: 1, nodes: 196
Average node length: 8.26, total dup: 144, max dup: 45
Average key length: 6.35, compression ratio: 2.99
Average prefix length: 14.91, average data length: 4.09
Clustering factor: 140, ratio: 0.71
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG (164)
Primary pointer page: 352, Index root page: 353
Total formats: 2, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_DTS (4)
Root page: 363, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_GDSCODE (2)
Root page: 361, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_ROWSET_DESC (1)
Root page: 360, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_UNIT (3)
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG (0)
Root page: 359, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG_TABLE_STATS (165)
Primary pointer page: 364, Index root page: 365
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_DTS (4)
Root page: 370, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_GDSCODE (2)
Root page: 368, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_ROWSET (1)
Root page: 367, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_TN_UNIT (3)
Root page: 369, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG_TABLE_STATS (0)
Root page: 366, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
OPTYPES (138)
Primary pointer page: 239, Index root page: 240
Total formats: 1, used formats: 1
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 5.54
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 9%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OPTYPES_MCODE_UNQ (1)
Root page: 242, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 8.56, total dup: 0, max dup: 0
Average key length: 6.89, compression ratio: 0.73
Average prefix length: 0.44, average data length: 4.56
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_OPTYPES (0)
Root page: 241, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 6.11, total dup: 0, max dup: 0
Average key length: 5.00, compression ratio: 0.60
Average prefix length: 0.89, average data length: 2.11
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PDISTR (150)
Primary pointer page: 293, Index root page: 294
Total formats: 1, used formats: 1
Average record length: 41.89, total records: 250390
Average version length: 29.68, total versions: 3947, max versions: 7
Average fragment length: 33.15, total fragments: 48, max fragments: 1
Average unpacked length: 64.00, compression ratio: 1.53
Pointer pages: 2, data page slots: 3264
Data pages: 3264, average fill: 58%
Primary pages: 3241, secondary pages: 23, swept pages: 3089
Empty pages: 4, full pages: 129
Fill distribution:
0 - 19% = 33
20 - 39% = 130
40 - 59% = 1505
60 - 79% = 1584
80 - 99% = 12
Index PDISTR_AGENT_ID (4)
Root page: 3600, depth: 2, leaf buckets: 230, nodes: 250390
Average node length: 4.66, total dup: 250341, max dup: 11508
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 35729, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 22
40 - 59% = 73
60 - 79% = 94
80 - 99% = 40
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4281, depth: 2, leaf buckets: 292, nodes: 250390
Average node length: 5.62, total dup: 225645, max dup: 30
Average key length: 2.97, compression ratio: 7.40
Average prefix length: 21.13, average data length: 0.87
Clustering factor: 42203, ratio: 0.17
Fill distribution:
0 - 19% = 2
20 - 39% = 36
40 - 59% = 107
60 - 79% = 109
80 - 99% = 38
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3974, depth: 2, leaf buckets: 298, nodes: 250390
Average node length: 5.62, total dup: 225645, max dup: 30
Average key length: 2.97, compression ratio: 7.40
Average prefix length: 21.13, average data length: 0.87
Clustering factor: 42287, ratio: 0.17
Fill distribution:
0 - 19% = 3
20 - 39% = 33
40 - 59% = 122
60 - 79% = 108
80 - 99% = 32
Index PDISTR_SND_ID (1)
Root page: 4313, depth: 2, leaf buckets: 310, nodes: 250390
Average node length: 5.40, total dup: 225645, max dup: 30
Average key length: 2.76, compression ratio: 3.27
Average prefix length: 8.34, average data length: 0.66
Clustering factor: 42296, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 56
40 - 59% = 147
60 - 79% = 87
80 - 99% = 20
PERF_ESTIMATED (160)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 27.88, total records: 262787
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: 64%
Primary pages: 2248, secondary pages: 0, swept pages: 0
Empty pages: 6, full pages: 2241
Fill distribution:
0 - 19% = 7
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2241
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 702908, depth: 2, leaf buckets: 205, nodes: 262787
Average node length: 4.51, total dup: 262596, max dup: 3108
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.58, average data length: 0.00
Clustering factor: 25334, ratio: 0.10
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 58
60 - 79% = 82
80 - 99% = 65
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.69, total records: 9509401
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1440.35, compression ratio: 9.75
Pointer pages: 136, data page slots: 221088
Data pages: 221088, average fill: 87%
Primary pages: 221088, secondary pages: 0, swept pages: 3
Empty pages: 6, full pages: 221081
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 221082
Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 59394, depth: 3, leaf buckets: 9657, nodes: 9509401
Average node length: 5.59, total dup: 8417909, max dup: 99
Average key length: 2.23, compression ratio: 3.59
Average prefix length: 7.82, average data length: 0.18
Clustering factor: 6260829, ratio: 0.66
Fill distribution:
0 - 19% = 17
20 - 39% = 0
40 - 59% = 3508
60 - 79% = 3790
80 - 99% = 2342
Index PERF_LOG_GDSCODE (3)
Root page: 163150, depth: 3, leaf buckets: 9140, nodes: 9509401
Average node length: 4.40, total dup: 9509396, max dup: 9100496
Average key length: 1.04, compression ratio: 0.21
Average prefix length: 0.21, average data length: 0.00
Clustering factor: 364957, ratio: 0.04
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 9110
60 - 79% = 2
80 - 99% = 27
Index PERF_LOG_TRN_DESC (2)
Root page: 43359, depth: 3, leaf buckets: 10559, nodes: 9509401
Average node length: 5.60, total dup: 9201259, max dup: 12987
Average key length: 2.24, compression ratio: 4.02
Average prefix length: 8.79, average data length: 0.21
Clustering factor: 4657870, ratio: 0.49
Fill distribution:
0 - 19% = 6
20 - 39% = 2
40 - 59% = 6235
60 - 79% = 2480
80 - 99% = 1836
Index PERF_LOG_UNIT (1)
Root page: 65474, depth: 3, leaf buckets: 11089, nodes: 9509401
Average node length: 5.45, total dup: 9464417, max dup: 1423811
Average key length: 2.09, compression ratio: 17.99
Average prefix length: 37.56, average data length: 0.09
Clustering factor: 5751502, ratio: 0.60
Fill distribution:
0 - 19% = 21
20 - 39% = 1
40 - 59% = 8879
60 - 79% = 687
80 - 99% = 1501
PHRASES (145)
Primary pointer page: 265, Index root page: 266
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_ID_DESC (3)
Root page: 279, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_NAME (2)
Root page: 278, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_UNQ (1)
Root page: 277, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_PHRASES (0)
Root page: 276, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PSTORNED (151)
Primary pointer page: 301, Index root page: 302
Total formats: 1, used formats: 1
Average record length: 54.59, total records: 328662
Average version length: 55.51, total versions: 2631, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.47
Pointer pages: 3, data page slots: 3984
Data pages: 3984, average fill: 73%
Primary pages: 3984, secondary pages: 0, swept pages: 2719
Empty pages: 7, full pages: 3145
Fill distribution:
0 - 19% = 9
20 - 39% = 13
40 - 59% = 81
60 - 79% = 3872
80 - 99% = 9
Index PSTORNED_RCV_ID (2)
Root page: 2296, depth: 2, leaf buckets: 418, nodes: 328662
Average node length: 5.95, total dup: 273616, max dup: 648
Average key length: 3.24, compression ratio: 2.78
Average prefix length: 7.93, average data length: 1.07
Clustering factor: 35488, ratio: 0.11
Fill distribution:
0 - 19% = 3
20 - 39% = 6
40 - 59% = 253
60 - 79% = 121
80 - 99% = 35
Index PSTORNED_SND_ID (1)
Root page: 2211, depth: 2, leaf buckets: 352, nodes: 328662
Average node length: 5.52, total dup: 293844, max dup: 344
Average key length: 2.81, compression ratio: 3.20
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 69208, ratio: 0.21
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 161
60 - 79% = 136
80 - 99% = 53
RULES_FOR_PDISTR (152)
Primary pointer page: 303, Index root page: 304
Total formats: 1, used formats: 1
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 336.00, compression ratio: 18.67
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 2%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_PDISTR_UNQ (0)
Root page: 308, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 11.50, total dup: 0, max dup: 0
Average key length: 10.25, compression ratio: 0.88
Average prefix length: 1.50, average data length: 7.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RULES_FOR_QDISTR (139)
Primary pointer page: 243, Index root page: 244
Total formats: 1, used formats: 1
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 332.00, compression ratio: 10.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_RCVOP (1)
Root page: 246, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 5.29, total dup: 2, max dup: 2
Average key length: 4.14, compression ratio: 0.72
Average prefix length: 1.43, average data length: 1.57
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_UNQ (0)
Root page: 245, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 10.14, total dup: 0, max dup: 0
Average key length: 8.86, compression ratio: 0.94
Average prefix length: 2.14, average data length: 6.14
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SEMAPHORES (156)
Primary pointer page: 315, Index root page: 316
Total formats: 1, used formats: 1
Average record length: 34.25, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 338.00, compression ratio: 9.87
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 3%
Primary pages: 1, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_SEMAPHORES (0)
Root page: 327, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 12.50, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.50, average data length: 8.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SEMAPHORES_TASK_UNQ (1)
Root page: 328, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 22.50, total dup: 0, max dup: 0
Average key length: 21.00, compression ratio: 1.07
Average prefix length: 4.00, average data length: 18.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SETTINGS (137)
Primary pointer page: 236, Index root page: 237
Total formats: 1, used formats: 1
Average record length: 98.32, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1347.00, compression ratio: 13.70
Pointer pages: 1, data page slots: 2
Data pages: 2, average fill: 81%
Primary pages: 2, secondary pages: 0, swept pages: 2
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1
Index SETTINGS_MODE_CODE (0)
Root page: 238, depth: 1, leaf buckets: 1, nodes: 114
Average node length: 27.07, total dup: 0, max dup: 0
Average key length: 26.06, compression ratio: 1.70
Average prefix length: 21.23, average data length: 23.07
Clustering factor: 6, ratio: 0.05
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$RAND$CALLS (136)
Primary pointer page: 234, Index root page: 235
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$SOURCE (135)
Primary pointer page: 232, Index root page: 233
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$DEP_DOCS (129)
Primary pointer page: 198, Index root page: 199
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_DEP_DOCS_UNQ (0)
Root page: 200, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$IDX_RECALC (132)
Primary pointer page: 207, Index root page: 224
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0)
Root page: 226, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG (133)
Primary pointer page: 227, Index root page: 228
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG_TABLE_STATS (134)
Primary pointer page: 230, Index root page: 231
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_LOG (163)
Primary pointer page: 350, Index root page: 351
Total formats: 2, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Root page: 358, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_MON (131)
Primary pointer page: 205, Index root page: 206
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$RESULT_SET (130)
Primary pointer page: 201, Index root page: 202
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_DOC (1)
Root page: 204, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_WARE_DOC (0)
Root page: 203, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$SHOPPING_CART (128)
Primary pointer page: 193, Index root page: 194
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_SHOPCART_UNQ (0)
Root page: 197, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRACE_STAT (276)
Primary pointer page: 557, Index root page: 68921
Total formats: 1, used formats: 1
Average record length: 54.25, total records: 3072
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: 67%
Primary pages: 40, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 35
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 0
60 - 79% = 36
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: 47.58, total records: 6852
Average version length: 72.17, total versions: 2332, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.86
Pointer pages: 5, data page slots: 4208
Data pages: 360, average fill: 23%
Primary pages: 360, secondary pages: 0, swept pages: 278
Empty pages: 181, full pages: 52
Fill distribution:
0 - 19% = 234
20 - 39% = 33
40 - 59% = 25
60 - 79% = 39
80 - 99% = 29
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1235, depth: 2, leaf buckets: 26, nodes: 6852
Average node length: 7.51, total dup: 5899, max dup: 14
Average key length: 4.70, compression ratio: 7.88
Average prefix length: 34.44, average data length: 2.56
Clustering factor: 1076, ratio: 0.16
Fill distribution:
0 - 19% = 8
20 - 39% = 13
40 - 59% = 4
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.57, total records: 1350332
Average version length: 71.67, total versions: 11373, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.90
Pointer pages: 14, data page slots: 21432
Data pages: 21432, average fill: 70%
Primary pages: 21432, secondary pages: 0, swept pages: 15723
Empty pages: 4, full pages: 11812
Fill distribution:
0 - 19% = 15
20 - 39% = 323
40 - 59% = 2943
60 - 79% = 18001
80 - 99% = 150
Index XQD_1000_3300_DOC (1)
Root page: 189193, depth: 3, leaf buckets: 1748, nodes: 1350332
Average node length: 5.15, total dup: 1315335, max dup: 123
Average key length: 2.20, compression ratio: 4.10
Average prefix length: 8.83, average data length: 0.17
Clustering factor: 296917, ratio: 0.22
Fill distribution:
0 - 19% = 26
20 - 39% = 109
40 - 59% = 1494
60 - 79% = 106
80 - 99% = 13
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 120574, depth: 3, leaf buckets: 1999, nodes: 1350332
Average node length: 6.28, total dup: 1179116, max dup: 28
Average key length: 3.32, compression ratio: 11.13
Average prefix length: 35.80, average data length: 1.20
Clustering factor: 370339, ratio: 0.27
Fill distribution:
0 - 19% = 32
20 - 39% = 160
40 - 59% = 1559
60 - 79% = 141
80 - 99% = 107
XQD_1200_2000 (260)
Primary pointer page: 705, Index root page: 706
Total formats: 1, used formats: 1
Average record length: 51.41, total records: 46411
Average version length: 72.05, total versions: 13171, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.65
Pointer pages: 8, data page slots: 8472
Data pages: 3272, average fill: 18%
Primary pages: 3272, secondary pages: 0, swept pages: 2877
Empty pages: 1038, full pages: 246
Fill distribution:
0 - 19% = 2447
20 - 39% = 375
40 - 59% = 179
60 - 79% = 138
80 - 99% = 133
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1346, depth: 2, leaf buckets: 100, nodes: 46411
Average node length: 6.65, total dup: 40241, max dup: 47
Average key length: 3.65, compression ratio: 10.13
Average prefix length: 35.48, average data length: 1.52
Clustering factor: 7919, ratio: 0.17
Fill distribution:
0 - 19% = 2
20 - 39% = 54
40 - 59% = 39
60 - 79% = 3
80 - 99% = 2
XQD_2000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 69.17, total records: 1465906
Average version length: 71.75, total versions: 61353, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.97
Pointer pages: 20, data page slots: 31096
Data pages: 31096, average fill: 54%
Primary pages: 31096, secondary pages: 0, swept pages: 25900
Empty pages: 343, full pages: 4982
Fill distribution:
0 - 19% = 1438
20 - 39% = 5613
40 - 59% = 11660
60 - 79% = 11218
80 - 99% = 1167
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 106942, depth: 3, leaf buckets: 2346, nodes: 1465906
Average node length: 5.62, total dup: 1377392, max dup: 97
Average key length: 2.66, compression ratio: 13.90
Average prefix length: 36.40, average data length: 0.60
Clustering factor: 456808, ratio: 0.31
Fill distribution:
0 - 19% = 30
20 - 39% = 1137
40 - 59% = 820
60 - 79% = 245
80 - 99% = 114
XQD_2100_3300 (263)
Primary pointer page: 734, Index root page: 735
Total formats: 1, used formats: 1
Average record length: 12.22, total records: 7156
Average version length: 72.02, total versions: 5908, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 11.12
Pointer pages: 6, data page slots: 7096
Data pages: 1083, average fill: 9%
Primary pages: 1083, secondary pages: 0, swept pages: 930
Empty pages: 770, full pages: 85
Fill distribution:
0 - 19% = 986
20 - 39% = 10
40 - 59% = 1
60 - 79% = 15
80 - 99% = 71
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1530, depth: 2, leaf buckets: 19, nodes: 7156
Average node length: 7.29, total dup: 6357, max dup: 57
Average key length: 4.36, compression ratio: 8.49
Average prefix length: 34.75, average data length: 2.25
Clustering factor: 861, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 13
40 - 59% = 3
60 - 79% = 1
80 - 99% = 1
XQD_3300_3400 (264)
Primary pointer page: 737, Index root page: 738
Total formats: 1, used formats: 1
Average record length: 70.46, total records: 2268551
Average version length: 71.01, total versions: 34794, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.93
Pointer pages: 21, data page slots: 34056
Data pages: 34056, average fill: 73%
Primary pages: 34056, secondary pages: 0, swept pages: 25622
Empty pages: 6, full pages: 21401
Fill distribution:
0 - 19% = 37
20 - 39% = 114
40 - 59% = 1679
60 - 79% = 31526
80 - 99% = 700
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 41262, depth: 3, leaf buckets: 4778, nodes: 2268551
Average node length: 6.95, total dup: 1817796, max dup: 21
Average key length: 3.98, compression ratio: 9.29
Average prefix length: 35.22, average data length: 1.78
Clustering factor: 656856, ratio: 0.29
Fill distribution:
0 - 19% = 5
20 - 39% = 2684
40 - 59% = 1741
60 - 79% = 220
80 - 99% = 128
XQS_1000_1200 (265)
Primary pointer page: 740, Index root page: 741
Total formats: 1, used formats: 1
Average record length: 83.64, total records: 3901191
Average version length: 84.07, total versions: 18104, 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: 38, data page slots: 60944
Data pages: 60944, average fill: 79%
Primary pages: 60944, secondary pages: 0, swept pages: 30755
Empty pages: 5, full pages: 58952
Fill distribution:
0 - 19% = 5
20 - 39% = 3
40 - 59% = 61
60 - 79% = 29532
80 - 99% = 31343
Index XQS_1000_1200_DOC_ID (0)
Root page: 54649, depth: 3, leaf buckets: 3785, nodes: 3901191
Average node length: 5.16, total dup: 3811109, max dup: 127
Average key length: 2.17, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 907502, ratio: 0.23
Fill distribution:
0 - 19% = 12
20 - 39% = 48
40 - 59% = 1374
60 - 79% = 1542
80 - 99% = 809
Index XQS_1000_1200_RCV_ID (2)
Root page: 78654, depth: 3, leaf buckets: 5183, nodes: 3901191
Average node length: 5.65, total dup: 3520079, max dup: 49
Average key length: 2.67, compression ratio: 3.37
Average prefix length: 8.43, average data length: 0.57
Clustering factor: 616702, ratio: 0.16
Fill distribution:
0 - 19% = 52
20 - 39% = 158
40 - 59% = 4088
60 - 79% = 419
80 - 99% = 466
Index XQS_1000_1200_SND_ID (1)
Root page: 48486, depth: 3, leaf buckets: 4275, nodes: 3901191
Average node length: 5.79, total dup: 3412881, max dup: 29
Average key length: 2.81, compression ratio: 3.20
Average prefix length: 8.31, average data length: 0.69
Clustering factor: 958081, ratio: 0.25
Fill distribution:
0 - 19% = 3
20 - 39% = 76
40 - 59% = 1753
60 - 79% = 1460
80 - 99% = 983
XQS_1000_3300 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 81.71, total records: 1601244
Average version length: 82.94, total versions: 26147, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.66
Pointer pages: 16, data page slots: 25816
Data pages: 25816, average fill: 76%
Primary pages: 25816, secondary pages: 0, swept pages: 18785
Empty pages: 7, full pages: 20653
Fill distribution:
0 - 19% = 25
20 - 39% = 60
40 - 59% = 778
60 - 79% = 15771
80 - 99% = 9182
Index XQS_1000_3300_DOC_ID (0)
Root page: 75516, depth: 3, leaf buckets: 1778, nodes: 1601244
Average node length: 5.14, total dup: 1563298, max dup: 217
Average key length: 2.18, compression ratio: 4.12
Average prefix length: 8.84, average data length: 0.16
Clustering factor: 337311, ratio: 0.21
Fill distribution:
0 - 19% = 1
20 - 39% = 48
40 - 59% = 1087
60 - 79% = 530
80 - 99% = 112
Index XQS_1000_3300_RCV_ID (2)
Root page: 122461, depth: 3, leaf buckets: 3102, nodes: 1601244
Average node length: 6.28, total dup: 1299609, max dup: 14
Average key length: 3.33, compression ratio: 2.70
Average prefix length: 7.86, average data length: 1.14
Clustering factor: 251044, ratio: 0.16
Fill distribution:
0 - 19% = 69
20 - 39% = 1690
40 - 59% = 1102
60 - 79% = 177
80 - 99% = 64
Index XQS_1000_3300_SND_ID (1)
Root page: 65477, depth: 3, leaf buckets: 1989, nodes: 1601244
Average node length: 5.78, total dup: 1402439, max dup: 41
Average key length: 2.83, compression ratio: 3.18
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 363115, ratio: 0.23
Fill distribution:
0 - 19% = 3
20 - 39% = 35
40 - 59% = 1256
60 - 79% = 572
80 - 99% = 123
XQS_1200_2000 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 82.33, total records: 4212674
Average version length: 85.30, total versions: 89514, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.65
Pointer pages: 43, data page slots: 69360
Data pages: 69360, average fill: 76%
Primary pages: 69360, secondary pages: 0, swept pages: 35298
Empty pages: 5, full pages: 53557
Fill distribution:
0 - 19% = 45
20 - 39% = 517
40 - 59% = 4053
60 - 79% = 37754
80 - 99% = 26991
Index XQS_1200_2000_DOC_ID (0)
Root page: 57323, depth: 3, leaf buckets: 4781, nodes: 4212674
Average node length: 5.04, total dup: 4188174, max dup: 562
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 1109298, ratio: 0.26
Fill distribution:
0 - 19% = 2
20 - 39% = 409
40 - 59% = 3000
60 - 79% = 1143
80 - 99% = 227
Index XQS_1200_2000_RCV_ID (2)
Root page: 78658, depth: 3, leaf buckets: 6058, nodes: 4212674
Average node length: 5.49, total dup: 3904567, max dup: 49
Average key length: 2.51, compression ratio: 3.59
Average prefix length: 8.57, average data length: 0.43
Clustering factor: 865768, ratio: 0.21
Fill distribution:
0 - 19% = 38
20 - 39% = 2348
40 - 59% = 2741
60 - 79% = 400
80 - 99% = 531
Index XQS_1200_2000_SND_ID (1)
Root page: 49624, depth: 3, leaf buckets: 5327, nodes: 4212674
Average node length: 5.62, total dup: 3817155, max dup: 101
Average key length: 2.64, compression ratio: 3.41
Average prefix length: 8.45, average data length: 0.55
Clustering factor: 1177159, ratio: 0.28
Fill distribution:
0 - 19% = 8
20 - 39% = 362
40 - 59% = 3498
60 - 79% = 1142
80 - 99% = 317
XQS_2000_3300 (268)
Primary pointer page: 757, Index root page: 758
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_DOC_ID (0)
Root page: 760, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_RCV_ID (2)
Root page: 762, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_SND_ID (1)
Root page: 761, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQS_2100_3300 (269)
Primary pointer page: 763, Index root page: 764
Total formats: 1, used formats: 1
Average record length: 82.99, total records: 2745116
Average version length: 83.98, total versions: 27757, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.64
Pointer pages: 28, data page slots: 44568
Data pages: 44568, average fill: 76%
Primary pages: 44568, secondary pages: 0, swept pages: 33351
Empty pages: 10, full pages: 34614
Fill distribution:
0 - 19% = 35
20 - 39% = 78
40 - 59% = 787
60 - 79% = 28977
80 - 99% = 14691
Index XQS_2100_3300_DOC_ID (0)
Root page: 85043, depth: 3, leaf buckets: 2985, nodes: 2745116
Average node length: 5.02, total dup: 2731556, max dup: 1086
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 733416, ratio: 0.27
Fill distribution:
0 - 19% = 23
20 - 39% = 353
40 - 59% = 1520
60 - 79% = 732
80 - 99% = 357
Index XQS_2100_3300_RCV_ID (2)
Root page: 94870, depth: 3, leaf buckets: 5562, nodes: 2745116
Average node length: 6.31, total dup: 2223726, max dup: 14
Average key length: 3.33, compression ratio: 2.70
Average prefix length: 7.85, average data length: 1.15
Clustering factor: 603241, ratio: 0.22
Fill distribution:
0 - 19% = 213
20 - 39% = 3168
40 - 59% = 1892
60 - 79% = 204
80 - 99% = 85
Index XQS_2100_3300_SND_ID (1)
Root page: 78028, depth: 3, leaf buckets: 3214, nodes: 2745116
Average node length: 5.53, total dup: 2525421, max dup: 93
Average key length: 2.56, compression ratio: 3.52
Average prefix length: 8.52, average data length: 0.48
Clustering factor: 766862, ratio: 0.28
Fill distribution:
0 - 19% = 3
20 - 39% = 324
40 - 59% = 1507
60 - 79% = 1013
80 - 99% = 367
XQS_3300_3400 (270)
Primary pointer page: 776, Index root page: 777
Total formats: 1, used formats: 1
Average record length: 68.28, total records: 490623
Average version length: 69.34, total versions: 7021, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.99
Pointer pages: 5, data page slots: 6848
Data pages: 6848, average fill: 76%
Primary pages: 6848, secondary pages: 0, swept pages: 5215
Empty pages: 3, full pages: 6165
Fill distribution:
0 - 19% = 13
20 - 39% = 30
40 - 59% = 101
60 - 79% = 6545
80 - 99% = 159
Index XQS_3300_3400_DOC_ID (0)
Root page: 513897, depth: 3, leaf buckets: 555, nodes: 490623
Average node length: 5.37, total dup: 456458, max dup: 118
Average key length: 2.54, compression ratio: 3.55
Average prefix length: 8.53, average data length: 0.47
Clustering factor: 46437, ratio: 0.09
Fill distribution:
0 - 19% = 1
20 - 39% = 58
40 - 59% = 256
60 - 79% = 170
80 - 99% = 70
Index XQS_3300_3400_SND_ID (1)
Root page: 380605, depth: 3, leaf buckets: 621, nodes: 490623
Average node length: 5.94, total dup: 416913, max dup: 29
Average key length: 3.10, compression ratio: 2.90
Average prefix length: 8.05, average data length: 0.95
Clustering factor: 52464, ratio: 0.11
Fill distribution:
0 - 19% = 6
20 - 39% = 66
40 - 59% = 281
60 - 79% = 198
80 - 99% = 70
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 118400 ms, from 7:14:42.45 to 7:16:40.85.
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
VERS_PERCENT |
AGENTS |
50 |
0 |
0.0000 |
BUSINESS_OPS |
19 |
0 |
0.0000 |
DOC_DATA |
1737844 |
5144 |
0.2959 |
DOC_LIST |
609859 |
2527 |
0.4143 |
DOC_STATES |
4 |
0 |
0.0000 |
FB_ERRORS |
758 |
0 |
0.0000 |
INVNT_SALDO |
400 |
0 |
0.0000 |
INVNT_TURNOVER_LOG |
11233 |
2986 |
26.5823 |
MONEY_SALDO |
49 |
0 |
0.0000 |
MONEY_TURNOVER_LOG |
196 |
0 |
0.0000 |
OPTYPES |
9 |
0 |
0.0000 |
PDISTR |
250390 |
3947 |
1.5763 |
PERF_ESTIMATED |
262787 |
0 |
0.0000 |
PERF_LOG |
9509401 |
0 |
0.0000 |
PSTORNED |
328662 |
2631 |
0.8005 |
RULES_FOR_PDISTR |
4 |
0 |
0.0000 |
RULES_FOR_QDISTR |
7 |
0 |
0.0000 |
SEMAPHORES |
4 |
0 |
0.0000 |
SETTINGS |
114 |
0 |
0.0000 |
TRACE_STAT |
3072 |
0 |
0.0000 |
WARES |
400 |
0 |
0.0000 |
WARE_GROUPS |
8 |
0 |
0.0000 |
XQD_1000_1200 |
6852 |
2332 |
34.0338 |
XQD_1000_3300 |
1350332 |
11373 |
0.8422 |
XQD_1200_2000 |
46411 |
13171 |
28.3790 |
XQD_2000_3300 |
1465906 |
61353 |
4.1853 |
XQD_2100_3300 |
7156 |
5908 |
82.5600 |
XQD_3300_3400 |
2268551 |
34794 |
1.5337 |
XQS_1000_1200 |
3901191 |
18104 |
0.4640 |
XQS_1000_3300 |
1601244 |
26147 |
1.6329 |
XQS_1200_2000 |
4212674 |
89514 |
2.1248 |
XQS_2100_3300 |
2745116 |
27757 |
1.0111 |
XQS_3300_3400 |
490623 |
7021 |
1.4310 |
Z_USED_VIEWS |
29 |
0 |
0.0000 |
Done for 2340 ms, from 7:16:51.99 to 7:16:54.33.
07:16:54.44 Validation started
07:16:54.44 Relation 140 (DOC_LIST)
07:16:54.44 process pointer page 0 of 5
07:16:54.53 process pointer page 1 of 5
07:16:54.64 process pointer page 2 of 5
07:16:54.69 process pointer page 3 of 5
07:16:54.73 process pointer page 4 of 5
07:16:54.78 Index 1 (PK_DOC_LIST)
07:16:54.87 Index 2 (DOC_LIST_ID_DESC)
07:16:55.14 Index 3 (FK_DOC_LIST_AGENTS)
07:16:55.39 Relation 140 (DOC_LIST) is ok
07:16:55.39 Relation 141 (DOC_DATA)
07:16:55.39 process pointer page 0 of 12
07:16:55.48 process pointer page 1 of 12
07:16:55.58 process pointer page 2 of 12
07:16:55.65 process pointer page 3 of 12
07:16:55.75 process pointer page 4 of 12
07:16:55.84 process pointer page 5 of 12
07:16:55.92 process pointer page 6 of 12
07:16:56.01 process pointer page 7 of 12
07:16:56.11 process pointer page 8 of 12
07:16:56.20 process pointer page 9 of 12
07:16:56.29 process pointer page 10 of 12
07:16:56.37 process pointer page 11 of 12
07:16:56.45 Index 2 (DOC_DATA_DOC_WARE_UNQ)
07:16:57.35 Index 3 (DOC_DATA_ID_DESC)
07:16:58.13 Index 4 (FK_DOC_DATA_DOC_LIST)
07:16:58.63 Relation 141 (DOC_DATA) is ok
07:16:58.63 Relation 147 (INVNT_SALDO)
07:16:58.63 process pointer page 0 of 3
07:16:58.65 process pointer page 1 of 3
07:16:58.65 process pointer page 2 of 3
07:16:58.65 Index 1 (PK_INVNT_SALDO)
07:16:58.65 Relation 147 (INVNT_SALDO) is ok
07:16:58.65 Relation 150 (PDISTR)
07:16:58.65 process pointer page 0 of 2
07:16:58.73 process pointer page 1 of 2
07:16:58.82 Index 2 (PDISTR_SND_ID)
07:16:58.90 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
07:16:58.99 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
07:16:59.05 Index 5 (PDISTR_AGENT_ID)
07:16:59.09 Relation 150 (PDISTR) is ok
07:16:59.09 Relation 151 (PSTORNED)
07:16:59.09 process pointer page 0 of 3
07:16:59.13 process pointer page 1 of 3
07:16:59.18 process pointer page 2 of 3
07:16:59.21 Index 2 (PSTORNED_SND_ID)
07:16:59.32 Index 3 (PSTORNED_RCV_ID)
07:16:59.41 Relation 151 (PSTORNED) is ok
07:16:59.41 Relation 156 (SEMAPHORES)
07:16:59.41 process pointer page 0 of 1
07:16:59.41 Index 1 (PK_SEMAPHORES)
07:16:59.41 Index 2 (SEMAPHORES_TASK_UNQ)
07:16:59.41 Relation 156 (SEMAPHORES) is ok
07:16:59.41 Relation 157 (INVNT_TURNOVER_LOG)
07:16:59.41 process pointer page 0 of 4
07:16:59.43 process pointer page 1 of 4
07:16:59.46 process pointer page 2 of 4
07:16:59.48 process pointer page 3 of 4
07:16:59.48 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
07:16:59.48 Relation 157 (INVNT_TURNOVER_LOG) is ok
07:16:59.48 Relation 160 (PERF_ESTIMATED)
07:16:59.48 process pointer page 0 of 2
07:16:59.57 process pointer page 1 of 2
07:16:59.62 Index 1 (PERF_EST_MINUTE_SINCE_START)
07:16:59.68 Relation 160 (PERF_ESTIMATED) is ok
07:16:59.68 Relation 161 (PERF_ISQL_STAT)
07:16:59.68 process pointer page 0 of 1
07:16:59.68 Index 1 (PERF_ISQL_STAT_TRN)
07:16:59.68 Relation 161 (PERF_ISQL_STAT) is ok
07:16:59.68 Relation 162 (PERF_LOG)
07:16:59.68 process pointer page 0 of 136
07:16:59.76 process pointer page 1 of 136
07:16:59.83 process pointer page 2 of 136
07:16:59.91 process pointer page 3 of 136
07:16:59.99 process pointer page 4 of 136
07:17:00.07 process pointer page 5 of 136
07:17:00.10 process pointer page 6 of 136
07:17:00.13 process pointer page 7 of 136
07:17:00.16 process pointer page 8 of 136
07:17:00.19 process pointer page 9 of 136
07:17:00.26 process pointer page 10 of 136
07:17:00.33 process pointer page 11 of 136
07:17:00.41 process pointer page 12 of 136
07:17:00.49 process pointer page 13 of 136
07:17:00.57 process pointer page 14 of 136
07:17:00.65 process pointer page 15 of 136
07:17:00.72 process pointer page 16 of 136
07:17:00.80 process pointer page 17 of 136
07:17:00.88 process pointer page 18 of 136
07:17:00.96 process pointer page 19 of 136
07:17:01.04 process pointer page 20 of 136
07:17:01.11 process pointer page 21 of 136
07:17:01.19 process pointer page 22 of 136
07:17:01.25 process pointer page 23 of 136
07:17:01.33 process pointer page 24 of 136
07:17:01.41 process pointer page 25 of 136
07:17:01.49 process pointer page 26 of 136
07:17:01.57 process pointer page 27 of 136
07:17:01.60 process pointer page 28 of 136
07:17:01.66 process pointer page 29 of 136
07:17:01.69 process pointer page 30 of 136
07:17:01.74 process pointer page 31 of 136
07:17:01.82 process pointer page 32 of 136
07:17:01.89 process pointer page 33 of 136
07:17:01.93 process pointer page 34 of 136
07:17:01.96 process pointer page 35 of 136
07:17:01.99 process pointer page 36 of 136
07:17:02.03 process pointer page 37 of 136
07:17:02.11 process pointer page 38 of 136
07:17:02.19 process pointer page 39 of 136
07:17:02.27 process pointer page 40 of 136
07:17:02.35 process pointer page 41 of 136
07:17:02.42 process pointer page 42 of 136
07:17:02.50 process pointer page 43 of 136
07:17:02.56 process pointer page 44 of 136
07:17:02.64 process pointer page 45 of 136
07:17:02.72 process pointer page 46 of 136
07:17:02.80 process pointer page 47 of 136
07:17:02.88 process pointer page 48 of 136
07:17:02.95 process pointer page 49 of 136
07:17:03.03 process pointer page 50 of 136
07:17:03.11 process pointer page 51 of 136
07:17:03.19 process pointer page 52 of 136
07:17:03.27 process pointer page 53 of 136
07:17:03.34 process pointer page 54 of 136
07:17:03.41 process pointer page 55 of 136
07:17:03.49 process pointer page 56 of 136
07:17:03.56 process pointer page 57 of 136
07:17:03.64 process pointer page 58 of 136
07:17:03.72 process pointer page 59 of 136
07:17:03.80 process pointer page 60 of 136
07:17:03.88 process pointer page 61 of 136
07:17:03.95 process pointer page 62 of 136
07:17:04.03 process pointer page 63 of 136
07:17:04.11 process pointer page 64 of 136
07:17:04.19 process pointer page 65 of 136
07:17:04.27 process pointer page 66 of 136
07:17:04.34 process pointer page 67 of 136
07:17:04.42 process pointer page 68 of 136
07:17:04.48 process pointer page 69 of 136
07:17:04.56 process pointer page 70 of 136
07:17:04.64 process pointer page 71 of 136
07:17:04.72 process pointer page 72 of 136
07:17:04.80 process pointer page 73 of 136
07:17:04.87 process pointer page 74 of 136
07:17:04.95 process pointer page 75 of 136
07:17:05.03 process pointer page 76 of 136
07:17:05.11 process pointer page 77 of 136
07:17:05.19 process pointer page 78 of 136
07:17:05.26 process pointer page 79 of 136
07:17:05.33 process pointer page 80 of 136
07:17:05.40 process pointer page 81 of 136
07:17:05.48 process pointer page 82 of 136
07:17:05.56 process pointer page 83 of 136
07:17:05.64 process pointer page 84 of 136
07:17:05.72 process pointer page 85 of 136
07:17:05.79 process pointer page 86 of 136
07:17:05.87 process pointer page 87 of 136
07:17:05.95 process pointer page 88 of 136
07:17:06.03 process pointer page 89 of 136
07:17:06.11 process pointer page 90 of 136
07:17:06.12 process pointer page 91 of 136
07:17:06.15 process pointer page 92 of 136
07:17:06.23 process pointer page 93 of 136
07:17:06.31 process pointer page 94 of 136
07:17:06.39 process pointer page 95 of 136
07:17:06.46 process pointer page 96 of 136
07:17:06.54 process pointer page 97 of 136
07:17:06.62 process pointer page 98 of 136
07:17:06.70 process pointer page 99 of 136
07:17:06.78 process pointer page 100 of 136
07:17:06.82 process pointer page 101 of 136
07:17:06.87 process pointer page 102 of 136
07:17:06.93 process pointer page 103 of 136
07:17:07.01 process pointer page 104 of 136
07:17:07.09 process pointer page 105 of 136
07:17:07.17 process pointer page 106 of 136
07:17:07.24 process pointer page 107 of 136
07:17:07.32 process pointer page 108 of 136
07:17:07.40 process pointer page 109 of 136
07:17:07.48 process pointer page 110 of 136
07:17:07.54 process pointer page 111 of 136
07:17:07.62 process pointer page 112 of 136
07:17:07.70 process pointer page 113 of 136
07:17:07.78 process pointer page 114 of 136
07:17:07.85 process pointer page 115 of 136
07:17:07.93 process pointer page 116 of 136
07:17:08.01 process pointer page 117 of 136
07:17:08.09 process pointer page 118 of 136
07:17:08.17 process pointer page 119 of 136
07:17:08.24 process pointer page 120 of 136
07:17:08.32 process pointer page 121 of 136
07:17:08.40 process pointer page 122 of 136
07:17:08.48 process pointer page 123 of 136
07:17:08.56 process pointer page 124 of 136
07:17:08.63 process pointer page 125 of 136
07:17:08.71 process pointer page 126 of 136
07:17:08.79 process pointer page 127 of 136
07:17:08.87 process pointer page 128 of 136
07:17:08.95 process pointer page 129 of 136
07:17:09.02 process pointer page 130 of 136
07:17:09.09 process pointer page 131 of 136
07:17:09.16 process pointer page 132 of 136
07:17:09.24 process pointer page 133 of 136
07:17:09.32 process pointer page 134 of 136
07:17:09.40 process pointer page 135 of 136
07:17:09.44 Index 1 (PERF_LOG_DTS_BEG_DESC)
07:17:12.63 Index 2 (PERF_LOG_UNIT)
07:17:17.14 Index 3 (PERF_LOG_TRN_DESC)
07:17:20.72 Index 4 (PERF_LOG_GDSCODE)
07:17:22.58 Relation 162 (PERF_LOG) is ok
07:17:22.58 Relation 166 (V_STOPTEST)
07:17:22.58 Relation 166 (V_STOPTEST) is ok
07:17:22.58 Relation 183 (V_QDISTR_SOURCE)
07:17:22.58 Relation 183 (V_QDISTR_SOURCE) is ok
07:17:22.58 Relation 184 (V_QSTORNED_SOURCE)
07:17:22.58 Relation 184 (V_QSTORNED_SOURCE) is ok
07:17:22.58 Relation 259 (XQD_1000_1200)
07:17:22.60 process pointer page 0 of 5
07:17:22.60 process pointer page 1 of 5
07:17:22.60 process pointer page 2 of 5
07:17:22.60 process pointer page 3 of 5
07:17:22.60 process pointer page 4 of 5
07:17:22.60 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
07:17:22.60 Relation 259 (XQD_1000_1200) is ok
07:17:22.60 Relation 260 (XQD_1200_2000)
07:17:22.60 process pointer page 0 of 8
07:17:22.61 process pointer page 1 of 8
07:17:22.61 process pointer page 2 of 8
07:17:22.64 process pointer page 3 of 8
07:17:22.67 process pointer page 4 of 8
07:17:22.69 process pointer page 5 of 8
07:17:22.69 process pointer page 6 of 8
07:17:22.72 process pointer page 7 of 8
07:17:22.74 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
07:17:22.75 Relation 260 (XQD_1200_2000) is ok
07:17:22.75 Relation 261 (XQD_1000_3300)
07:17:22.75 process pointer page 0 of 14
07:17:22.83 process pointer page 1 of 14
07:17:22.92 process pointer page 2 of 14
07:17:23.00 process pointer page 3 of 14
07:17:23.08 process pointer page 4 of 14
07:17:23.17 process pointer page 5 of 14
07:17:23.25 process pointer page 6 of 14
07:17:23.33 process pointer page 7 of 14
07:17:23.41 process pointer page 8 of 14
07:17:23.50 process pointer page 9 of 14
07:17:23.59 process pointer page 10 of 14
07:17:23.66 process pointer page 11 of 14
07:17:23.69 process pointer page 12 of 14
07:17:23.73 process pointer page 13 of 14
07:17:23.73 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
07:17:24.09 Index 2 (XQD_1000_3300_DOC)
07:17:24.53 Relation 261 (XQD_1000_3300) is ok
07:17:24.53 Relation 262 (XQD_2000_3300)
07:17:24.53 process pointer page 0 of 20
07:17:24.56 process pointer page 1 of 20
07:17:24.59 process pointer page 2 of 20
07:17:24.67 process pointer page 3 of 20
07:17:24.75 process pointer page 4 of 20
07:17:24.83 process pointer page 5 of 20
07:17:24.90 process pointer page 6 of 20
07:17:25.00 process pointer page 7 of 20
07:17:25.08 process pointer page 8 of 20
07:17:25.17 process pointer page 9 of 20
07:17:25.25 process pointer page 10 of 20
07:17:25.33 process pointer page 11 of 20
07:17:25.40 process pointer page 12 of 20
07:17:25.48 process pointer page 13 of 20
07:17:25.56 process pointer page 14 of 20
07:17:25.64 process pointer page 15 of 20
07:17:25.72 process pointer page 16 of 20
07:17:25.79 process pointer page 17 of 20
07:17:25.87 process pointer page 18 of 20
07:17:25.96 process pointer page 19 of 20
07:17:25.96 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
07:17:26.43 Relation 262 (XQD_2000_3300) is ok
07:17:26.43 Relation 263 (XQD_2100_3300)
07:17:26.45 process pointer page 0 of 6
07:17:26.45 process pointer page 1 of 6
07:17:26.46 process pointer page 2 of 6
07:17:26.48 process pointer page 3 of 6
07:17:26.48 process pointer page 4 of 6
07:17:26.48 process pointer page 5 of 6
07:17:26.48 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
07:17:26.50 Relation 263 (XQD_2100_3300) is ok
07:17:26.50 Relation 264 (XQD_3300_3400)
07:17:26.50 process pointer page 0 of 21
07:17:26.59 process pointer page 1 of 21
07:17:26.68 process pointer page 2 of 21
07:17:26.78 process pointer page 3 of 21
07:17:26.82 process pointer page 4 of 21
07:17:26.89 process pointer page 5 of 21
07:17:26.96 process pointer page 6 of 21
07:17:26.99 process pointer page 7 of 21
07:17:27.09 process pointer page 8 of 21
07:17:27.17 process pointer page 9 of 21
07:17:27.26 process pointer page 10 of 21
07:17:27.35 process pointer page 11 of 21
07:17:27.42 process pointer page 12 of 21
07:17:27.46 process pointer page 13 of 21
07:17:27.49 process pointer page 14 of 21
07:17:27.52 process pointer page 15 of 21
07:17:27.59 process pointer page 16 of 21
07:17:27.68 process pointer page 17 of 21
07:17:27.77 process pointer page 18 of 21
07:17:27.85 process pointer page 19 of 21
07:17:27.95 process pointer page 20 of 21
07:17:28.02 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
07:17:28.93 Relation 264 (XQD_3300_3400) is ok
07:17:28.93 Relation 265 (XQS_1000_1200)
07:17:28.94 process pointer page 0 of 38
07:17:29.02 process pointer page 1 of 38
07:17:29.12 process pointer page 2 of 38
07:17:29.21 process pointer page 3 of 38
07:17:29.29 process pointer page 4 of 38
07:17:29.38 process pointer page 5 of 38
07:17:29.47 process pointer page 6 of 38
07:17:29.55 process pointer page 7 of 38
07:17:29.65 process pointer page 8 of 38
07:17:29.74 process pointer page 9 of 38
07:17:29.82 process pointer page 10 of 38
07:17:29.91 process pointer page 11 of 38
07:17:30.01 process pointer page 12 of 38
07:17:30.08 process pointer page 13 of 38
07:17:30.18 process pointer page 14 of 38
07:17:30.27 process pointer page 15 of 38
07:17:30.36 process pointer page 16 of 38
07:17:30.43 process pointer page 17 of 38
07:17:30.46 process pointer page 18 of 38
07:17:30.49 process pointer page 19 of 38
07:17:30.52 process pointer page 20 of 38
07:17:30.57 process pointer page 21 of 38
07:17:30.64 process pointer page 22 of 38
07:17:30.74 process pointer page 23 of 38
07:17:30.83 process pointer page 24 of 38
07:17:30.91 process pointer page 25 of 38
07:17:31.00 process pointer page 26 of 38
07:17:31.10 process pointer page 27 of 38
07:17:31.18 process pointer page 28 of 38
07:17:31.27 process pointer page 29 of 38
07:17:31.35 process pointer page 30 of 38
07:17:31.44 process pointer page 31 of 38
07:17:31.53 process pointer page 32 of 38
07:17:31.61 process pointer page 33 of 38
07:17:31.71 process pointer page 34 of 38
07:17:31.80 process pointer page 35 of 38
07:17:31.88 process pointer page 36 of 38
07:17:31.97 process pointer page 37 of 38
07:17:31.99 Index 1 (XQS_1000_1200_DOC_ID)
07:17:33.19 Index 2 (XQS_1000_1200_SND_ID)
07:17:34.31 Index 3 (XQS_1000_1200_RCV_ID)
07:17:35.34 Relation 265 (XQS_1000_1200) is ok
07:17:35.34 Relation 266 (XQS_1200_2000)
07:17:35.34 process pointer page 0 of 43
07:17:35.39 process pointer page 1 of 43
07:17:35.42 process pointer page 2 of 43
07:17:35.51 process pointer page 3 of 43
07:17:35.59 process pointer page 4 of 43
07:17:35.68 process pointer page 5 of 43
07:17:35.78 process pointer page 6 of 43
07:17:35.87 process pointer page 7 of 43
07:17:35.95 process pointer page 8 of 43
07:17:36.04 process pointer page 9 of 43
07:17:36.14 process pointer page 10 of 43
07:17:36.23 process pointer page 11 of 43
07:17:36.31 process pointer page 12 of 43
07:17:36.40 process pointer page 13 of 43
07:17:36.49 process pointer page 14 of 43
07:17:36.59 process pointer page 15 of 43
07:17:36.67 process pointer page 16 of 43
07:17:36.70 process pointer page 17 of 43
07:17:36.78 process pointer page 18 of 43
07:17:36.87 process pointer page 19 of 43
07:17:36.96 process pointer page 20 of 43
07:17:37.06 process pointer page 21 of 43
07:17:37.09 process pointer page 22 of 43
07:17:37.12 process pointer page 23 of 43
07:17:37.15 process pointer page 24 of 43
07:17:37.24 process pointer page 25 of 43
07:17:37.32 process pointer page 26 of 43
07:17:37.42 process pointer page 27 of 43
07:17:37.51 process pointer page 28 of 43
07:17:37.60 process pointer page 29 of 43
07:17:37.66 process pointer page 30 of 43
07:17:37.71 process pointer page 31 of 43
07:17:37.74 process pointer page 32 of 43
07:17:37.77 process pointer page 33 of 43
07:17:37.85 process pointer page 34 of 43
07:17:37.95 process pointer page 35 of 43
07:17:38.04 process pointer page 36 of 43
07:17:38.13 process pointer page 37 of 43
07:17:38.21 process pointer page 38 of 43
07:17:38.30 process pointer page 39 of 43
07:17:38.40 process pointer page 40 of 43
07:17:38.49 process pointer page 41 of 43
07:17:38.59 process pointer page 42 of 43
07:17:38.63 Index 1 (XQS_1200_2000_DOC_ID)
07:17:39.52 Index 2 (XQS_1200_2000_SND_ID)
07:17:41.17 Index 3 (XQS_1200_2000_RCV_ID)
07:17:42.17 Relation 266 (XQS_1200_2000) is ok
07:17:42.17 Relation 267 (XQS_1000_3300)
07:17:42.17 process pointer page 0 of 16
07:17:42.20 process pointer page 1 of 16
07:17:42.25 process pointer page 2 of 16
07:17:42.34 process pointer page 3 of 16
07:17:42.44 process pointer page 4 of 16
07:17:42.55 process pointer page 5 of 16
07:17:42.66 process pointer page 6 of 16
07:17:42.75 process pointer page 7 of 16
07:17:42.86 process pointer page 8 of 16
07:17:42.89 process pointer page 9 of 16
07:17:43.00 process pointer page 10 of 16
07:17:43.09 process pointer page 11 of 16
07:17:43.14 process pointer page 12 of 16
07:17:43.19 process pointer page 13 of 16
07:17:43.23 process pointer page 14 of 16
07:17:43.31 process pointer page 15 of 16
07:17:43.34 Index 1 (XQS_1000_3300_DOC_ID)
07:17:43.81 Index 2 (XQS_1000_3300_SND_ID)
07:17:44.45 Index 3 (XQS_1000_3300_RCV_ID)
07:17:45.01 Relation 267 (XQS_1000_3300) is ok
07:17:45.01 Relation 268 (XQS_2000_3300)
07:17:45.01 process pointer page 0 of 1
07:17:45.01 Index 1 (XQS_2000_3300_DOC_ID)
07:17:45.01 Index 2 (XQS_2000_3300_SND_ID)
07:17:45.01 Index 3 (XQS_2000_3300_RCV_ID)
07:17:45.01 Relation 268 (XQS_2000_3300) is ok
07:17:45.01 Relation 269 (XQS_2100_3300)
07:17:45.01 process pointer page 0 of 28
07:17:45.11 process pointer page 1 of 28
07:17:45.22 process pointer page 2 of 28
07:17:45.31 process pointer page 3 of 28
07:17:45.42 process pointer page 4 of 28
07:17:45.53 process pointer page 5 of 28
07:17:45.62 process pointer page 6 of 28
07:17:45.71 process pointer page 7 of 28
07:17:45.82 process pointer page 8 of 28
07:17:45.93 process pointer page 9 of 28
07:17:46.03 process pointer page 10 of 28
07:17:46.14 process pointer page 11 of 28
07:17:46.18 process pointer page 12 of 28
07:17:46.23 process pointer page 13 of 28
07:17:46.28 process pointer page 14 of 28
07:17:46.39 process pointer page 15 of 28
07:17:46.48 process pointer page 16 of 28
07:17:46.59 process pointer page 17 of 28
07:17:46.68 process pointer page 18 of 28
07:17:46.78 process pointer page 19 of 28
07:17:46.88 process pointer page 20 of 28
07:17:46.98 process pointer page 21 of 28
07:17:47.09 process pointer page 22 of 28
07:17:47.18 process pointer page 23 of 28
07:17:47.27 process pointer page 24 of 28
07:17:47.38 process pointer page 25 of 28
07:17:47.48 process pointer page 26 of 28
07:17:47.57 process pointer page 27 of 28
07:17:47.60 Index 1 (XQS_2100_3300_DOC_ID)
07:17:48.58 Index 2 (XQS_2100_3300_SND_ID)
07:17:49.68 Index 3 (XQS_2100_3300_RCV_ID)
07:17:50.69 Relation 269 (XQS_2100_3300) is ok
07:17:50.69 Relation 270 (XQS_3300_3400)
07:17:50.69 process pointer page 0 of 5
07:17:50.78 process pointer page 1 of 5
07:17:50.89 process pointer page 2 of 5
07:17:51.00 process pointer page 3 of 5
07:17:51.10 process pointer page 4 of 5
07:17:51.13 Index 1 (XQS_3300_3400_DOC_ID)
07:17:51.27 Index 2 (XQS_3300_3400_SND_ID)
07:17:51.38 Relation 270 (XQS_3300_3400) is ok
07:17:51.38 Relation 276 (TRACE_STAT)
07:17:51.38 process pointer page 0 of 1
07:17:51.38 Relation 276 (TRACE_STAT) is ok
07:17:51.38 Validation finished
Done for 57030 ms, from 7:16:54.36 to 7:17:51.39.
Differences between old and current firebird.log
7:17:52.44. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2016-11-19 07:17 504 oltp30_fb_log_when_test_finished.log
End of gathering firebird.log AFTER test finish.
+++ Start of comparison +++
Comparing files E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Sat Nov 19 07:16:54 2016
7: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Sat Nov 19 07:17:51 2016
12: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++
Remove 401 logs of every ISQL session if there were no serious errors.
Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp30\oltp30_*.*:
ERRORS_CHECKING_RESULT |
NO_SEVERE_ERRORS_FOUND |
ISQL logs are removed because no severe errors occured during test.
2016-11-19 7:18:01.66 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html