Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2017-11-04 11:20:00.18.
Server version: WI-T4.0.0.783 Firebird 4.0 Alpha 1
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 |
0 |
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 |
100000 |
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 |
cpu_8x3Ghz_ram_16gb |
upload_report |
1 |
max_snapshots_to_store |
720 |
replace_instance |
1 |
etalon_dbnm |
E:\OLTP-EMUL\oltp40-docs_100000-fw__ON.fdb |
used_in_replication |
0 |
FINISH_STATE |
DTS_END |
FB_GDSCODE |
FB_MNEMONA |
STACK |
IP |
TRN_ID |
ATT_ID |
EXC_UNIT |
NORMAL: TEST_TIME EXPIRED. |
2017-11-04 11:16:47.1800 |
-1 |
<null> |
|
::1/56032 |
439609 |
9159 |
2 |
CATEGORY |
SETTING |
VAL |
COMMON |
TRACED_UNITS |
,, |
COMMON |
ENABLE_MON_QUERY |
0 |
COMMON |
HALT_TEST_ON_ERRORS |
,CK, |
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 |
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: |
7081.42 |
1001 |
1274655 |
2017-11-04 08:16 |
2017-11-04 11:16 |
customer order: creation |
451.31 |
112 |
81236 |
2017-11-04 08:16 |
2017-11-04 11:16 |
customer order: refuse |
36.66 |
57 |
6599 |
2017-11-04 08:16 |
2017-11-04 11:16 |
order to supplier: creation |
114.04 |
452 |
20528 |
2017-11-04 08:16 |
2017-11-04 11:16 |
order to supplier: removal |
3.28 |
6696 |
588 |
2017-11-04 08:16 |
2017-11-04 11:16 |
invoice (draft): creation |
115.67 |
693 |
20820 |
2017-11-04 08:16 |
2017-11-04 11:16 |
invoice (draft): removal |
49.83 |
114 |
8969 |
2017-11-04 08:16 |
2017-11-04 11:16 |
invoice accept: apply |
67.65 |
2579 |
12177 |
2017-11-04 08:16 |
2017-11-04 11:16 |
invoice accept: cancel |
23.83 |
561 |
4266 |
2017-11-04 08:16 |
2017-11-04 11:16 |
customer reserve: creation |
4027.36 |
35 |
724924 |
2017-11-04 08:16 |
2017-11-04 11:16 |
customer reserve: removal |
1562.27 |
14 |
281209 |
2017-11-04 08:16 |
2017-11-04 11:16 |
realization accept: apply |
211.88 |
125 |
38139 |
2017-11-04 08:16 |
2017-11-04 11:16 |
realization accept: cancel |
98.00 |
36 |
17542 |
2017-11-04 08:16 |
2017-11-04 11:16 |
payment from customer: creation |
148.88 |
197 |
26799 |
2017-11-04 08:16 |
2017-11-04 11:16 |
payment from customer: removal |
14.89 |
33 |
2680 |
2017-11-04 08:16 |
2017-11-04 11:16 |
payment to supplier: creation |
123.51 |
101 |
22232 |
2017-11-04 08:16 |
2017-11-04 11:16 |
payment to supplier: removal |
8.88 |
35 |
1598 |
2017-11-04 08:16 |
2017-11-04 11:16 |
service: total inventory turnovers |
11.76 |
634 |
2116 |
2017-11-04 08:16 |
2017-11-04 11:16 |
service: total monetary turnovers |
12.34 |
21 |
2221 |
2017-11-04 08:16 |
2017-11-04 11:16 |
service: refresh index statistics |
0.07 |
6523 |
12 |
2017-11-04 08:16 |
2017-11-04 11:16 |
Done for 78180 ms, from 11:22:33.53 to 11:23:51.71.
ACTION |
ITRV_NO |
CNT_OK_PER_MINUTE |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
ITRV_BEG |
ITRV_END |
interval # 1, overall |
1 |
5212 |
109536 |
93817 |
15719 |
14.35 |
08:16:48 |
08:34:48 |
interval # 2, overall |
2 |
6918 |
139985 |
124520 |
15465 |
11.05 |
08:34:49 |
08:52:49 |
interval # 3, overall |
3 |
7314 |
150896 |
131651 |
19245 |
12.75 |
08:52:50 |
09:10:50 |
interval # 4, overall |
4 |
7079 |
149062 |
127419 |
21643 |
14.52 |
09:10:51 |
09:28:51 |
interval # 5, overall |
5 |
6992 |
148848 |
125852 |
22996 |
15.45 |
09:28:52 |
09:46:52 |
interval # 6, overall |
6 |
7461 |
168246 |
134293 |
33953 |
20.18 |
09:46:53 |
10:04:53 |
interval # 7, overall |
7 |
7132 |
154487 |
128382 |
26105 |
16.90 |
10:04:54 |
10:22:54 |
interval # 8, overall |
8 |
7628 |
160300 |
137306 |
22994 |
14.34 |
10:22:55 |
10:40:55 |
interval # 9, overall |
9 |
7629 |
158119 |
137327 |
20792 |
13.15 |
10:40:56 |
10:58:56 |
interval # 10, overall |
10 |
7449 |
162432 |
134088 |
28344 |
17.45 |
10:58:57 |
11:16:57 |
Done for 199580 ms, from 11:27:07.64 to 11:30:27.22.
TEST_PHASE |
MINUTE_SINCE_TEST_START |
AVG_ESTIMATED |
MIN_TO_AVG_RATIO |
MAX_TO_AVG_RATIO |
ROWS_AGGREGATED |
DISTINCT_ATTACHMENTS |
TEST_TIME |
1 |
2429.08 |
0.0790 |
1.9962 |
2226 |
100 |
TEST_TIME |
2 |
3271.44 |
0.7411 |
1.3487 |
1879 |
100 |
TEST_TIME |
3 |
3815.11 |
0.7714 |
1.1836 |
1533 |
100 |
TEST_TIME |
4 |
3791.81 |
0.8936 |
1.1143 |
1718 |
100 |
TEST_TIME |
5 |
3779.67 |
0.8946 |
1.1115 |
1587 |
100 |
TEST_TIME |
6 |
3863.22 |
0.9063 |
1.0697 |
1536 |
100 |
TEST_TIME |
7 |
3872.61 |
0.9157 |
1.0845 |
2039 |
100 |
TEST_TIME |
8 |
3995.79 |
0.9197 |
1.1035 |
1808 |
100 |
TEST_TIME |
9 |
4153.24 |
0.9437 |
1.0593 |
1957 |
100 |
TEST_TIME |
10 |
4244.96 |
0.9328 |
1.0703 |
1784 |
100 |
TEST_TIME |
11 |
4344.25 |
0.9508 |
1.0627 |
1811 |
100 |
TEST_TIME |
12 |
4477.50 |
0.9452 |
1.0605 |
1727 |
100 |
TEST_TIME |
13 |
4595.62 |
0.9538 |
1.0462 |
1520 |
100 |
TEST_TIME |
14 |
4652.48 |
0.9596 |
1.0452 |
1302 |
100 |
TEST_TIME |
15 |
4707.05 |
0.9642 |
1.0305 |
1324 |
100 |
TEST_TIME |
16 |
4770.58 |
0.9535 |
1.0465 |
1765 |
100 |
TEST_TIME |
17 |
4927.70 |
0.9536 |
1.0443 |
1863 |
100 |
TEST_TIME |
18 |
5051.89 |
0.9646 |
1.0408 |
1827 |
100 |
TEST_TIME |
19 |
5146.70 |
0.9726 |
1.0217 |
1753 |
100 |
TEST_TIME |
20 |
5161.39 |
0.9678 |
1.0397 |
1562 |
100 |
TEST_TIME |
21 |
5283.01 |
0.9674 |
1.0271 |
2023 |
100 |
TEST_TIME |
22 |
5337.38 |
0.9704 |
1.0337 |
1554 |
100 |
TEST_TIME |
23 |
5393.47 |
0.9785 |
1.0270 |
1598 |
100 |
TEST_TIME |
24 |
5439.89 |
0.9763 |
1.0224 |
1615 |
100 |
TEST_TIME |
25 |
5481.76 |
0.9746 |
1.0197 |
1268 |
100 |
TEST_TIME |
26 |
5503.39 |
0.9767 |
1.0227 |
1601 |
100 |
TEST_TIME |
27 |
5533.44 |
0.9802 |
1.0194 |
1428 |
100 |
TEST_TIME |
28 |
5539.29 |
0.9820 |
1.0188 |
1305 |
100 |
TEST_TIME |
29 |
5528.53 |
0.9856 |
1.0156 |
1384 |
100 |
TEST_TIME |
30 |
5540.74 |
0.9796 |
1.0172 |
1355 |
100 |
TEST_TIME |
31 |
5625.22 |
0.9696 |
1.0264 |
2224 |
100 |
TEST_TIME |
32 |
5755.46 |
0.9723 |
1.0260 |
2061 |
100 |
TEST_TIME |
33 |
5848.87 |
0.9790 |
1.0187 |
2155 |
100 |
TEST_TIME |
34 |
5903.38 |
0.9796 |
1.0233 |
1924 |
100 |
TEST_TIME |
35 |
5972.40 |
0.9826 |
1.0161 |
1608 |
100 |
TEST_TIME |
36 |
6000.97 |
0.9835 |
1.0156 |
1702 |
100 |
TEST_TIME |
37 |
6050.18 |
0.9801 |
1.0175 |
1767 |
100 |
TEST_TIME |
38 |
6087.16 |
0.9847 |
1.0130 |
1340 |
100 |
TEST_TIME |
39 |
6089.40 |
0.9866 |
1.0147 |
1356 |
100 |
TEST_TIME |
40 |
6100.95 |
0.9875 |
1.0154 |
1322 |
100 |
TEST_TIME |
41 |
6100.46 |
0.9908 |
1.0111 |
1402 |
100 |
TEST_TIME |
42 |
6084.47 |
0.9902 |
1.0093 |
1414 |
100 |
TEST_TIME |
43 |
6062.13 |
0.9903 |
1.0105 |
1321 |
100 |
TEST_TIME |
44 |
6067.01 |
0.9867 |
1.0110 |
1308 |
100 |
TEST_TIME |
45 |
6052.57 |
0.9909 |
1.0123 |
1273 |
100 |
TEST_TIME |
46 |
6100.19 |
0.9826 |
1.0174 |
1982 |
100 |
TEST_TIME |
47 |
6164.76 |
0.9853 |
1.0192 |
1998 |
100 |
TEST_TIME |
48 |
6250.59 |
0.9846 |
1.0147 |
1868 |
100 |
TEST_TIME |
49 |
6316.36 |
0.9836 |
1.0156 |
1687 |
100 |
TEST_TIME |
50 |
6382.27 |
0.9851 |
1.0136 |
1647 |
100 |
TEST_TIME |
51 |
6400.15 |
0.9909 |
1.0129 |
1717 |
100 |
TEST_TIME |
52 |
6432.54 |
0.9885 |
1.0103 |
1695 |
100 |
TEST_TIME |
53 |
6446.96 |
0.9890 |
1.0103 |
1347 |
100 |
TEST_TIME |
54 |
6450.76 |
0.9911 |
1.0046 |
1706 |
100 |
TEST_TIME |
55 |
6434.35 |
0.9889 |
1.0117 |
1249 |
100 |
TEST_TIME |
56 |
6450.82 |
0.9911 |
1.0075 |
1302 |
100 |
TEST_TIME |
57 |
6434.13 |
0.9924 |
1.0104 |
1399 |
100 |
TEST_TIME |
58 |
6440.05 |
0.9921 |
1.0075 |
1215 |
100 |
TEST_TIME |
59 |
6422.98 |
0.9930 |
1.0095 |
1294 |
100 |
TEST_TIME |
60 |
6421.70 |
0.9929 |
1.0085 |
1099 |
100 |
TEST_TIME |
61 |
6430.05 |
0.9916 |
1.0119 |
1881 |
100 |
TEST_TIME |
62 |
6484.08 |
0.9880 |
1.0117 |
2083 |
100 |
TEST_TIME |
63 |
6523.98 |
0.9895 |
1.0092 |
1978 |
100 |
TEST_TIME |
64 |
6544.20 |
0.9904 |
1.0100 |
1870 |
100 |
TEST_TIME |
65 |
6563.33 |
0.9915 |
1.0083 |
1784 |
100 |
TEST_TIME |
66 |
6570.01 |
0.9921 |
1.0067 |
1662 |
100 |
TEST_TIME |
67 |
6569.60 |
0.9919 |
1.0079 |
1710 |
100 |
TEST_TIME |
68 |
6584.86 |
0.9907 |
1.0099 |
1399 |
100 |
TEST_TIME |
69 |
6604.33 |
0.9924 |
1.0071 |
1623 |
100 |
TEST_TIME |
70 |
6601.47 |
0.9931 |
1.0063 |
1447 |
100 |
TEST_TIME |
71 |
6608.81 |
0.9910 |
1.0069 |
1377 |
100 |
TEST_TIME |
72 |
6604.64 |
0.9936 |
1.0064 |
1378 |
100 |
TEST_TIME |
73 |
6595.13 |
0.9940 |
1.0052 |
1356 |
100 |
TEST_TIME |
74 |
6565.57 |
0.9961 |
1.0067 |
1326 |
100 |
TEST_TIME |
75 |
6555.10 |
0.9949 |
1.0061 |
1306 |
100 |
TEST_TIME |
76 |
6564.35 |
0.9914 |
1.0075 |
1876 |
100 |
TEST_TIME |
77 |
6574.44 |
0.9929 |
1.0083 |
1912 |
100 |
TEST_TIME |
78 |
6610.49 |
0.9900 |
1.0092 |
1711 |
100 |
TEST_TIME |
79 |
6637.56 |
0.9925 |
1.0068 |
1664 |
100 |
TEST_TIME |
80 |
6653.29 |
0.9919 |
1.0088 |
1724 |
100 |
TEST_TIME |
81 |
6690.35 |
0.9909 |
1.0074 |
1618 |
100 |
TEST_TIME |
82 |
6707.65 |
0.9925 |
1.0072 |
1573 |
100 |
TEST_TIME |
83 |
6715.90 |
0.9938 |
1.0092 |
1492 |
100 |
TEST_TIME |
84 |
6735.40 |
0.9943 |
1.0051 |
1487 |
100 |
TEST_TIME |
85 |
6727.29 |
0.9945 |
1.0059 |
1487 |
100 |
TEST_TIME |
86 |
6717.33 |
0.9957 |
1.0046 |
1513 |
100 |
TEST_TIME |
87 |
6709.56 |
0.9942 |
1.0051 |
1383 |
100 |
TEST_TIME |
88 |
6703.53 |
0.9946 |
1.0039 |
1243 |
100 |
TEST_TIME |
89 |
6687.33 |
0.9952 |
1.0049 |
1377 |
100 |
TEST_TIME |
90 |
6678.40 |
0.9951 |
1.0044 |
1229 |
100 |
TEST_TIME |
91 |
6676.21 |
0.9937 |
1.0062 |
1914 |
100 |
TEST_TIME |
92 |
6708.14 |
0.9905 |
1.0089 |
1761 |
100 |
TEST_TIME |
93 |
6734.53 |
0.9942 |
1.0059 |
1685 |
100 |
TEST_TIME |
94 |
6752.05 |
0.9926 |
1.0052 |
1370 |
100 |
TEST_TIME |
95 |
6766.64 |
0.9928 |
1.0064 |
1443 |
100 |
TEST_TIME |
96 |
6766.41 |
0.9959 |
1.0044 |
1621 |
100 |
TEST_TIME |
97 |
6778.85 |
0.9922 |
1.0044 |
1344 |
100 |
TEST_TIME |
98 |
6766.82 |
0.9959 |
1.0038 |
1167 |
100 |
TEST_TIME |
99 |
6776.35 |
0.9922 |
1.0045 |
1248 |
100 |
TEST_TIME |
100 |
6775.36 |
0.9946 |
1.0036 |
1330 |
100 |
TEST_TIME |
101 |
6758.70 |
0.9961 |
1.0052 |
1362 |
100 |
TEST_TIME |
102 |
6766.88 |
0.9942 |
1.0064 |
1323 |
100 |
TEST_TIME |
103 |
6765.72 |
0.9968 |
1.0031 |
1325 |
100 |
TEST_TIME |
104 |
6742.12 |
0.9969 |
1.0026 |
1309 |
100 |
TEST_TIME |
105 |
6729.47 |
0.9950 |
1.0042 |
1163 |
100 |
TEST_TIME |
106 |
6736.26 |
0.9938 |
1.0057 |
1890 |
100 |
TEST_TIME |
107 |
6770.50 |
0.9912 |
1.0067 |
1792 |
100 |
TEST_TIME |
108 |
6798.47 |
0.9934 |
1.0056 |
1500 |
100 |
TEST_TIME |
109 |
6816.90 |
0.9937 |
1.0073 |
1564 |
100 |
TEST_TIME |
110 |
6841.05 |
0.9947 |
1.0048 |
1612 |
100 |
TEST_TIME |
111 |
6843.10 |
0.9955 |
1.0046 |
1516 |
100 |
TEST_TIME |
112 |
6846.40 |
0.9951 |
1.0053 |
1291 |
100 |
TEST_TIME |
113 |
6849.00 |
0.9963 |
1.0038 |
1173 |
100 |
TEST_TIME |
114 |
6840.16 |
0.9963 |
1.0054 |
1270 |
100 |
TEST_TIME |
115 |
6849.65 |
0.9953 |
1.0054 |
1159 |
100 |
TEST_TIME |
116 |
6855.76 |
0.9959 |
1.0053 |
1110 |
100 |
TEST_TIME |
117 |
6866.16 |
0.9952 |
1.0042 |
1218 |
100 |
TEST_TIME |
118 |
6859.94 |
0.9966 |
1.0033 |
1279 |
100 |
TEST_TIME |
119 |
6853.54 |
0.9958 |
1.0058 |
1019 |
100 |
TEST_TIME |
120 |
6843.01 |
0.9990 |
1.0011 |
1143 |
93 |
TEST_TIME |
121 |
6814.57 |
0.9970 |
1.0017 |
870 |
88 |
TEST_TIME |
122 |
6788.74 |
0.9972 |
1.0034 |
1762 |
92 |
TEST_TIME |
123 |
6797.10 |
0.9940 |
1.0066 |
1725 |
99 |
TEST_TIME |
124 |
6822.62 |
0.9947 |
1.0044 |
1679 |
100 |
TEST_TIME |
125 |
6831.69 |
0.9951 |
1.0057 |
1623 |
100 |
TEST_TIME |
126 |
6847.79 |
0.9954 |
1.0044 |
1652 |
100 |
TEST_TIME |
127 |
6853.33 |
0.9957 |
1.0044 |
1640 |
100 |
TEST_TIME |
128 |
6858.86 |
0.9957 |
1.0046 |
1551 |
100 |
TEST_TIME |
129 |
6871.71 |
0.9950 |
1.0040 |
1443 |
100 |
TEST_TIME |
130 |
6879.05 |
0.9952 |
1.0053 |
1209 |
100 |
TEST_TIME |
131 |
6896.41 |
0.9952 |
1.0035 |
1350 |
100 |
TEST_TIME |
132 |
6893.04 |
0.9963 |
1.0032 |
1254 |
100 |
TEST_TIME |
133 |
6890.91 |
0.9960 |
1.0031 |
1214 |
100 |
TEST_TIME |
134 |
6886.18 |
0.9965 |
1.0030 |
1127 |
100 |
TEST_TIME |
135 |
6873.05 |
0.9975 |
1.0032 |
1088 |
100 |
TEST_TIME |
136 |
6872.83 |
0.9958 |
1.0016 |
1892 |
100 |
TEST_TIME |
137 |
6857.54 |
0.9965 |
1.0044 |
1840 |
91 |
TEST_TIME |
138 |
6868.30 |
0.9956 |
1.0057 |
1695 |
85 |
TEST_TIME |
139 |
6895.19 |
0.9946 |
1.0042 |
1377 |
100 |
TEST_TIME |
140 |
6912.09 |
0.9946 |
1.0053 |
1455 |
100 |
TEST_TIME |
141 |
6936.87 |
0.9946 |
1.0036 |
1471 |
100 |
TEST_TIME |
142 |
6942.10 |
0.9958 |
1.0031 |
1650 |
100 |
TEST_TIME |
143 |
6938.12 |
0.9967 |
1.0042 |
1597 |
100 |
TEST_TIME |
144 |
6942.11 |
0.9966 |
1.0038 |
1379 |
100 |
TEST_TIME |
145 |
6949.81 |
0.9961 |
1.0040 |
1361 |
100 |
TEST_TIME |
146 |
6966.59 |
0.9948 |
1.0043 |
1253 |
100 |
TEST_TIME |
147 |
6972.20 |
0.9966 |
1.0021 |
1243 |
100 |
TEST_TIME |
148 |
6971.78 |
0.9954 |
1.0039 |
1136 |
100 |
TEST_TIME |
149 |
6969.84 |
0.9974 |
1.0032 |
1183 |
99 |
TEST_TIME |
150 |
6963.30 |
0.9977 |
1.0035 |
1066 |
100 |
TEST_TIME |
151 |
6969.23 |
0.9961 |
1.0037 |
1747 |
100 |
TEST_TIME |
152 |
6981.38 |
0.9954 |
1.0048 |
1698 |
100 |
TEST_TIME |
153 |
7006.72 |
0.9946 |
1.0042 |
1609 |
100 |
TEST_TIME |
154 |
7022.83 |
0.9954 |
1.0044 |
1421 |
100 |
TEST_TIME |
155 |
7033.80 |
0.9964 |
1.0032 |
1402 |
100 |
TEST_TIME |
156 |
7033.96 |
0.9968 |
1.0030 |
1651 |
100 |
TEST_TIME |
157 |
7037.35 |
0.9961 |
1.0031 |
1461 |
100 |
TEST_TIME |
158 |
7033.77 |
0.9973 |
1.0030 |
1297 |
100 |
TEST_TIME |
159 |
7043.04 |
0.9955 |
1.0033 |
1098 |
100 |
TEST_TIME |
160 |
7033.91 |
0.9983 |
1.0026 |
1260 |
100 |
TEST_TIME |
161 |
7023.82 |
0.9979 |
1.0031 |
1167 |
79 |
TEST_TIME |
162 |
7014.12 |
0.9982 |
1.0018 |
1059 |
87 |
TEST_TIME |
163 |
7016.54 |
0.9953 |
1.0026 |
1023 |
100 |
TEST_TIME |
164 |
7012.38 |
0.9973 |
1.0026 |
1050 |
100 |
TEST_TIME |
165 |
7010.23 |
0.9968 |
1.0026 |
1072 |
100 |
TEST_TIME |
166 |
7018.32 |
0.9954 |
1.0033 |
1527 |
100 |
TEST_TIME |
167 |
7039.04 |
0.9944 |
1.0048 |
1614 |
100 |
TEST_TIME |
168 |
7050.86 |
0.9972 |
1.0029 |
1623 |
100 |
TEST_TIME |
169 |
7059.62 |
0.9958 |
1.0039 |
1660 |
100 |
TEST_TIME |
170 |
7071.52 |
0.9963 |
1.0044 |
1566 |
100 |
TEST_TIME |
171 |
7087.43 |
0.9963 |
1.0047 |
1375 |
100 |
TEST_TIME |
172 |
7097.45 |
0.9975 |
1.0032 |
1334 |
100 |
TEST_TIME |
173 |
7104.84 |
0.9963 |
1.0028 |
1352 |
100 |
TEST_TIME |
174 |
7100.83 |
0.9976 |
1.0028 |
1369 |
100 |
TEST_TIME |
175 |
7097.25 |
0.9975 |
1.0024 |
1201 |
100 |
TEST_TIME |
176 |
7092.81 |
0.9974 |
1.0029 |
1191 |
100 |
TEST_TIME |
177 |
7089.76 |
0.9977 |
1.0030 |
1174 |
100 |
TEST_TIME |
178 |
7084.88 |
0.9981 |
1.0027 |
1287 |
100 |
TEST_TIME |
179 |
7081.35 |
0.9976 |
1.0024 |
1117 |
100 |
TEST_TIME |
180 |
7070.28 |
0.9984 |
1.0015 |
903 |
100 |
Done for 9300 ms, from 11:30:28.56 to 11:30:37.86.
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 |
76824 |
113612 |
64918 |
83307 |
70534 |
27828 |
88544 |
93543 |
114255 |
94563 |
86265 |
60487 |
114615 |
130190 |
158746 |
<null> |
319106 |
600100 |
<null> |
08:16:48 |
08:34:48 |
fetches per second |
2 |
60809 |
106354 |
54757 |
110817 |
68779 |
198377 |
85235 |
86385 |
57373 |
24211 |
70227 |
35145 |
81382 |
62741 |
111895 |
96748 |
335561 |
458583 |
<null> |
08:34:49 |
08:52:49 |
fetches per second |
3 |
72195 |
106443 |
64009 |
<null> |
65620 |
51210 |
77952 |
<null> |
70358 |
55664 |
70687 |
76395 |
107260 |
99625 |
124229 |
75309 |
188000 |
573800 |
<null> |
08:52:50 |
09:10:50 |
fetches per second |
4 |
63347 |
98724 |
50153 |
<null> |
60093 |
<null> |
76186 |
88511 |
30891 |
29325 |
64753 |
24865 |
80752 |
90773 |
86476 |
53717 |
176324 |
<null> |
<null> |
09:10:51 |
09:28:51 |
fetches per second |
5 |
63258 |
168367 |
68342 |
<null> |
61091 |
92000 |
95077 |
87696 |
126431 |
63005 |
94069 |
43725 |
106713 |
50832 |
102103 |
119083 |
276877 |
31444 |
<null> |
09:28:52 |
09:46:52 |
fetches per second |
6 |
64092 |
120043 |
68733 |
93007 |
54609 |
36952 |
103903 |
<null> |
74812 |
137502 |
111065 |
83039 |
98747 |
125317 |
84068 |
<null> |
<null> |
379087 |
<null> |
09:46:53 |
10:04:53 |
fetches per second |
7 |
47457 |
126294 |
41583 |
<null> |
48206 |
98787 |
68673 |
96157 |
22860 |
29388 |
68012 |
2995 |
81611 |
98387 |
95658 |
177314 |
<null> |
306570 |
<null> |
10:04:54 |
10:22:54 |
fetches per second |
8 |
58844 |
74981 |
44029 |
<null> |
51579 |
<null> |
98125 |
91248 |
34879 |
57540 |
54063 |
106000 |
76195 |
48259 |
61459 |
72057 |
133781 |
<null> |
<null> |
10:22:55 |
10:40:55 |
fetches per second |
9 |
58573 |
76798 |
54048 |
<null> |
52377 |
21648 |
88858 |
8958 |
118263 |
69250 |
74584 |
33409 |
77013 |
49117 |
81071 |
37833 |
194653 |
20292 |
<null> |
10:40:56 |
10:58:56 |
fetches per second |
10 |
68647 |
87919 |
60810 |
<null> |
68172 |
<null> |
95080 |
51711 |
52975 |
104839 |
85477 |
2814 |
112611 |
76212 |
84126 |
45445 |
96653 |
<null> |
<null> |
10:58:57 |
11:16:57 |
marks per second |
1 |
17188 |
15672 |
14327 |
17358 |
15307 |
5425 |
12909 |
18468 |
14687 |
19048 |
17108 |
10166 |
10322 |
26239 |
7782 |
<null> |
17910 |
27100 |
<null> |
08:16:48 |
08:34:48 |
marks per second |
2 |
13571 |
14742 |
12104 |
22347 |
15820 |
51622 |
12708 |
14764 |
10682 |
4809 |
11893 |
6221 |
7945 |
9771 |
11128 |
17541 |
30436 |
41833 |
<null> |
08:34:49 |
08:52:49 |
marks per second |
3 |
15687 |
14042 |
14328 |
<null> |
15161 |
12305 |
11602 |
<null> |
10005 |
11881 |
11832 |
12145 |
9775 |
16750 |
12339 |
11861 |
36569 |
61500 |
<null> |
08:52:50 |
09:10:50 |
marks per second |
4 |
13584 |
13290 |
10474 |
<null> |
13776 |
<null> |
10917 |
16986 |
4782 |
5674 |
11358 |
4148 |
6689 |
15549 |
15231 |
8273 |
32367 |
<null> |
<null> |
09:10:51 |
09:28:51 |
marks per second |
5 |
13705 |
21725 |
15663 |
<null> |
13812 |
13181 |
12285 |
14838 |
18814 |
10757 |
14578 |
7156 |
7268 |
9986 |
19005 |
22055 |
21302 |
3185 |
<null> |
09:28:52 |
09:46:52 |
marks per second |
6 |
13942 |
14407 |
14947 |
16847 |
11478 |
8170 |
14550 |
<null> |
10402 |
27343 |
13203 |
11842 |
6670 |
22202 |
16413 |
<null> |
<null> |
22500 |
<null> |
09:46:53 |
10:04:53 |
marks per second |
7 |
9815 |
15732 |
9127 |
<null> |
10793 |
26574 |
9714 |
15327 |
3639 |
4728 |
8576 |
450 |
5253 |
15735 |
17115 |
18200 |
<null> |
26589 |
<null> |
10:04:54 |
10:22:54 |
marks per second |
8 |
12581 |
11133 |
9493 |
<null> |
10785 |
<null> |
14464 |
15875 |
5142 |
9338 |
8159 |
18750 |
3918 |
8872 |
11563 |
12768 |
17717 |
<null> |
<null> |
10:22:55 |
10:40:55 |
marks per second |
9 |
12441 |
9820 |
11987 |
<null> |
11543 |
5084 |
13311 |
1484 |
15593 |
10250 |
11074 |
5299 |
3170 |
10176 |
15825 |
7375 |
18903 |
1777 |
<null> |
10:40:56 |
10:58:56 |
marks per second |
10 |
14532 |
11322 |
12672 |
<null> |
14780 |
<null> |
14081 |
8688 |
7796 |
10159 |
10566 |
492 |
3371 |
13461 |
13640 |
8360 |
36450 |
<null> |
<null> |
10:58:57 |
11:16:57 |
reads/fetches*100 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
08:16:48 |
08:34:48 |
reads/fetches*100 |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
08:34:49 |
08:52:49 |
reads/fetches*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
08:52:50 |
09:10:50 |
reads/fetches*100 |
4 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
09:10:51 |
09:28:51 |
reads/fetches*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
09:28:52 |
09:46:52 |
reads/fetches*100 |
6 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
0 |
<null> |
09:46:53 |
10:04:53 |
reads/fetches*100 |
7 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
10:04:54 |
10:22:54 |
reads/fetches*100 |
8 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
10:22:55 |
10:40:55 |
reads/fetches*100 |
9 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
10:40:56 |
10:58:56 |
reads/fetches*100 |
10 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
10:58:57 |
11:16:57 |
writes/marks*100 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
5 |
0 |
<null> |
08:16:48 |
08:34:48 |
writes/marks*100 |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
<null> |
08:34:49 |
08:52:49 |
writes/marks*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
08:52:50 |
09:10:50 |
writes/marks*100 |
4 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
<null> |
<null> |
09:10:51 |
09:28:51 |
writes/marks*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
1 |
0 |
<null> |
09:28:52 |
09:46:52 |
writes/marks*100 |
6 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
0 |
<null> |
09:46:53 |
10:04:53 |
writes/marks*100 |
7 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
10:04:54 |
10:22:54 |
writes/marks*100 |
8 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
1 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
<null> |
<null> |
10:22:55 |
10:40:55 |
writes/marks*100 |
9 |
1 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
3 |
0 |
<null> |
10:40:56 |
10:58:56 |
writes/marks*100 |
10 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
1 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
4 |
<null> |
<null> |
10:58:57 |
11:16:57 |
Done for 9230 ms, from 11:30:39.02 to 11:30:48.25.
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 |
2260394 |
2043242 |
217152 |
9.60 |
0 |
6771 |
8 |
217152 |
2017-11-04 08:16 |
2017-11-04 11:16 |
doc_list_biud |
2260781 |
2043242 |
217539 |
9.62 |
0 |
4618 |
4 |
217539 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_add_invoice_to_stock |
19366 |
12177 |
7189 |
37.12 |
0 |
188838 |
2579 |
7189 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_cancel_adding_invoice |
5607 |
4266 |
1341 |
23.91 |
0 |
34866 |
561 |
1341 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_cancel_client_order |
6731 |
6599 |
132 |
1.96 |
0 |
1825 |
57 |
132 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_cancel_customer_reserve |
486139 |
281209 |
204930 |
42.15 |
0 |
2199 |
14 |
204930 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_cancel_pay_from_customer |
2694 |
2680 |
14 |
0.51 |
0 |
1482 |
33 |
14 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_cancel_pay_to_supplier |
1604 |
1598 |
6 |
0.37 |
0 |
1216 |
35 |
6 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_cancel_supplier_invoice |
11704 |
8969 |
2735 |
23.36 |
0 |
5788 |
114 |
2735 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_cancel_supplier_order |
1510 |
588 |
922 |
61.05 |
15 |
123319 |
6696 |
922 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_cancel_write_off |
26675 |
17542 |
9133 |
34.23 |
0 |
2278 |
36 |
9133 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_client_order |
81236 |
81236 |
0 |
0.00 |
0 |
3697 |
112 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_customer_reserve |
724924 |
724924 |
0 |
0.00 |
0 |
7332 |
35 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_fill_shopping_cart |
122943 |
122584 |
359 |
0.29 |
0 |
2512 |
24 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_fill_shopping_cart_clo_res |
724924 |
724924 |
0 |
0.00 |
0 |
2309 |
2 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_get_clo_for_invoice |
12177 |
12177 |
0 |
0.00 |
0 |
4056 |
79 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_kill_cost_storno |
36225 |
26086 |
10139 |
27.98 |
0 |
1248 |
4 |
10139 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_kill_qstorno_ret_qs2qd |
1010552 |
589517 |
421035 |
41.66 |
0 |
4602 |
5 |
421035 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_kill_qty_storno |
586976 |
369489 |
217487 |
37.05 |
0 |
4618 |
16 |
217487 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_lock_selected_doc |
80020 |
70432 |
9588 |
11.98 |
0 |
1232 |
2 |
9588 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_make_cost_storno |
99347 |
99347 |
0 |
0.00 |
0 |
6303 |
81 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_multiply_rows_for_pdistr |
99347 |
99347 |
0 |
0.00 |
0 |
1529 |
10 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_multiply_rows_for_qdistr |
81236 |
81236 |
0 |
0.00 |
0 |
2886 |
37 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_pay_from_customer |
26799 |
26799 |
0 |
0.00 |
0 |
7410 |
197 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_pay_to_supplier |
22232 |
22232 |
0 |
0.00 |
0 |
4727 |
101 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_payment_common |
49031 |
49031 |
0 |
0.00 |
0 |
2481 |
19 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_qd_handle_on_cancel_clo |
6727 |
6599 |
128 |
1.90 |
0 |
1357 |
23 |
128 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_qd_handle_on_invoice_upd_sts |
17642 |
16443 |
1199 |
6.79 |
0 |
4228 |
91 |
1199 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_qd_handle_on_reserve_upd_sts |
38139 |
38139 |
0 |
0.00 |
0 |
1077 |
11 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_reserve_write_off |
38634 |
38139 |
495 |
1.28 |
0 |
6458 |
125 |
495 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_supplier_invoice |
20944 |
20820 |
124 |
0.59 |
0 |
32308 |
693 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
sp_supplier_order |
20763 |
20528 |
235 |
1.13 |
0 |
13229 |
452 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
srv_find_qd_qs_mism |
1396766 |
1179711 |
217055 |
15.53 |
0 |
3682 |
4 |
217055 |
2017-11-04 08:16 |
2017-11-04 11:16 |
srv_make_invnt_saldo |
2116 |
2116 |
0 |
0.00 |
0 |
19142 |
634 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
srv_make_money_saldo |
2221 |
2221 |
0 |
0.00 |
0 |
1029 |
21 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
2153 |
39952 |
6523 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-abend:sp_add_invoice_to_stock |
7189 |
7189 |
0 |
0.00 |
0 |
1529 |
17 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-abend:sp_cancel_adding_invoice |
511 |
511 |
0 |
0.00 |
0 |
1545 |
60 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-abend:sp_cancel_client_order |
132 |
132 |
0 |
0.00 |
0 |
312 |
14 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-abend:sp_cancel_customer_reserve |
29 |
29 |
0 |
0.00 |
0 |
218 |
16 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-abend:sp_cancel_pay_from_customer |
14 |
14 |
0 |
0.00 |
0 |
32 |
8 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-abend:sp_cancel_pay_to_supplier |
6 |
6 |
0 |
0.00 |
0 |
624 |
109 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-abend:sp_cancel_supplier_invoice |
593 |
593 |
0 |
0.00 |
0 |
1139 |
17 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-abend:sp_cancel_supplier_order |
24664 |
24664 |
0 |
0.00 |
0 |
2761 |
27 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-abend:sp_cancel_write_off |
19 |
19 |
0 |
0.00 |
0 |
62 |
9 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-abend:sp_reserve_write_off |
495 |
495 |
0 |
0.00 |
0 |
905 |
13 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-abend:sp_supplier_invoice |
124 |
124 |
0 |
0.00 |
0 |
1638 |
27 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-abend:sp_supplier_order |
235 |
235 |
0 |
0.00 |
0 |
515 |
13 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-norm:sp_add_invoice_to_stock |
12177 |
12177 |
0 |
0.00 |
0 |
10545 |
182 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-norm:sp_cancel_adding_invoice |
1400 |
1400 |
0 |
0.00 |
0 |
6911 |
172 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-norm:sp_cancel_client_order |
6599 |
6599 |
0 |
0.00 |
0 |
1809 |
14 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-norm:sp_cancel_customer_reserve |
2537 |
2537 |
0 |
0.00 |
0 |
1092 |
15 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-norm:sp_cancel_pay_from_customer |
2680 |
2680 |
0 |
0.00 |
0 |
593 |
9 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-norm:sp_cancel_pay_to_supplier |
1598 |
1598 |
0 |
0.00 |
0 |
1030 |
11 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-norm:sp_cancel_supplier_invoice |
1049 |
1049 |
0 |
0.00 |
0 |
1186 |
11 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-norm:sp_cancel_supplier_order |
588 |
588 |
0 |
0.00 |
0 |
12916 |
794 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-norm:sp_cancel_write_off |
3665 |
3665 |
0 |
0.00 |
0 |
1263 |
13 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-norm:sp_client_order |
81236 |
81236 |
0 |
0.00 |
0 |
2433 |
15 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-norm:sp_customer_reserve |
3778 |
3778 |
0 |
0.00 |
0 |
1170 |
10 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-norm:sp_pay_from_customer |
26799 |
26799 |
0 |
0.00 |
0 |
2418 |
13 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-norm:sp_pay_to_supplier |
22232 |
22232 |
0 |
0.00 |
0 |
1732 |
11 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-norm:sp_reserve_write_off |
38139 |
38139 |
0 |
0.00 |
0 |
2606 |
14 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-norm:sp_supplier_invoice |
20820 |
20820 |
0 |
0.00 |
0 |
2012 |
11 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-norm:sp_supplier_order |
20528 |
20528 |
0 |
0.00 |
0 |
1904 |
12 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-norm:srv_make_invnt_saldo |
2116 |
2116 |
0 |
0.00 |
0 |
624 |
4 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-norm:srv_make_money_saldo |
2221 |
2221 |
0 |
0.00 |
0 |
609 |
7 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
t$perf-norm:srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
0 |
47 |
10 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
v_add_invoice_to_stock |
38732 |
24354 |
14378 |
37.12 |
0 |
1201 |
5 |
14378 |
2017-11-04 08:16 |
2017-11-04 11:16 |
v_all_customers |
121792 |
121792 |
0 |
0.00 |
0 |
640 |
1 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
v_all_suppliers |
84430 |
83712 |
718 |
0.85 |
0 |
889 |
1 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
v_all_wares |
162472 |
162472 |
0 |
0.00 |
0 |
780 |
1 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
v_cancel_adding_invoice |
3178 |
2800 |
378 |
11.89 |
0 |
1482 |
35 |
378 |
2017-11-04 08:16 |
2017-11-04 11:16 |
v_cancel_client_order |
13462 |
13198 |
264 |
1.96 |
0 |
749 |
2 |
264 |
2017-11-04 08:16 |
2017-11-04 11:16 |
v_cancel_customer_prepayment |
5388 |
5360 |
28 |
0.51 |
0 |
530 |
2 |
28 |
2017-11-04 08:16 |
2017-11-04 11:16 |
v_cancel_customer_reserve |
5132 |
5074 |
58 |
1.13 |
0 |
671 |
3 |
58 |
2017-11-04 08:16 |
2017-11-04 11:16 |
v_cancel_payment_to_supplier |
3208 |
3196 |
12 |
0.37 |
0 |
265 |
3 |
12 |
2017-11-04 08:16 |
2017-11-04 11:16 |
v_cancel_supplier_invoice |
3284 |
2098 |
1186 |
36.11 |
0 |
296 |
5 |
1186 |
2017-11-04 08:16 |
2017-11-04 11:16 |
v_cancel_supplier_order |
3020 |
1176 |
1844 |
61.05 |
0 |
656 |
2 |
1844 |
2017-11-04 08:16 |
2017-11-04 11:16 |
v_cancel_write_off |
7368 |
7330 |
38 |
0.51 |
0 |
1810 |
27 |
38 |
2017-11-04 08:16 |
2017-11-04 11:16 |
v_max_id_clo_ord |
20763 |
20528 |
235 |
1.13 |
0 |
515 |
1 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
v_max_id_clo_res |
3778 |
3778 |
0 |
0.00 |
0 |
1280 |
5 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
v_max_id_ord_sup |
20944 |
20820 |
124 |
0.59 |
0 |
531 |
1 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
v_max_non_paid_invoice |
21724 |
21724 |
0 |
0.00 |
0 |
577 |
1 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
v_max_non_paid_realizn |
26799 |
26799 |
0 |
0.00 |
0 |
1030 |
1 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
v_min_id_clo_ord |
20763 |
20528 |
235 |
1.13 |
0 |
375 |
2 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
v_min_id_clo_res |
3778 |
3778 |
0 |
0.00 |
0 |
562 |
3 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
v_min_id_ord_sup |
20944 |
20820 |
124 |
0.59 |
0 |
827 |
2 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
v_min_non_paid_invoice |
22232 |
22232 |
0 |
0.00 |
0 |
1856 |
2 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
v_min_non_paid_realizn |
26799 |
26799 |
0 |
0.00 |
0 |
500 |
2 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
v_our_firm |
40680 |
40680 |
0 |
0.00 |
0 |
889 |
1 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
v_reserve_write_off |
77268 |
76278 |
990 |
1.28 |
0 |
1076 |
2 |
990 |
2017-11-04 08:16 |
2017-11-04 11:16 |
x_lock_depdocs_on_canc_invoice |
22875 |
12186 |
10689 |
46.72 |
0 |
1419 |
8 |
10689 |
2017-11-04 08:16 |
2017-11-04 11:16 |
x_lock_depdocs_on_canc_sup_ord |
1510 |
588 |
922 |
61.05 |
0 |
764 |
16 |
922 |
2017-11-04 08:16 |
2017-11-04 11:16 |
x_make_qstorno_1000_1200 |
20763 |
20528 |
235 |
1.13 |
0 |
11747 |
397 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
x_make_qstorno_1200_2000 |
20944 |
20820 |
124 |
0.59 |
0 |
31575 |
637 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
x_make_qstorno_2100_3300 |
724924 |
724924 |
0 |
0.00 |
0 |
7083 |
30 |
0 |
2017-11-04 08:16 |
2017-11-04 11:16 |
Done for 370020 ms, from 11:36:50.62 to 11:43:00.64.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
DTS_BEG |
DTS_END |
deadlock |
74 |
sp_kill_cost_storno |
335544336 |
2017-11-04 08:17 |
2017-11-04 11:13 |
deadlock |
78 |
sp_kill_qstorno_ret_qs2qd |
335544336 |
2017-11-04 08:19 |
2017-11-04 11:11 |
deadlock |
8332 |
sp_lock_selected_doc |
335544336 |
2017-11-04 08:16 |
2017-11-04 11:16 |
deadlock |
128 |
sp_qd_handle_on_cancel_clo |
335544336 |
2017-11-04 08:17 |
2017-11-04 11:16 |
deadlock |
200 |
sp_qd_handle_on_invoice_upd_sts |
335544336 |
2017-11-04 08:17 |
2017-11-04 11:16 |
deadlock |
603 |
x_lock_depdocs_on_canc_invoice |
335544336 |
2017-11-04 08:17 |
2017-11-04 11:16 |
deadlock |
170 |
x_lock_depdocs_on_canc_sup_ord |
335544336 |
2017-11-04 08:19 |
2017-11-04 11:14 |
user_exc |
235 |
x_make_qstorno_1000_1200 |
335544517 |
2017-11-04 08:17 |
2017-11-04 11:15 |
user_exc |
124 |
x_make_qstorno_1200_2000 |
335544517 |
2017-11-04 08:17 |
2017-11-04 11:16 |
Done for 12370 ms, from 11:43:11.23 to 11:43:23.60.
MON$DATABASE_NAME D:\OLTP-EMUL\OLTP40-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 13
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 440211
MON$OLDEST_ACTIVE 440212
MON$OLDEST_SNAPSHOT 440212
MON$NEXT_TRANSACTION 440212
MON$PAGE_BUFFERS 786432
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2017-01-11 15:15:54.2050
MON$PAGES 901856
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.783 Firebird 4.0 Alpha 1
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.783 Firebird 4.0 Alpha 1"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T4.0.0.783 Firebird 4.0 Alpha 1/tcp (WIN-2BE1UI8LGDL)/P16"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T4.0.0.783 Firebird 4.0 Alpha 1/tcp (WIN-2BE1UI8LGDL)/P16"
on disk structure version 13.0
Database "D:\OLTP-EMUL\OLTP40-SMALL.FDB"
Database header page information:
Flags 0
Generation 440252
System Change Number 0
Page size 8192
ODS version 13.0
Oldest transaction 440213
Oldest active 440214
Oldest snapshot 440214
Next transaction 440215
Sequence number 0
Next attachment ID 9333
Implementation HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jan 11, 2017 15:15:54
Attributes force write
Variable header data:
Sweep interval: 0
*END*
Database file sequence:
File D:\OLTP-EMUL\OLTP40-SMALL.FDB is the only file
Analyzing database pages ...
AGENTS (154)
Primary pointer page: 314, Index root page: 315
Total formats: 1, used formats: 1
Average record length: 33.50, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 344.00, compression ratio: 10.27
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_ID_DESC (2)
Root page: 325, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_OUR_FIRM (4)
Root page: 327, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 48
Average key length: 2.04, compression ratio: 0.50
Average prefix length: 0.96, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_SUPPLIER (3)
Root page: 326, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 43
Average key length: 2.04, compression ratio: 0.55
Average prefix length: 1.06, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_NAME_UNQ (1)
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.32, total dup: 0, max dup: 0
Average key length: 15.94, compression ratio: 0.91
Average prefix length: 1.20, average data length: 13.32
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_AGENTS (0)
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BUSINESS_OPS (158)
Primary pointer page: 335, Index root page: 336
Total formats: 1, used formats: 1
Average record length: 107.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1236.00, compression ratio: 11.55
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 29%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BO_UNIT_UNQ (1)
Root page: 339, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 18.00, total dup: 0, max dup: 0
Average key length: 16.95, compression ratio: 1.25
Average prefix length: 7.21, average data length: 14.00
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BUSINESS_OPS_RND_WGTH (2)
Root page: 340, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 4.05, total dup: 7, max dup: 3
Average key length: 3.00, compression ratio: 0.75
Average prefix length: 1.42, average data length: 0.84
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$1 (0)
Root page: 338, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 5.26, total dup: 0, max dup: 0
Average key length: 4.21, compression ratio: 0.64
Average prefix length: 1.05, average data length: 1.63
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DOC_DATA (141)
Primary pointer page: 254, Index root page: 255
Total formats: 1, used formats: 1
Average record length: 47.13, total records: 2141947
Average version length: 47.79, total versions: 1505, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.36
Pointer pages: 15, data page slots: 23120
Data pages: 23120, average fill: 73%
Primary pages: 23120, secondary pages: 0, swept pages: 13581
Empty pages: 5, full pages: 22199
Fill distribution:
0 - 19% = 5
20 - 39% = 7
40 - 59% = 58
60 - 79% = 23048
80 - 99% = 2
Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26714, depth: 3, leaf buckets: 10478, nodes: 2141947
Average node length: 19.40, total dup: 0, max dup: 0
Average key length: 16.45, compression ratio: 1.64
Average prefix length: 13.55, average data length: 13.45
Clustering factor: 310752, ratio: 0.15
Fill distribution:
0 - 19% = 884
20 - 39% = 2907
40 - 59% = 3640
60 - 79% = 1228
80 - 99% = 1819
Index DOC_DATA_ID_DESC (2)
Root page: 46473, depth: 3, leaf buckets: 7732, nodes: 2141947
Average node length: 11.63, total dup: 0, max dup: 0
Average key length: 8.68, compression ratio: 1.04
Average prefix length: 3.32, average data length: 5.68
Clustering factor: 310850, ratio: 0.15
Fill distribution:
0 - 19% = 0
20 - 39% = 3852
40 - 59% = 3704
60 - 79% = 152
80 - 99% = 24
Index FK_DOC_DATA_DOC_LIST (3)
Root page: 175729, depth: 3, leaf buckets: 3513, nodes: 2141947
Average node length: 6.87, total dup: 1542273, max dup: 49
Average key length: 3.92, compression ratio: 2.30
Average prefix length: 7.36, average data length: 1.64
Clustering factor: 275928, ratio: 0.13
Fill distribution:
0 - 19% = 139
20 - 39% = 1142
40 - 59% = 1028
60 - 79% = 530
80 - 99% = 674
DOC_LIST (140)
Primary pointer page: 249, Index root page: 250
Total formats: 1, used formats: 1
Average record length: 60.52, total records: 664657
Average version length: 61.47, total versions: 475, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 6, data page slots: 8392
Data pages: 8392, average fill: 75%
Primary pages: 8391, secondary pages: 1, swept pages: 7593
Empty pages: 5, full pages: 8192
Fill distribution:
0 - 19% = 8
20 - 39% = 7
40 - 59% = 22
60 - 79% = 8334
80 - 99% = 21
Index DOC_LIST_ID_DESC (1)
Root page: 185483, depth: 3, leaf buckets: 2409, nodes: 664657
Average node length: 11.68, total dup: 0, max dup: 0
Average key length: 8.81, compression ratio: 1.02
Average prefix length: 3.19, average data length: 5.81
Clustering factor: 143907, ratio: 0.22
Fill distribution:
0 - 19% = 1
20 - 39% = 1262
40 - 59% = 1052
60 - 79% = 85
80 - 99% = 9
Index FK_DOC_LIST_AGENTS (2)
Root page: 2940, depth: 2, leaf buckets: 695, nodes: 664657
Average node length: 4.88, total dup: 664607, max dup: 34841
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 300946, ratio: 0.45
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 585
60 - 79% = 88
80 - 99% = 21
Index PK_DOC_LIST (0)
Root page: 349717, depth: 3, leaf buckets: 1622, nodes: 664657
Average node length: 11.67, total dup: 0, max dup: 0
Average key length: 8.80, compression ratio: 1.02
Average prefix length: 3.20, average data length: 5.80
Clustering factor: 143907, ratio: 0.22
Fill distribution:
0 - 19% = 94
20 - 39% = 274
40 - 59% = 426
60 - 79% = 409
80 - 99% = 419
DOC_STATES (153)
Primary pointer page: 312, Index root page: 313
Total formats: 1, used formats: 1
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 650.00, compression ratio: 9.63
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_MCODE_UNQ (1)
Root page: 321, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 17.75, total dup: 0, max dup: 0
Average key length: 16.50, compression ratio: 1.08
Average prefix length: 4.00, average data length: 13.75
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_NAME_UNQ (2)
Root page: 322, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 33.25, total dup: 0, max dup: 0
Average key length: 32.00, compression ratio: 0.99
Average prefix length: 2.50, average data length: 29.25
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_DOC_STATES (0)
Root page: 320, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 4.75, total dup: 0, max dup: 0
Average key length: 3.50, compression ratio: 0.86
Average prefix length: 1.50, average data length: 1.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
FB_ERRORS (159)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 148.00, compression ratio: 1.86
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 56%
Primary pages: 16, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 11
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7
Index FB_ERRORS_GDS_CODE (0)
Root page: 343, depth: 1, leaf buckets: 1, nodes: 758
Average node length: 4.24, total dup: 0, max dup: 0
Average key length: 3.04, compression ratio: 1.64
Average prefix length: 3.97, average data length: 1.03
Clustering factor: 353, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
INVNT_SALDO (147)
Primary pointer page: 273, Index root page: 274
Total formats: 1, used formats: 1
Average record length: 67.17, total records: 400
Average version length: 18.25, total versions: 7508, max versions: 29
Average fragment length: 19.35, total fragments: 384, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.55
Pointer pages: 1, data page slots: 48
Data pages: 48, average fill: 81%
Primary pages: 5, secondary pages: 43, swept pages: 0
Empty pages: 1, full pages: 46
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 15
80 - 99% = 32
Index PK_INVNT_SALDO (0)
Root page: 285, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 303, ratio: 0.76
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
INVNT_TURNOVER_LOG (157)
Primary pointer page: 333, Index root page: 334
Total formats: 1, used formats: 1
Average record length: 13.04, total records: 7703
Average version length: 70.83, total versions: 6293, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 7.36
Pointer pages: 1, data page slots: 288
Data pages: 280, average fill: 37%
Primary pages: 279, secondary pages: 1, swept pages: 70
Empty pages: 70, full pages: 31
Fill distribution:
0 - 19% = 91
20 - 39% = 53
40 - 59% = 77
60 - 79% = 44
80 - 99% = 15
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1481, depth: 2, leaf buckets: 36, nodes: 7703
Average node length: 14.01, total dup: 607, max dup: 1
Average key length: 12.05, compression ratio: 2.24
Average prefix length: 17.86, average data length: 9.14
Clustering factor: 6293, ratio: 0.82
Fill distribution:
0 - 19% = 0
20 - 39% = 28
40 - 59% = 5
60 - 79% = 3
80 - 99% = 0
MONEY_SALDO (143)
Primary pointer page: 265, Index root page: 266
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: 276, depth: 1, leaf buckets: 1, nodes: 49
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MONEY_TURNOVER_LOG (142)
Primary pointer page: 263, Index root page: 264
Total formats: 1, used formats: 1
Average record length: 45.64, total records: 132
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.40
Pointer pages: 1, data page slots: 32
Data pages: 16, average fill: 9%
Primary pages: 15, secondary pages: 1, swept pages: 11
Empty pages: 7, full pages: 0
Fill distribution:
0 - 19% = 13
20 - 39% = 3
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 659422, depth: 2, leaf buckets: 1, nodes: 132
Average node length: 8.56, total dup: 84, max dup: 19
Average key length: 7.48, compression ratio: 2.54
Average prefix length: 13.88, average data length: 5.12
Clustering factor: 91, ratio: 0.69
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG (165)
Primary pointer page: 356, Index root page: 357
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_DTS (4)
Root page: 367, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_GDSCODE (2)
Root page: 365, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_ROWSET_DESC (1)
Root page: 364, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_UNIT (3)
Root page: 366, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG (0)
Root page: 363, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG_TABLE_STATS (166)
Primary pointer page: 369, Index root page: 370
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_DTS (4)
Root page: 376, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_GDSCODE (2)
Root page: 374, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_ROWSET (1)
Root page: 373, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_TN_UNIT (3)
Root page: 375, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG_TABLE_STATS (0)
Root page: 372, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
OPTYPES (138)
Primary pointer page: 241, Index root page: 242
Total formats: 1, used formats: 1
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 5.54
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 9%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OPTYPES_MCODE_UNQ (1)
Root page: 244, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 8.56, total dup: 0, max dup: 0
Average key length: 6.89, compression ratio: 0.73
Average prefix length: 0.44, average data length: 4.56
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_OPTYPES (0)
Root page: 243, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 6.11, total dup: 0, max dup: 0
Average key length: 5.00, compression ratio: 0.60
Average prefix length: 0.89, average data length: 2.11
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PDISTR (150)
Primary pointer page: 296, Index root page: 297
Total formats: 1, used formats: 1
Average record length: 18.06, total records: 723282
Average version length: 42.62, total versions: 731, max versions: 13
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 3.54
Pointer pages: 3, data page slots: 4152
Data pages: 4152, average fill: 75%
Primary pages: 4151, secondary pages: 1, swept pages: 3617
Empty pages: 0, full pages: 3934
Fill distribution:
0 - 19% = 2
20 - 39% = 3
40 - 59% = 18
60 - 79% = 3679
80 - 99% = 450
Index PDISTR_AGENT_ID (4)
Root page: 3976, depth: 2, leaf buckets: 209, nodes: 195116
Average node length: 4.89, total dup: 195067, max dup: 9444
Average key length: 2.01, compression ratio: 4.47
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 26993, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 22
40 - 59% = 118
60 - 79% = 52
80 - 99% = 16
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 3600, depth: 2, leaf buckets: 240, nodes: 195116
Average node length: 5.83, total dup: 175796, max dup: 35
Average key length: 2.96, compression ratio: 7.44
Average prefix length: 21.14, average data length: 0.86
Clustering factor: 30441, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 31
40 - 59% = 99
60 - 79% = 73
80 - 99% = 36
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3602, depth: 2, leaf buckets: 235, nodes: 195116
Average node length: 5.83, total dup: 175796, max dup: 35
Average key length: 2.96, compression ratio: 7.44
Average prefix length: 21.14, average data length: 0.86
Clustering factor: 30473, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 21
40 - 59% = 104
60 - 79% = 72
80 - 99% = 38
Index PDISTR_SND_ID (1)
Root page: 3001, depth: 2, leaf buckets: 225, nodes: 195116
Average node length: 5.62, total dup: 175796, max dup: 35
Average key length: 2.74, compression ratio: 3.28
Average prefix length: 8.36, average data length: 0.64
Clustering factor: 30552, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 27
40 - 59% = 90
60 - 79% = 75
80 - 99% = 32
PERF_ESTIMATED (160)
Primary pointer page: 344, Index root page: 345
Total formats: 1, used formats: 1
Average record length: 27.98, total records: 269672
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 1.14
Pointer pages: 2, data page slots: 2312
Data pages: 2312, average fill: 64%
Primary pages: 2312, secondary pages: 0, swept pages: 0
Empty pages: 7, full pages: 2304
Fill distribution:
0 - 19% = 7
20 - 39% = 1
40 - 59% = 0
60 - 79% = 2304
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 114409, depth: 2, leaf buckets: 212, nodes: 269672
Average node length: 4.53, total dup: 269491, max dup: 2225
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.57, average data length: 0.00
Clustering factor: 68989, ratio: 0.26
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 71
60 - 79% = 71
80 - 99% = 70
PERF_ISQL_STAT (161)
Primary pointer page: 347, Index root page: 348
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PERF_ISQL_STAT_TRN (0)
Root page: 349, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PERF_LOG (163)
Primary pointer page: 352, Index root page: 353
Total formats: 1, used formats: 1
Average record length: 151.96, total records: 13607350
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.16
Pointer pages: 199, data page slots: 323560
Data pages: 323560, average fill: 87%
Primary pages: 323560, secondary pages: 0, swept pages: 3
Empty pages: 3, full pages: 323556
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 323556
Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 61748, depth: 3, leaf buckets: 16356, nodes: 13607350
Average node length: 5.72, total dup: 12738130, max dup: 147
Average key length: 2.16, compression ratio: 3.70
Average prefix length: 7.88, average data length: 0.12
Clustering factor: 2238176, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 11040
60 - 79% = 3526
80 - 99% = 1789
Index PERF_LOG_GDSCODE (3)
Root page: 163282, depth: 3, leaf buckets: 13787, nodes: 13607350
Average node length: 4.68, total dup: 13607346, max dup: 12035784
Average key length: 1.12, compression ratio: 0.52
Average prefix length: 0.58, average data length: 0.00
Clustering factor: 384447, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 13783
60 - 79% = 2
80 - 99% = 2
Index PERF_LOG_TRN_DESC (2)
Root page: 42827, depth: 3, leaf buckets: 17209, nodes: 13607350
Average node length: 5.76, total dup: 13244386, max dup: 27518
Average key length: 2.20, compression ratio: 4.09
Average prefix length: 8.83, average data length: 0.17
Clustering factor: 715604, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 13888
60 - 79% = 1878
80 - 99% = 1442
Index PERF_LOG_UNIT (1)
Root page: 77433, depth: 3, leaf buckets: 16665, nodes: 13607350
Average node length: 5.62, total dup: 13590889, max dup: 2159582
Average key length: 2.06, compression ratio: 18.43
Average prefix length: 37.90, average data length: 0.06
Clustering factor: 5853580, ratio: 0.43
Fill distribution:
0 - 19% = 15
20 - 39% = 0
40 - 59% = 14588
60 - 79% = 293
80 - 99% = 1769
PHRASES (145)
Primary pointer page: 269, Index root page: 270
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_ID_DESC (3)
Root page: 283, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_NAME (2)
Root page: 282, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_UNQ (1)
Root page: 281, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_PHRASES (0)
Root page: 280, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PSTORNED (151)
Primary pointer page: 303, Index root page: 304
Total formats: 1, used formats: 1
Average record length: 55.17, total records: 461373
Average version length: 55.62, total versions: 399, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.45
Pointer pages: 4, data page slots: 5480
Data pages: 5480, average fill: 75%
Primary pages: 5480, secondary pages: 0, swept pages: 3934
Empty pages: 4, full pages: 5215
Fill distribution:
0 - 19% = 6
20 - 39% = 3
40 - 59% = 6
60 - 79% = 5464
80 - 99% = 1
Index PSTORNED_RCV_ID (2)
Root page: 681399, depth: 3, leaf buckets: 605, nodes: 461373
Average node length: 5.86, total dup: 394097, max dup: 546
Average key length: 3.07, compression ratio: 2.94
Average prefix length: 8.08, average data length: 0.92
Clustering factor: 55863, ratio: 0.12
Fill distribution:
0 - 19% = 6
20 - 39% = 41
40 - 59% = 375
60 - 79% = 128
80 - 99% = 55
Index PSTORNED_SND_ID (1)
Root page: 2643, depth: 2, leaf buckets: 495, nodes: 461373
Average node length: 5.65, total dup: 408624, max dup: 276
Average key length: 2.85, compression ratio: 3.16
Average prefix length: 8.26, average data length: 0.74
Clustering factor: 115311, ratio: 0.25
Fill distribution:
0 - 19% = 2
20 - 39% = 3
40 - 59% = 213
60 - 79% = 184
80 - 99% = 93
RULES_FOR_PDISTR (152)
Primary pointer page: 305, Index root page: 306
Total formats: 1, used formats: 1
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 336.00, compression ratio: 18.67
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 2%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_PDISTR_UNQ (0)
Root page: 310, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 11.50, total dup: 0, max dup: 0
Average key length: 10.25, compression ratio: 0.88
Average prefix length: 1.50, average data length: 7.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RULES_FOR_QDISTR (139)
Primary pointer page: 245, Index root page: 246
Total formats: 1, used formats: 1
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 332.00, compression ratio: 10.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_RCVOP (1)
Root page: 248, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 5.29, total dup: 2, max dup: 2
Average key length: 4.14, compression ratio: 0.72
Average prefix length: 1.43, average data length: 1.57
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_UNQ (0)
Root page: 247, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 10.14, total dup: 0, max dup: 0
Average key length: 8.86, compression ratio: 0.94
Average prefix length: 2.14, average data length: 6.14
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SEMAPHORES (156)
Primary pointer page: 318, Index root page: 319
Total formats: 1, used formats: 1
Average record length: 34.25, total records: 4
Average version length: 9.00, total versions: 29, max versions: 29
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: 12%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_SEMAPHORES (0)
Root page: 330, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 12.50, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.50, average data length: 8.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SEMAPHORES_TASK_UNQ (1)
Root page: 331, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 22.50, total dup: 0, max dup: 0
Average key length: 21.00, compression ratio: 1.07
Average prefix length: 4.00, average data length: 18.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SETTINGS (137)
Primary pointer page: 238, Index root page: 239
Total formats: 1, used formats: 1
Average record length: 98.31, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1347.00, compression ratio: 13.70
Pointer pages: 1, data page slots: 2
Data pages: 2, average fill: 80%
Primary pages: 2, secondary pages: 0, swept pages: 2
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1
Index SETTINGS_MODE_CODE (0)
Root page: 240, depth: 1, leaf buckets: 1, nodes: 114
Average node length: 27.11, total dup: 0, max dup: 0
Average key length: 26.10, compression ratio: 1.70
Average prefix length: 21.18, average data length: 23.11
Clustering factor: 6, ratio: 0.05
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$RAND$CALLS (136)
Primary pointer page: 236, Index root page: 237
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$SOURCE (135)
Primary pointer page: 234, Index root page: 235
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$DEP_DOCS (129)
Primary pointer page: 216, Index root page: 217
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_DEP_DOCS_UNQ (0)
Root page: 218, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$IDX_RECALC (132)
Primary pointer page: 226, Index root page: 227
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0)
Root page: 229, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG (133)
Primary pointer page: 230, Index root page: 231
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG_TABLE_STATS (134)
Primary pointer page: 232, Index root page: 233
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_LOG (164)
Primary pointer page: 354, Index root page: 355
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_MON (131)
Primary pointer page: 224, Index root page: 225
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$RESULT_SET (130)
Primary pointer page: 219, Index root page: 220
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_DOC (1)
Root page: 222, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_WARE_DOC (0)
Root page: 221, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$SHOPPING_CART (128)
Primary pointer page: 211, Index root page: 212
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_SHOPCART_UNQ (0)
Root page: 215, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRACE_STAT (162)
Primary pointer page: 350, Index root page: 351
Total formats: 1, used formats: 1
Average record length: 57.41, total records: 2806
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 6.55
Pointer pages: 1, data page slots: 40
Data pages: 40, average fill: 64%
Primary pages: 40, secondary pages: 0, swept pages: 0
Empty pages: 6, full pages: 33
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 0
60 - 79% = 34
80 - 99% = 0
WARES (144)
Primary pointer page: 267, Index root page: 268
Total formats: 1, used formats: 1
Average record length: 77.71, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 448.00, compression ratio: 5.77
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 77%
Primary pages: 6, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2
Index FK_WARES_WARE_GROUPS (3)
Root page: 380, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 65
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 47, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARES (0)
Root page: 277, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 333, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_ID_DESC (2)
Root page: 279, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 333, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_NUMB_UNQ (1)
Root page: 585, depth: 2, leaf buckets: 4, nodes: 400
Average node length: 52.81, total dup: 0, max dup: 0
Average key length: 51.79, compression ratio: 1.00
Average prefix length: 2.72, average data length: 48.81
Clustering factor: 342, ratio: 0.85
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3
80 - 99% = 0
WARE_GROUPS (155)
Primary pointer page: 316, Index root page: 317
Total formats: 1, used formats: 1
Average record length: 32.13, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 352.00, compression ratio: 10.96
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 5%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARE_GROUPS (0)
Root page: 328, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 11.25, total dup: 0, max dup: 0
Average key length: 10.13, compression ratio: 0.89
Average prefix length: 1.75, average data length: 7.25
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index WARE_GROUPS_NAME_UNQ (1)
Root page: 329, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 19.88, total dup: 0, max dup: 0
Average key length: 18.13, compression ratio: 0.89
Average prefix length: 0.25, average data length: 15.88
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQD_1000_1200 (260)
Primary pointer page: 298, Index root page: 307
Total formats: 1, used formats: 1
Average record length: 30.64, total records: 7248
Average version length: 72.12, total versions: 4170, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 4.44
Pointer pages: 1, data page slots: 296
Data pages: 282, average fill: 33%
Primary pages: 281, secondary pages: 1, swept pages: 102
Empty pages: 103, full pages: 76
Fill distribution:
0 - 19% = 148
20 - 39% = 24
40 - 59% = 24
60 - 79% = 31
80 - 99% = 55
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1583, depth: 2, leaf buckets: 17, nodes: 7248
Average node length: 6.59, total dup: 6256, max dup: 14
Average key length: 4.60, compression ratio: 8.04
Average prefix length: 34.53, average data length: 2.47
Clustering factor: 1110, ratio: 0.15
Fill distribution:
0 - 19% = 0
20 - 39% = 12
40 - 59% = 5
60 - 79% = 0
80 - 99% = 0
XQD_1000_3300 (262)
Primary pointer page: 782, Index root page: 783
Total formats: 1, used formats: 1
Average record length: 71.80, total records: 733258
Average version length: 70.99, total versions: 3812, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.89
Pointer pages: 7, data page slots: 10992
Data pages: 10992, average fill: 73%
Primary pages: 10992, secondary pages: 0, swept pages: 7286
Empty pages: 7, full pages: 8381
Fill distribution:
0 - 19% = 27
20 - 39% = 152
40 - 59% = 619
60 - 79% = 10137
80 - 99% = 57
Index XQD_1000_3300_DOC (1)
Root page: 657332, depth: 3, leaf buckets: 671, nodes: 733258
Average node length: 5.10, total dup: 712762, max dup: 125
Average key length: 2.20, compression ratio: 4.08
Average prefix length: 8.82, average data length: 0.18
Clustering factor: 82403, ratio: 0.11
Fill distribution:
0 - 19% = 5
20 - 39% = 62
40 - 59% = 272
60 - 79% = 42
80 - 99% = 290
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 258547, depth: 3, leaf buckets: 1035, nodes: 733258
Average node length: 6.23, total dup: 639889, max dup: 17
Average key length: 3.33, compression ratio: 11.12
Average prefix length: 35.80, average data length: 1.20
Clustering factor: 146133, ratio: 0.20
Fill distribution:
0 - 19% = 21
20 - 39% = 146
40 - 59% = 591
60 - 79% = 151
80 - 99% = 126
XQD_1200_2000 (261)
Primary pointer page: 777, Index root page: 778
Total formats: 1, used formats: 1
Average record length: 14.27, total records: 103450
Average version length: 71.80, total versions: 7977, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 9.53
Pointer pages: 2, data page slots: 2192
Data pages: 2136, average fill: 24%
Primary pages: 2125, secondary pages: 11, swept pages: 1230
Empty pages: 513, full pages: 315
Fill distribution:
0 - 19% = 1339
20 - 39% = 250
40 - 59% = 209
60 - 79% = 104
80 - 99% = 234
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1052, depth: 2, leaf buckets: 35, nodes: 17813
Average node length: 5.97, total dup: 15410, max dup: 45
Average key length: 3.99, compression ratio: 9.28
Average prefix length: 35.15, average data length: 1.85
Clustering factor: 1877, ratio: 0.11
Fill distribution:
0 - 19% = 0
20 - 39% = 19
40 - 59% = 16
60 - 79% = 0
80 - 99% = 0
XQD_2000_3300 (263)
Primary pointer page: 786, Index root page: 787
Total formats: 1, used formats: 1
Average record length: 46.78, total records: 2614933
Average version length: 71.40, total versions: 15655, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.91
Pointer pages: 20, data page slots: 31960
Data pages: 31928, average fill: 65%
Primary pages: 31928, secondary pages: 0, swept pages: 8265
Empty pages: 165, full pages: 30978
Fill distribution:
0 - 19% = 252
20 - 39% = 7056
40 - 59% = 1625
60 - 79% = 19267
80 - 99% = 3728
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 194005, depth: 3, leaf buckets: 2487, nodes: 1581036
Average node length: 5.57, total dup: 1495115, max dup: 49
Average key length: 2.60, compression ratio: 14.24
Average prefix length: 36.45, average data length: 0.55
Clustering factor: 133286, ratio: 0.08
Fill distribution:
0 - 19% = 22
20 - 39% = 1198
40 - 59% = 912
60 - 79% = 171
80 - 99% = 184
XQD_2100_3300 (264)
Primary pointer page: 789, Index root page: 790
Total formats: 1, used formats: 1
Average record length: 9.04, total records: 4627441
Average version length: 69.56, total versions: 2646, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 15.04
Pointer pages: 18, data page slots: 29336
Data pages: 29224, average fill: 51%
Primary pages: 29223, secondary pages: 1, swept pages: 10707
Empty pages: 69, full pages: 28711
Fill distribution:
0 - 19% = 201
20 - 39% = 9947
40 - 59% = 6565
60 - 79% = 12351
80 - 99% = 160
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1684, depth: 2, leaf buckets: 19, nodes: 6103
Average node length: 9.52, total dup: 4337, max dup: 37
Average key length: 6.52, compression ratio: 5.68
Average prefix length: 32.77, average data length: 4.23
Clustering factor: 1274, ratio: 0.21
Fill distribution:
0 - 19% = 0
20 - 39% = 11
40 - 59% = 5
60 - 79% = 3
80 - 99% = 0
XQD_3300_3400 (265)
Primary pointer page: 801, Index root page: 802
Total formats: 1, used formats: 1
Average record length: 62.78, total records: 3268244
Average version length: 71.63, total versions: 9893, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.17
Pointer pages: 26, data page slots: 41808
Data pages: 41808, average fill: 77%
Primary pages: 41808, secondary pages: 0, swept pages: 27806
Empty pages: 26, full pages: 40718
Fill distribution:
0 - 19% = 48
20 - 39% = 313
40 - 59% = 740
60 - 79% = 37921
80 - 99% = 2786
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 37222, depth: 3, leaf buckets: 5871, nodes: 2822073
Average node length: 6.89, total dup: 2276399, max dup: 14
Average key length: 3.92, compression ratio: 9.45
Average prefix length: 35.28, average data length: 1.72
Clustering factor: 421460, ratio: 0.15
Fill distribution:
0 - 19% = 6
20 - 39% = 3278
40 - 59% = 2036
60 - 79% = 357
80 - 99% = 194
XQS_1000_1200 (266)
Primary pointer page: 805, Index root page: 806
Total formats: 1, used formats: 1
Average record length: 83.68, total records: 4682588
Average version length: 84.14, total versions: 496, 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: 45, data page slots: 71880
Data pages: 71880, average fill: 80%
Primary pages: 71880, secondary pages: 0, swept pages: 26387
Empty pages: 4, full pages: 71777
Fill distribution:
0 - 19% = 4
20 - 39% = 1
40 - 59% = 6
60 - 79% = 20202
80 - 99% = 51667
Index XQS_1000_1200_DOC_ID (0)
Root page: 55157, depth: 3, leaf buckets: 4821, nodes: 4682588
Average node length: 5.16, total dup: 4576199, max dup: 131
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 702401, ratio: 0.15
Fill distribution:
0 - 19% = 23
20 - 39% = 68
40 - 59% = 2148
60 - 79% = 2112
80 - 99% = 470
Index XQS_1000_1200_RCV_ID (2)
Root page: 83992, depth: 3, leaf buckets: 4224, nodes: 4682588
Average node length: 5.70, total dup: 4189445, max dup: 49
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 138851, ratio: 0.03
Fill distribution:
0 - 19% = 27
20 - 39% = 79
40 - 59% = 1185
60 - 79% = 274
80 - 99% = 2659
Index XQS_1000_1200_SND_ID (1)
Root page: 48960, depth: 3, leaf buckets: 5364, nodes: 4682588
Average node length: 5.81, total dup: 4096857, max dup: 25
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 755885, ratio: 0.16
Fill distribution:
0 - 19% = 32
20 - 39% = 79
40 - 59% = 2324
60 - 79% = 2262
80 - 99% = 667
XQS_1000_3300 (268)
Primary pointer page: 815, Index root page: 816
Total formats: 1, used formats: 1
Average record length: 83.34, total records: 2784303
Average version length: 83.80, total versions: 9853, 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: 27, data page slots: 43304
Data pages: 43296, average fill: 79%
Primary pages: 43296, secondary pages: 0, swept pages: 30064
Empty pages: 25, full pages: 42372
Fill distribution:
0 - 19% = 52
20 - 39% = 86
40 - 59% = 219
60 - 79% = 14581
80 - 99% = 28358
Index XQS_1000_3300_DOC_ID (0)
Root page: 76716, depth: 3, leaf buckets: 2936, nodes: 2784303
Average node length: 5.15, total dup: 2719406, max dup: 163
Average key length: 2.18, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 443062, ratio: 0.16
Fill distribution:
0 - 19% = 3
20 - 39% = 40
40 - 59% = 1677
60 - 79% = 886
80 - 99% = 330
Index XQS_1000_3300_RCV_ID (2)
Root page: 110552, depth: 3, leaf buckets: 4210, nodes: 2784303
Average node length: 6.26, total dup: 2267817, max dup: 14
Average key length: 3.29, compression ratio: 2.74
Average prefix length: 7.90, average data length: 1.10
Clustering factor: 204125, ratio: 0.07
Fill distribution:
0 - 19% = 100
20 - 39% = 1284
40 - 59% = 1547
60 - 79% = 746
80 - 99% = 533
Index XQS_1000_3300_SND_ID (1)
Root page: 66178, depth: 3, leaf buckets: 3307, nodes: 2784303
Average node length: 5.81, total dup: 2435094, max dup: 38
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 536022, ratio: 0.19
Fill distribution:
0 - 19% = 15
20 - 39% = 43
40 - 59% = 1875
60 - 79% = 968
80 - 99% = 406
XQS_1200_2000 (267)
Primary pointer page: 810, Index root page: 811
Total formats: 1, used formats: 1
Average record length: 83.80, total records: 4958720
Average version length: 84.34, total versions: 4019, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.62
Pointer pages: 47, data page slots: 76016
Data pages: 76008, average fill: 81%
Primary pages: 76008, secondary pages: 0, swept pages: 15782
Empty pages: 163, full pages: 75558
Fill distribution:
0 - 19% = 198
20 - 39% = 67
40 - 59% = 86
60 - 79% = 10818
80 - 99% = 64839
Index XQS_1200_2000_DOC_ID (0)
Root page: 58219, depth: 3, leaf buckets: 5046, nodes: 4958720
Average node length: 5.04, total dup: 4930008, max dup: 716
Average key length: 2.05, compression ratio: 4.39
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 701617, ratio: 0.14
Fill distribution:
0 - 19% = 7
20 - 39% = 121
40 - 59% = 2647
60 - 79% = 1636
80 - 99% = 635
Index XQS_1200_2000_RCV_ID (2)
Root page: 84200, depth: 3, leaf buckets: 5452, nodes: 4958720
Average node length: 5.50, total dup: 4582388, max dup: 49
Average key length: 2.52, compression ratio: 3.57
Average prefix length: 8.56, average data length: 0.44
Clustering factor: 141770, ratio: 0.03
Fill distribution:
0 - 19% = 103
20 - 39% = 1154
40 - 59% = 1792
60 - 79% = 714
80 - 99% = 1689
Index XQS_1200_2000_SND_ID (1)
Root page: 50796, depth: 3, leaf buckets: 5659, nodes: 4958720
Average node length: 5.69, total dup: 4445935, max dup: 80
Average key length: 2.70, compression ratio: 3.33
Average prefix length: 8.40, average data length: 0.60
Clustering factor: 774760, ratio: 0.16
Fill distribution:
0 - 19% = 4
20 - 39% = 132
40 - 59% = 2932
60 - 79% = 1805
80 - 99% = 786
XQS_2000_3300 (269)
Primary pointer page: 821, Index root page: 822
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_DOC_ID (0)
Root page: 823, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_RCV_ID (2)
Root page: 825, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_SND_ID (1)
Root page: 824, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQS_2100_3300 (270)
Primary pointer page: 826, Index root page: 827
Total formats: 1, used formats: 1
Average record length: 83.44, total records: 3396064
Average version length: 84.06, total versions: 10201, 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: 33, data page slots: 52656
Data pages: 52656, average fill: 80%
Primary pages: 52656, secondary pages: 0, swept pages: 35160
Empty pages: 23, full pages: 51689
Fill distribution:
0 - 19% = 58
20 - 39% = 112
40 - 59% = 270
60 - 79% = 14987
80 - 99% = 37229
Index XQS_2100_3300_DOC_ID (0)
Root page: 92352, depth: 3, leaf buckets: 3754, nodes: 3396064
Average node length: 5.02, total dup: 3379857, max dup: 1431
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 604875, ratio: 0.18
Fill distribution:
0 - 19% = 20
20 - 39% = 453
40 - 59% = 2052
60 - 79% = 815
80 - 99% = 414
Index XQS_2100_3300_RCV_ID (2)
Root page: 110525, depth: 3, leaf buckets: 5117, nodes: 3396064
Average node length: 6.27, total dup: 2765001, max dup: 14
Average key length: 3.29, compression ratio: 2.74
Average prefix length: 7.89, average data length: 1.11
Clustering factor: 267675, ratio: 0.08
Fill distribution:
0 - 19% = 125
20 - 39% = 1645
40 - 59% = 1748
60 - 79% = 889
80 - 99% = 710
Index XQS_2100_3300_SND_ID (1)
Root page: 77842, depth: 3, leaf buckets: 4122, nodes: 3396064
Average node length: 5.57, total dup: 3104420, max dup: 59
Average key length: 2.59, compression ratio: 3.47
Average prefix length: 8.49, average data length: 0.51
Clustering factor: 654445, ratio: 0.19
Fill distribution:
0 - 19% = 20
20 - 39% = 485
40 - 59% = 2141
60 - 79% = 1003
80 - 99% = 473
XQS_3300_3400 (271)
Primary pointer page: 831, Index root page: 832
Total formats: 1, used formats: 1
Average record length: 69.34, total records: 575029
Average version length: 69.69, total versions: 1346, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.96
Pointer pages: 5, data page slots: 7944
Data pages: 7944, average fill: 77%
Primary pages: 7944, secondary pages: 0, swept pages: 6162
Empty pages: 7, full pages: 7662
Fill distribution:
0 - 19% = 14
20 - 39% = 32
40 - 59% = 73
60 - 79% = 7791
80 - 99% = 34
Index XQS_3300_3400_DOC_ID (0)
Root page: 222767, depth: 3, leaf buckets: 695, nodes: 575029
Average node length: 5.34, total dup: 538952, max dup: 119
Average key length: 2.48, compression ratio: 3.63
Average prefix length: 8.59, average data length: 0.41
Clustering factor: 52151, ratio: 0.09
Fill distribution:
0 - 19% = 3
20 - 39% = 151
40 - 59% = 306
60 - 79% = 163
80 - 99% = 72
Index XQS_3300_3400_SND_ID (1)
Root page: 163039, depth: 3, leaf buckets: 779, nodes: 575029
Average node length: 5.93, total dup: 489370, max dup: 14
Average key length: 3.07, compression ratio: 2.93
Average prefix length: 8.08, average data length: 0.92
Clustering factor: 54146, ratio: 0.09
Fill distribution:
0 - 19% = 3
20 - 39% = 170
40 - 59% = 343
60 - 79% = 184
80 - 99% = 79
ZDOC_DATA (230)
Primary pointer page: 674, Index root page: 675
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZDOC_LIST (229)
Primary pointer page: 672, Index root page: 673
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZINVNT_TURNOVER_LOG (231)
Primary pointer page: 676, Index root page: 677
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPDISTR (234)
Primary pointer page: 682, Index root page: 683
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPDISTR_ID (0)
Root page: 692, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPSTORNED (235)
Primary pointer page: 684, Index root page: 685
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPSTORNED_ID (0)
Root page: 693, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQDISTR (232)
Primary pointer page: 678, Index root page: 679
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_ID (0)
Root page: 686, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Root page: 687, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQSTORNED (233)
Primary pointer page: 680, Index root page: 681
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_DOC_ID (1)
Root page: 689, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_ID (0)
Root page: 688, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_RCV_ID (3)
Root page: 691, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_SND_ID (2)
Root page: 690, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_DEP_DOCS (228)
Primary pointer page: 622, Index root page: 623
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_SHOPPING_CART (227)
Primary pointer page: 620, Index root page: 621
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Z_USED_VIEWS (146)
Primary pointer page: 271, Index root page: 272
Total formats: 1, used formats: 1
Average record length: 29.38, total records: 29
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 99.00, compression ratio: 3.37
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 16%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index Z_USED_VIEWS_UNQ (0)
Root page: 284, depth: 1, leaf buckets: 1, nodes: 29
Average node length: 15.17, total dup: 0, max dup: 0
Average key length: 14.14, compression ratio: 1.44
Average prefix length: 9.17, average data length: 11.17
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Done for 74960 ms, from 11:43:24.04 to 11:44:39.00.
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
VERS_PERCENT |
AGENTS |
50 |
0 |
0.0000 |
BUSINESS_OPS |
19 |
0 |
0.0000 |
DOC_DATA |
2141947 |
1505 |
0.0702 |
DOC_LIST |
664657 |
475 |
0.0714 |
DOC_STATES |
4 |
0 |
0.0000 |
FB_ERRORS |
758 |
0 |
0.0000 |
INVNT_SALDO |
400 |
7508 |
1877.0000 |
INVNT_TURNOVER_LOG |
7703 |
6293 |
81.6954 |
MONEY_SALDO |
49 |
0 |
0.0000 |
MONEY_TURNOVER_LOG |
132 |
0 |
0.0000 |
OPTYPES |
9 |
0 |
0.0000 |
PDISTR |
723282 |
731 |
0.1010 |
PERF_ESTIMATED |
269672 |
0 |
0.0000 |
PERF_LOG |
13607350 |
0 |
0.0000 |
PSTORNED |
461373 |
399 |
0.0864 |
RULES_FOR_PDISTR |
4 |
0 |
0.0000 |
RULES_FOR_QDISTR |
7 |
0 |
0.0000 |
SEMAPHORES |
4 |
29 |
725.0000 |
SETTINGS |
114 |
0 |
0.0000 |
TRACE_STAT |
2806 |
0 |
0.0000 |
WARES |
400 |
0 |
0.0000 |
WARE_GROUPS |
8 |
0 |
0.0000 |
XQD_1000_1200 |
7248 |
4170 |
57.5331 |
XQD_1000_3300 |
733258 |
3812 |
0.5198 |
XQD_1200_2000 |
103450 |
7977 |
7.7109 |
XQD_2000_3300 |
2614933 |
15655 |
0.5986 |
XQD_2100_3300 |
4627441 |
2646 |
0.0571 |
XQD_3300_3400 |
3268244 |
9893 |
0.3027 |
XQS_1000_1200 |
4682588 |
496 |
0.0105 |
XQS_1000_3300 |
2784303 |
9853 |
0.3538 |
XQS_1200_2000 |
4958720 |
4019 |
0.0810 |
XQS_2100_3300 |
3396064 |
10201 |
0.3003 |
XQS_3300_3400 |
575029 |
1346 |
0.2340 |
Z_USED_VIEWS |
29 |
0 |
0.0000 |
Done for 2150 ms, from 11:44:50.33 to 11:44:52.48.
11:44:52.57 Validation started
11:44:52.60 Relation 140 (DOC_LIST)
11:44:52.60 process pointer page 0 of 6
11:44:52.65 process pointer page 1 of 6
11:44:52.68 process pointer page 2 of 6
11:44:52.76 process pointer page 3 of 6
11:44:52.81 process pointer page 4 of 6
11:44:52.84 process pointer page 5 of 6
11:44:52.85 Index 1 (PK_DOC_LIST)
11:44:52.95 Index 2 (DOC_LIST_ID_DESC)
11:44:53.04 Index 3 (FK_DOC_LIST_AGENTS)
11:44:53.13 Relation 140 (DOC_LIST) is ok
11:44:53.13 Relation 141 (DOC_DATA)
11:44:53.13 process pointer page 0 of 15
11:44:53.16 process pointer page 1 of 15
11:44:53.20 process pointer page 2 of 15
11:44:53.23 process pointer page 3 of 15
11:44:53.26 process pointer page 4 of 15
11:44:53.29 process pointer page 5 of 15
11:44:53.32 process pointer page 6 of 15
11:44:53.35 process pointer page 7 of 15
11:44:53.38 process pointer page 8 of 15
11:44:53.45 process pointer page 9 of 15
11:44:53.54 process pointer page 10 of 15
11:44:53.62 process pointer page 11 of 15
11:44:53.71 process pointer page 12 of 15
11:44:53.84 process pointer page 13 of 15
11:44:53.91 process pointer page 14 of 15
11:44:53.91 Index 2 (DOC_DATA_DOC_WARE_UNQ)
11:44:54.57 Index 3 (DOC_DATA_ID_DESC)
11:44:55.15 Index 4 (FK_DOC_DATA_DOC_LIST)
11:44:55.60 Relation 141 (DOC_DATA) is ok
11:44:55.60 Relation 147 (INVNT_SALDO)
11:44:55.60 process pointer page 0 of 1
11:44:55.61 Index 1 (PK_INVNT_SALDO)
11:44:55.61 Relation 147 (INVNT_SALDO) is ok
11:44:55.61 Relation 150 (PDISTR)
11:44:55.61 process pointer page 0 of 3
11:44:55.69 process pointer page 1 of 3
11:44:55.79 process pointer page 2 of 3
11:44:55.83 Index 2 (PDISTR_SND_ID)
11:44:55.91 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
11:44:55.93 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
11:44:55.96 Index 5 (PDISTR_AGENT_ID)
11:44:55.99 Relation 150 (PDISTR) is ok
11:44:55.99 Relation 151 (PSTORNED)
11:44:55.99 process pointer page 0 of 4
11:44:56.07 process pointer page 1 of 4
11:44:56.13 process pointer page 2 of 4
11:44:56.18 process pointer page 3 of 4
11:44:56.21 Index 2 (PSTORNED_SND_ID)
11:44:56.27 Index 3 (PSTORNED_RCV_ID)
11:44:56.35 Relation 151 (PSTORNED) is ok
11:44:56.35 Relation 156 (SEMAPHORES)
11:44:56.35 process pointer page 0 of 1
11:44:56.35 Index 1 (PK_SEMAPHORES)
11:44:56.35 Index 2 (SEMAPHORES_TASK_UNQ)
11:44:56.35 Relation 156 (SEMAPHORES) is ok
11:44:56.35 Relation 157 (INVNT_TURNOVER_LOG)
11:44:56.35 process pointer page 0 of 1
11:44:56.36 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
11:44:56.36 Relation 157 (INVNT_TURNOVER_LOG) is ok
11:44:56.36 Relation 160 (PERF_ESTIMATED)
11:44:56.36 process pointer page 0 of 2
11:44:56.39 process pointer page 1 of 2
11:44:56.41 Index 1 (PERF_EST_MINUTE_SINCE_START)
11:44:56.44 Relation 160 (PERF_ESTIMATED) is ok
11:44:56.44 Relation 161 (PERF_ISQL_STAT)
11:44:56.44 process pointer page 0 of 1
11:44:56.44 Index 1 (PERF_ISQL_STAT_TRN)
11:44:56.44 Relation 161 (PERF_ISQL_STAT) is ok
11:44:56.44 Relation 162 (TRACE_STAT)
11:44:56.44 process pointer page 0 of 1
11:44:56.44 Relation 162 (TRACE_STAT) is ok
11:44:56.44 Relation 163 (PERF_LOG)
11:44:56.44 process pointer page 0 of 199
11:44:56.52 process pointer page 1 of 199
11:44:56.60 process pointer page 2 of 199
11:44:56.63 process pointer page 3 of 199
11:44:56.67 process pointer page 4 of 199
11:44:56.71 process pointer page 5 of 199
11:44:56.74 process pointer page 6 of 199
11:44:56.77 process pointer page 7 of 199
11:44:56.78 process pointer page 8 of 199
11:44:56.83 process pointer page 9 of 199
11:44:56.92 process pointer page 10 of 199
11:44:56.97 process pointer page 11 of 199
11:44:57.00 process pointer page 12 of 199
11:44:57.03 process pointer page 13 of 199
11:44:57.06 process pointer page 14 of 199
11:44:57.10 process pointer page 15 of 199
11:44:57.13 process pointer page 16 of 199
11:44:57.14 process pointer page 17 of 199
11:44:57.17 process pointer page 18 of 199
11:44:57.22 process pointer page 19 of 199
11:44:57.30 process pointer page 20 of 199
11:44:57.33 process pointer page 21 of 199
11:44:57.39 process pointer page 22 of 199
11:44:57.47 process pointer page 23 of 199
11:44:57.55 process pointer page 24 of 199
11:44:57.61 process pointer page 25 of 199
11:44:57.64 process pointer page 26 of 199
11:44:57.70 process pointer page 27 of 199
11:44:57.78 process pointer page 28 of 199
11:44:57.86 process pointer page 29 of 199
11:44:57.94 process pointer page 30 of 199
11:44:58.03 process pointer page 31 of 199
11:44:58.11 process pointer page 32 of 199
11:44:58.16 process pointer page 33 of 199
11:44:58.19 process pointer page 34 of 199
11:44:58.22 process pointer page 35 of 199
11:44:58.25 process pointer page 36 of 199
11:44:58.28 process pointer page 37 of 199
11:44:58.31 process pointer page 38 of 199
11:44:58.34 process pointer page 39 of 199
11:44:58.37 process pointer page 40 of 199
11:44:58.39 process pointer page 41 of 199
11:44:58.42 process pointer page 42 of 199
11:44:58.45 process pointer page 43 of 199
11:44:58.47 process pointer page 44 of 199
11:44:58.50 process pointer page 45 of 199
11:44:58.52 process pointer page 46 of 199
11:44:58.53 process pointer page 47 of 199
11:44:58.56 process pointer page 48 of 199
11:44:58.58 process pointer page 49 of 199
11:44:58.61 process pointer page 50 of 199
11:44:58.62 process pointer page 51 of 199
11:44:58.66 process pointer page 52 of 199
11:44:58.67 process pointer page 53 of 199
11:44:58.69 process pointer page 54 of 199
11:44:58.72 process pointer page 55 of 199
11:44:58.75 process pointer page 56 of 199
11:44:58.81 process pointer page 57 of 199
11:44:58.89 process pointer page 58 of 199
11:44:58.97 process pointer page 59 of 199
11:44:59.00 process pointer page 60 of 199
11:44:59.03 process pointer page 61 of 199
11:44:59.06 process pointer page 62 of 199
11:44:59.09 process pointer page 63 of 199
11:44:59.12 process pointer page 64 of 199
11:44:59.14 process pointer page 65 of 199
11:44:59.17 process pointer page 66 of 199
11:44:59.20 process pointer page 67 of 199
11:44:59.22 process pointer page 68 of 199
11:44:59.25 process pointer page 69 of 199
11:44:59.28 process pointer page 70 of 199
11:44:59.31 process pointer page 71 of 199
11:44:59.39 process pointer page 72 of 199
11:44:59.47 process pointer page 73 of 199
11:44:59.51 process pointer page 74 of 199
11:44:59.54 process pointer page 75 of 199
11:44:59.58 process pointer page 76 of 199
11:44:59.64 process pointer page 77 of 199
11:44:59.72 process pointer page 78 of 199
11:44:59.75 process pointer page 79 of 199
11:44:59.79 process pointer page 80 of 199
11:44:59.87 process pointer page 81 of 199
11:44:59.95 process pointer page 82 of 199
11:45:00.04 process pointer page 83 of 199
11:45:00.12 process pointer page 84 of 199
11:45:00.20 process pointer page 85 of 199
11:45:00.28 process pointer page 86 of 199
11:45:00.36 process pointer page 87 of 199
11:45:00.39 process pointer page 88 of 199
11:45:00.42 process pointer page 89 of 199
11:45:00.45 process pointer page 90 of 199
11:45:00.48 process pointer page 91 of 199
11:45:00.51 process pointer page 92 of 199
11:45:00.53 process pointer page 93 of 199
11:45:00.56 process pointer page 94 of 199
11:45:00.59 process pointer page 95 of 199
11:45:00.61 process pointer page 96 of 199
11:45:00.64 process pointer page 97 of 199
11:45:00.67 process pointer page 98 of 199
11:45:00.68 process pointer page 99 of 199
11:45:00.71 process pointer page 100 of 199
11:45:00.79 process pointer page 101 of 199
11:45:00.82 process pointer page 102 of 199
11:45:00.86 process pointer page 103 of 199
11:45:00.89 process pointer page 104 of 199
11:45:00.95 process pointer page 105 of 199
11:45:01.01 process pointer page 106 of 199
11:45:01.04 process pointer page 107 of 199
11:45:01.07 process pointer page 108 of 199
11:45:01.12 process pointer page 109 of 199
11:45:01.20 process pointer page 110 of 199
11:45:01.23 process pointer page 111 of 199
11:45:01.26 process pointer page 112 of 199
11:45:01.29 process pointer page 113 of 199
11:45:01.32 process pointer page 114 of 199
11:45:01.35 process pointer page 115 of 199
11:45:01.39 process pointer page 116 of 199
11:45:01.40 process pointer page 117 of 199
11:45:01.43 process pointer page 118 of 199
11:45:01.46 process pointer page 119 of 199
11:45:01.48 process pointer page 120 of 199
11:45:01.51 process pointer page 121 of 199
11:45:01.54 process pointer page 122 of 199
11:45:01.56 process pointer page 123 of 199
11:45:01.57 process pointer page 124 of 199
11:45:01.60 process pointer page 125 of 199
11:45:01.62 process pointer page 126 of 199
11:45:01.65 process pointer page 127 of 199
11:45:01.67 process pointer page 128 of 199
11:45:01.70 process pointer page 129 of 199
11:45:01.71 process pointer page 130 of 199
11:45:01.74 process pointer page 131 of 199
11:45:01.78 process pointer page 132 of 199
11:45:01.81 process pointer page 133 of 199
11:45:01.84 process pointer page 134 of 199
11:45:01.90 process pointer page 135 of 199
11:45:01.98 process pointer page 136 of 199
11:45:02.06 process pointer page 137 of 199
11:45:02.12 process pointer page 138 of 199
11:45:02.15 process pointer page 139 of 199
11:45:02.18 process pointer page 140 of 199
11:45:02.21 process pointer page 141 of 199
11:45:02.24 process pointer page 142 of 199
11:45:02.27 process pointer page 143 of 199
11:45:02.29 process pointer page 144 of 199
11:45:02.32 process pointer page 145 of 199
11:45:02.35 process pointer page 146 of 199
11:45:02.38 process pointer page 147 of 199
11:45:02.40 process pointer page 148 of 199
11:45:02.43 process pointer page 149 of 199
11:45:02.46 process pointer page 150 of 199
11:45:02.48 process pointer page 151 of 199
11:45:02.51 process pointer page 152 of 199
11:45:02.52 process pointer page 153 of 199
11:45:02.54 process pointer page 154 of 199
11:45:02.57 process pointer page 155 of 199
11:45:02.59 process pointer page 156 of 199
11:45:02.62 process pointer page 157 of 199
11:45:02.63 process pointer page 158 of 199
11:45:02.66 process pointer page 159 of 199
11:45:02.70 process pointer page 160 of 199
11:45:02.73 process pointer page 161 of 199
11:45:02.76 process pointer page 162 of 199
11:45:02.79 process pointer page 163 of 199
11:45:02.85 process pointer page 164 of 199
11:45:02.93 process pointer page 165 of 199
11:45:03.01 process pointer page 166 of 199
11:45:03.09 process pointer page 167 of 199
11:45:03.16 process pointer page 168 of 199
11:45:03.24 process pointer page 169 of 199
11:45:03.30 process pointer page 170 of 199
11:45:03.34 process pointer page 171 of 199
11:45:03.37 process pointer page 172 of 199
11:45:03.40 process pointer page 173 of 199
11:45:03.48 process pointer page 174 of 199
11:45:03.52 process pointer page 175 of 199
11:45:03.55 process pointer page 176 of 199
11:45:03.59 process pointer page 177 of 199
11:45:03.62 process pointer page 178 of 199
11:45:03.65 process pointer page 179 of 199
11:45:03.68 process pointer page 180 of 199
11:45:03.71 process pointer page 181 of 199
11:45:03.74 process pointer page 182 of 199
11:45:03.77 process pointer page 183 of 199
11:45:03.80 process pointer page 184 of 199
11:45:03.82 process pointer page 185 of 199
11:45:03.85 process pointer page 186 of 199
11:45:03.87 process pointer page 187 of 199
11:45:03.90 process pointer page 188 of 199
11:45:03.91 process pointer page 189 of 199
11:45:03.94 process pointer page 190 of 199
11:45:03.96 process pointer page 191 of 199
11:45:03.99 process pointer page 192 of 199
11:45:04.02 process pointer page 193 of 199
11:45:04.04 process pointer page 194 of 199
11:45:04.07 process pointer page 195 of 199
11:45:04.08 process pointer page 196 of 199
11:45:04.12 process pointer page 197 of 199
11:45:04.13 process pointer page 198 of 199
11:45:04.15 Index 1 (PERF_LOG_DTS_BEG_DESC)
11:45:06.17 Index 2 (PERF_LOG_UNIT)
11:45:09.75 Index 3 (PERF_LOG_TRN_DESC)
11:45:12.68 Index 4 (PERF_LOG_GDSCODE)
11:45:14.43 Relation 163 (PERF_LOG) is ok
11:45:14.43 Relation 167 (V_STOPTEST)
11:45:14.43 Relation 167 (V_STOPTEST) is ok
11:45:14.43 Relation 184 (V_QDISTR_SOURCE)
11:45:14.43 Relation 184 (V_QDISTR_SOURCE) is ok
11:45:14.43 Relation 185 (V_QSTORNED_SOURCE)
11:45:14.43 Relation 185 (V_QSTORNED_SOURCE) is ok
11:45:14.43 Relation 260 (XQD_1000_1200)
11:45:14.43 process pointer page 0 of 1
11:45:14.43 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
11:45:14.44 Relation 260 (XQD_1000_1200) is ok
11:45:14.44 Relation 261 (XQD_1200_2000)
11:45:14.44 process pointer page 0 of 2
11:45:14.46 process pointer page 1 of 2
11:45:14.47 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
11:45:14.47 Relation 261 (XQD_1200_2000) is ok
11:45:14.47 Relation 262 (XQD_1000_3300)
11:45:14.47 process pointer page 0 of 7
11:45:14.51 process pointer page 1 of 7
11:45:14.54 process pointer page 2 of 7
11:45:14.57 process pointer page 3 of 7
11:45:14.60 process pointer page 4 of 7
11:45:14.61 process pointer page 5 of 7
11:45:14.65 process pointer page 6 of 7
11:45:14.66 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
11:45:14.74 Index 2 (XQD_1000_3300_DOC)
11:45:14.80 Relation 262 (XQD_1000_3300) is ok
11:45:14.80 Relation 263 (XQD_2000_3300)
11:45:14.80 process pointer page 0 of 20
11:45:14.82 process pointer page 1 of 20
11:45:14.85 process pointer page 2 of 20
11:45:14.88 process pointer page 3 of 20
11:45:14.91 process pointer page 4 of 20
11:45:14.93 process pointer page 5 of 20
11:45:14.96 process pointer page 6 of 20
11:45:14.97 process pointer page 7 of 20
11:45:15.00 process pointer page 8 of 20
11:45:15.02 process pointer page 9 of 20
11:45:15.05 process pointer page 10 of 20
11:45:15.08 process pointer page 11 of 20
11:45:15.10 process pointer page 12 of 20
11:45:15.13 process pointer page 13 of 20
11:45:15.14 process pointer page 14 of 20
11:45:15.18 process pointer page 15 of 20
11:45:15.19 process pointer page 16 of 20
11:45:15.24 process pointer page 17 of 20
11:45:15.27 process pointer page 18 of 20
11:45:15.30 process pointer page 19 of 20
11:45:15.32 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
11:45:15.52 Relation 263 (XQD_2000_3300) is ok
11:45:15.52 Relation 264 (XQD_2100_3300)
11:45:15.52 process pointer page 0 of 18
11:45:15.60 process pointer page 1 of 18
11:45:15.66 process pointer page 2 of 18
11:45:15.72 process pointer page 3 of 18
11:45:15.78 process pointer page 4 of 18
11:45:15.82 process pointer page 5 of 18
11:45:15.83 process pointer page 6 of 18
11:45:15.88 process pointer page 7 of 18
11:45:15.94 process pointer page 8 of 18
11:45:16.00 process pointer page 9 of 18
11:45:16.07 process pointer page 10 of 18
11:45:16.11 process pointer page 11 of 18
11:45:16.14 process pointer page 12 of 18
11:45:16.17 process pointer page 13 of 18
11:45:16.19 process pointer page 14 of 18
11:45:16.22 process pointer page 15 of 18
11:45:16.25 process pointer page 16 of 18
11:45:16.27 process pointer page 17 of 18
11:45:16.30 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
11:45:16.30 Relation 264 (XQD_2100_3300) is ok
11:45:16.30 Relation 265 (XQD_3300_3400)
11:45:16.30 process pointer page 0 of 26
11:45:16.36 process pointer page 1 of 26
11:45:16.42 process pointer page 2 of 26
11:45:16.46 process pointer page 3 of 26
11:45:16.49 process pointer page 4 of 26
11:45:16.55 process pointer page 5 of 26
11:45:16.61 process pointer page 6 of 26
11:45:16.66 process pointer page 7 of 26
11:45:16.69 process pointer page 8 of 26
11:45:16.75 process pointer page 9 of 26
11:45:16.83 process pointer page 10 of 26
11:45:16.86 process pointer page 11 of 26
11:45:16.89 process pointer page 12 of 26
11:45:16.92 process pointer page 13 of 26
11:45:16.95 process pointer page 14 of 26
11:45:16.99 process pointer page 15 of 26
11:45:17.05 process pointer page 16 of 26
11:45:17.13 process pointer page 17 of 26
11:45:17.17 process pointer page 18 of 26
11:45:17.24 process pointer page 19 of 26
11:45:17.31 process pointer page 20 of 26
11:45:17.34 process pointer page 21 of 26
11:45:17.39 process pointer page 22 of 26
11:45:17.42 process pointer page 23 of 26
11:45:17.45 process pointer page 24 of 26
11:45:17.48 process pointer page 25 of 26
11:45:17.52 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
11:45:18.11 Relation 265 (XQD_3300_3400) is ok
11:45:18.11 Relation 266 (XQS_1000_1200)
11:45:18.12 process pointer page 0 of 45
11:45:18.16 process pointer page 1 of 45
11:45:18.25 process pointer page 2 of 45
11:45:18.30 process pointer page 3 of 45
11:45:18.33 process pointer page 4 of 45
11:45:18.36 process pointer page 5 of 45
11:45:18.41 process pointer page 6 of 45
11:45:18.44 process pointer page 7 of 45
11:45:18.45 process pointer page 8 of 45
11:45:18.48 process pointer page 9 of 45
11:45:18.51 process pointer page 10 of 45
11:45:18.55 process pointer page 11 of 45
11:45:18.59 process pointer page 12 of 45
11:45:18.65 process pointer page 13 of 45
11:45:18.72 process pointer page 14 of 45
11:45:18.76 process pointer page 15 of 45
11:45:18.86 process pointer page 16 of 45
11:45:18.92 process pointer page 17 of 45
11:45:18.95 process pointer page 18 of 45
11:45:18.98 process pointer page 19 of 45
11:45:19.04 process pointer page 20 of 45
11:45:19.14 process pointer page 21 of 45
11:45:19.23 process pointer page 22 of 45
11:45:19.31 process pointer page 23 of 45
11:45:19.40 process pointer page 24 of 45
11:45:19.50 process pointer page 25 of 45
11:45:19.56 process pointer page 26 of 45
11:45:19.61 process pointer page 27 of 45
11:45:19.64 process pointer page 28 of 45
11:45:19.68 process pointer page 29 of 45
11:45:19.78 process pointer page 30 of 45
11:45:19.82 process pointer page 31 of 45
11:45:19.86 process pointer page 32 of 45
11:45:19.90 process pointer page 33 of 45
11:45:19.97 process pointer page 34 of 45
11:45:20.03 process pointer page 35 of 45
11:45:20.07 process pointer page 36 of 45
11:45:20.12 process pointer page 37 of 45
11:45:20.17 process pointer page 38 of 45
11:45:20.20 process pointer page 39 of 45
11:45:20.28 process pointer page 40 of 45
11:45:20.32 process pointer page 41 of 45
11:45:20.39 process pointer page 42 of 45
11:45:20.48 process pointer page 43 of 45
11:45:20.56 process pointer page 44 of 45
11:45:20.56 Index 1 (XQS_1000_1200_DOC_ID)
11:45:21.34 Index 2 (XQS_1000_1200_SND_ID)
11:45:21.77 Index 3 (XQS_1000_1200_RCV_ID)
11:45:22.57 Relation 266 (XQS_1000_1200) is ok
11:45:22.57 Relation 267 (XQS_1200_2000)
11:45:22.57 process pointer page 0 of 47
11:45:22.66 process pointer page 1 of 47
11:45:22.76 process pointer page 2 of 47
11:45:22.79 process pointer page 3 of 47
11:45:22.84 process pointer page 4 of 47
11:45:22.88 process pointer page 5 of 47
11:45:22.91 process pointer page 6 of 47
11:45:22.94 process pointer page 7 of 47
11:45:23.04 process pointer page 8 of 47
11:45:23.09 process pointer page 9 of 47
11:45:23.12 process pointer page 10 of 47
11:45:23.16 process pointer page 11 of 47
11:45:23.21 process pointer page 12 of 47
11:45:23.24 process pointer page 13 of 47
11:45:23.32 process pointer page 14 of 47
11:45:23.38 process pointer page 15 of 47
11:45:23.43 process pointer page 16 of 47
11:45:23.46 process pointer page 17 of 47
11:45:23.51 process pointer page 18 of 47
11:45:23.62 process pointer page 19 of 47
11:45:23.65 process pointer page 20 of 47
11:45:23.69 process pointer page 21 of 47
11:45:23.72 process pointer page 22 of 47
11:45:23.77 process pointer page 23 of 47
11:45:23.80 process pointer page 24 of 47
11:45:23.83 process pointer page 25 of 47
11:45:23.88 process pointer page 26 of 47
11:45:23.97 process pointer page 27 of 47
11:45:24.04 process pointer page 28 of 47
11:45:24.08 process pointer page 29 of 47
11:45:24.13 process pointer page 30 of 47
11:45:24.18 process pointer page 31 of 47
11:45:24.21 process pointer page 32 of 47
11:45:24.27 process pointer page 33 of 47
11:45:24.38 process pointer page 34 of 47
11:45:24.43 process pointer page 35 of 47
11:45:24.50 process pointer page 36 of 47
11:45:24.60 process pointer page 37 of 47
11:45:24.65 process pointer page 38 of 47
11:45:24.69 process pointer page 39 of 47
11:45:24.77 process pointer page 40 of 47
11:45:24.83 process pointer page 41 of 47
11:45:24.88 process pointer page 42 of 47
11:45:24.91 process pointer page 43 of 47
11:45:24.96 process pointer page 44 of 47
11:45:24.99 process pointer page 45 of 47
11:45:25.02 process pointer page 46 of 47
11:45:25.04 Index 1 (XQS_1200_2000_DOC_ID)
11:45:25.57 Index 2 (XQS_1200_2000_SND_ID)
11:45:26.75 Index 3 (XQS_1200_2000_RCV_ID)
11:45:27.41 Relation 267 (XQS_1200_2000) is ok
11:45:27.41 Relation 268 (XQS_1000_3300)
11:45:27.41 process pointer page 0 of 27
11:45:27.83 process pointer page 1 of 27
11:45:28.31 process pointer page 2 of 27
11:45:28.79 process pointer page 3 of 27
11:45:29.28 process pointer page 4 of 27
11:45:29.59 process pointer page 5 of 27
11:45:29.87 process pointer page 6 of 27
11:45:30.14 process pointer page 7 of 27
11:45:30.40 process pointer page 8 of 27
11:45:30.65 process pointer page 9 of 27
11:45:30.95 process pointer page 10 of 27
11:45:31.26 process pointer page 11 of 27
11:45:31.57 process pointer page 12 of 27
11:45:31.90 process pointer page 13 of 27
11:45:32.20 process pointer page 14 of 27
11:45:32.52 process pointer page 15 of 27
11:45:32.84 process pointer page 16 of 27
11:45:33.24 process pointer page 17 of 27
11:45:33.69 process pointer page 18 of 27
11:45:34.13 process pointer page 19 of 27
11:45:34.58 process pointer page 20 of 27
11:45:34.96 process pointer page 21 of 27
11:45:35.27 process pointer page 22 of 27
11:45:35.58 process pointer page 23 of 27
11:45:35.89 process pointer page 24 of 27
11:45:36.17 process pointer page 25 of 27
11:45:36.49 process pointer page 26 of 27
11:45:36.64 Index 1 (XQS_1000_3300_DOC_ID)
11:45:37.92 Index 2 (XQS_1000_3300_SND_ID)
11:45:39.39 Index 3 (XQS_1000_3300_RCV_ID)
11:45:41.09 Relation 268 (XQS_1000_3300) is ok
11:45:41.09 Relation 269 (XQS_2000_3300)
11:45:41.09 process pointer page 0 of 1
11:45:41.09 Index 1 (XQS_2000_3300_DOC_ID)
11:45:41.09 Index 2 (XQS_2000_3300_SND_ID)
11:45:41.09 Index 3 (XQS_2000_3300_RCV_ID)
11:45:41.09 Relation 269 (XQS_2000_3300) is ok
11:45:41.09 Relation 270 (XQS_2100_3300)
11:45:41.09 process pointer page 0 of 33
11:45:41.54 process pointer page 1 of 33
11:45:42.01 process pointer page 2 of 33
11:45:42.48 process pointer page 3 of 33
11:45:42.94 process pointer page 4 of 33
11:45:43.29 process pointer page 5 of 33
11:45:43.74 process pointer page 6 of 33
11:45:44.19 process pointer page 7 of 33
11:45:44.64 process pointer page 8 of 33
11:45:45.10 process pointer page 9 of 33
11:45:45.53 process pointer page 10 of 33
11:45:45.99 process pointer page 11 of 33
11:45:46.39 process pointer page 12 of 33
11:45:46.81 process pointer page 13 of 33
11:45:47.23 process pointer page 14 of 33
11:45:47.64 process pointer page 15 of 33
11:45:48.06 process pointer page 16 of 33
11:45:48.44 process pointer page 17 of 33
11:45:48.78 process pointer page 18 of 33
11:45:49.15 process pointer page 19 of 33
11:45:49.56 process pointer page 20 of 33
11:45:50.04 process pointer page 21 of 33
11:45:50.49 process pointer page 22 of 33
11:45:50.95 process pointer page 23 of 33
11:45:51.41 process pointer page 24 of 33
11:45:51.85 process pointer page 25 of 33
11:45:52.27 process pointer page 26 of 33
11:45:52.69 process pointer page 27 of 33
11:45:53.12 process pointer page 28 of 33
11:45:53.51 process pointer page 29 of 33
11:45:53.91 process pointer page 30 of 33
11:45:54.32 process pointer page 31 of 33
11:45:54.72 process pointer page 32 of 33
11:45:54.80 Index 1 (XQS_2100_3300_DOC_ID)
11:45:56.42 Index 2 (XQS_2100_3300_SND_ID)
11:45:58.23 Index 3 (XQS_2100_3300_RCV_ID)
11:45:59.87 Relation 270 (XQS_2100_3300) is ok
11:45:59.87 Relation 271 (XQS_3300_3400)
11:45:59.87 process pointer page 0 of 5
11:46:00.26 process pointer page 1 of 5
11:46:00.71 process pointer page 2 of 5
11:46:01.13 process pointer page 3 of 5
11:46:01.57 process pointer page 4 of 5
11:46:01.96 Index 1 (XQS_3300_3400_DOC_ID)
11:46:02.29 Index 2 (XQS_3300_3400_SND_ID)
11:46:02.63 Relation 271 (XQS_3300_3400) is ok
11:46:02.66 Validation finished
Done for 70250 ms, from 11:44:52.49 to 11:46:02.74.
Differences between old and current firebird.log
11:46:04.94. 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:
2017-11-04 11:46 477 oltp40_fb_log_when_test_finished.log
End of gathering firebird.log AFTER test finish.
+++ Start of comparison +++
Comparing files E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
***** 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 Sat Nov 04 11:44:52 2017
7: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Sat Nov 04 11:46:02 2017
12: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++
Remove 401 logs of every ISQL session if there were no serious errors.
Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp40\oltp40_*.*:
ERRORS_CHECKING_RESULT |
NO_SEVERE_ERRORS_FOUND |
ISQL logs are removed because no severe errors occured during test.
2017-11-04 11:46:12.07 - end of report, text file: e:\temp\logs.oltp40\oltp40.report.txt, html: e:\temp\logs.oltp40\oltp40.report.html