Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2016-03-18 7:58:39.05.
Server version: WI-T4.0.0.32401 Firebird 4.0 Unstable
Server implementation: Firebird/Windows/AMD/Intel/x64
FB_ARCHITECTURE |
DB_NAME |
FORCED_WRITES |
SWEEP_INT |
PAGE_BUFFERS |
PAGE_SIZE |
SuperServer 4.0.0 |
D:\OLTP-EMUL\OLTP40-SMALL.FDB |
ON |
0 |
786432 |
8192 |
Test configuration settings
File: E:\OLTP-EMUL\src\oltp40_config.win
PARAM_NAME |
PARAM_VALUE |
fbc |
E:\FB40.TMPINSTANCE |
dbnm |
D:\OLTP-EMUL\oltp40-small.fdb |
host |
localhost |
port |
3400 |
usr |
SYSDBA |
pwd |
masterkey |
tmpdir |
e:\temp\logs.oltp40 |
working_mode |
small_03 |
warm_time |
10 |
test_time |
180 |
idle_time |
0 |
use_mtee |
0 |
is_embed |
0 |
remove_isql_logs |
if_no_severe_errors |
no_auto_undo |
1 |
detailed_info |
0 |
mon_unit_perf |
0 |
trc_unit_perf |
1 |
init_buff |
32768 |
create_with_fw |
sync |
create_with_sweep |
0 |
wait_if_not_exists |
0 |
wait_after_create |
0 |
init_docs |
0 |
wait_for_copy |
0 |
create_with_debug_objects |
1 |
create_with_split_heavy_tabs |
1 |
create_with_separate_qdistr_idx |
0 |
create_with_compound_columns_order |
most_selective_first |
make_html |
1 |
run_db_statistics |
1 |
run_db_validation |
1 |
file_name_with_test_params |
regular |
file_name_this_host_info |
ak40 |
upload_report |
1 |
FINISH_STATE |
DTS_END |
FB_GDSCODE |
FB_MNEMONA |
STACK |
IP |
TRN_ID |
ATT_ID |
EXC_UNIT |
NORMAL: TEST_TIME EXPIRED. |
2016-03-18 07:56:09.1480 |
-1 |
<null> |
|
::1/61895 |
332827 |
4950 |
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: |
5024.19 |
7098 |
904354 |
2016-03-18 04:56 |
2016-03-18 07:56 |
customer order: creation |
386.66 |
1101 |
69598 |
2016-03-18 04:56 |
2016-03-18 07:56 |
customer order: refuse |
30.64 |
76 |
5516 |
2016-03-18 04:56 |
2016-03-18 07:56 |
order to supplier: creation |
99.71 |
7965 |
17947 |
2016-03-18 04:56 |
2016-03-18 07:56 |
order to supplier: removal |
2.36 |
76068 |
424 |
2016-03-18 04:56 |
2016-03-18 07:56 |
invoice (draft): creation |
98.32 |
12584 |
17698 |
2016-03-18 04:56 |
2016-03-18 07:56 |
invoice (draft): removal |
34.32 |
2552 |
6177 |
2016-03-18 04:56 |
2016-03-18 07:56 |
invoice accept: apply |
59.44 |
21890 |
10700 |
2016-03-18 04:56 |
2016-03-18 07:56 |
invoice accept: cancel |
16.27 |
4722 |
2929 |
2016-03-18 04:56 |
2016-03-18 07:56 |
customer reserve: creation |
2942.00 |
372 |
529560 |
2016-03-18 04:56 |
2016-03-18 07:56 |
customer reserve: removal |
827.12 |
121 |
148881 |
2016-03-18 04:56 |
2016-03-18 07:56 |
realization accept: apply |
177.32 |
337 |
31918 |
2016-03-18 04:56 |
2016-03-18 07:56 |
realization accept: cancel |
53.12 |
223 |
9562 |
2016-03-18 04:56 |
2016-03-18 07:56 |
payment from customer: creation |
128.42 |
340 |
23116 |
2016-03-18 04:56 |
2016-03-18 07:56 |
payment from customer: removal |
12.49 |
109 |
2249 |
2016-03-18 04:56 |
2016-03-18 07:56 |
payment to supplier: creation |
107.83 |
766 |
19410 |
2016-03-18 04:56 |
2016-03-18 07:56 |
payment to supplier: removal |
7.35 |
152 |
1323 |
2016-03-18 04:56 |
2016-03-18 07:56 |
service: total inventory turnovers |
17.92 |
1746 |
3226 |
2016-03-18 04:56 |
2016-03-18 07:56 |
service: total monetary turnovers |
22.82 |
94 |
4108 |
2016-03-18 04:56 |
2016-03-18 07:56 |
service: refresh index statistics |
0.07 |
3640 |
12 |
2016-03-18 04:56 |
2016-03-18 07:56 |
Done for 46810 ms, from 7:59:35.46 to 8:00:22.27.
ACTION |
ITRV_NO |
CNT_OK_PER_MINUTE |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
ITRV_BEG |
ITRV_END |
interval # 1, overall |
1 |
4573 |
87512 |
82309 |
5203 |
5.95 |
04:56:10 |
05:14:10 |
interval # 2, overall |
2 |
4731 |
89379 |
85153 |
4226 |
4.73 |
05:14:11 |
05:32:11 |
interval # 3, overall |
3 |
5228 |
101744 |
94097 |
7647 |
7.52 |
05:32:12 |
05:50:12 |
interval # 4, overall |
4 |
5213 |
101322 |
93834 |
7488 |
7.39 |
05:50:13 |
06:08:13 |
interval # 5, overall |
5 |
4801 |
93570 |
86424 |
7146 |
7.64 |
06:08:14 |
06:26:14 |
interval # 6, overall |
6 |
4905 |
93289 |
88281 |
5008 |
5.37 |
06:26:15 |
06:44:15 |
interval # 7, overall |
7 |
5109 |
96655 |
91962 |
4693 |
4.86 |
06:44:16 |
07:02:16 |
interval # 8, overall |
8 |
5484 |
100591 |
98720 |
1871 |
1.86 |
07:02:17 |
07:20:17 |
interval # 9, overall |
9 |
5298 |
99764 |
95364 |
4400 |
4.41 |
07:20:18 |
07:38:18 |
interval # 10, overall |
10 |
4901 |
90942 |
88210 |
2732 |
3.00 |
07:38:19 |
07:56:19 |
Done for 173370 ms, from 8:03:12.25 to 8:06:05.62.
TEST_PHASE |
MINUTE_SINCE_TEST_START |
AVG_ESTIMATED |
MIN_TO_AVG_RATIO |
MAX_TO_AVG_RATIO |
ROWS_AGGREGATED |
DISTINCT_ATTACHMENTS |
WARM_TIME |
1 |
6752.06 |
0.5990 |
1.3538 |
2141 |
100 |
WARM_TIME |
2 |
5405.75 |
0.8521 |
1.1272 |
2696 |
99 |
WARM_TIME |
3 |
4485.63 |
0.9057 |
1.0984 |
1985 |
83 |
WARM_TIME |
4 |
4024.11 |
0.9184 |
1.0750 |
1650 |
75 |
WARM_TIME |
5 |
3740.11 |
0.9253 |
1.0701 |
1532 |
71 |
WARM_TIME |
6 |
3623.93 |
0.9204 |
1.0760 |
1615 |
84 |
WARM_TIME |
7 |
3608.67 |
0.9262 |
1.0774 |
1542 |
86 |
WARM_TIME |
8 |
3658.98 |
0.9298 |
1.0597 |
1725 |
93 |
WARM_TIME |
9 |
3689.07 |
0.9344 |
1.0514 |
1804 |
95 |
WARM_TIME |
10 |
3688.94 |
0.9463 |
1.0528 |
1834 |
94 |
TEST_TIME |
11 |
3726.62 |
0.9474 |
1.0439 |
1741 |
98 |
TEST_TIME |
12 |
3692.50 |
0.9657 |
1.0417 |
1704 |
96 |
TEST_TIME |
13 |
3706.21 |
0.9580 |
1.0507 |
1588 |
96 |
TEST_TIME |
14 |
3734.04 |
0.9684 |
1.0330 |
1519 |
96 |
TEST_TIME |
15 |
3716.24 |
0.9688 |
1.0366 |
1437 |
94 |
TEST_TIME |
16 |
3729.61 |
0.9684 |
1.0322 |
1499 |
97 |
TEST_TIME |
17 |
3725.46 |
0.9726 |
1.0357 |
1391 |
98 |
TEST_TIME |
18 |
3749.94 |
0.9718 |
1.0253 |
1342 |
94 |
TEST_TIME |
19 |
3751.69 |
0.9714 |
1.0374 |
1419 |
98 |
TEST_TIME |
20 |
3843.02 |
0.9621 |
1.0266 |
1776 |
95 |
TEST_TIME |
21 |
3875.60 |
0.9701 |
1.0386 |
1784 |
96 |
TEST_TIME |
22 |
3991.99 |
0.9625 |
1.0312 |
1781 |
100 |
TEST_TIME |
23 |
4017.32 |
0.9801 |
1.0232 |
1317 |
92 |
TEST_TIME |
24 |
4058.87 |
0.9705 |
1.0245 |
1420 |
94 |
TEST_TIME |
25 |
4120.44 |
0.9694 |
1.0275 |
1679 |
96 |
TEST_TIME |
26 |
4167.33 |
0.9769 |
1.0223 |
1599 |
96 |
TEST_TIME |
27 |
4205.78 |
0.9764 |
1.0236 |
1554 |
97 |
TEST_TIME |
28 |
4242.28 |
0.9785 |
1.0178 |
1473 |
97 |
TEST_TIME |
29 |
4255.18 |
0.9798 |
1.0208 |
1566 |
95 |
TEST_TIME |
30 |
4284.39 |
0.9801 |
1.0171 |
1378 |
97 |
TEST_TIME |
31 |
4263.73 |
0.9890 |
1.0114 |
1207 |
88 |
TEST_TIME |
32 |
4256.06 |
0.9816 |
1.0179 |
1345 |
96 |
TEST_TIME |
33 |
4252.63 |
0.9879 |
1.0162 |
1288 |
95 |
TEST_TIME |
34 |
4277.16 |
0.9806 |
1.0173 |
1641 |
96 |
TEST_TIME |
35 |
4312.53 |
0.9801 |
1.0183 |
1775 |
97 |
TEST_TIME |
36 |
4340.92 |
0.9836 |
1.0178 |
1776 |
97 |
TEST_TIME |
37 |
4367.02 |
0.9844 |
1.0117 |
1511 |
97 |
TEST_TIME |
38 |
4368.00 |
0.9849 |
1.0150 |
1494 |
96 |
TEST_TIME |
39 |
4391.53 |
0.9837 |
1.0175 |
1440 |
95 |
TEST_TIME |
40 |
4420.07 |
0.9857 |
1.0125 |
1310 |
94 |
TEST_TIME |
41 |
4422.34 |
0.9873 |
1.0123 |
1299 |
93 |
TEST_TIME |
42 |
4407.68 |
0.9915 |
1.0085 |
1112 |
84 |
TEST_TIME |
43 |
4401.77 |
0.9864 |
1.0137 |
1333 |
94 |
TEST_TIME |
44 |
4412.17 |
0.9883 |
1.0128 |
1175 |
99 |
TEST_TIME |
45 |
4425.24 |
0.9874 |
1.0121 |
1427 |
96 |
TEST_TIME |
46 |
4435.84 |
0.9877 |
1.0126 |
1356 |
98 |
TEST_TIME |
47 |
4434.08 |
0.9914 |
1.0107 |
1334 |
96 |
TEST_TIME |
48 |
4443.77 |
0.9875 |
1.0123 |
1204 |
98 |
TEST_TIME |
49 |
4463.47 |
0.9873 |
1.0142 |
1730 |
96 |
TEST_TIME |
50 |
4498.10 |
0.9863 |
1.0118 |
1641 |
95 |
TEST_TIME |
51 |
4529.22 |
0.9852 |
1.0142 |
1654 |
94 |
TEST_TIME |
52 |
4564.88 |
0.9870 |
1.0129 |
1822 |
96 |
TEST_TIME |
53 |
4589.28 |
0.9885 |
1.0105 |
1575 |
94 |
TEST_TIME |
54 |
4604.64 |
0.9884 |
1.0120 |
1494 |
95 |
TEST_TIME |
55 |
4619.75 |
0.9904 |
1.0133 |
1406 |
96 |
TEST_TIME |
56 |
4642.20 |
0.9904 |
1.0085 |
1340 |
96 |
TEST_TIME |
57 |
4635.90 |
0.9921 |
1.0083 |
1339 |
91 |
TEST_TIME |
58 |
4638.68 |
0.9903 |
1.0094 |
1314 |
97 |
TEST_TIME |
59 |
4644.38 |
0.9911 |
1.0101 |
1401 |
96 |
TEST_TIME |
60 |
4658.63 |
0.9903 |
1.0090 |
1245 |
94 |
TEST_TIME |
61 |
4656.67 |
0.9929 |
1.0069 |
1170 |
93 |
TEST_TIME |
62 |
4649.10 |
0.9923 |
1.0080 |
1137 |
87 |
TEST_TIME |
63 |
4635.78 |
0.9949 |
1.0043 |
1193 |
88 |
TEST_TIME |
64 |
4616.64 |
0.9927 |
1.0078 |
1425 |
90 |
TEST_TIME |
65 |
4624.39 |
0.9906 |
1.0102 |
1433 |
87 |
TEST_TIME |
66 |
4651.64 |
0.9891 |
1.0111 |
1507 |
92 |
TEST_TIME |
67 |
4685.62 |
0.9887 |
1.0087 |
1241 |
92 |
TEST_TIME |
68 |
4697.29 |
0.9914 |
1.0065 |
1326 |
91 |
TEST_TIME |
69 |
4693.84 |
0.9926 |
1.0094 |
1290 |
91 |
TEST_TIME |
70 |
4710.34 |
0.9915 |
1.0069 |
1338 |
92 |
TEST_TIME |
71 |
4712.14 |
0.9923 |
1.0089 |
1316 |
96 |
TEST_TIME |
72 |
4721.77 |
0.9928 |
1.0075 |
1281 |
97 |
TEST_TIME |
73 |
4721.85 |
0.9937 |
1.0076 |
1391 |
92 |
TEST_TIME |
74 |
4728.09 |
0.9927 |
1.0071 |
1282 |
91 |
TEST_TIME |
75 |
4732.06 |
0.9929 |
1.0069 |
1313 |
93 |
TEST_TIME |
76 |
4734.09 |
0.9932 |
1.0063 |
1249 |
92 |
TEST_TIME |
77 |
4737.58 |
0.9925 |
1.0065 |
1255 |
95 |
TEST_TIME |
78 |
4738.21 |
0.9935 |
1.0052 |
1225 |
94 |
TEST_TIME |
79 |
4743.18 |
0.9914 |
1.0091 |
1592 |
97 |
TEST_TIME |
80 |
4755.00 |
0.9940 |
1.0072 |
1390 |
93 |
TEST_TIME |
81 |
4762.39 |
0.9932 |
1.0068 |
1400 |
93 |
TEST_TIME |
82 |
4764.18 |
0.9941 |
1.0079 |
1274 |
93 |
TEST_TIME |
83 |
4773.28 |
0.9938 |
1.0058 |
1262 |
91 |
TEST_TIME |
84 |
4774.28 |
0.9937 |
1.0067 |
1170 |
91 |
TEST_TIME |
85 |
4787.69 |
0.9921 |
1.0083 |
1159 |
94 |
TEST_TIME |
86 |
4795.77 |
0.9949 |
1.0050 |
1074 |
89 |
TEST_TIME |
87 |
4795.11 |
0.9936 |
1.0067 |
1262 |
91 |
TEST_TIME |
88 |
4793.47 |
0.9956 |
1.0043 |
1105 |
86 |
TEST_TIME |
89 |
4783.39 |
0.9951 |
1.0046 |
1027 |
89 |
TEST_TIME |
90 |
4775.87 |
0.9950 |
1.0060 |
1170 |
92 |
TEST_TIME |
91 |
4779.44 |
0.9942 |
1.0037 |
1170 |
93 |
TEST_TIME |
92 |
4770.90 |
0.9946 |
1.0050 |
1248 |
95 |
TEST_TIME |
93 |
4763.57 |
0.9957 |
1.0055 |
1161 |
97 |
TEST_TIME |
94 |
4765.00 |
0.9945 |
1.0044 |
1278 |
92 |
TEST_TIME |
95 |
4758.10 |
0.9953 |
1.0054 |
1241 |
90 |
TEST_TIME |
96 |
4760.33 |
0.9944 |
1.0058 |
1363 |
88 |
TEST_TIME |
97 |
4762.99 |
0.9949 |
1.0044 |
1152 |
88 |
TEST_TIME |
98 |
4764.18 |
0.9939 |
1.0044 |
1191 |
93 |
TEST_TIME |
99 |
4756.69 |
0.9959 |
1.0051 |
1240 |
93 |
TEST_TIME |
100 |
4764.67 |
0.9934 |
1.0056 |
1273 |
94 |
TEST_TIME |
101 |
4761.90 |
0.9963 |
1.0049 |
1216 |
92 |
TEST_TIME |
102 |
4759.55 |
0.9955 |
1.0041 |
1108 |
91 |
TEST_TIME |
103 |
4752.58 |
0.9958 |
1.0048 |
1238 |
92 |
TEST_TIME |
104 |
4754.35 |
0.9948 |
1.0039 |
1221 |
94 |
TEST_TIME |
105 |
4745.09 |
0.9962 |
1.0041 |
999 |
91 |
TEST_TIME |
106 |
4743.53 |
0.9949 |
1.0046 |
1134 |
93 |
TEST_TIME |
107 |
4750.50 |
0.9938 |
1.0044 |
1253 |
91 |
TEST_TIME |
108 |
4744.44 |
0.9963 |
1.0051 |
1151 |
88 |
TEST_TIME |
109 |
4751.84 |
0.9943 |
1.0036 |
1328 |
95 |
TEST_TIME |
110 |
4741.18 |
0.9969 |
1.0031 |
1030 |
84 |
TEST_TIME |
111 |
4740.78 |
0.9942 |
1.0055 |
1275 |
93 |
TEST_TIME |
112 |
4743.69 |
0.9959 |
1.0050 |
1401 |
93 |
TEST_TIME |
113 |
4750.10 |
0.9947 |
1.0068 |
1150 |
95 |
TEST_TIME |
114 |
4762.42 |
0.9954 |
1.0046 |
1373 |
92 |
TEST_TIME |
115 |
4760.76 |
0.9962 |
1.0041 |
1100 |
90 |
TEST_TIME |
116 |
4755.82 |
0.9965 |
1.0035 |
1039 |
85 |
TEST_TIME |
117 |
4755.92 |
0.9949 |
1.0053 |
1184 |
86 |
TEST_TIME |
118 |
4763.57 |
0.9952 |
1.0050 |
1269 |
91 |
TEST_TIME |
119 |
4769.75 |
0.9953 |
1.0050 |
1112 |
92 |
TEST_TIME |
120 |
4774.35 |
0.9957 |
1.0048 |
1195 |
90 |
TEST_TIME |
121 |
4788.19 |
0.9936 |
1.0054 |
1106 |
93 |
TEST_TIME |
122 |
4790.57 |
0.9967 |
1.0028 |
1090 |
88 |
TEST_TIME |
123 |
4785.67 |
0.9957 |
1.0038 |
1135 |
93 |
TEST_TIME |
124 |
4782.99 |
0.9963 |
1.0037 |
1299 |
93 |
TEST_TIME |
125 |
4783.04 |
0.9956 |
1.0037 |
1292 |
87 |
TEST_TIME |
126 |
4784.06 |
0.9955 |
1.0040 |
1221 |
93 |
TEST_TIME |
127 |
4781.49 |
0.9966 |
1.0030 |
1242 |
90 |
TEST_TIME |
128 |
4778.53 |
0.9958 |
1.0046 |
1275 |
88 |
TEST_TIME |
129 |
4789.40 |
0.9945 |
1.0041 |
1369 |
94 |
TEST_TIME |
130 |
4792.22 |
0.9959 |
1.0038 |
1179 |
90 |
TEST_TIME |
131 |
4797.48 |
0.9951 |
1.0038 |
1110 |
91 |
TEST_TIME |
132 |
4799.25 |
0.9958 |
1.0050 |
1084 |
93 |
TEST_TIME |
133 |
4803.77 |
0.9965 |
1.0033 |
1120 |
91 |
TEST_TIME |
134 |
4801.86 |
0.9962 |
1.0027 |
1180 |
87 |
TEST_TIME |
135 |
4806.66 |
0.9943 |
1.0051 |
1147 |
92 |
TEST_TIME |
136 |
4816.36 |
0.9957 |
1.0037 |
1157 |
93 |
TEST_TIME |
137 |
4818.34 |
0.9960 |
1.0034 |
1129 |
93 |
TEST_TIME |
138 |
4818.03 |
0.9962 |
1.0042 |
1192 |
93 |
TEST_TIME |
139 |
4818.82 |
0.9968 |
1.0036 |
1375 |
93 |
TEST_TIME |
140 |
4820.80 |
0.9960 |
1.0048 |
1299 |
92 |
TEST_TIME |
141 |
4830.22 |
0.9957 |
1.0046 |
1343 |
89 |
TEST_TIME |
142 |
4836.51 |
0.9962 |
1.0033 |
1171 |
92 |
TEST_TIME |
143 |
4833.49 |
0.9969 |
1.0032 |
1327 |
90 |
TEST_TIME |
144 |
4829.26 |
0.9971 |
1.0024 |
1127 |
85 |
TEST_TIME |
145 |
4831.33 |
0.9950 |
1.0046 |
1202 |
88 |
TEST_TIME |
146 |
4846.43 |
0.9946 |
1.0050 |
1210 |
94 |
TEST_TIME |
147 |
4851.51 |
0.9971 |
1.0035 |
1230 |
91 |
TEST_TIME |
148 |
4854.23 |
0.9961 |
1.0038 |
1278 |
91 |
TEST_TIME |
149 |
4854.34 |
0.9971 |
1.0040 |
1171 |
87 |
TEST_TIME |
150 |
4857.78 |
0.9966 |
1.0035 |
1140 |
90 |
TEST_TIME |
151 |
4858.65 |
0.9967 |
1.0025 |
1207 |
90 |
TEST_TIME |
152 |
4854.97 |
0.9966 |
1.0029 |
1132 |
89 |
TEST_TIME |
153 |
4858.36 |
0.9957 |
1.0034 |
1064 |
89 |
TEST_TIME |
154 |
4867.77 |
0.9951 |
1.0041 |
1314 |
90 |
TEST_TIME |
155 |
4875.48 |
0.9961 |
1.0037 |
1359 |
92 |
TEST_TIME |
156 |
4882.93 |
0.9957 |
1.0044 |
1212 |
90 |
TEST_TIME |
157 |
4895.02 |
0.9955 |
1.0042 |
1313 |
93 |
TEST_TIME |
158 |
4901.99 |
0.9964 |
1.0043 |
1223 |
90 |
TEST_TIME |
159 |
4908.81 |
0.9965 |
1.0055 |
1145 |
91 |
TEST_TIME |
160 |
4918.87 |
0.9971 |
1.0025 |
1014 |
91 |
TEST_TIME |
161 |
4917.51 |
0.9966 |
1.0036 |
1098 |
93 |
TEST_TIME |
162 |
4921.65 |
0.9965 |
1.0030 |
1107 |
90 |
TEST_TIME |
163 |
4921.17 |
0.9971 |
1.0024 |
1112 |
91 |
TEST_TIME |
164 |
4918.42 |
0.9969 |
1.0027 |
1111 |
87 |
TEST_TIME |
165 |
4919.11 |
0.9965 |
1.0030 |
1176 |
92 |
TEST_TIME |
166 |
4921.40 |
0.9965 |
1.0037 |
1076 |
89 |
TEST_TIME |
167 |
4927.80 |
0.9964 |
1.0036 |
1080 |
93 |
TEST_TIME |
168 |
4930.98 |
0.9970 |
1.0032 |
1029 |
92 |
TEST_TIME |
169 |
4931.15 |
0.9972 |
1.0027 |
1373 |
93 |
TEST_TIME |
170 |
4933.93 |
0.9962 |
1.0047 |
1205 |
96 |
TEST_TIME |
171 |
4942.41 |
0.9972 |
1.0029 |
1170 |
93 |
TEST_TIME |
172 |
4942.74 |
0.9970 |
1.0030 |
1274 |
93 |
TEST_TIME |
173 |
4941.63 |
0.9975 |
1.0027 |
1084 |
92 |
TEST_TIME |
174 |
4938.95 |
0.9975 |
1.0025 |
1279 |
91 |
TEST_TIME |
175 |
4938.89 |
0.9969 |
1.0029 |
1179 |
88 |
TEST_TIME |
176 |
4939.45 |
0.9971 |
1.0024 |
1172 |
90 |
TEST_TIME |
177 |
4935.68 |
0.9975 |
1.0026 |
1035 |
86 |
TEST_TIME |
178 |
4937.61 |
0.9966 |
1.0021 |
1047 |
92 |
TEST_TIME |
179 |
4934.45 |
0.9971 |
1.0032 |
1082 |
91 |
TEST_TIME |
180 |
4937.91 |
0.9969 |
1.0023 |
1102 |
90 |
TEST_TIME |
181 |
4933.67 |
0.9976 |
1.0021 |
1134 |
92 |
TEST_TIME |
182 |
4930.28 |
0.9973 |
1.0018 |
1133 |
88 |
TEST_TIME |
183 |
4926.50 |
0.9971 |
1.0025 |
1071 |
92 |
TEST_TIME |
184 |
4926.29 |
0.9971 |
1.0026 |
1238 |
95 |
TEST_TIME |
185 |
4930.24 |
0.9964 |
1.0029 |
1026 |
95 |
TEST_TIME |
186 |
4932.78 |
0.9970 |
1.0029 |
1162 |
91 |
TEST_TIME |
187 |
4934.92 |
0.9971 |
1.0028 |
1278 |
89 |
TEST_TIME |
188 |
4935.14 |
0.9974 |
1.0022 |
1221 |
91 |
TEST_TIME |
189 |
4932.78 |
0.9973 |
1.0028 |
1185 |
89 |
TEST_TIME |
190 |
4930.25 |
0.9981 |
1.0045 |
375 |
100 |
Done for 11640 ms, from 8:06:09.51 to 8:06:21.15.
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 |
2008 |
8787 |
3762 |
<null> |
3763 |
3056 |
5794 |
4357 |
7994 |
4615 |
3421 |
3305 |
11200 |
2840 |
14467 |
<null> |
284643 |
191981 |
<null> |
04:56:10 |
05:14:10 |
fetches per second |
2 |
1793 |
5692 |
5114 |
4104 |
5456 |
3797 |
6106 |
3142 |
9344 |
5275 |
2931 |
4665 |
13096 |
4344 |
38540 |
2735 |
365046 |
274116 |
<null> |
05:14:11 |
05:32:11 |
fetches per second |
3 |
1891 |
6671 |
4361 |
<null> |
4945 |
3036 |
5403 |
5248 |
3847 |
3733 |
4396 |
4071 |
17286 |
4661 |
24859 |
3073 |
341629 |
239789 |
<null> |
05:32:12 |
05:50:12 |
fetches per second |
4 |
1844 |
6495 |
5603 |
3208 |
6298 |
3640 |
7414 |
3523 |
5967 |
3831 |
4127 |
3364 |
17299 |
3917 |
30282 |
3236 |
406858 |
336531 |
<null> |
05:50:13 |
06:08:13 |
fetches per second |
5 |
1658 |
5031 |
6918 |
<null> |
7458 |
2610 |
7500 |
4084 |
4733 |
3617 |
6618 |
3098 |
19190 |
2946 |
33652 |
<null> |
480116 |
310977 |
<null> |
06:08:14 |
06:26:14 |
fetches per second |
6 |
1544 |
5260 |
6590 |
<null> |
6878 |
2980 |
6374 |
4126 |
5361 |
3300 |
4735 |
2991 |
23445 |
2607 |
30316 |
2760 |
398328 |
248177 |
<null> |
06:26:15 |
06:44:15 |
fetches per second |
7 |
1755 |
7563 |
6358 |
3693 |
6558 |
2957 |
6502 |
<null> |
6677 |
2647 |
4786 |
3017 |
23124 |
3154 |
20720 |
<null> |
354112 |
254514 |
<null> |
06:44:16 |
07:02:16 |
fetches per second |
8 |
1718 |
5975 |
4691 |
<null> |
5275 |
<null> |
5959 |
<null> |
4425 |
<null> |
5605 |
2792 |
21965 |
2882 |
8393 |
4661 |
419315 |
265907 |
<null> |
07:02:17 |
07:20:17 |
fetches per second |
9 |
1779 |
5042 |
5242 |
2480 |
7665 |
<null> |
6844 |
3673 |
11244 |
3495 |
5077 |
3155 |
29009 |
4233 |
19881 |
<null> |
442749 |
311994 |
<null> |
07:20:18 |
07:38:18 |
fetches per second |
10 |
1761 |
5724 |
5097 |
<null> |
5934 |
3356 |
6171 |
<null> |
5209 |
3476 |
5102 |
3576 |
34992 |
3473 |
25540 |
4314 |
388456 |
167251 |
<null> |
07:38:19 |
07:56:19 |
marks per second |
1 |
350 |
823 |
280 |
<null> |
287 |
474 |
440 |
522 |
485 |
632 |
493 |
374 |
567 |
401 |
511 |
<null> |
1779 |
717 |
<null> |
04:56:10 |
05:14:10 |
marks per second |
2 |
315 |
584 |
270 |
561 |
302 |
585 |
376 |
449 |
531 |
594 |
418 |
543 |
552 |
437 |
476 |
403 |
1029 |
337 |
<null> |
05:14:11 |
05:32:11 |
marks per second |
3 |
330 |
642 |
276 |
<null> |
290 |
446 |
399 |
583 |
346 |
484 |
457 |
437 |
558 |
572 |
574 |
510 |
1162 |
582 |
<null> |
05:32:12 |
05:50:12 |
marks per second |
4 |
314 |
624 |
269 |
548 |
261 |
603 |
409 |
381 |
342 |
436 |
452 |
368 |
477 |
499 |
480 |
385 |
1142 |
508 |
<null> |
05:50:13 |
06:08:13 |
marks per second |
5 |
282 |
493 |
261 |
<null> |
257 |
425 |
360 |
470 |
323 |
388 |
465 |
359 |
433 |
330 |
457 |
<null> |
828 |
471 |
<null> |
06:08:14 |
06:26:14 |
marks per second |
6 |
272 |
508 |
233 |
<null> |
246 |
491 |
391 |
479 |
359 |
400 |
413 |
339 |
403 |
353 |
429 |
333 |
1049 |
403 |
<null> |
06:26:15 |
06:44:15 |
marks per second |
7 |
294 |
702 |
250 |
438 |
263 |
478 |
381 |
<null> |
371 |
408 |
379 |
336 |
393 |
473 |
364 |
<null> |
984 |
620 |
<null> |
06:44:16 |
07:02:16 |
marks per second |
8 |
291 |
597 |
240 |
<null> |
308 |
<null> |
376 |
<null> |
344 |
<null> |
399 |
349 |
385 |
352 |
338 |
530 |
1106 |
455 |
<null> |
07:02:17 |
07:20:17 |
marks per second |
9 |
299 |
475 |
262 |
417 |
281 |
<null> |
394 |
401 |
552 |
412 |
389 |
331 |
464 |
485 |
408 |
<null> |
1113 |
525 |
<null> |
07:20:18 |
07:38:18 |
marks per second |
10 |
297 |
530 |
251 |
<null> |
254 |
557 |
405 |
<null> |
323 |
377 |
369 |
325 |
406 |
396 |
434 |
520 |
1240 |
190 |
<null> |
07:38:19 |
07:56:19 |
reads/fetches*100 |
1 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
04:56:10 |
05:14:10 |
reads/fetches*100 |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:14:11 |
05:32:11 |
reads/fetches*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:32:12 |
05:50:12 |
reads/fetches*100 |
4 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:50:13 |
06:08:13 |
reads/fetches*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
06:08:14 |
06:26:14 |
reads/fetches*100 |
6 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
06:26:15 |
06:44:15 |
reads/fetches*100 |
7 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
06:44:16 |
07:02:16 |
reads/fetches*100 |
8 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
07:02:17 |
07:20:17 |
reads/fetches*100 |
9 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
07:20:18 |
07:38:18 |
reads/fetches*100 |
10 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
07:38:19 |
07:56:19 |
writes/marks*100 |
1 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
2 |
0 |
<null> |
04:56:10 |
05:14:10 |
writes/marks*100 |
2 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
1 |
0 |
0 |
0 |
0 |
5 |
0 |
<null> |
05:14:11 |
05:32:11 |
writes/marks*100 |
3 |
1 |
0 |
0 |
<null> |
0 |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0 |
<null> |
05:32:12 |
05:50:12 |
writes/marks*100 |
4 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
4 |
0 |
<null> |
05:50:13 |
06:08:13 |
writes/marks*100 |
5 |
1 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
<null> |
4 |
0 |
<null> |
06:08:14 |
06:26:14 |
writes/marks*100 |
6 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
4 |
0 |
<null> |
06:26:15 |
06:44:15 |
writes/marks*100 |
7 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
3 |
0 |
<null> |
06:44:16 |
07:02:16 |
writes/marks*100 |
8 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
1 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
7 |
0 |
<null> |
07:02:17 |
07:20:17 |
writes/marks*100 |
9 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
5 |
0 |
<null> |
07:20:18 |
07:38:18 |
writes/marks*100 |
10 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
1 |
4 |
0 |
<null> |
07:38:19 |
07:56:19 |
Done for 9680 ms, from 8:06:22.28 to 8:06:31.96.
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 |
1518851 |
1477228 |
41623 |
2.74 |
0 |
15538 |
28 |
41623 |
2016-03-18 04:56 |
2016-03-18 07:56 |
doc_list_biud |
1519237 |
1477222 |
42015 |
2.76 |
0 |
10655 |
37 |
42015 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_add_invoice_to_stock |
16612 |
10700 |
5912 |
35.58 |
280 |
146384 |
21890 |
5912 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_cancel_adding_invoice |
3481 |
2929 |
552 |
15.85 |
125 |
136232 |
4722 |
552 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_cancel_client_order |
5816 |
5516 |
300 |
5.15 |
15 |
297 |
76 |
300 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_cancel_customer_reserve |
186913 |
148881 |
38032 |
20.34 |
0 |
2543 |
121 |
38032 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_cancel_pay_from_customer |
2269 |
2249 |
20 |
0.88 |
15 |
1857 |
109 |
20 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_cancel_pay_to_supplier |
1351 |
1323 |
28 |
2.07 |
15 |
702 |
152 |
28 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_cancel_supplier_invoice |
7319 |
6177 |
1142 |
15.60 |
15 |
9903 |
2552 |
1142 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_cancel_supplier_order |
1293 |
424 |
869 |
67.20 |
437 |
447811 |
76068 |
869 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_cancel_write_off |
12283 |
9562 |
2721 |
22.15 |
0 |
2418 |
223 |
2721 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_client_order |
69598 |
69598 |
0 |
0.00 |
62 |
4321 |
1101 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_customer_reserve |
529560 |
529560 |
0 |
0.00 |
0 |
6266 |
372 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_fill_shopping_cart |
105243 |
105243 |
0 |
0.00 |
0 |
21424 |
270 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_fill_shopping_cart_clo_res |
529560 |
529560 |
0 |
0.00 |
0 |
561 |
1 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_get_clo_for_invoice |
10701 |
10701 |
0 |
0.00 |
0 |
8705 |
1132 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_kill_cost_storno |
19096 |
16064 |
3032 |
15.87 |
0 |
8734 |
88 |
3032 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_kill_qstorno_ret_qs2qd |
393130 |
313926 |
79204 |
20.14 |
0 |
9476 |
101 |
79204 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_kill_qty_storno |
258030 |
216109 |
41921 |
16.24 |
0 |
10655 |
252 |
41921 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_lock_selected_doc |
68398 |
59592 |
8806 |
12.87 |
0 |
125 |
3 |
8806 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_make_cost_storno |
85149 |
85149 |
0 |
0.00 |
0 |
15366 |
273 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_multiply_rows_for_pdistr |
85148 |
85148 |
0 |
0.00 |
0 |
577 |
157 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_multiply_rows_for_qdistr |
69599 |
69599 |
0 |
0.00 |
0 |
3650 |
820 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_pay_from_customer |
23116 |
23116 |
0 |
0.00 |
47 |
5070 |
340 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_pay_to_supplier |
19410 |
19410 |
0 |
0.00 |
93 |
12495 |
766 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_payment_common |
42526 |
42526 |
0 |
0.00 |
0 |
5148 |
32 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_qd_handle_on_cancel_clo |
5815 |
5516 |
299 |
5.14 |
0 |
265 |
52 |
299 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_qd_handle_on_invoice_upd_sts |
14027 |
13629 |
398 |
2.83 |
0 |
10655 |
1285 |
398 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_qd_handle_on_reserve_upd_sts |
31919 |
31919 |
0 |
0.00 |
0 |
2074 |
125 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_reserve_write_off |
32756 |
31918 |
838 |
2.55 |
16 |
5990 |
337 |
838 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_supplier_invoice |
17698 |
17698 |
0 |
0.00 |
109 |
50709 |
12584 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
sp_supplier_order |
17947 |
17947 |
0 |
0.00 |
94 |
27430 |
7965 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
srv_find_qd_qs_mism |
865223 |
823647 |
41576 |
4.80 |
0 |
498 |
1 |
41576 |
2016-03-18 04:56 |
2016-03-18 07:56 |
srv_make_invnt_saldo |
3226 |
3226 |
0 |
0.00 |
187 |
50461 |
1746 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
srv_make_money_saldo |
4108 |
4108 |
0 |
0.00 |
0 |
5161 |
94 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
2589 |
4539 |
3640 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-abend:sp_add_invoice_to_stock |
5912 |
5912 |
0 |
0.00 |
62 |
421 |
152 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-abend:sp_cancel_adding_invoice |
468 |
468 |
0 |
0.00 |
78 |
2699 |
1250 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-abend:sp_cancel_client_order |
300 |
300 |
0 |
0.00 |
93 |
453 |
243 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-abend:sp_cancel_customer_reserve |
60 |
60 |
0 |
0.00 |
47 |
281 |
149 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-abend:sp_cancel_pay_from_customer |
20 |
20 |
0 |
0.00 |
140 |
406 |
223 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-abend:sp_cancel_pay_to_supplier |
28 |
28 |
0 |
0.00 |
140 |
406 |
255 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-abend:sp_cancel_supplier_invoice |
509 |
509 |
0 |
0.00 |
63 |
312 |
149 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-abend:sp_cancel_supplier_order |
5209 |
5209 |
0 |
0.00 |
47 |
3245 |
1649 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-abend:sp_cancel_write_off |
72 |
72 |
0 |
0.00 |
78 |
312 |
141 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-abend:sp_reserve_write_off |
838 |
838 |
0 |
0.00 |
62 |
374 |
151 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-norm:sp_add_invoice_to_stock |
10723 |
10723 |
0 |
0.00 |
437 |
51389 |
11799 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-norm:sp_cancel_adding_invoice |
1190 |
1190 |
0 |
0.00 |
515 |
36815 |
9751 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-norm:sp_cancel_client_order |
5516 |
5516 |
0 |
0.00 |
78 |
592 |
270 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-norm:sp_cancel_customer_reserve |
2145 |
2145 |
0 |
0.00 |
109 |
624 |
300 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-norm:sp_cancel_pay_from_customer |
2249 |
2249 |
0 |
0.00 |
94 |
562 |
210 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-norm:sp_cancel_pay_to_supplier |
1323 |
1323 |
0 |
0.00 |
93 |
561 |
214 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-norm:sp_cancel_supplier_invoice |
830 |
830 |
0 |
0.00 |
125 |
530 |
271 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-norm:sp_cancel_supplier_order |
425 |
425 |
0 |
0.00 |
312 |
337626 |
52821 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-norm:sp_cancel_write_off |
3299 |
3299 |
0 |
0.00 |
125 |
609 |
300 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-norm:sp_client_order |
69607 |
69607 |
0 |
0.00 |
85 |
983 |
362 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-norm:sp_customer_reserve |
3226 |
3226 |
0 |
0.00 |
62 |
593 |
202 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-norm:sp_pay_from_customer |
23116 |
23116 |
0 |
0.00 |
93 |
624 |
242 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-norm:sp_pay_to_supplier |
19411 |
19411 |
0 |
0.00 |
62 |
813 |
243 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-norm:sp_reserve_write_off |
31922 |
31922 |
0 |
0.00 |
95 |
734 |
331 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-norm:sp_supplier_invoice |
17724 |
17724 |
0 |
0.00 |
15 |
905 |
364 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-norm:sp_supplier_order |
17960 |
17960 |
0 |
0.00 |
31 |
870 |
362 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-norm:srv_make_invnt_saldo |
3227 |
3227 |
0 |
0.00 |
0 |
172 |
30 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-norm:srv_make_money_saldo |
4108 |
4108 |
0 |
0.00 |
0 |
188 |
32 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
t$perf-norm:srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
1029 |
1576 |
1256 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
v_add_invoice_to_stock |
33224 |
21400 |
11824 |
35.58 |
0 |
125 |
6 |
11824 |
2016-03-18 04:56 |
2016-03-18 07:56 |
v_all_customers |
104412 |
104412 |
0 |
0.00 |
0 |
125 |
5 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
v_all_suppliers |
73538 |
73538 |
0 |
0.00 |
0 |
156 |
6 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
v_all_wares |
139196 |
139196 |
0 |
0.00 |
0 |
172 |
9 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
v_cancel_adding_invoice |
2776 |
2380 |
396 |
14.26 |
0 |
421 |
62 |
396 |
2016-03-18 04:56 |
2016-03-18 07:56 |
v_cancel_client_order |
11632 |
11032 |
600 |
5.15 |
0 |
94 |
5 |
600 |
2016-03-18 04:56 |
2016-03-18 07:56 |
v_cancel_customer_prepayment |
4538 |
4498 |
40 |
0.88 |
0 |
93 |
6 |
40 |
2016-03-18 04:56 |
2016-03-18 07:56 |
v_cancel_customer_reserve |
4408 |
4288 |
120 |
2.72 |
0 |
452 |
6 |
120 |
2016-03-18 04:56 |
2016-03-18 07:56 |
v_cancel_payment_to_supplier |
2702 |
2646 |
56 |
2.07 |
0 |
94 |
6 |
56 |
2016-03-18 04:56 |
2016-03-18 07:56 |
v_cancel_supplier_invoice |
2676 |
1658 |
1018 |
38.04 |
0 |
78 |
8 |
1018 |
2016-03-18 04:56 |
2016-03-18 07:56 |
v_cancel_supplier_order |
2586 |
848 |
1738 |
67.20 |
0 |
62 |
7 |
1738 |
2016-03-18 04:56 |
2016-03-18 07:56 |
v_cancel_write_off |
6742 |
6598 |
144 |
2.13 |
0 |
344 |
34 |
144 |
2016-03-18 04:56 |
2016-03-18 07:56 |
v_max_id_clo_ord |
17947 |
17947 |
0 |
0.00 |
0 |
1123 |
20 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
v_max_id_clo_res |
3226 |
3226 |
0 |
0.00 |
0 |
265 |
22 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
v_max_id_ord_sup |
17698 |
17698 |
0 |
0.00 |
0 |
1544 |
20 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
v_max_non_paid_invoice |
18286 |
18286 |
0 |
0.00 |
0 |
1794 |
8 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
v_max_non_paid_realizn |
23116 |
23116 |
0 |
0.00 |
0 |
109 |
7 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
v_min_id_clo_ord |
17947 |
17947 |
0 |
0.00 |
0 |
1912 |
16 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
v_min_id_clo_res |
3226 |
3226 |
0 |
0.00 |
0 |
515 |
11 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
v_min_id_ord_sup |
17698 |
17698 |
0 |
0.00 |
0 |
1201 |
16 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
v_min_non_paid_invoice |
19410 |
19410 |
0 |
0.00 |
0 |
5086 |
21 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
v_min_non_paid_realizn |
23116 |
23116 |
0 |
0.00 |
0 |
733 |
6 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
v_our_firm |
34784 |
34784 |
0 |
0.00 |
0 |
114 |
5 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
v_reserve_write_off |
65512 |
63836 |
1676 |
2.55 |
0 |
156 |
5 |
1676 |
2016-03-18 04:56 |
2016-03-18 07:56 |
x_lock_depdocs_on_canc_invoice |
11904 |
8272 |
3632 |
30.51 |
0 |
874 |
9 |
3632 |
2016-03-18 04:56 |
2016-03-18 07:56 |
x_lock_depdocs_on_canc_sup_ord |
1290 |
424 |
866 |
67.13 |
0 |
47 |
6 |
866 |
2016-03-18 04:56 |
2016-03-18 07:56 |
x_make_qstorno_1000_1200 |
17948 |
17948 |
0 |
0.00 |
47 |
23106 |
7273 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
x_make_qstorno_1200_2000 |
17700 |
17700 |
0 |
0.00 |
62 |
49741 |
11910 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
x_make_qstorno_2100_3300 |
529560 |
529560 |
0 |
0.00 |
0 |
6262 |
369 |
0 |
2016-03-18 04:56 |
2016-03-18 07:56 |
Done for 315830 ms, from 8:11:39.85 to 8:16:55.68.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
DTS_BEG |
DTS_END |
deadlock |
120 |
sp_kill_cost_storno |
335544336 |
2016-03-18 04:56 |
2016-03-18 07:55 |
deadlock |
8 |
sp_kill_qstorno_ret_qs2qd |
335544336 |
2016-03-18 04:56 |
2016-03-18 07:54 |
deadlock |
121 |
sp_lock_selected_doc |
335544336 |
2016-03-18 04:56 |
2016-03-18 07:54 |
deadlock |
299 |
sp_qd_handle_on_cancel_clo |
335544336 |
2016-03-18 04:57 |
2016-03-18 07:55 |
deadlock |
54 |
sp_qd_handle_on_invoice_upd_sts |
335544336 |
2016-03-18 04:58 |
2016-03-18 07:55 |
deadlock |
1 |
x_lock_depdocs_on_canc_sup_ord |
335544336 |
2016-03-18 05:07 |
2016-03-18 05:07 |
concurrent_transaction |
7307 |
sp_lock_selected_doc |
335544878 |
2016-03-18 04:56 |
2016-03-18 07:56 |
concurrent_transaction |
431 |
x_lock_depdocs_on_canc_invoice |
335544878 |
2016-03-18 04:56 |
2016-03-18 07:55 |
concurrent_transaction |
465 |
x_lock_depdocs_on_canc_sup_ord |
335544878 |
2016-03-18 04:57 |
2016-03-18 07:55 |
Done for 9400 ms, from 8:17:04.67 to 8:17:14.07.
MON$DATABASE_NAME D:\OLTP-EMUL\OLTP40-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 333532
MON$OLDEST_ACTIVE 333533
MON$OLDEST_SNAPSHOT 333533
MON$NEXT_TRANSACTION 333533
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-T4.0.0.32401 Firebird 4.0 Unstable
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.32401 Firebird 4.0 Unstable"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T4.0.0.32401 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P13"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T4.0.0.32401 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P13"
on disk structure version 12.0
Database "D:\OLTP-EMUL\OLTP40-SMALL.FDB"
Database header page information:
Flags 0
Generation 333849
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 333534
Oldest active 333535
Oldest snapshot 333535
Next transaction 333536
Sequence number 0
Next attachment ID 5150
Implementation HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Dec 11, 2015 13:07:49
Attributes force write
Variable header data:
Sweep interval: 0
*END*
Database file sequence:
File D:\OLTP-EMUL\OLTP40-SMALL.FDB is the only file
Analyzing database pages ...
AGENTS (154)
Primary pointer page: 311, Index root page: 312
Total formats: 1, used formats: 1
Average record length: 34.24, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 344.00, compression ratio: 10.05
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_ID_DESC (2)
Root page: 322, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_OUR_FIRM (4)
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 48
Average key length: 2.04, compression ratio: 0.50
Average prefix length: 0.96, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_SUPPLIER (3)
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 45
Average key length: 2.04, compression ratio: 0.53
Average prefix length: 1.02, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_NAME_UNQ (1)
Root page: 321, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.92, total dup: 0, max dup: 0
Average key length: 16.60, compression ratio: 0.92
Average prefix length: 1.34, average data length: 13.92
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_AGENTS (0)
Root page: 320, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BUSINESS_OPS (158)
Primary pointer page: 332, Index root page: 333
Total formats: 1, used formats: 1
Average record length: 103.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 996.00, compression ratio: 9.67
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 28%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BO_UNIT_UNQ (1)
Root page: 336, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 18.00, total dup: 0, max dup: 0
Average key length: 16.95, compression ratio: 1.25
Average prefix length: 7.21, average data length: 14.00
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BUSINESS_OPS_RND_WGTH (2)
Root page: 337, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 4.05, total dup: 7, max dup: 3
Average key length: 3.00, compression ratio: 0.75
Average prefix length: 1.42, average data length: 0.84
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$1 (0)
Root page: 335, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 5.26, total dup: 0, max dup: 0
Average key length: 4.21, compression ratio: 0.64
Average prefix length: 1.05, average data length: 1.63
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DOC_DATA (141)
Primary pointer page: 251, Index root page: 252
Total formats: 1, used formats: 1
Average record length: 46.97, total records: 1650877
Average version length: 47.48, total versions: 6102, 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: 18352
Data pages: 18352, average fill: 71%
Primary pages: 18352, secondary pages: 0, swept pages: 13144
Empty pages: 4, full pages: 8344
Fill distribution:
0 - 19% = 5
20 - 39% = 1
40 - 59% = 223
60 - 79% = 18123
80 - 99% = 0
Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 19783, depth: 3, leaf buckets: 7683, nodes: 1650877
Average node length: 19.90, total dup: 0, max dup: 0
Average key length: 16.95, compression ratio: 1.59
Average prefix length: 13.04, average data length: 13.96
Clustering factor: 652241, ratio: 0.40
Fill distribution:
0 - 19% = 236
20 - 39% = 585
40 - 59% = 4956
60 - 79% = 1261
80 - 99% = 645
Index DOC_DATA_ID_DESC (2)
Root page: 46992, depth: 3, leaf buckets: 5674, nodes: 1650877
Average node length: 11.64, total dup: 0, max dup: 0
Average key length: 8.70, compression ratio: 1.03
Average prefix length: 3.30, average data length: 5.70
Clustering factor: 607923, ratio: 0.37
Fill distribution:
0 - 19% = 0
20 - 39% = 2100
40 - 59% = 3572
60 - 79% = 2
80 - 99% = 0
Index FK_DOC_DATA_DOC_LIST (3)
Root page: 150666, depth: 3, leaf buckets: 3066, nodes: 1650877
Average node length: 7.12, total dup: 1134245, max dup: 49
Average key length: 4.18, compression ratio: 2.15
Average prefix length: 7.13, average data length: 1.87
Clustering factor: 610534, ratio: 0.37
Fill distribution:
0 - 19% = 52
20 - 39% = 649
40 - 59% = 2096
60 - 79% = 64
80 - 99% = 205
DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 60.09, total records: 566609
Average version length: 60.65, total versions: 1092, max versions: 3
Average fragment length: 9.64, total fragments: 14, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.60
Pointer pages: 5, data page slots: 7376
Data pages: 7376, average fill: 73%
Primary pages: 7374, secondary pages: 2, swept pages: 6845
Empty pages: 1, full pages: 4651
Fill distribution:
0 - 19% = 4
20 - 39% = 1
40 - 59% = 128
60 - 79% = 7231
80 - 99% = 12
Index DOC_LIST_ID_DESC (1)
Root page: 234762, depth: 3, leaf buckets: 2109, nodes: 566609
Average node length: 11.77, total dup: 0, max dup: 0
Average key length: 8.92, compression ratio: 1.01
Average prefix length: 3.07, average data length: 5.93
Clustering factor: 172913, ratio: 0.31
Fill distribution:
0 - 19% = 0
20 - 39% = 1226
40 - 59% = 882
60 - 79% = 1
80 - 99% = 0
Index FK_DOC_LIST_AGENTS (2)
Root page: 2964, depth: 2, leaf buckets: 698, nodes: 566609
Average node length: 4.86, total dup: 566559, max dup: 45279
Average key length: 2.01, compression ratio: 4.47
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 269035, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 645
60 - 79% = 37
80 - 99% = 15
Index PK_DOC_LIST (0)
Root page: 187946, depth: 3, leaf buckets: 2083, nodes: 566609
Average node length: 11.77, total dup: 0, max dup: 0
Average key length: 8.92, compression ratio: 1.01
Average prefix length: 3.07, average data length: 5.93
Clustering factor: 172913, ratio: 0.31
Fill distribution:
0 - 19% = 63
20 - 39% = 1175
40 - 59% = 766
60 - 79% = 9
80 - 99% = 70
DOC_STATES (153)
Primary pointer page: 309, Index root page: 310
Total formats: 1, used formats: 1
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 650.00, compression ratio: 9.63
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_MCODE_UNQ (1)
Root page: 318, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 17.75, total dup: 0, max dup: 0
Average key length: 16.50, compression ratio: 1.08
Average prefix length: 4.00, average data length: 13.75
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_NAME_UNQ (2)
Root page: 319, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 33.25, total dup: 0, max dup: 0
Average key length: 32.00, compression ratio: 0.99
Average prefix length: 2.50, average data length: 29.25
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_DOC_STATES (0)
Root page: 317, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 4.75, total dup: 0, max dup: 0
Average key length: 3.50, compression ratio: 0.86
Average prefix length: 1.50, average data length: 1.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
FB_ERRORS (159)
Primary pointer page: 338, Index root page: 339
Total formats: 1, used formats: 1
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 148.00, compression ratio: 1.86
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 56%
Primary pages: 16, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 11
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7
Index FB_ERRORS_GDS_CODE (0)
Root page: 340, depth: 1, leaf buckets: 1, nodes: 758
Average node length: 4.24, total dup: 0, max dup: 0
Average key length: 3.04, compression ratio: 1.64
Average prefix length: 3.97, average data length: 1.03
Clustering factor: 353, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
INVNT_SALDO (147)
Primary pointer page: 269, Index root page: 270
Total formats: 1, used formats: 1
Average record length: 64.84, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 18.16, total fragments: 392, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.60
Pointer pages: 3, data page slots: 1238
Data pages: 28, average fill: 24%
Primary pages: 10, secondary pages: 18, swept pages: 4
Empty pages: 13, full pages: 3
Fill distribution:
0 - 19% = 18
20 - 39% = 4
40 - 59% = 1
60 - 79% = 2
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: 18.60, total records: 35287
Average version length: 71.16, total versions: 26015, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 5.16
Pointer pages: 4, data page slots: 2400
Data pages: 1592, average fill: 29%
Primary pages: 1592, secondary pages: 0, swept pages: 1041
Empty pages: 401, full pages: 387
Fill distribution:
0 - 19% = 949
20 - 39% = 190
40 - 59% = 26
60 - 79% = 151
80 - 99% = 276
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 145301, depth: 3, leaf buckets: 149, nodes: 35287
Average node length: 14.68, total dup: 1776, max dup: 2
Average key length: 11.68, compression ratio: 2.31
Average prefix length: 18.27, average data length: 8.73
Clustering factor: 30143, ratio: 0.85
Fill distribution:
0 - 19% = 1
20 - 39% = 70
40 - 59% = 59
60 - 79% = 19
80 - 99% = 0
MONEY_SALDO (143)
Primary pointer page: 261, Index root page: 262
Total formats: 1, used formats: 1
Average record length: 15.08, 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.12
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: 35.55, total records: 311
Average version length: 48.50, total versions: 80, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.80
Pointer pages: 1, data page slots: 176
Data pages: 71, average fill: 8%
Primary pages: 71, secondary pages: 0, swept pages: 57
Empty pages: 23, full pages: 0
Fill distribution:
0 - 19% = 69
20 - 39% = 2
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 101113, depth: 2, leaf buckets: 1, nodes: 311
Average node length: 6.51, total dup: 261, max dup: 80
Average key length: 4.73, compression ratio: 4.02
Average prefix length: 16.43, average data length: 2.57
Clustering factor: 238, ratio: 0.77
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: 23.11, total records: 569405
Average version length: 42.79, total versions: 5886, max versions: 8
Average fragment length: 33.33, total fragments: 3, max fragments: 1
Average unpacked length: 64.00, compression ratio: 2.77
Pointer pages: 3, data page slots: 4408
Data pages: 4408, average fill: 65%
Primary pages: 4392, secondary pages: 16, swept pages: 3738
Empty pages: 14, full pages: 1648
Fill distribution:
0 - 19% = 48
20 - 39% = 211
40 - 59% = 730
60 - 79% = 3336
80 - 99% = 83
Index PDISTR_AGENT_ID (4)
Root page: 3600, depth: 2, leaf buckets: 263, nodes: 247362
Average node length: 4.75, total dup: 247313, max dup: 11002
Average key length: 2.01, compression ratio: 4.47
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 35621, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 21
40 - 59% = 168
60 - 79% = 61
80 - 99% = 12
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4281, depth: 2, leaf buckets: 290, nodes: 247362
Average node length: 5.72, total dup: 222634, max dup: 38
Average key length: 2.98, compression ratio: 7.38
Average prefix length: 21.12, average data length: 0.88
Clustering factor: 40384, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 21
40 - 59% = 128
60 - 79% = 102
80 - 99% = 38
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3974, depth: 2, leaf buckets: 280, nodes: 247362
Average node length: 5.72, total dup: 222634, max dup: 38
Average key length: 2.98, compression ratio: 7.38
Average prefix length: 21.12, average data length: 0.88
Clustering factor: 40532, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 15
40 - 59% = 108
60 - 79% = 114
80 - 99% = 42
Index PDISTR_SND_ID (1)
Root page: 4313, depth: 2, leaf buckets: 314, nodes: 247362
Average node length: 5.50, total dup: 222634, max dup: 38
Average key length: 2.76, compression ratio: 3.26
Average prefix length: 8.33, average data length: 0.67
Clustering factor: 40562, ratio: 0.16
Fill distribution:
0 - 19% = 2
20 - 39% = 56
40 - 59% = 147
60 - 79% = 92
80 - 99% = 17
PERF_ESTIMATED (160)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 27.90, total records: 250990
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: 2152
Data pages: 2152, average fill: 64%
Primary pages: 2152, secondary pages: 0, swept pages: 0
Empty pages: 8, full pages: 2142
Fill distribution:
0 - 19% = 9
20 - 39% = 0
40 - 59% = 1
60 - 79% = 2142
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 114914, depth: 2, leaf buckets: 197, nodes: 250990
Average node length: 4.49, total dup: 250799, max dup: 2695
Average key length: 2.00, compression ratio: 1.28
Average prefix length: 2.56, average data length: 0.00
Clustering factor: 52575, ratio: 0.21
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 37
60 - 79% = 109
80 - 99% = 51
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.68, total records: 9095407
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1439.64, compression ratio: 9.75
Pointer pages: 130, data page slots: 211448
Data pages: 211448, average fill: 87%
Primary pages: 211448, secondary pages: 0, swept pages: 3
Empty pages: 4, full pages: 211443
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 211443
Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 59394, depth: 3, leaf buckets: 9248, nodes: 9095407
Average node length: 5.60, total dup: 7774119, max dup: 57
Average key length: 2.26, compression ratio: 3.53
Average prefix length: 7.78, average data length: 0.21
Clustering factor: 6120279, ratio: 0.67
Fill distribution:
0 - 19% = 21
20 - 39% = 0
40 - 59% = 3364
60 - 79% = 3634
80 - 99% = 2229
Index PERF_LOG_GDSCODE (3)
Root page: 142864, depth: 3, leaf buckets: 9780, nodes: 9095407
Average node length: 4.37, total dup: 9095402, max dup: 8741335
Average key length: 1.04, compression ratio: 0.19
Average prefix length: 0.19, average data length: 0.00
Clustering factor: 345979, ratio: 0.04
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 9751
60 - 79% = 1
80 - 99% = 27
Index PERF_LOG_TRN_DESC (2)
Root page: 43359, depth: 3, leaf buckets: 10114, nodes: 9095407
Average node length: 5.57, total dup: 8799377, max dup: 13761
Average key length: 2.24, compression ratio: 4.02
Average prefix length: 8.79, average data length: 0.21
Clustering factor: 4638680, ratio: 0.51
Fill distribution:
0 - 19% = 3
20 - 39% = 2
40 - 59% = 6048
60 - 79% = 2268
80 - 99% = 1793
Index PERF_LOG_UNIT (1)
Root page: 65474, depth: 3, leaf buckets: 10611, nodes: 9095407
Average node length: 5.49, total dup: 8992918, max dup: 1347373
Average key length: 2.16, compression ratio: 17.46
Average prefix length: 37.51, average data length: 0.15
Clustering factor: 5603287, ratio: 0.62
Fill distribution:
0 - 19% = 19
20 - 39% = 3
40 - 59% = 8257
60 - 79% = 766
80 - 99% = 1566
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.31, total records: 308295
Average version length: 55.43, total versions: 3639, 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: 3792
Data pages: 3792, average fill: 72%
Primary pages: 3792, secondary pages: 0, swept pages: 2521
Empty pages: 8, full pages: 2688
Fill distribution:
0 - 19% = 16
20 - 39% = 28
40 - 59% = 143
60 - 79% = 3587
80 - 99% = 18
Index PSTORNED_RCV_ID (2)
Root page: 2296, depth: 2, leaf buckets: 401, nodes: 308295
Average node length: 5.95, total dup: 256240, max dup: 1035
Average key length: 3.25, compression ratio: 2.77
Average prefix length: 7.92, average data length: 1.08
Clustering factor: 34056, ratio: 0.11
Fill distribution:
0 - 19% = 6
20 - 39% = 13
40 - 59% = 248
60 - 79% = 107
80 - 99% = 27
Index PSTORNED_SND_ID (1)
Root page: 2211, depth: 2, leaf buckets: 340, nodes: 308295
Average node length: 5.53, total dup: 274625, max dup: 272
Average key length: 2.83, compression ratio: 3.18
Average prefix length: 8.27, average data length: 0.73
Clustering factor: 66650, ratio: 0.22
Fill distribution:
0 - 19% = 0
20 - 39% = 6
40 - 59% = 153
60 - 79% = 142
80 - 99% = 39
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.26, total records: 2992
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: 65%
Primary pages: 40, secondary pages: 0, swept pages: 0
Empty pages: 5, full pages: 34
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 35
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: 49.09, total records: 5537
Average version length: 72.26, total versions: 1755, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.77
Pointer pages: 6, data page slots: 3456
Data pages: 336, average fill: 20%
Primary pages: 336, secondary pages: 0, swept pages: 244
Empty pages: 159, full pages: 46
Fill distribution:
0 - 19% = 236
20 - 39% = 30
40 - 59% = 18
60 - 79% = 39
80 - 99% = 13
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1235, depth: 2, leaf buckets: 22, nodes: 5537
Average node length: 7.47, total dup: 4759, max dup: 14
Average key length: 4.84, compression ratio: 7.65
Average prefix length: 34.30, average data length: 2.70
Clustering factor: 825, ratio: 0.15
Fill distribution:
0 - 19% = 8
20 - 39% = 11
40 - 59% = 2
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: 70.96, total records: 1336142
Average version length: 71.23, total versions: 22044, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.92
Pointer pages: 14, data page slots: 22192
Data pages: 22192, average fill: 67%
Primary pages: 22192, secondary pages: 0, swept pages: 16695
Empty pages: 45, full pages: 9800
Fill distribution:
0 - 19% = 295
20 - 39% = 844
40 - 59% = 3580
60 - 79% = 17244
80 - 99% = 229
Index XQD_1000_3300_DOC (1)
Root page: 200796, depth: 3, leaf buckets: 1732, nodes: 1336142
Average node length: 5.15, total dup: 1300614, max dup: 130
Average key length: 2.20, compression ratio: 4.09
Average prefix length: 8.82, average data length: 0.18
Clustering factor: 271396, ratio: 0.20
Fill distribution:
0 - 19% = 21
20 - 39% = 125
40 - 59% = 1455
60 - 79% = 110
80 - 99% = 21
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 121414, depth: 3, leaf buckets: 2071, nodes: 1336142
Average node length: 6.28, total dup: 1166255, max dup: 25
Average key length: 3.33, compression ratio: 11.10
Average prefix length: 35.79, average data length: 1.21
Clustering factor: 346233, ratio: 0.26
Fill distribution:
0 - 19% = 36
20 - 39% = 118
40 - 59% = 1614
60 - 79% = 169
80 - 99% = 134
XQD_1200_2000 (260)
Primary pointer page: 705, Index root page: 706
Total formats: 1, used formats: 1
Average record length: 30.10, total records: 134114
Average version length: 72.01, total versions: 28723, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 4.52
Pointer pages: 8, data page slots: 12896
Data pages: 11744, average fill: 11%
Primary pages: 11742, secondary pages: 2, swept pages: 9519
Empty pages: 4527, full pages: 335
Fill distribution:
0 - 19% = 9785
20 - 39% = 776
40 - 59% = 624
60 - 79% = 416
80 - 99% = 143
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 123402, depth: 3, leaf buckets: 157, nodes: 78108
Average node length: 6.41, total dup: 68873, max dup: 66
Average key length: 3.40, compression ratio: 10.87
Average prefix length: 35.71, average data length: 1.29
Clustering factor: 11667, ratio: 0.15
Fill distribution:
0 - 19% = 1
20 - 39% = 85
40 - 59% = 57
60 - 79% = 12
80 - 99% = 2
XQD_2000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 53.36, total records: 2036767
Average version length: 71.78, total versions: 87887, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.55
Pointer pages: 22, data page slots: 35488
Data pages: 35464, average fill: 54%
Primary pages: 35464, secondary pages: 0, swept pages: 26325
Empty pages: 152, full pages: 7022
Fill distribution:
0 - 19% = 1429
20 - 39% = 6811
40 - 59% = 12779
60 - 79% = 12861
80 - 99% = 1584
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 110478, depth: 3, leaf buckets: 2456, nodes: 1530433
Average node length: 5.63, total dup: 1438899, max dup: 93
Average key length: 2.66, compression ratio: 13.92
Average prefix length: 36.40, average data length: 0.60
Clustering factor: 438540, ratio: 0.29
Fill distribution:
0 - 19% = 37
20 - 39% = 1100
40 - 59% = 915
60 - 79% = 309
80 - 99% = 95
XQD_2100_3300 (263)
Primary pointer page: 734, Index root page: 735
Total formats: 1, used formats: 1
Average record length: 9.04, total records: 3367238
Average version length: 69.69, total versions: 1798, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 15.05
Pointer pages: 14, data page slots: 21608
Data pages: 21552, average fill: 50%
Primary pages: 21551, secondary pages: 1, swept pages: 5961
Empty pages: 22, full pages: 19816
Fill distribution:
0 - 19% = 110
20 - 39% = 7497
40 - 59% = 4933
60 - 79% = 8995
80 - 99% = 17
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1530, depth: 2, leaf buckets: 15, nodes: 4193
Average node length: 10.07, total dup: 2996, max dup: 23
Average key length: 7.07, compression ratio: 5.24
Average prefix length: 32.22, average data length: 4.78
Clustering factor: 1002, ratio: 0.24
Fill distribution:
0 - 19% = 1
20 - 39% = 8
40 - 59% = 4
60 - 79% = 2
80 - 99% = 0
XQD_3300_3400 (264)
Primary pointer page: 737, Index root page: 738
Total formats: 1, used formats: 1
Average record length: 65.42, total records: 2240839
Average version length: 71.02, total versions: 51592, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.08
Pointer pages: 21, data page slots: 32808
Data pages: 32808, average fill: 71%
Primary pages: 32808, secondary pages: 0, swept pages: 22739
Empty pages: 20, full pages: 17513
Fill distribution:
0 - 19% = 59
20 - 39% = 255
40 - 59% = 2982
60 - 79% = 28188
80 - 99% = 1324
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 41262, depth: 3, leaf buckets: 4634, nodes: 2087536
Average node length: 6.98, total dup: 1668667, max dup: 25
Average key length: 4.02, compression ratio: 9.21
Average prefix length: 35.18, average data length: 1.82
Clustering factor: 581135, ratio: 0.28
Fill distribution:
0 - 19% = 6
20 - 39% = 3042
40 - 59% = 1200
60 - 79% = 247
80 - 99% = 139
XQS_1000_1200 (265)
Primary pointer page: 740, Index root page: 741
Total formats: 1, used formats: 1
Average record length: 83.22, total records: 3757972
Average version length: 83.38, total versions: 20433, 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: 36, data page slots: 58728
Data pages: 58728, average fill: 79%
Primary pages: 58728, secondary pages: 0, swept pages: 29622
Empty pages: 2, full pages: 55336
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 116
60 - 79% = 29295
80 - 99% = 29314
Index XQS_1000_1200_DOC_ID (0)
Root page: 54649, depth: 3, leaf buckets: 3660, nodes: 3757972
Average node length: 5.16, total dup: 3671193, max dup: 130
Average key length: 2.17, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 880552, ratio: 0.23
Fill distribution:
0 - 19% = 12
20 - 39% = 41
40 - 59% = 1386
60 - 79% = 1450
80 - 99% = 771
Index XQS_1000_1200_RCV_ID (2)
Root page: 78654, depth: 3, leaf buckets: 4982, nodes: 3757972
Average node length: 5.65, total dup: 3391332, max dup: 49
Average key length: 2.67, compression ratio: 3.37
Average prefix length: 8.43, average data length: 0.57
Clustering factor: 601465, ratio: 0.16
Fill distribution:
0 - 19% = 43
20 - 39% = 156
40 - 59% = 3913
60 - 79% = 406
80 - 99% = 464
Index XQS_1000_1200_SND_ID (1)
Root page: 48486, depth: 3, leaf buckets: 4145, nodes: 3757972
Average node length: 5.80, total dup: 3287152, max dup: 29
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.31, average data length: 0.69
Clustering factor: 930127, ratio: 0.25
Fill distribution:
0 - 19% = 5
20 - 39% = 56
40 - 59% = 1782
60 - 79% = 1356
80 - 99% = 946
XQS_1000_3300 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 80.41, total records: 1530618
Average version length: 82.54, total versions: 38800, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.69
Pointer pages: 16, data page slots: 25248
Data pages: 25248, average fill: 75%
Primary pages: 25248, secondary pages: 0, swept pages: 17475
Empty pages: 12, full pages: 17905
Fill distribution:
0 - 19% = 43
20 - 39% = 192
40 - 59% = 1513
60 - 79% = 16209
80 - 99% = 7291
Index XQS_1000_3300_DOC_ID (0)
Root page: 75516, depth: 3, leaf buckets: 1704, nodes: 1530618
Average node length: 5.14, total dup: 1494588, max dup: 184
Average key length: 2.18, compression ratio: 4.12
Average prefix length: 8.84, average data length: 0.16
Clustering factor: 315308, ratio: 0.21
Fill distribution:
0 - 19% = 1
20 - 39% = 50
40 - 59% = 1064
60 - 79% = 492
80 - 99% = 97
Index XQS_1000_3300_RCV_ID (2)
Root page: 98912, depth: 3, leaf buckets: 2960, nodes: 1530618
Average node length: 6.29, total dup: 1241789, max dup: 14
Average key length: 3.34, compression ratio: 2.70
Average prefix length: 7.85, average data length: 1.15
Clustering factor: 233749, ratio: 0.15
Fill distribution:
0 - 19% = 40
20 - 39% = 1648
40 - 59% = 1019
60 - 79% = 211
80 - 99% = 42
Index XQS_1000_3300_SND_ID (1)
Root page: 65477, depth: 3, leaf buckets: 1901, nodes: 1530618
Average node length: 5.79, total dup: 1341861, max dup: 41
Average key length: 2.83, compression ratio: 3.18
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 342038, ratio: 0.22
Fill distribution:
0 - 19% = 5
20 - 39% = 42
40 - 59% = 1168
60 - 79% = 562
80 - 99% = 124
XQS_1200_2000 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 81.22, total records: 4071434
Average version length: 84.98, total versions: 125371, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.67
Pointer pages: 43, data page slots: 68688
Data pages: 68680, average fill: 74%
Primary pages: 68680, secondary pages: 0, swept pages: 33029
Empty pages: 13, full pages: 47128
Fill distribution:
0 - 19% = 79
20 - 39% = 1043
40 - 59% = 5867
60 - 79% = 39289
80 - 99% = 22402
Index XQS_1200_2000_DOC_ID (0)
Root page: 57323, depth: 3, leaf buckets: 4639, nodes: 4071434
Average node length: 5.04, total dup: 4047897, max dup: 562
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 1119346, ratio: 0.27
Fill distribution:
0 - 19% = 6
20 - 39% = 438
40 - 59% = 2901
60 - 79% = 1058
80 - 99% = 236
Index XQS_1200_2000_RCV_ID (2)
Root page: 78658, depth: 3, leaf buckets: 5782, nodes: 4071434
Average node length: 5.49, total dup: 3773981, max dup: 49
Average key length: 2.51, compression ratio: 3.59
Average prefix length: 8.56, average data length: 0.44
Clustering factor: 888907, ratio: 0.22
Fill distribution:
0 - 19% = 34
20 - 39% = 2129
40 - 59% = 2646
60 - 79% = 420
80 - 99% = 553
Index XQS_1200_2000_SND_ID (1)
Root page: 49624, depth: 3, leaf buckets: 5152, nodes: 4071434
Average node length: 5.62, total dup: 3692209, max dup: 106
Average key length: 2.64, compression ratio: 3.41
Average prefix length: 8.45, average data length: 0.55
Clustering factor: 1185205, ratio: 0.29
Fill distribution:
0 - 19% = 6
20 - 39% = 397
40 - 59% = 3348
60 - 79% = 1104
80 - 99% = 297
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: 81.50, total records: 2559182
Average version length: 84.00, total versions: 58060, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.67
Pointer pages: 26, data page slots: 42384
Data pages: 42384, average fill: 75%
Primary pages: 42384, secondary pages: 0, swept pages: 27832
Empty pages: 9, full pages: 29333
Fill distribution:
0 - 19% = 56
20 - 39% = 148
40 - 59% = 1968
60 - 79% = 27903
80 - 99% = 12309
Index XQS_2100_3300_DOC_ID (0)
Root page: 89519, depth: 3, leaf buckets: 2860, nodes: 2559182
Average node length: 5.02, total dup: 2546306, max dup: 1037
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 668886, ratio: 0.26
Fill distribution:
0 - 19% = 15
20 - 39% = 423
40 - 59% = 1424
60 - 79% = 727
80 - 99% = 271
Index XQS_2100_3300_RCV_ID (2)
Root page: 89860, depth: 3, leaf buckets: 5187, nodes: 2559182
Average node length: 6.32, total dup: 2070017, max dup: 14
Average key length: 3.35, compression ratio: 2.69
Average prefix length: 7.84, average data length: 1.16
Clustering factor: 540301, ratio: 0.21
Fill distribution:
0 - 19% = 148
20 - 39% = 3045
40 - 59% = 1691
60 - 79% = 238
80 - 99% = 65
Index XQS_2100_3300_SND_ID (1)
Root page: 78028, depth: 3, leaf buckets: 3078, nodes: 2559182
Average node length: 5.54, total dup: 2351855, max dup: 92
Average key length: 2.57, compression ratio: 3.50
Average prefix length: 8.51, average data length: 0.49
Clustering factor: 701746, ratio: 0.27
Fill distribution:
0 - 19% = 4
20 - 39% = 355
40 - 59% = 1530
60 - 79% = 900
80 - 99% = 289
XQS_3300_3400 (270)
Primary pointer page: 776, Index root page: 777
Total formats: 1, used formats: 1
Average record length: 67.65, total records: 475838
Average version length: 69.23, total versions: 10660, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.01
Pointer pages: 5, data page slots: 6704
Data pages: 6704, average fill: 75%
Primary pages: 6704, secondary pages: 0, swept pages: 4648
Empty pages: 4, full pages: 5790
Fill distribution:
0 - 19% = 19
20 - 39% = 50
40 - 59% = 165
60 - 79% = 6219
80 - 99% = 251
Index XQS_3300_3400_DOC_ID (0)
Root page: 602506, depth: 3, leaf buckets: 528, nodes: 475838
Average node length: 5.36, total dup: 443512, max dup: 141
Average key length: 2.52, compression ratio: 3.57
Average prefix length: 8.54, average data length: 0.46
Clustering factor: 44225, ratio: 0.09
Fill distribution:
0 - 19% = 3
20 - 39% = 42
40 - 59% = 242
60 - 79% = 169
80 - 99% = 72
Index XQS_3300_3400_SND_ID (1)
Root page: 298589, depth: 3, leaf buckets: 585, nodes: 475838
Average node length: 5.93, total dup: 404879, max dup: 27
Average key length: 3.09, compression ratio: 2.91
Average prefix length: 8.06, average data length: 0.94
Clustering factor: 49299, ratio: 0.10
Fill distribution:
0 - 19% = 1
20 - 39% = 59
40 - 59% = 257
60 - 79% = 182
80 - 99% = 86
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 78860 ms, from 8:17:14.50 to 8:18:33.36.
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
VERS_PERCENT |
AGENTS |
50 |
0 |
0.0000 |
BUSINESS_OPS |
19 |
0 |
0.0000 |
DOC_DATA |
1650877 |
6102 |
0.3696 |
DOC_LIST |
566609 |
1092 |
0.1927 |
DOC_STATES |
4 |
0 |
0.0000 |
FB_ERRORS |
758 |
0 |
0.0000 |
INVNT_SALDO |
400 |
0 |
0.0000 |
INVNT_TURNOVER_LOG |
35287 |
26015 |
73.7240 |
MONEY_SALDO |
49 |
0 |
0.0000 |
MONEY_TURNOVER_LOG |
311 |
80 |
25.7234 |
OPTYPES |
9 |
0 |
0.0000 |
PDISTR |
569405 |
5886 |
1.0337 |
PERF_ESTIMATED |
250990 |
0 |
0.0000 |
PERF_LOG |
9095407 |
0 |
0.0000 |
PSTORNED |
308295 |
3639 |
1.1803 |
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 |
2992 |
0 |
0.0000 |
WARES |
400 |
0 |
0.0000 |
WARE_GROUPS |
8 |
0 |
0.0000 |
XQD_1000_1200 |
5537 |
1755 |
31.6958 |
XQD_1000_3300 |
1336142 |
22044 |
1.6498 |
XQD_1200_2000 |
134114 |
28723 |
21.4168 |
XQD_2000_3300 |
2036767 |
87887 |
4.3150 |
XQD_2100_3300 |
3367238 |
1798 |
0.0533 |
XQD_3300_3400 |
2240839 |
51592 |
2.3023 |
XQS_1000_1200 |
3757972 |
20433 |
0.5437 |
XQS_1000_3300 |
1530618 |
38800 |
2.5349 |
XQS_1200_2000 |
4071434 |
125371 |
3.0792 |
XQS_2100_3300 |
2559182 |
58060 |
2.2686 |
XQS_3300_3400 |
475838 |
10660 |
2.2402 |
Z_USED_VIEWS |
29 |
0 |
0.0000 |
Done for 2280 ms, from 8:18:47.26 to 8:18:49.54.
08:18:49.63 Validation started
08:18:49.64 Relation 140 (DOC_LIST)
08:18:49.64 process pointer page 0 of 5
08:18:49.74 process pointer page 1 of 5
08:18:49.85 process pointer page 2 of 5
08:18:49.96 process pointer page 3 of 5
08:18:50.05 process pointer page 4 of 5
08:18:50.08 Index 1 (PK_DOC_LIST)
08:18:50.33 Index 2 (DOC_LIST_ID_DESC)
08:18:50.60 Index 3 (FK_DOC_LIST_AGENTS)
08:18:50.83 Relation 140 (DOC_LIST) is ok
08:18:50.83 Relation 141 (DOC_DATA)
08:18:50.83 process pointer page 0 of 12
08:18:50.92 process pointer page 1 of 12
08:18:51.02 process pointer page 2 of 12
08:18:51.10 process pointer page 3 of 12
08:18:51.19 process pointer page 4 of 12
08:18:51.28 process pointer page 5 of 12
08:18:51.38 process pointer page 6 of 12
08:18:51.47 process pointer page 7 of 12
08:18:51.55 process pointer page 8 of 12
08:18:51.64 process pointer page 9 of 12
08:18:51.72 process pointer page 10 of 12
08:18:51.81 process pointer page 11 of 12
08:18:51.83 Index 2 (DOC_DATA_DOC_WARE_UNQ)
08:18:52.75 Index 3 (DOC_DATA_ID_DESC)
08:18:53.51 Index 4 (FK_DOC_DATA_DOC_LIST)
08:18:54.17 Relation 141 (DOC_DATA) is ok
08:18:54.17 Relation 147 (INVNT_SALDO)
08:18:54.17 process pointer page 0 of 3
08:18:54.17 process pointer page 1 of 3
08:18:54.17 process pointer page 2 of 3
08:18:54.17 Index 1 (PK_INVNT_SALDO)
08:18:54.18 Relation 147 (INVNT_SALDO) is ok
08:18:54.18 Relation 150 (PDISTR)
08:18:54.18 process pointer page 0 of 3
08:18:54.26 process pointer page 1 of 3
08:18:54.36 process pointer page 2 of 3
08:18:54.42 Index 2 (PDISTR_SND_ID)
08:18:54.50 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
08:18:54.59 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
08:18:54.68 Index 5 (PDISTR_AGENT_ID)
08:18:54.78 Relation 150 (PDISTR) is ok
08:18:54.78 Relation 151 (PSTORNED)
08:18:54.78 process pointer page 0 of 3
08:18:54.87 process pointer page 1 of 3
08:18:54.95 process pointer page 2 of 3
08:18:54.98 Index 2 (PSTORNED_SND_ID)
08:18:55.07 Index 3 (PSTORNED_RCV_ID)
08:18:55.17 Relation 151 (PSTORNED) is ok
08:18:55.17 Relation 156 (SEMAPHORES)
08:18:55.17 process pointer page 0 of 1
08:18:55.17 Index 1 (PK_SEMAPHORES)
08:18:55.17 Index 2 (SEMAPHORES_TASK_UNQ)
08:18:55.17 Relation 156 (SEMAPHORES) is ok
08:18:55.17 Relation 157 (INVNT_TURNOVER_LOG)
08:18:55.17 process pointer page 0 of 4
08:18:55.17 process pointer page 1 of 4
08:18:55.17 process pointer page 2 of 4
08:18:55.26 process pointer page 3 of 4
08:18:55.28 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
08:18:55.29 Relation 157 (INVNT_TURNOVER_LOG) is ok
08:18:55.29 Relation 160 (PERF_ESTIMATED)
08:18:55.29 process pointer page 0 of 2
08:18:55.39 process pointer page 1 of 2
08:18:55.42 Index 1 (PERF_EST_MINUTE_SINCE_START)
08:18:55.49 Relation 160 (PERF_ESTIMATED) is ok
08:18:55.49 Relation 161 (PERF_ISQL_STAT)
08:18:55.49 process pointer page 0 of 1
08:18:55.49 Index 1 (PERF_ISQL_STAT_TRN)
08:18:55.49 Relation 161 (PERF_ISQL_STAT) is ok
08:18:55.49 Relation 162 (PERF_LOG)
08:18:55.49 process pointer page 0 of 130
08:18:55.57 process pointer page 1 of 130
08:18:55.65 process pointer page 2 of 130
08:18:55.73 process pointer page 3 of 130
08:18:55.81 process pointer page 4 of 130
08:18:55.88 process pointer page 5 of 130
08:18:55.96 process pointer page 6 of 130
08:18:56.04 process pointer page 7 of 130
08:18:56.10 process pointer page 8 of 130
08:18:56.18 process pointer page 9 of 130
08:18:56.26 process pointer page 10 of 130
08:18:56.34 process pointer page 11 of 130
08:18:56.41 process pointer page 12 of 130
08:18:56.49 process pointer page 13 of 130
08:18:56.57 process pointer page 14 of 130
08:18:56.65 process pointer page 15 of 130
08:18:56.71 process pointer page 16 of 130
08:18:56.79 process pointer page 17 of 130
08:18:56.87 process pointer page 18 of 130
08:18:56.95 process pointer page 19 of 130
08:18:57.02 process pointer page 20 of 130
08:18:57.09 process pointer page 21 of 130
08:18:57.16 process pointer page 22 of 130
08:18:57.24 process pointer page 23 of 130
08:18:57.32 process pointer page 24 of 130
08:18:57.38 process pointer page 25 of 130
08:18:57.46 process pointer page 26 of 130
08:18:57.54 process pointer page 27 of 130
08:18:57.62 process pointer page 28 of 130
08:18:57.69 process pointer page 29 of 130
08:18:57.76 process pointer page 30 of 130
08:18:57.83 process pointer page 31 of 130
08:18:57.91 process pointer page 32 of 130
08:18:57.99 process pointer page 33 of 130
08:18:58.07 process pointer page 34 of 130
08:18:58.13 process pointer page 35 of 130
08:18:58.21 process pointer page 36 of 130
08:18:58.29 process pointer page 37 of 130
08:18:58.36 process pointer page 38 of 130
08:18:58.44 process pointer page 39 of 130
08:18:58.51 process pointer page 40 of 130
08:18:58.58 process pointer page 41 of 130
08:18:58.66 process pointer page 42 of 130
08:18:58.74 process pointer page 43 of 130
08:18:58.82 process pointer page 44 of 130
08:18:58.88 process pointer page 45 of 130
08:18:58.96 process pointer page 46 of 130
08:18:59.04 process pointer page 47 of 130
08:18:59.11 process pointer page 48 of 130
08:18:59.19 process pointer page 49 of 130
08:18:59.25 process pointer page 50 of 130
08:18:59.33 process pointer page 51 of 130
08:18:59.41 process pointer page 52 of 130
08:18:59.49 process pointer page 53 of 130
08:18:59.57 process pointer page 54 of 130
08:18:59.63 process pointer page 55 of 130
08:18:59.71 process pointer page 56 of 130
08:18:59.78 process pointer page 57 of 130
08:18:59.86 process pointer page 58 of 130
08:18:59.92 process pointer page 59 of 130
08:19:00.00 process pointer page 60 of 130
08:19:00.08 process pointer page 61 of 130
08:19:00.16 process pointer page 62 of 130
08:19:00.24 process pointer page 63 of 130
08:19:00.30 process pointer page 64 of 130
08:19:00.38 process pointer page 65 of 130
08:19:00.46 process pointer page 66 of 130
08:19:00.53 process pointer page 67 of 130
08:19:00.61 process pointer page 68 of 130
08:19:00.67 process pointer page 69 of 130
08:19:00.75 process pointer page 70 of 130
08:19:00.83 process pointer page 71 of 130
08:19:00.91 process pointer page 72 of 130
08:19:00.99 process pointer page 73 of 130
08:19:01.06 process pointer page 74 of 130
08:19:01.13 process pointer page 75 of 130
08:19:01.20 process pointer page 76 of 130
08:19:01.28 process pointer page 77 of 130
08:19:01.36 process pointer page 78 of 130
08:19:01.44 process pointer page 79 of 130
08:19:01.50 process pointer page 80 of 130
08:19:01.58 process pointer page 81 of 130
08:19:01.66 process pointer page 82 of 130
08:19:01.73 process pointer page 83 of 130
08:19:01.80 process pointer page 84 of 130
08:19:01.87 process pointer page 85 of 130
08:19:01.95 process pointer page 86 of 130
08:19:02.03 process pointer page 87 of 130
08:19:02.11 process pointer page 88 of 130
08:19:02.17 process pointer page 89 of 130
08:19:02.25 process pointer page 90 of 130
08:19:02.33 process pointer page 91 of 130
08:19:02.41 process pointer page 92 of 130
08:19:02.48 process pointer page 93 of 130
08:19:02.55 process pointer page 94 of 130
08:19:02.62 process pointer page 95 of 130
08:19:02.70 process pointer page 96 of 130
08:19:02.78 process pointer page 97 of 130
08:19:02.86 process pointer page 98 of 130
08:19:02.92 process pointer page 99 of 130
08:19:03.00 process pointer page 100 of 130
08:19:03.08 process pointer page 101 of 130
08:19:03.15 process pointer page 102 of 130
08:19:03.23 process pointer page 103 of 130
08:19:03.29 process pointer page 104 of 130
08:19:03.37 process pointer page 105 of 130
08:19:03.45 process pointer page 106 of 130
08:19:03.53 process pointer page 107 of 130
08:19:03.61 process pointer page 108 of 130
08:19:03.67 process pointer page 109 of 130
08:19:03.75 process pointer page 110 of 130
08:19:03.82 process pointer page 111 of 130
08:19:03.90 process pointer page 112 of 130
08:19:03.98 process pointer page 113 of 130
08:19:04.04 process pointer page 114 of 130
08:19:04.12 process pointer page 115 of 130
08:19:04.20 process pointer page 116 of 130
08:19:04.28 process pointer page 117 of 130
08:19:04.34 process pointer page 118 of 130
08:19:04.42 process pointer page 119 of 130
08:19:04.50 process pointer page 120 of 130
08:19:04.57 process pointer page 121 of 130
08:19:04.65 process pointer page 122 of 130
08:19:04.73 process pointer page 123 of 130
08:19:04.79 process pointer page 124 of 130
08:19:04.87 process pointer page 125 of 130
08:19:04.95 process pointer page 126 of 130
08:19:05.03 process pointer page 127 of 130
08:19:05.10 process pointer page 128 of 130
08:19:05.17 process pointer page 129 of 130
08:19:05.21 Index 1 (PERF_LOG_DTS_BEG_DESC)
08:19:09.72 Index 2 (PERF_LOG_UNIT)
08:19:15.29 Index 3 (PERF_LOG_TRN_DESC)
08:19:19.25 Index 4 (PERF_LOG_GDSCODE)
08:19:21.42 Relation 162 (PERF_LOG) is ok
08:19:21.42 Relation 166 (V_STOPTEST)
08:19:21.42 Relation 166 (V_STOPTEST) is ok
08:19:21.42 Relation 183 (V_QDISTR_SOURCE)
08:19:21.42 Relation 183 (V_QDISTR_SOURCE) is ok
08:19:21.42 Relation 184 (V_QSTORNED_SOURCE)
08:19:21.42 Relation 184 (V_QSTORNED_SOURCE) is ok
08:19:21.42 Relation 259 (XQD_1000_1200)
08:19:21.42 process pointer page 0 of 6
08:19:21.42 process pointer page 1 of 6
08:19:21.43 process pointer page 2 of 6
08:19:21.43 process pointer page 3 of 6
08:19:21.43 process pointer page 4 of 6
08:19:21.43 process pointer page 5 of 6
08:19:21.43 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
08:19:21.45 Relation 259 (XQD_1000_1200) is ok
08:19:21.45 Relation 260 (XQD_1200_2000)
08:19:21.45 process pointer page 0 of 8
08:19:21.50 process pointer page 1 of 8
08:19:21.54 process pointer page 2 of 8
08:19:21.64 process pointer page 3 of 8
08:19:21.68 process pointer page 4 of 8
08:19:21.75 process pointer page 5 of 8
08:19:21.78 process pointer page 6 of 8
08:19:21.82 process pointer page 7 of 8
08:19:21.87 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
08:19:21.90 Relation 260 (XQD_1200_2000) is ok
08:19:21.90 Relation 261 (XQD_1000_3300)
08:19:21.90 process pointer page 0 of 14
08:19:21.98 process pointer page 1 of 14
08:19:22.07 process pointer page 2 of 14
08:19:22.15 process pointer page 3 of 14
08:19:22.25 process pointer page 4 of 14
08:19:22.34 process pointer page 5 of 14
08:19:22.42 process pointer page 6 of 14
08:19:22.49 process pointer page 7 of 14
08:19:22.59 process pointer page 8 of 14
08:19:22.68 process pointer page 9 of 14
08:19:22.76 process pointer page 10 of 14
08:19:22.85 process pointer page 11 of 14
08:19:22.93 process pointer page 12 of 14
08:19:23.03 process pointer page 13 of 14
08:19:23.07 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
08:19:23.65 Index 2 (XQD_1000_3300_DOC)
08:19:24.10 Relation 261 (XQD_1000_3300) is ok
08:19:24.10 Relation 262 (XQD_2000_3300)
08:19:24.10 process pointer page 0 of 22
08:19:24.21 process pointer page 1 of 22
08:19:24.29 process pointer page 2 of 22
08:19:24.37 process pointer page 3 of 22
08:19:24.46 process pointer page 4 of 22
08:19:24.55 process pointer page 5 of 22
08:19:24.63 process pointer page 6 of 22
08:19:24.73 process pointer page 7 of 22
08:19:24.80 process pointer page 8 of 22
08:19:24.90 process pointer page 9 of 22
08:19:24.98 process pointer page 10 of 22
08:19:25.05 process pointer page 11 of 22
08:19:25.13 process pointer page 12 of 22
08:19:25.21 process pointer page 13 of 22
08:19:25.29 process pointer page 14 of 22
08:19:25.38 process pointer page 15 of 22
08:19:25.46 process pointer page 16 of 22
08:19:25.54 process pointer page 17 of 22
08:19:25.63 process pointer page 18 of 22
08:19:25.72 process pointer page 19 of 22
08:19:25.80 process pointer page 20 of 22
08:19:25.88 process pointer page 21 of 22
08:19:25.94 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
08:19:26.64 Relation 262 (XQD_2000_3300) is ok
08:19:26.64 Relation 263 (XQD_2100_3300)
08:19:26.64 process pointer page 0 of 14
08:19:26.71 process pointer page 1 of 14
08:19:26.77 process pointer page 2 of 14
08:19:26.83 process pointer page 3 of 14
08:19:26.89 process pointer page 4 of 14
08:19:26.96 process pointer page 5 of 14
08:19:27.02 process pointer page 6 of 14
08:19:27.08 process pointer page 7 of 14
08:19:27.14 process pointer page 8 of 14
08:19:27.21 process pointer page 9 of 14
08:19:27.27 process pointer page 10 of 14
08:19:27.33 process pointer page 11 of 14
08:19:27.39 process pointer page 12 of 14
08:19:27.46 process pointer page 13 of 14
08:19:27.46 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
08:19:27.47 Relation 263 (XQD_2100_3300) is ok
08:19:27.47 Relation 264 (XQD_3300_3400)
08:19:27.47 process pointer page 0 of 21
08:19:27.56 process pointer page 1 of 21
08:19:27.66 process pointer page 2 of 21
08:19:27.74 process pointer page 3 of 21
08:19:27.83 process pointer page 4 of 21
08:19:27.92 process pointer page 5 of 21
08:19:28.02 process pointer page 6 of 21
08:19:28.10 process pointer page 7 of 21
08:19:28.19 process pointer page 8 of 21
08:19:28.28 process pointer page 9 of 21
08:19:28.38 process pointer page 10 of 21
08:19:28.45 process pointer page 11 of 21
08:19:28.55 process pointer page 12 of 21
08:19:28.63 process pointer page 13 of 21
08:19:28.72 process pointer page 14 of 21
08:19:28.81 process pointer page 15 of 21
08:19:28.91 process pointer page 16 of 21
08:19:28.98 process pointer page 17 of 21
08:19:29.08 process pointer page 18 of 21
08:19:29.17 process pointer page 19 of 21
08:19:29.25 process pointer page 20 of 21
08:19:29.25 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
08:19:30.25 Relation 264 (XQD_3300_3400) is ok
08:19:30.25 Relation 265 (XQS_1000_1200)
08:19:30.25 process pointer page 0 of 36
08:19:30.34 process pointer page 1 of 36
08:19:30.44 process pointer page 2 of 36
08:19:30.51 process pointer page 3 of 36
08:19:30.61 process pointer page 4 of 36
08:19:30.70 process pointer page 5 of 36
08:19:30.78 process pointer page 6 of 36
08:19:30.87 process pointer page 7 of 36
08:19:30.97 process pointer page 8 of 36
08:19:31.06 process pointer page 9 of 36
08:19:31.14 process pointer page 10 of 36
08:19:31.23 process pointer page 11 of 36
08:19:31.32 process pointer page 12 of 36
08:19:31.40 process pointer page 13 of 36
08:19:31.50 process pointer page 14 of 36
08:19:31.59 process pointer page 15 of 36
08:19:31.67 process pointer page 16 of 36
08:19:31.76 process pointer page 17 of 36
08:19:31.85 process pointer page 18 of 36
08:19:31.93 process pointer page 19 of 36
08:19:32.03 process pointer page 20 of 36
08:19:32.12 process pointer page 21 of 36
08:19:32.21 process pointer page 22 of 36
08:19:32.29 process pointer page 23 of 36
08:19:32.39 process pointer page 24 of 36
08:19:32.46 process pointer page 25 of 36
08:19:32.56 process pointer page 26 of 36
08:19:32.65 process pointer page 27 of 36
08:19:32.73 process pointer page 28 of 36
08:19:32.82 process pointer page 29 of 36
08:19:32.90 process pointer page 30 of 36
08:19:32.99 process pointer page 31 of 36
08:19:33.09 process pointer page 32 of 36
08:19:33.17 process pointer page 33 of 36
08:19:33.26 process pointer page 34 of 36
08:19:33.34 process pointer page 35 of 36
08:19:33.43 Index 1 (XQS_1000_1200_DOC_ID)
08:19:34.68 Index 2 (XQS_1000_1200_SND_ID)
08:19:35.94 Index 3 (XQS_1000_1200_RCV_ID)
08:19:37.08 Relation 265 (XQS_1000_1200) is ok
08:19:37.08 Relation 266 (XQS_1200_2000)
08:19:37.08 process pointer page 0 of 43
08:19:37.17 process pointer page 1 of 43
08:19:37.25 process pointer page 2 of 43
08:19:37.35 process pointer page 3 of 43
08:19:37.44 process pointer page 4 of 43
08:19:37.52 process pointer page 5 of 43
08:19:37.61 process pointer page 6 of 43
08:19:37.69 process pointer page 7 of 43
08:19:37.78 process pointer page 8 of 43
08:19:37.88 process pointer page 9 of 43
08:19:37.95 process pointer page 10 of 43
08:19:38.05 process pointer page 11 of 43
08:19:38.14 process pointer page 12 of 43
08:19:38.24 process pointer page 13 of 43
08:19:38.33 process pointer page 14 of 43
08:19:38.42 process pointer page 15 of 43
08:19:38.51 process pointer page 16 of 43
08:19:38.60 process pointer page 17 of 43
08:19:38.70 process pointer page 18 of 43
08:19:38.79 process pointer page 19 of 43
08:19:38.88 process pointer page 20 of 43
08:19:38.97 process pointer page 21 of 43
08:19:39.06 process pointer page 22 of 43
08:19:39.16 process pointer page 23 of 43
08:19:39.25 process pointer page 24 of 43
08:19:39.34 process pointer page 25 of 43
08:19:39.43 process pointer page 26 of 43
08:19:39.51 process pointer page 27 of 43
08:19:39.61 process pointer page 28 of 43
08:19:39.70 process pointer page 29 of 43
08:19:39.79 process pointer page 30 of 43
08:19:39.88 process pointer page 31 of 43
08:19:39.97 process pointer page 32 of 43
08:19:40.07 process pointer page 33 of 43
08:19:40.16 process pointer page 34 of 43
08:19:40.25 process pointer page 35 of 43
08:19:40.34 process pointer page 36 of 43
08:19:40.44 process pointer page 37 of 43
08:19:40.52 process pointer page 38 of 43
08:19:40.60 process pointer page 39 of 43
08:19:40.69 process pointer page 40 of 43
08:19:40.77 process pointer page 41 of 43
08:19:40.85 process pointer page 42 of 43
08:19:40.86 Index 1 (XQS_1200_2000_DOC_ID)
08:19:42.46 Index 2 (XQS_1200_2000_SND_ID)
08:19:44.12 Index 3 (XQS_1200_2000_RCV_ID)
08:19:45.52 Relation 266 (XQS_1200_2000) is ok
08:19:45.52 Relation 267 (XQS_1000_3300)
08:19:45.52 process pointer page 0 of 16
08:19:45.61 process pointer page 1 of 16
08:19:45.71 process pointer page 2 of 16
08:19:45.80 process pointer page 3 of 16
08:19:45.89 process pointer page 4 of 16
08:19:45.99 process pointer page 5 of 16
08:19:46.07 process pointer page 6 of 16
08:19:46.16 process pointer page 7 of 16
08:19:46.25 process pointer page 8 of 16
08:19:46.33 process pointer page 9 of 16
08:19:46.42 process pointer page 10 of 16
08:19:46.52 process pointer page 11 of 16
08:19:46.60 process pointer page 12 of 16
08:19:46.69 process pointer page 13 of 16
08:19:46.78 process pointer page 14 of 16
08:19:46.86 process pointer page 15 of 16
08:19:46.91 Index 1 (XQS_1000_3300_DOC_ID)
08:19:47.48 Index 2 (XQS_1000_3300_SND_ID)
08:19:48.08 Index 3 (XQS_1000_3300_RCV_ID)
08:19:48.59 Relation 267 (XQS_1000_3300) is ok
08:19:48.59 Relation 268 (XQS_2000_3300)
08:19:48.59 process pointer page 0 of 1
08:19:48.59 Index 1 (XQS_2000_3300_DOC_ID)
08:19:48.59 Index 2 (XQS_2000_3300_SND_ID)
08:19:48.59 Index 3 (XQS_2000_3300_RCV_ID)
08:19:48.59 Relation 268 (XQS_2000_3300) is ok
08:19:48.59 Relation 269 (XQS_2100_3300)
08:19:48.59 process pointer page 0 of 26
08:19:48.69 process pointer page 1 of 26
08:19:48.76 process pointer page 2 of 26
08:19:48.86 process pointer page 3 of 26
08:19:48.95 process pointer page 4 of 26
08:19:49.04 process pointer page 5 of 26
08:19:49.14 process pointer page 6 of 26
08:19:49.22 process pointer page 7 of 26
08:19:49.31 process pointer page 8 of 26
08:19:49.40 process pointer page 9 of 26
08:19:49.50 process pointer page 10 of 26
08:19:49.58 process pointer page 11 of 26
08:19:49.67 process pointer page 12 of 26
08:19:49.76 process pointer page 13 of 26
08:19:49.86 process pointer page 14 of 26
08:19:49.95 process pointer page 15 of 26
08:19:50.03 process pointer page 16 of 26
08:19:50.12 process pointer page 17 of 26
08:19:50.21 process pointer page 18 of 26
08:19:50.29 process pointer page 19 of 26
08:19:50.39 process pointer page 20 of 26
08:19:50.48 process pointer page 21 of 26
08:19:50.56 process pointer page 22 of 26
08:19:50.65 process pointer page 23 of 26
08:19:50.75 process pointer page 24 of 26
08:19:50.82 process pointer page 25 of 26
08:19:50.92 Index 1 (XQS_2100_3300_DOC_ID)
08:19:51.88 Index 2 (XQS_2100_3300_SND_ID)
08:19:52.88 Index 3 (XQS_2100_3300_RCV_ID)
08:19:53.79 Relation 269 (XQS_2100_3300) is ok
08:19:53.79 Relation 270 (XQS_3300_3400)
08:19:53.79 process pointer page 0 of 5
08:19:53.88 process pointer page 1 of 5
08:19:53.97 process pointer page 2 of 5
08:19:54.05 process pointer page 3 of 5
08:19:54.15 process pointer page 4 of 5
08:19:54.16 Index 1 (XQS_3300_3400_DOC_ID)
08:19:54.29 Index 2 (XQS_3300_3400_SND_ID)
08:19:54.44 Relation 270 (XQS_3300_3400) is ok
08:19:54.44 Relation 276 (TRACE_STAT)
08:19:54.44 process pointer page 0 of 1
08:19:54.44 Relation 276 (TRACE_STAT) is ok
08:19:54.44 Validation finished
Done for 64910 ms, from 8:18:49.55 to 8:19:54.46.
Differences between old and current firebird.log
8:19:55.64. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2016-03-18 08:19 513 oltp40_fb_log_when_test_finished.log
End of gathering firebird.log AFTER test finish.
+++ Start of comparison +++
***** E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Fri Mar 18 08:18:49 2016
7: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Fri Mar 18 08:19:54 2016
12: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++
Remove 302 logs of every ISQL session if there were no serious errors.
Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp40\oltp40_*.*:
ERRORS_CHECKING_RESULT |
NO_SEVERE_ERRORS_FOUND |
ISQL logs are removed because no severe errors occured during test.
2016-03-18 8:20:06.36 - end of report, text file: e:\temp\logs.oltp40\oltp40.report.txt, html: e:\temp\logs.oltp40\oltp40.report.html