Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2016-04-13 6:58:25.95.
Server version: WI-V3.0.0.32474 Firebird 3.0
Server implementation: Firebird/Windows/AMD/Intel/x64
FB_ARCHITECTURE |
DB_NAME |
FORCED_WRITES |
SWEEP_INT |
PAGE_BUFFERS |
PAGE_SIZE |
SuperServer 3.0.0 |
D:\OLTP-EMUL\OLTP30-SMALL.FDB |
ON |
0 |
786432 |
8192 |
Test configuration settings
File: E:\OLTP-EMUL\src\oltp30_config.win
PARAM_NAME |
PARAM_VALUE |
fbc |
E:\FB30.TMPINSTANCE |
dbnm |
D:\OLTP-EMUL\oltp30-small.fdb |
host |
localhost |
port |
3333 |
usr |
SYSDBA |
pwd |
masterkey |
tmpdir |
e:\temp\logs.oltp30 |
working_mode |
small_03 |
warm_time |
10 |
test_time |
180 |
idle_time |
0 |
use_mtee |
0 |
is_embed |
0 |
remove_isql_logs |
if_no_severe_errors |
no_auto_undo |
1 |
detailed_info |
0 |
mon_unit_perf |
0 |
trc_unit_perf |
1 |
init_buff |
32768 |
create_with_fw |
sync |
create_with_sweep |
0 |
wait_if_not_exists |
0 |
wait_after_create |
0 |
init_docs |
0 |
wait_for_copy |
0 |
create_with_debug_objects |
1 |
create_with_split_heavy_tabs |
1 |
create_with_separate_qdistr_idx |
0 |
create_with_compound_columns_order |
most_selective_first |
make_html |
1 |
run_db_statistics |
1 |
run_db_validation |
1 |
file_name_with_test_params |
regular |
file_name_this_host_info |
ak30 |
upload_report |
1 |
FINISH_STATE |
DTS_END |
FB_GDSCODE |
FB_MNEMONA |
STACK |
IP |
TRN_ID |
ATT_ID |
EXC_UNIT |
NORMAL: TEST_TIME EXPIRED. |
2016-04-13 06:56:05.6960 |
-1 |
<null> |
|
::1/53269 |
305887 |
4922 |
2 |
CATEGORY |
SETTING |
VAL |
COMMON |
TRACED_UNITS |
,, |
COMMON |
HALT_TEST_ON_ERRORS |
,CK, |
COMMON |
LOG_PK_VIOLATION |
0 |
COMMON |
QMISM_VERIFY_BITSET |
1 |
COMMON |
RECALC_IDX_MIN_INTERVAL |
15 |
COMMON |
ENABLE_RESERVES_WHEN_ADD_INVOICE |
1 |
COMMON |
ORDER_FOR_OUR_FIRM_PERCENT |
25 |
COMMON |
ENABLE_FILL_PHRASES |
0 |
COMMON |
RANDOM_SEEK_VIA_ROWS_LIMIT |
0 |
COMMON |
C_INVOICE_MIN_PURCHASE |
1000 |
COMMON |
C_INVOICE_MAX_PURCHASE |
2000 |
COMMON |
C_INVOICE_MIN_PROFIT_PRC |
35 |
COMMON |
C_INVOICE_MAX_PROFIT_PRC |
80 |
COMMON |
C_MIN_COST_TO_BE_SPLITTED |
1000 |
COMMON |
C_ROWS_TO_MULTIPLY |
10 |
COMMON |
C_PAYMENT_FROM_CLIENT_MIN_TOTAL |
1000 |
COMMON |
C_PAYMENT_FROM_CLIENT_MAX_TOTAL |
5000 |
COMMON |
C_PAYMENT_TO_SUPPLIER_MIN_TOTAL |
2000 |
COMMON |
C_PAYMENT_TO_SUPPLIER_MAX_TOTAL |
15000 |
COMMON |
BUILD_WITH_SPLIT_HEAVY_TABS |
1 |
COMMON |
BUILD_WITH_SEPAR_QDISTR_IDX |
0 |
COMMON |
BUILD_WITH_QD_COMPOUND_ORDR |
MOST_SELECTIVE_FIRST |
COMMON |
ENABLE_MON_QUERY |
0 |
SMALL_03 |
C_WARES_MAX_ID |
400 |
SMALL_03 |
C_CUSTOMER_DOC_MAX_ROWS |
10 |
SMALL_03 |
C_SUPPLIER_DOC_MAX_ROWS |
50 |
SMALL_03 |
C_CUSTOMER_DOC_MAX_QTY |
15 |
SMALL_03 |
C_SUPPLIER_DOC_MAX_QTY |
50 |
SMALL_03 |
C_NUMBER_OF_AGENTS |
50 |
TAB_NAME |
IDX_NAME |
IDX_KEY |
XQD_1000_1200 |
XQD_1000_1200_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_1000_3300 |
XQD_1000_3300_DOC |
DOC_ID |
XQD_1000_3300 |
XQD_1000_3300_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_1200_2000 |
XQD_1200_2000_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_2000_3300 |
XQD_2000_3300_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_2100_3300 |
XQD_2100_3300_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_3300_3400 |
XQD_3300_3400_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
Performance reports
ACTION |
AVG_TIMES_PER_MINUTE |
AVG_ELAPSED_MS |
SUCCESSFUL_TIMES_DONE |
JOB_BEG |
JOB_END |
*** OVERALL *** for 180 minutes: |
4431.17 |
8101 |
797611 |
2016-04-13 03:56 |
2016-04-13 06:56 |
customer order: creation |
350.71 |
1206 |
63128 |
2016-04-13 03:56 |
2016-04-13 06:56 |
customer order: refuse |
27.93 |
84 |
5027 |
2016-04-13 03:56 |
2016-04-13 06:56 |
order to supplier: creation |
89.50 |
8723 |
16110 |
2016-04-13 03:56 |
2016-04-13 06:56 |
order to supplier: removal |
1.94 |
89692 |
345 |
2016-04-13 03:56 |
2016-04-13 06:56 |
invoice (draft): creation |
90.22 |
13001 |
16240 |
2016-04-13 03:56 |
2016-04-13 06:56 |
invoice (draft): removal |
28.44 |
2704 |
5091 |
2016-04-13 03:56 |
2016-04-13 06:56 |
invoice accept: apply |
56.54 |
24394 |
10177 |
2016-04-13 03:56 |
2016-04-13 06:56 |
invoice accept: cancel |
13.34 |
5833 |
2402 |
2016-04-13 03:56 |
2016-04-13 06:56 |
customer reserve: creation |
2643.63 |
433 |
475854 |
2016-04-13 03:56 |
2016-04-13 06:56 |
customer reserve: removal |
653.57 |
173 |
117642 |
2016-04-13 03:56 |
2016-04-13 06:56 |
realization accept: apply |
161.82 |
401 |
29128 |
2016-04-13 03:56 |
2016-04-13 06:56 |
realization accept: cancel |
45.98 |
283 |
8277 |
2016-04-13 03:56 |
2016-04-13 06:56 |
payment from customer: creation |
116.71 |
383 |
21007 |
2016-04-13 03:56 |
2016-04-13 06:56 |
payment from customer: removal |
10.78 |
107 |
1941 |
2016-04-13 03:56 |
2016-04-13 06:56 |
payment to supplier: creation |
96.96 |
824 |
17453 |
2016-04-13 03:56 |
2016-04-13 06:56 |
payment to supplier: removal |
6.62 |
172 |
1192 |
2016-04-13 03:56 |
2016-04-13 06:56 |
service: total inventory turnovers |
16.21 |
1984 |
2918 |
2016-04-13 03:56 |
2016-04-13 06:56 |
service: total monetary turnovers |
20.38 |
109 |
3668 |
2016-04-13 03:56 |
2016-04-13 06:56 |
service: refresh index statistics |
0.07 |
3413 |
11 |
2016-04-13 03:56 |
2016-04-13 06:56 |
Done for 34320 ms, from 6:59:12.23 to 6:59:46.55.
ACTION |
ITRV_NO |
CNT_OK_PER_MINUTE |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
ITRV_BEG |
ITRV_END |
interval # 1, overall |
1 |
3276 |
63346 |
58959 |
4387 |
6.93 |
03:56:06 |
04:14:06 |
interval # 2, overall |
2 |
4223 |
80175 |
76021 |
4154 |
5.18 |
04:14:07 |
04:32:07 |
interval # 3, overall |
3 |
4710 |
89311 |
84771 |
4540 |
5.08 |
04:32:08 |
04:50:08 |
interval # 4, overall |
4 |
4659 |
89368 |
83862 |
5506 |
6.16 |
04:50:09 |
05:08:09 |
interval # 5, overall |
5 |
4447 |
87856 |
80040 |
7816 |
8.90 |
05:08:10 |
05:26:10 |
interval # 6, overall |
6 |
4839 |
91476 |
87106 |
4370 |
4.78 |
05:26:11 |
05:44:11 |
interval # 7, overall |
7 |
4435 |
84149 |
79826 |
4323 |
5.14 |
05:44:12 |
06:02:12 |
interval # 8, overall |
8 |
4526 |
83112 |
81471 |
1641 |
1.97 |
06:02:13 |
06:20:13 |
interval # 9, overall |
9 |
4715 |
87751 |
84871 |
2880 |
3.28 |
06:20:14 |
06:38:14 |
interval # 10, overall |
10 |
4482 |
85503 |
80684 |
4819 |
5.64 |
06:38:15 |
06:56:15 |
Done for 50380 ms, from 7:00:34.23 to 7:01:24.61.
TEST_PHASE |
MINUTE_SINCE_TEST_START |
AVG_ESTIMATED |
MIN_TO_AVG_RATIO |
MAX_TO_AVG_RATIO |
ROWS_AGGREGATED |
DISTINCT_ATTACHMENTS |
WARM_TIME |
1 |
5310.10 |
0.7144 |
1.2355 |
2692 |
96 |
WARM_TIME |
2 |
3852.54 |
0.8516 |
1.1627 |
2104 |
80 |
WARM_TIME |
3 |
3283.93 |
0.9094 |
1.0901 |
1712 |
63 |
WARM_TIME |
4 |
2875.87 |
0.9337 |
1.0623 |
1381 |
59 |
WARM_TIME |
5 |
2579.36 |
0.9476 |
1.0579 |
1067 |
50 |
WARM_TIME |
6 |
2416.94 |
0.9409 |
1.0574 |
1112 |
55 |
WARM_TIME |
7 |
2322.80 |
0.9431 |
1.0593 |
1175 |
54 |
WARM_TIME |
8 |
2276.44 |
0.9458 |
1.0439 |
1134 |
53 |
WARM_TIME |
9 |
2245.58 |
0.9407 |
1.0604 |
1239 |
66 |
WARM_TIME |
10 |
2255.74 |
0.9515 |
1.0493 |
1362 |
67 |
TEST_TIME |
11 |
2279.67 |
0.9439 |
1.0556 |
1448 |
76 |
TEST_TIME |
12 |
2327.93 |
0.9477 |
1.0537 |
1440 |
85 |
TEST_TIME |
13 |
2371.02 |
0.9550 |
1.0490 |
1383 |
87 |
TEST_TIME |
14 |
2425.47 |
0.9523 |
1.0497 |
1561 |
88 |
TEST_TIME |
15 |
2487.19 |
0.9555 |
1.0455 |
1485 |
93 |
TEST_TIME |
16 |
2536.94 |
0.9609 |
1.0386 |
1346 |
98 |
TEST_TIME |
17 |
2572.23 |
0.9641 |
1.0374 |
1324 |
98 |
TEST_TIME |
18 |
2604.37 |
0.9677 |
1.0366 |
1276 |
95 |
TEST_TIME |
19 |
2643.85 |
0.9674 |
1.0285 |
1150 |
91 |
TEST_TIME |
20 |
2679.15 |
0.9642 |
1.0352 |
1239 |
95 |
TEST_TIME |
21 |
2711.04 |
0.9743 |
1.0205 |
1219 |
93 |
TEST_TIME |
22 |
2693.14 |
0.9806 |
1.0209 |
1012 |
89 |
TEST_TIME |
23 |
2724.39 |
0.9654 |
1.0336 |
1280 |
97 |
TEST_TIME |
24 |
2782.58 |
0.9706 |
1.0271 |
1133 |
93 |
TEST_TIME |
25 |
2830.75 |
0.9693 |
1.0289 |
1553 |
95 |
TEST_TIME |
26 |
2875.63 |
0.9739 |
1.0268 |
1334 |
97 |
TEST_TIME |
27 |
2915.26 |
0.9754 |
1.0270 |
1536 |
95 |
TEST_TIME |
28 |
2958.64 |
0.9759 |
1.0241 |
1378 |
97 |
TEST_TIME |
29 |
3015.06 |
0.9703 |
1.0254 |
1668 |
97 |
TEST_TIME |
30 |
3052.48 |
0.9791 |
1.0237 |
1338 |
96 |
TEST_TIME |
31 |
3096.43 |
0.9767 |
1.0213 |
1548 |
94 |
TEST_TIME |
32 |
3144.62 |
0.9743 |
1.0220 |
1497 |
96 |
TEST_TIME |
33 |
3150.33 |
0.9892 |
1.0109 |
1213 |
84 |
TEST_TIME |
34 |
3160.87 |
0.9779 |
1.0224 |
1231 |
90 |
TEST_TIME |
35 |
3186.66 |
0.9852 |
1.0180 |
1206 |
90 |
TEST_TIME |
36 |
3213.83 |
0.9814 |
1.0168 |
1279 |
93 |
TEST_TIME |
37 |
3237.10 |
0.9822 |
1.0191 |
1256 |
95 |
TEST_TIME |
38 |
3266.36 |
0.9834 |
1.0174 |
1161 |
94 |
TEST_TIME |
39 |
3291.59 |
0.9837 |
1.0157 |
1137 |
96 |
TEST_TIME |
40 |
3319.43 |
0.9820 |
1.0188 |
1327 |
96 |
TEST_TIME |
41 |
3358.66 |
0.9827 |
1.0170 |
1276 |
95 |
TEST_TIME |
42 |
3383.34 |
0.9855 |
1.0125 |
1391 |
92 |
TEST_TIME |
43 |
3386.30 |
0.9881 |
1.0128 |
1221 |
97 |
TEST_TIME |
44 |
3395.15 |
0.9872 |
1.0143 |
1227 |
95 |
TEST_TIME |
45 |
3425.39 |
0.9830 |
1.0168 |
1243 |
97 |
TEST_TIME |
46 |
3456.35 |
0.9858 |
1.0154 |
1356 |
97 |
TEST_TIME |
47 |
3478.29 |
0.9876 |
1.0126 |
1378 |
96 |
TEST_TIME |
48 |
3493.22 |
0.9873 |
1.0126 |
1202 |
93 |
TEST_TIME |
49 |
3503.43 |
0.9890 |
1.0115 |
1176 |
94 |
TEST_TIME |
50 |
3514.51 |
0.9882 |
1.0139 |
1097 |
94 |
TEST_TIME |
51 |
3531.93 |
0.9892 |
1.0111 |
1066 |
93 |
TEST_TIME |
52 |
3537.70 |
0.9900 |
1.0116 |
1010 |
92 |
TEST_TIME |
53 |
3565.20 |
0.9877 |
1.0124 |
1113 |
95 |
TEST_TIME |
54 |
3582.12 |
0.9890 |
1.0105 |
1227 |
92 |
TEST_TIME |
55 |
3610.92 |
0.9842 |
1.0143 |
1473 |
95 |
TEST_TIME |
56 |
3637.80 |
0.9888 |
1.0097 |
1335 |
90 |
TEST_TIME |
57 |
3662.90 |
0.9852 |
1.0138 |
1428 |
93 |
TEST_TIME |
58 |
3686.59 |
0.9899 |
1.0114 |
1372 |
92 |
TEST_TIME |
59 |
3710.83 |
0.9878 |
1.0133 |
1268 |
95 |
TEST_TIME |
60 |
3741.66 |
0.9882 |
1.0101 |
1287 |
96 |
TEST_TIME |
61 |
3761.82 |
0.9882 |
1.0104 |
1134 |
94 |
TEST_TIME |
62 |
3772.38 |
0.9913 |
1.0072 |
1129 |
93 |
TEST_TIME |
63 |
3778.98 |
0.9895 |
1.0085 |
1095 |
94 |
TEST_TIME |
64 |
3786.24 |
0.9909 |
1.0113 |
1262 |
91 |
TEST_TIME |
65 |
3797.89 |
0.9927 |
1.0074 |
1132 |
90 |
TEST_TIME |
66 |
3803.14 |
0.9909 |
1.0081 |
1166 |
94 |
TEST_TIME |
67 |
3813.38 |
0.9904 |
1.0086 |
1172 |
93 |
TEST_TIME |
68 |
3816.77 |
0.9929 |
1.0064 |
942 |
87 |
TEST_TIME |
69 |
3818.54 |
0.9914 |
1.0078 |
1070 |
88 |
TEST_TIME |
70 |
3827.67 |
0.9910 |
1.0076 |
1368 |
92 |
TEST_TIME |
71 |
3832.76 |
0.9921 |
1.0086 |
1154 |
92 |
TEST_TIME |
72 |
3845.16 |
0.9914 |
1.0087 |
1385 |
92 |
TEST_TIME |
73 |
3863.14 |
0.9902 |
1.0089 |
1227 |
93 |
TEST_TIME |
74 |
3891.46 |
0.9880 |
1.0111 |
1198 |
97 |
TEST_TIME |
75 |
3910.21 |
0.9928 |
1.0081 |
1003 |
89 |
TEST_TIME |
76 |
3919.72 |
0.9924 |
1.0059 |
1132 |
90 |
TEST_TIME |
77 |
3913.67 |
0.9944 |
1.0049 |
1052 |
81 |
TEST_TIME |
78 |
3913.42 |
0.9921 |
1.0096 |
1136 |
87 |
TEST_TIME |
79 |
3935.64 |
0.9912 |
1.0091 |
1061 |
91 |
TEST_TIME |
80 |
3958.84 |
0.9906 |
1.0074 |
1094 |
93 |
TEST_TIME |
81 |
3966.85 |
0.9929 |
1.0078 |
1154 |
94 |
TEST_TIME |
82 |
3975.34 |
0.9934 |
1.0082 |
1013 |
94 |
TEST_TIME |
83 |
3981.81 |
0.9944 |
1.0054 |
968 |
88 |
TEST_TIME |
84 |
3977.48 |
0.9945 |
1.0055 |
1069 |
89 |
TEST_TIME |
85 |
3979.31 |
0.9932 |
1.0071 |
1228 |
94 |
TEST_TIME |
86 |
3986.27 |
0.9937 |
1.0063 |
1166 |
91 |
TEST_TIME |
87 |
4001.57 |
0.9909 |
1.0066 |
1241 |
92 |
TEST_TIME |
88 |
4008.25 |
0.9935 |
1.0066 |
1193 |
88 |
TEST_TIME |
89 |
4013.83 |
0.9939 |
1.0063 |
1226 |
92 |
TEST_TIME |
90 |
4011.05 |
0.9958 |
1.0040 |
1227 |
95 |
TEST_TIME |
91 |
4003.76 |
0.9948 |
1.0060 |
1157 |
90 |
TEST_TIME |
92 |
4015.09 |
0.9923 |
1.0060 |
1143 |
89 |
TEST_TIME |
93 |
4016.54 |
0.9949 |
1.0061 |
1153 |
86 |
TEST_TIME |
94 |
4027.80 |
0.9926 |
1.0063 |
999 |
90 |
TEST_TIME |
95 |
4035.16 |
0.9938 |
1.0064 |
1139 |
90 |
TEST_TIME |
96 |
4043.96 |
0.9938 |
1.0049 |
1253 |
90 |
TEST_TIME |
97 |
4043.78 |
0.9946 |
1.0065 |
1215 |
89 |
TEST_TIME |
98 |
4055.88 |
0.9932 |
1.0077 |
1150 |
92 |
TEST_TIME |
99 |
4061.39 |
0.9962 |
1.0032 |
950 |
82 |
TEST_TIME |
100 |
4055.31 |
0.9947 |
1.0061 |
1240 |
91 |
TEST_TIME |
101 |
4066.39 |
0.9934 |
1.0081 |
1293 |
93 |
TEST_TIME |
102 |
4084.60 |
0.9938 |
1.0075 |
1414 |
96 |
TEST_TIME |
103 |
4094.39 |
0.9954 |
1.0059 |
1347 |
92 |
TEST_TIME |
104 |
4105.14 |
0.9936 |
1.0058 |
1385 |
93 |
TEST_TIME |
105 |
4108.27 |
0.9955 |
1.0046 |
1268 |
95 |
TEST_TIME |
106 |
4109.41 |
0.9949 |
1.0047 |
1211 |
89 |
TEST_TIME |
107 |
4114.13 |
0.9942 |
1.0054 |
1245 |
89 |
TEST_TIME |
108 |
4118.11 |
0.9951 |
1.0061 |
1166 |
94 |
TEST_TIME |
109 |
4129.53 |
0.9941 |
1.0066 |
1177 |
96 |
TEST_TIME |
110 |
4137.80 |
0.9955 |
1.0038 |
1090 |
91 |
TEST_TIME |
111 |
4139.98 |
0.9942 |
1.0053 |
969 |
91 |
TEST_TIME |
112 |
4148.14 |
0.9945 |
1.0049 |
1083 |
92 |
TEST_TIME |
113 |
4152.68 |
0.9949 |
1.0054 |
1169 |
94 |
TEST_TIME |
114 |
4157.30 |
0.9954 |
1.0050 |
1043 |
91 |
TEST_TIME |
115 |
4163.30 |
0.9948 |
1.0042 |
1202 |
93 |
TEST_TIME |
116 |
4165.60 |
0.9950 |
1.0045 |
1260 |
92 |
TEST_TIME |
117 |
4167.55 |
0.9955 |
1.0039 |
1174 |
91 |
TEST_TIME |
118 |
4167.24 |
0.9955 |
1.0051 |
1181 |
88 |
TEST_TIME |
119 |
4173.00 |
0.9954 |
1.0059 |
1157 |
92 |
TEST_TIME |
120 |
4185.16 |
0.9946 |
1.0049 |
1147 |
96 |
TEST_TIME |
121 |
4188.01 |
0.9959 |
1.0041 |
1025 |
94 |
TEST_TIME |
122 |
4186.87 |
0.9963 |
1.0042 |
1076 |
92 |
TEST_TIME |
123 |
4185.10 |
0.9964 |
1.0037 |
1021 |
88 |
TEST_TIME |
124 |
4186.23 |
0.9953 |
1.0035 |
997 |
92 |
TEST_TIME |
125 |
4182.44 |
0.9964 |
1.0038 |
884 |
86 |
TEST_TIME |
126 |
4183.11 |
0.9957 |
1.0028 |
968 |
92 |
TEST_TIME |
127 |
4175.53 |
0.9968 |
1.0036 |
1148 |
93 |
TEST_TIME |
128 |
4174.76 |
0.9959 |
1.0030 |
1158 |
88 |
TEST_TIME |
129 |
4170.86 |
0.9963 |
1.0031 |
974 |
88 |
TEST_TIME |
130 |
4166.50 |
0.9964 |
1.0066 |
1246 |
91 |
TEST_TIME |
131 |
4177.88 |
0.9962 |
1.0038 |
1311 |
91 |
TEST_TIME |
132 |
4177.92 |
0.9962 |
1.0037 |
1189 |
88 |
TEST_TIME |
133 |
4188.12 |
0.9937 |
1.0036 |
1051 |
92 |
TEST_TIME |
134 |
4194.02 |
0.9947 |
1.0023 |
779 |
81 |
TEST_TIME |
135 |
4187.44 |
0.9964 |
1.0035 |
1188 |
85 |
TEST_TIME |
136 |
4194.41 |
0.9945 |
1.0077 |
1236 |
94 |
TEST_TIME |
137 |
4212.40 |
0.9961 |
1.0052 |
1152 |
94 |
TEST_TIME |
138 |
4221.08 |
0.9958 |
1.0042 |
1127 |
95 |
TEST_TIME |
139 |
4224.72 |
0.9961 |
1.0034 |
1176 |
90 |
TEST_TIME |
140 |
4223.60 |
0.9965 |
1.0032 |
1033 |
88 |
TEST_TIME |
141 |
4222.94 |
0.9962 |
1.0031 |
1215 |
86 |
TEST_TIME |
142 |
4216.58 |
0.9975 |
1.0024 |
1019 |
84 |
TEST_TIME |
143 |
4211.58 |
0.9965 |
1.0031 |
910 |
88 |
TEST_TIME |
144 |
4207.21 |
0.9972 |
1.0032 |
988 |
80 |
TEST_TIME |
145 |
4213.10 |
0.9949 |
1.0036 |
1072 |
92 |
TEST_TIME |
146 |
4210.29 |
0.9974 |
1.0027 |
967 |
85 |
TEST_TIME |
147 |
4206.54 |
0.9968 |
1.0032 |
1034 |
90 |
TEST_TIME |
148 |
4209.87 |
0.9957 |
1.0051 |
1092 |
91 |
TEST_TIME |
149 |
4217.04 |
0.9966 |
1.0030 |
978 |
93 |
TEST_TIME |
150 |
4212.64 |
0.9974 |
1.0025 |
891 |
88 |
TEST_TIME |
151 |
4211.68 |
0.9961 |
1.0038 |
1025 |
88 |
TEST_TIME |
152 |
4212.26 |
0.9971 |
1.0029 |
868 |
87 |
TEST_TIME |
153 |
4209.30 |
0.9970 |
1.0039 |
1028 |
85 |
TEST_TIME |
154 |
4212.17 |
0.9967 |
1.0031 |
1027 |
87 |
TEST_TIME |
155 |
4215.20 |
0.9959 |
1.0043 |
1031 |
89 |
TEST_TIME |
156 |
4222.85 |
0.9961 |
1.0030 |
1037 |
92 |
TEST_TIME |
157 |
4221.59 |
0.9969 |
1.0039 |
957 |
90 |
TEST_TIME |
158 |
4227.92 |
0.9961 |
1.0037 |
1048 |
89 |
TEST_TIME |
159 |
4229.50 |
0.9971 |
1.0025 |
906 |
91 |
TEST_TIME |
160 |
4229.31 |
0.9963 |
1.0032 |
929 |
85 |
TEST_TIME |
161 |
4233.09 |
0.9961 |
1.0033 |
1091 |
91 |
TEST_TIME |
162 |
4237.15 |
0.9962 |
1.0049 |
1018 |
91 |
TEST_TIME |
163 |
4242.57 |
0.9974 |
1.0020 |
1070 |
93 |
TEST_TIME |
164 |
4237.43 |
0.9971 |
1.0030 |
1141 |
88 |
TEST_TIME |
165 |
4243.11 |
0.9956 |
1.0044 |
1198 |
88 |
TEST_TIME |
166 |
4249.80 |
0.9967 |
1.0037 |
1177 |
91 |
TEST_TIME |
167 |
4257.64 |
0.9959 |
1.0036 |
1120 |
93 |
TEST_TIME |
168 |
4268.30 |
0.9951 |
1.0046 |
1098 |
96 |
TEST_TIME |
169 |
4282.89 |
0.9953 |
1.0036 |
997 |
98 |
TEST_TIME |
170 |
4285.12 |
0.9972 |
1.0032 |
1070 |
93 |
TEST_TIME |
171 |
4285.66 |
0.9972 |
1.0027 |
1165 |
87 |
TEST_TIME |
172 |
4292.31 |
0.9953 |
1.0034 |
1166 |
92 |
TEST_TIME |
173 |
4294.63 |
0.9970 |
1.0030 |
1080 |
86 |
TEST_TIME |
174 |
4295.04 |
0.9971 |
1.0028 |
1015 |
90 |
TEST_TIME |
175 |
4293.80 |
0.9973 |
1.0031 |
1015 |
88 |
TEST_TIME |
176 |
4300.89 |
0.9958 |
1.0032 |
1161 |
92 |
TEST_TIME |
177 |
4305.42 |
0.9965 |
1.0035 |
1329 |
91 |
TEST_TIME |
178 |
4310.45 |
0.9967 |
1.0032 |
1220 |
87 |
TEST_TIME |
179 |
4313.41 |
0.9969 |
1.0038 |
1238 |
89 |
TEST_TIME |
180 |
4317.55 |
0.9973 |
1.0026 |
1006 |
90 |
TEST_TIME |
181 |
4318.22 |
0.9969 |
1.0028 |
1091 |
88 |
TEST_TIME |
182 |
4322.32 |
0.9963 |
1.0033 |
1140 |
94 |
TEST_TIME |
183 |
4323.21 |
0.9977 |
1.0019 |
1166 |
88 |
TEST_TIME |
184 |
4324.01 |
0.9963 |
1.0026 |
1041 |
89 |
TEST_TIME |
185 |
4322.64 |
0.9975 |
1.0021 |
984 |
85 |
TEST_TIME |
186 |
4322.45 |
0.9968 |
1.0036 |
1000 |
88 |
TEST_TIME |
187 |
4324.07 |
0.9978 |
1.0022 |
977 |
88 |
TEST_TIME |
188 |
4323.19 |
0.9971 |
1.0022 |
1033 |
91 |
TEST_TIME |
189 |
4324.35 |
0.9966 |
1.0026 |
954 |
93 |
TEST_TIME |
190 |
4315.63 |
0.9994 |
1.0013 |
283 |
100 |
Done for 9580 ms, from 7:01:25.29 to 7:01:34.87.
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 |
1749 |
6149 |
5063 |
3615 |
4719 |
<null> |
9399 |
<null> |
8722 |
<null> |
3177 |
3410 |
17211 |
2620 |
37582 |
3692 |
315346 |
208365 |
<null> |
03:56:06 |
04:14:06 |
fetches per second |
2 |
1701 |
5609 |
5458 |
3370 |
5379 |
<null> |
12828 |
4308 |
8703 |
2401 |
4861 |
3145 |
18309 |
3036 |
42522 |
3296 |
351168 |
249180 |
<null> |
04:14:07 |
04:32:07 |
fetches per second |
3 |
1557 |
4227 |
5765 |
4126 |
6221 |
2908 |
13079 |
<null> |
<null> |
2229 |
4329 |
4516 |
22437 |
4344 |
49601 |
2355 |
298492 |
248247 |
<null> |
04:32:08 |
04:50:08 |
fetches per second |
4 |
1666 |
6125 |
4714 |
<null> |
5080 |
<null> |
13705 |
4212 |
39730 |
3290 |
7824 |
3166 |
32582 |
3303 |
30227 |
<null> |
344117 |
232020 |
<null> |
04:50:09 |
05:08:09 |
fetches per second |
5 |
1566 |
5750 |
5353 |
<null> |
6338 |
3054 |
12374 |
3396 |
8674 |
3377 |
3277 |
2888 |
29184 |
4089 |
35684 |
2803 |
368384 |
287929 |
<null> |
05:08:10 |
05:26:10 |
fetches per second |
6 |
1620 |
6442 |
4792 |
<null> |
5184 |
3028 |
10726 |
4460 |
29090 |
3395 |
5818 |
3829 |
42266 |
5048 |
29467 |
5957 |
324543 |
311513 |
<null> |
05:26:11 |
05:44:11 |
fetches per second |
7 |
1576 |
5819 |
5649 |
<null> |
6504 |
3192 |
13327 |
3844 |
18183 |
3567 |
5410 |
2734 |
54216 |
3961 |
35841 |
3151 |
353625 |
283793 |
<null> |
05:44:12 |
06:02:12 |
fetches per second |
8 |
1468 |
4910 |
5574 |
3926 |
6467 |
<null> |
14241 |
<null> |
14762 |
3420 |
5682 |
3076 |
44952 |
3410 |
25780 |
2603 |
371983 |
182026 |
<null> |
06:02:13 |
06:20:13 |
fetches per second |
9 |
1680 |
4010 |
5118 |
<null> |
4888 |
<null> |
13261 |
3923 |
15273 |
4235 |
7493 |
3293 |
35238 |
2738 |
25026 |
3130 |
327211 |
278940 |
<null> |
06:20:14 |
06:38:14 |
fetches per second |
10 |
1658 |
3673 |
4903 |
3147 |
5081 |
<null> |
11728 |
4528 |
13354 |
3115 |
11397 |
<null> |
41723 |
3195 |
25717 |
3600 |
472427 |
164703 |
<null> |
06:38:15 |
06:56:15 |
marks per second |
1 |
290 |
510 |
239 |
553 |
237 |
<null> |
319 |
<null> |
345 |
<null> |
382 |
381 |
432 |
317 |
353 |
341 |
1065 |
481 |
<null> |
03:56:06 |
04:14:06 |
marks per second |
2 |
272 |
499 |
242 |
545 |
236 |
<null> |
296 |
410 |
940 |
384 |
377 |
311 |
361 |
313 |
359 |
328 |
1053 |
350 |
<null> |
04:14:07 |
04:32:07 |
marks per second |
3 |
264 |
396 |
228 |
358 |
232 |
486 |
342 |
<null> |
<null> |
354 |
361 |
409 |
383 |
437 |
374 |
302 |
843 |
260 |
<null> |
04:32:08 |
04:50:08 |
marks per second |
4 |
269 |
584 |
246 |
<null> |
246 |
<null> |
355 |
371 |
7954 |
320 |
369 |
311 |
453 |
294 |
456 |
<null> |
922 |
226 |
<null> |
04:50:09 |
05:08:09 |
marks per second |
5 |
256 |
500 |
238 |
<null> |
219 |
414 |
355 |
315 |
794 |
334 |
464 |
290 |
332 |
421 |
372 |
314 |
887 |
409 |
<null> |
05:08:10 |
05:26:10 |
marks per second |
6 |
264 |
612 |
226 |
<null> |
261 |
452 |
309 |
390 |
401 |
346 |
400 |
378 |
324 |
457 |
351 |
521 |
5124 |
449 |
<null> |
05:26:11 |
05:44:11 |
marks per second |
7 |
248 |
533 |
225 |
<null> |
222 |
454 |
291 |
333 |
314 |
372 |
307 |
268 |
288 |
371 |
359 |
369 |
972 |
365 |
<null> |
05:44:12 |
06:02:12 |
marks per second |
8 |
241 |
434 |
229 |
476 |
231 |
<null> |
295 |
<null> |
257 |
324 |
305 |
292 |
319 |
318 |
313 |
295 |
748 |
173 |
<null> |
06:02:13 |
06:20:13 |
marks per second |
9 |
273 |
376 |
227 |
<null> |
250 |
<null> |
616 |
349 |
312 |
401 |
342 |
332 |
328 |
292 |
377 |
407 |
1141 |
337 |
<null> |
06:20:14 |
06:38:14 |
marks per second |
10 |
261 |
389 |
234 |
329 |
237 |
<null> |
306 |
404 |
336 |
349 |
316 |
<null> |
340 |
279 |
378 |
450 |
1047 |
630 |
<null> |
06:38:15 |
06:56:15 |
reads/fetches*100 |
1 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
03:56:06 |
04:14:06 |
reads/fetches*100 |
2 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:14:07 |
04:32:07 |
reads/fetches*100 |
3 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:32:08 |
04:50:08 |
reads/fetches*100 |
4 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
04:50:09 |
05:08:09 |
reads/fetches*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:08:10 |
05:26:10 |
reads/fetches*100 |
6 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:26:11 |
05:44:11 |
reads/fetches*100 |
7 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:44:12 |
06:02:12 |
reads/fetches*100 |
8 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
06:02:13 |
06:20:13 |
reads/fetches*100 |
9 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
06:20:14 |
06:38:14 |
reads/fetches*100 |
10 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
06:38:15 |
06:56:15 |
writes/marks*100 |
1 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
1 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
4 |
0 |
<null> |
03:56:06 |
04:14:06 |
writes/marks*100 |
2 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
5 |
0 |
<null> |
04:14:07 |
04:32:07 |
writes/marks*100 |
3 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
<null> |
04:32:08 |
04:50:08 |
writes/marks*100 |
4 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
2 |
0 |
<null> |
04:50:09 |
05:08:09 |
writes/marks*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
5 |
0 |
<null> |
05:08:10 |
05:26:10 |
writes/marks*100 |
6 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
4 |
0 |
<null> |
05:26:11 |
05:44:11 |
writes/marks*100 |
7 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
1 |
0 |
0 |
0 |
4 |
0 |
<null> |
05:44:12 |
06:02:12 |
writes/marks*100 |
8 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0 |
<null> |
06:02:13 |
06:20:13 |
writes/marks*100 |
9 |
1 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
6 |
0 |
<null> |
06:20:14 |
06:38:14 |
writes/marks*100 |
10 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
1 |
1 |
0 |
<null> |
0 |
0 |
0 |
0 |
3 |
0 |
<null> |
06:38:15 |
06:56:15 |
Done for 8150 ms, from 7:01:35.42 to 7:01:43.57.
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 |
1347024 |
1310300 |
36724 |
2.72 |
0 |
23142 |
31 |
36724 |
2016-04-13 03:56 |
2016-04-13 06:56 |
doc_list_biud |
1347367 |
1310298 |
37069 |
2.75 |
0 |
10001 |
50 |
37069 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_add_invoice_to_stock |
15103 |
10177 |
4926 |
32.61 |
455 |
191203 |
24394 |
4926 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_cancel_adding_invoice |
2906 |
2402 |
504 |
17.34 |
169 |
206096 |
5833 |
504 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_cancel_client_order |
5257 |
5027 |
230 |
4.37 |
14 |
272 |
84 |
230 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_cancel_customer_reserve |
150212 |
117642 |
32570 |
21.68 |
1 |
3800 |
173 |
32570 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_cancel_pay_from_customer |
1968 |
1941 |
27 |
1.37 |
14 |
2159 |
107 |
27 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_cancel_pay_to_supplier |
1208 |
1192 |
16 |
1.32 |
15 |
1117 |
172 |
16 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_cancel_supplier_invoice |
6016 |
5091 |
925 |
15.37 |
44 |
10262 |
2704 |
925 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_cancel_supplier_order |
1177 |
345 |
832 |
70.68 |
549 |
440133 |
89692 |
832 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_cancel_write_off |
11786 |
8277 |
3509 |
29.77 |
3 |
4201 |
283 |
3509 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_client_order |
63128 |
63128 |
0 |
0.00 |
65 |
4727 |
1206 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_customer_reserve |
475854 |
475854 |
0 |
0.00 |
1 |
25548 |
433 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_fill_shopping_cart |
95478 |
95478 |
0 |
0.00 |
8 |
27237 |
287 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_fill_shopping_cart_clo_res |
475854 |
475854 |
0 |
0.00 |
0 |
263 |
1 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_get_clo_for_invoice |
10177 |
10177 |
0 |
0.00 |
5 |
10102 |
1211 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_kill_cost_storno |
17551 |
13812 |
3739 |
21.30 |
0 |
5323 |
93 |
3739 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_kill_qstorno_ret_qs2qd |
317904 |
248997 |
68907 |
21.67 |
0 |
9982 |
131 |
68907 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_kill_qty_storno |
215074 |
178089 |
36985 |
17.19 |
0 |
9993 |
363 |
36985 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_lock_selected_doc |
62014 |
54317 |
7697 |
12.41 |
1 |
64 |
3 |
7697 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_make_cost_storno |
77767 |
77767 |
0 |
0.00 |
1 |
22913 |
300 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_multiply_rows_for_pdistr |
77767 |
77767 |
0 |
0.00 |
1 |
811 |
173 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_multiply_rows_for_qdistr |
63129 |
63129 |
0 |
0.00 |
5 |
3829 |
901 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_pay_from_customer |
21007 |
21007 |
0 |
0.00 |
63 |
23118 |
383 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_pay_to_supplier |
17453 |
17453 |
0 |
0.00 |
118 |
21828 |
824 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_payment_common |
38460 |
38460 |
0 |
0.00 |
5 |
7173 |
50 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_qd_handle_on_cancel_clo |
5257 |
5027 |
230 |
4.37 |
4 |
245 |
58 |
230 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_qd_handle_on_invoice_upd_sts |
12913 |
12579 |
334 |
2.58 |
12 |
8322 |
2077 |
334 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_qd_handle_on_reserve_upd_sts |
29129 |
29128 |
1 |
0.00 |
8 |
2110 |
160 |
1 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_reserve_write_off |
30025 |
29128 |
897 |
2.98 |
99 |
23191 |
401 |
897 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_supplier_invoice |
16240 |
16240 |
0 |
0.00 |
132 |
46460 |
13001 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
sp_supplier_order |
16110 |
16110 |
0 |
0.00 |
114 |
24997 |
8723 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
srv_find_qd_qs_mism |
760145 |
723420 |
36725 |
4.83 |
0 |
956 |
1 |
36725 |
2016-04-13 03:56 |
2016-04-13 06:56 |
srv_make_invnt_saldo |
2918 |
2918 |
0 |
0.00 |
478 |
48641 |
1984 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
srv_make_money_saldo |
3668 |
3668 |
0 |
0.00 |
21 |
7491 |
109 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
srv_recalc_idx_stat |
11 |
11 |
0 |
0.00 |
2711 |
4264 |
3413 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-abend:sp_add_invoice_to_stock |
4926 |
4926 |
0 |
0.00 |
56 |
502 |
162 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-abend:sp_cancel_adding_invoice |
532 |
532 |
0 |
0.00 |
47 |
3115 |
1323 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-abend:sp_cancel_client_order |
230 |
230 |
0 |
0.00 |
124 |
466 |
250 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-abend:sp_cancel_customer_reserve |
68 |
68 |
0 |
0.00 |
90 |
329 |
172 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-abend:sp_cancel_pay_from_customer |
27 |
27 |
0 |
0.00 |
163 |
405 |
272 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-abend:sp_cancel_pay_to_supplier |
16 |
16 |
0 |
0.00 |
216 |
435 |
299 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-abend:sp_cancel_supplier_invoice |
404 |
404 |
0 |
0.00 |
72 |
304 |
162 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-abend:sp_cancel_supplier_order |
4585 |
4585 |
0 |
0.00 |
96 |
3389 |
1788 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-abend:sp_cancel_write_off |
81 |
81 |
0 |
0.00 |
71 |
301 |
156 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-abend:sp_reserve_write_off |
897 |
897 |
0 |
0.00 |
71 |
394 |
164 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-norm:sp_add_invoice_to_stock |
10227 |
10227 |
0 |
0.00 |
349 |
46061 |
12178 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-norm:sp_cancel_adding_invoice |
978 |
978 |
0 |
0.00 |
412 |
44102 |
10231 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-norm:sp_cancel_client_order |
5027 |
5027 |
0 |
0.00 |
100 |
1066 |
293 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-norm:sp_cancel_customer_reserve |
1890 |
1890 |
0 |
0.00 |
106 |
700 |
328 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-norm:sp_cancel_pay_from_customer |
1941 |
1941 |
0 |
0.00 |
83 |
502 |
229 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-norm:sp_cancel_pay_to_supplier |
1192 |
1192 |
0 |
0.00 |
105 |
919 |
234 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-norm:sp_cancel_supplier_invoice |
825 |
825 |
0 |
0.00 |
110 |
603 |
293 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-norm:sp_cancel_supplier_order |
345 |
345 |
0 |
0.00 |
272 |
338982 |
57445 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-norm:sp_cancel_write_off |
2814 |
2814 |
0 |
0.00 |
119 |
650 |
327 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-norm:sp_client_order |
63130 |
63130 |
0 |
0.00 |
108 |
1313 |
394 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-norm:sp_customer_reserve |
2957 |
2957 |
0 |
0.00 |
65 |
720 |
218 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-norm:sp_pay_from_customer |
21007 |
21007 |
0 |
0.00 |
94 |
728 |
264 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-norm:sp_pay_to_supplier |
17453 |
17453 |
0 |
0.00 |
64 |
1031 |
267 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-norm:sp_reserve_write_off |
29131 |
29131 |
0 |
0.00 |
79 |
1080 |
362 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-norm:sp_supplier_invoice |
16248 |
16248 |
0 |
0.00 |
12 |
937 |
396 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-norm:sp_supplier_order |
16119 |
16119 |
0 |
0.00 |
36 |
911 |
396 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-norm:srv_make_invnt_saldo |
2919 |
2919 |
0 |
0.00 |
11 |
156 |
32 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-norm:srv_make_money_saldo |
3668 |
3668 |
0 |
0.00 |
12 |
151 |
35 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
t$perf-norm:srv_recalc_idx_stat |
11 |
11 |
0 |
0.00 |
1096 |
1659 |
1323 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
v_add_invoice_to_stock |
30206 |
20354 |
9852 |
32.61 |
1 |
103 |
7 |
9852 |
2016-04-13 03:56 |
2016-04-13 06:56 |
v_all_customers |
95054 |
95054 |
0 |
0.00 |
1 |
131 |
6 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
v_all_suppliers |
66856 |
66856 |
0 |
0.00 |
1 |
123 |
7 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
v_all_wares |
126256 |
126256 |
0 |
0.00 |
1 |
135 |
10 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
v_cancel_adding_invoice |
2388 |
1956 |
432 |
18.09 |
2 |
460 |
68 |
432 |
2016-04-13 03:56 |
2016-04-13 06:56 |
v_cancel_client_order |
10514 |
10054 |
460 |
4.37 |
1 |
90 |
5 |
460 |
2016-04-13 03:56 |
2016-04-13 06:56 |
v_cancel_customer_prepayment |
3936 |
3882 |
54 |
1.37 |
1 |
88 |
6 |
54 |
2016-04-13 03:56 |
2016-04-13 06:56 |
v_cancel_customer_reserve |
3916 |
3780 |
136 |
3.47 |
1 |
66 |
7 |
136 |
2016-04-13 03:56 |
2016-04-13 06:56 |
v_cancel_payment_to_supplier |
2416 |
2384 |
32 |
1.32 |
1 |
81 |
7 |
32 |
2016-04-13 03:56 |
2016-04-13 06:56 |
v_cancel_supplier_invoice |
2458 |
1650 |
808 |
32.87 |
2 |
69 |
8 |
808 |
2016-04-13 03:56 |
2016-04-13 06:56 |
v_cancel_supplier_order |
2354 |
690 |
1664 |
70.68 |
2 |
69 |
7 |
1664 |
2016-04-13 03:56 |
2016-04-13 06:56 |
v_cancel_write_off |
5790 |
5628 |
162 |
2.79 |
1 |
438 |
36 |
162 |
2016-04-13 03:56 |
2016-04-13 06:56 |
v_max_id_clo_ord |
16110 |
16110 |
0 |
0.00 |
4 |
1299 |
22 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
v_max_id_clo_res |
2957 |
2957 |
0 |
0.00 |
3 |
233 |
25 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
v_max_id_ord_sup |
16240 |
16240 |
0 |
0.00 |
4 |
1459 |
21 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
v_max_non_paid_invoice |
16375 |
16375 |
0 |
0.00 |
2 |
281 |
11 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
v_max_non_paid_realizn |
21007 |
21007 |
0 |
0.00 |
1 |
110 |
7 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
v_min_id_clo_ord |
16110 |
16110 |
0 |
0.00 |
3 |
935 |
17 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
v_min_id_clo_res |
2957 |
2957 |
0 |
0.00 |
2 |
758 |
13 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
v_min_id_ord_sup |
16240 |
16240 |
0 |
0.00 |
3 |
1464 |
18 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
v_min_non_paid_invoice |
17453 |
17453 |
0 |
0.00 |
1 |
4016 |
46 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
v_min_non_paid_realizn |
21007 |
21007 |
0 |
0.00 |
1 |
341 |
7 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
v_our_firm |
31202 |
31202 |
0 |
0.00 |
1 |
84 |
6 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
v_reserve_write_off |
60050 |
58256 |
1794 |
2.98 |
1 |
124 |
6 |
1794 |
2016-04-13 03:56 |
2016-04-13 06:56 |
x_lock_depdocs_on_canc_invoice |
9969 |
6668 |
3301 |
33.11 |
0 |
738 |
10 |
3301 |
2016-04-13 03:56 |
2016-04-13 06:56 |
x_lock_depdocs_on_canc_sup_ord |
1174 |
345 |
829 |
70.61 |
0 |
45 |
6 |
829 |
2016-04-13 03:56 |
2016-04-13 06:56 |
x_make_qstorno_1000_1200 |
16111 |
16111 |
0 |
0.00 |
44 |
23487 |
8005 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
x_make_qstorno_1200_2000 |
16240 |
16240 |
0 |
0.00 |
73 |
45771 |
12264 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
x_make_qstorno_2100_3300 |
475854 |
475854 |
0 |
0.00 |
0 |
25451 |
429 |
0 |
2016-04-13 03:56 |
2016-04-13 06:56 |
Done for 99670 ms, from 7:03:16.60 to 7:04:56.27.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
DTS_BEG |
DTS_END |
deadlock |
119 |
sp_kill_cost_storno |
335544336 |
2016-04-13 03:56 |
2016-04-13 06:52 |
deadlock |
8 |
sp_kill_qstorno_ret_qs2qd |
335544336 |
2016-04-13 04:03 |
2016-04-13 05:51 |
deadlock |
44 |
sp_lock_selected_doc |
335544336 |
2016-04-13 04:01 |
2016-04-13 06:55 |
deadlock |
230 |
sp_qd_handle_on_cancel_clo |
335544336 |
2016-04-13 03:56 |
2016-04-13 06:55 |
deadlock |
73 |
sp_qd_handle_on_invoice_upd_sts |
335544336 |
2016-04-13 03:56 |
2016-04-13 06:50 |
deadlock |
1 |
sp_qd_handle_on_reserve_upd_sts |
335544336 |
2016-04-13 04:14 |
2016-04-13 04:14 |
concurrent_transaction |
6364 |
sp_lock_selected_doc |
335544878 |
2016-04-13 03:56 |
2016-04-13 06:56 |
concurrent_transaction |
435 |
x_lock_depdocs_on_canc_invoice |
335544878 |
2016-04-13 03:56 |
2016-04-13 06:54 |
concurrent_transaction |
425 |
x_lock_depdocs_on_canc_sup_ord |
335544878 |
2016-04-13 03:56 |
2016-04-13 06:55 |
Done for 3200 ms, from 7:04:58.31 to 7:05:01.51.
MON$DATABASE_NAME D:\OLTP-EMUL\OLTP30-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 307021
MON$OLDEST_ACTIVE 307022
MON$OLDEST_SNAPSHOT 307022
MON$NEXT_TRANSACTION 307022
MON$PAGE_BUFFERS 786432
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2015-12-11 13:07:49.8140
MON$PAGES 648416
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-V3.0.0.32474 Firebird 3.0
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.0.32474 Firebird 3.0"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.0.32474 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P13"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.0.32474 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P13"
on disk structure version 12.0
Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB"
Database header page information:
Flags 0
Generation 307305
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 307023
Oldest active 307024
Oldest snapshot 307024
Next transaction 307025
Sequence number 0
Next attachment ID 5062
Implementation HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Dec 11, 2015 13:07:49
Attributes force write
Variable header data:
Sweep interval: 0
*END*
Database file sequence:
File D:\OLTP-EMUL\OLTP30-SMALL.FDB is the only file
Analyzing database pages ...
AGENTS (154)
Primary pointer page: 311, Index root page: 312
Total formats: 1, used formats: 1
Average record length: 34.24, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 344.00, compression ratio: 10.05
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_ID_DESC (2)
Root page: 322, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_OUR_FIRM (4)
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 48
Average key length: 2.04, compression ratio: 0.50
Average prefix length: 0.96, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_SUPPLIER (3)
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 45
Average key length: 2.04, compression ratio: 0.53
Average prefix length: 1.02, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_NAME_UNQ (1)
Root page: 321, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.92, total dup: 0, max dup: 0
Average key length: 16.60, compression ratio: 0.92
Average prefix length: 1.34, average data length: 13.92
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_AGENTS (0)
Root page: 320, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BUSINESS_OPS (158)
Primary pointer page: 332, Index root page: 333
Total formats: 1, used formats: 1
Average record length: 103.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 996.00, compression ratio: 9.67
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 28%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BO_UNIT_UNQ (1)
Root page: 336, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 18.00, total dup: 0, max dup: 0
Average key length: 16.95, compression ratio: 1.25
Average prefix length: 7.21, average data length: 14.00
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BUSINESS_OPS_RND_WGTH (2)
Root page: 337, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 4.05, total dup: 7, max dup: 3
Average key length: 3.00, compression ratio: 0.75
Average prefix length: 1.42, average data length: 0.84
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$1 (0)
Root page: 335, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 5.26, total dup: 0, max dup: 0
Average key length: 4.21, compression ratio: 0.64
Average prefix length: 1.05, average data length: 1.63
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DOC_DATA (141)
Primary pointer page: 251, Index root page: 252
Total formats: 1, used formats: 1
Average record length: 45.71, total records: 1579444
Average version length: 47.71, total versions: 47469, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.40
Pointer pages: 11, data page slots: 17184
Data pages: 17184, average fill: 73%
Primary pages: 17184, secondary pages: 0, swept pages: 2829
Empty pages: 4, full pages: 14618
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 54
60 - 79% = 17123
80 - 99% = 3
Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 19783, depth: 3, leaf buckets: 6983, nodes: 1579444
Average node length: 19.95, total dup: 0, max dup: 0
Average key length: 17.01, compression ratio: 1.59
Average prefix length: 12.98, average data length: 14.02
Clustering factor: 613327, ratio: 0.39
Fill distribution:
0 - 19% = 238
20 - 39% = 273
40 - 59% = 4174
60 - 79% = 1615
80 - 99% = 683
Index DOC_DATA_ID_DESC (2)
Root page: 46992, depth: 3, leaf buckets: 5163, nodes: 1579444
Average node length: 11.64, total dup: 0, max dup: 0
Average key length: 8.70, compression ratio: 1.03
Average prefix length: 3.30, average data length: 5.70
Clustering factor: 563997, ratio: 0.36
Fill distribution:
0 - 19% = 0
20 - 39% = 1041
40 - 59% = 4120
60 - 79% = 2
80 - 99% = 0
Index FK_DOC_DATA_DOC_LIST (3)
Root page: 162624, depth: 3, leaf buckets: 2783, nodes: 1579444
Average node length: 7.15, total dup: 1078833, max dup: 49
Average key length: 4.21, compression ratio: 2.14
Average prefix length: 7.10, average data length: 1.90
Clustering factor: 576729, ratio: 0.37
Fill distribution:
0 - 19% = 56
20 - 39% = 270
40 - 59% = 2135
60 - 79% = 113
80 - 99% = 209
DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 57.87, total records: 544338
Average version length: 38.73, total versions: 46020, max versions: 5
Average fragment length: 10.42, total fragments: 57, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.66
Pointer pages: 5, data page slots: 6912
Data pages: 6912, average fill: 77%
Primary pages: 6904, secondary pages: 8, swept pages: 848
Empty pages: 1, full pages: 6348
Fill distribution:
0 - 19% = 9
20 - 39% = 4
40 - 59% = 13
60 - 79% = 5667
80 - 99% = 1219
Index DOC_LIST_ID_DESC (1)
Root page: 251544, depth: 3, leaf buckets: 1899, nodes: 544338
Average node length: 11.78, total dup: 0, max dup: 0
Average key length: 8.94, compression ratio: 1.01
Average prefix length: 3.06, average data length: 5.94
Clustering factor: 146192, ratio: 0.27
Fill distribution:
0 - 19% = 0
20 - 39% = 754
40 - 59% = 1145
60 - 79% = 0
80 - 99% = 0
Index FK_DOC_LIST_AGENTS (2)
Root page: 2964, depth: 2, leaf buckets: 648, nodes: 544338
Average node length: 4.85, total dup: 544288, max dup: 41346
Average key length: 2.01, compression ratio: 4.47
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 254620, ratio: 0.47
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 595
60 - 79% = 24
80 - 99% = 28
Index PK_DOC_LIST (0)
Root page: 97484, depth: 3, leaf buckets: 1884, nodes: 544338
Average node length: 11.78, total dup: 0, max dup: 0
Average key length: 8.94, compression ratio: 1.01
Average prefix length: 3.06, average data length: 5.94
Clustering factor: 146192, ratio: 0.27
Fill distribution:
0 - 19% = 70
20 - 39% = 730
40 - 59% = 1009
60 - 79% = 1
80 - 99% = 74
DOC_STATES (153)
Primary pointer page: 309, Index root page: 310
Total formats: 1, used formats: 1
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 650.00, compression ratio: 9.63
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_MCODE_UNQ (1)
Root page: 318, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 17.75, total dup: 0, max dup: 0
Average key length: 16.50, compression ratio: 1.08
Average prefix length: 4.00, average data length: 13.75
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_NAME_UNQ (2)
Root page: 319, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 33.25, total dup: 0, max dup: 0
Average key length: 32.00, compression ratio: 0.99
Average prefix length: 2.50, average data length: 29.25
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_DOC_STATES (0)
Root page: 317, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 4.75, total dup: 0, max dup: 0
Average key length: 3.50, compression ratio: 0.86
Average prefix length: 1.50, average data length: 1.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
FB_ERRORS (159)
Primary pointer page: 338, Index root page: 339
Total formats: 1, used formats: 1
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 148.00, compression ratio: 1.86
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 56%
Primary pages: 16, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 11
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7
Index FB_ERRORS_GDS_CODE (0)
Root page: 340, depth: 1, leaf buckets: 1, nodes: 758
Average node length: 4.24, total dup: 0, max dup: 0
Average key length: 3.04, compression ratio: 1.64
Average prefix length: 3.97, average data length: 1.03
Clustering factor: 353, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
INVNT_SALDO (147)
Primary pointer page: 269, Index root page: 270
Total formats: 1, used formats: 1
Average record length: 68.34, total records: 400
Average version length: 14.95, total versions: 784093, max versions: 2047
Average fragment length: 21.64, total fragments: 400, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.52
Pointer pages: 3, data page slots: 4056
Data pages: 4056, average fill: 78%
Primary pages: 4, secondary pages: 4052, swept pages: 0
Empty pages: 0, full pages: 4055
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 2935
80 - 99% = 1120
Index PK_INVNT_SALDO (0)
Root page: 281, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 262, ratio: 0.66
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
INVNT_TURNOVER_LOG (157)
Primary pointer page: 330, Index root page: 331
Total formats: 1, used formats: 1
Average record length: 1.20, total records: 223761
Average version length: 71.09, total versions: 219984, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 79.76
Pointer pages: 4, data page slots: 5744
Data pages: 4231, average fill: 69%
Primary pages: 4231, secondary pages: 0, swept pages: 87
Empty pages: 405, full pages: 3109
Fill distribution:
0 - 19% = 822
20 - 39% = 129
40 - 59% = 122
60 - 79% = 328
80 - 99% = 2830
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 121546, depth: 3, leaf buckets: 743, nodes: 223761
Average node length: 13.81, total dup: 15487, max dup: 3
Average key length: 11.15, compression ratio: 2.42
Average prefix length: 18.78, average data length: 8.22
Clustering factor: 196838, ratio: 0.88
Fill distribution:
0 - 19% = 6
20 - 39% = 323
40 - 59% = 85
60 - 79% = 232
80 - 99% = 97
MONEY_SALDO (143)
Primary pointer page: 261, Index root page: 262
Total formats: 1, used formats: 1
Average record length: 15.06, total records: 49
Average version length: 9.01, total versions: 46649, max versions: 3406
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: 168
Data pages: 168, average fill: 89%
Primary pages: 8, secondary pages: 160, swept pages: 0
Empty pages: 7, full pages: 160
Fill distribution:
0 - 19% = 7
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 160
Index PK_MONEY_SALDO (0)
Root page: 272, depth: 1, leaf buckets: 1, nodes: 49
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MONEY_TURNOVER_LOG (142)
Primary pointer page: 259, Index root page: 260
Total formats: 1, used formats: 1
Average record length: 0.21, total records: 10392
Average version length: 45.27, total versions: 10346, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 305.09
Pointer pages: 1, data page slots: 160
Data pages: 152, average fill: 68%
Primary pages: 152, secondary pages: 0, swept pages: 3
Empty pages: 7, full pages: 111
Fill distribution:
0 - 19% = 34
20 - 39% = 5
40 - 59% = 1
60 - 79% = 8
80 - 99% = 104
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 95848, depth: 2, leaf buckets: 11, nodes: 10392
Average node length: 4.07, total dup: 10309, max dup: 1419
Average key length: 2.11, compression ratio: 9.00
Average prefix length: 18.90, average data length: 0.10
Clustering factor: 4271, ratio: 0.41
Fill distribution:
0 - 19% = 0
20 - 39% = 4
40 - 59% = 5
60 - 79% = 2
80 - 99% = 0
MON_LOG (164)
Primary pointer page: 352, Index root page: 353
Total formats: 2, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_DTS (4)
Root page: 363, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_GDSCODE (2)
Root page: 361, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_ROWSET_DESC (1)
Root page: 360, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_UNIT (3)
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG (0)
Root page: 359, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG_TABLE_STATS (165)
Primary pointer page: 364, Index root page: 365
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_DTS (4)
Root page: 370, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_GDSCODE (2)
Root page: 368, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_ROWSET (1)
Root page: 367, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_TN_UNIT (3)
Root page: 369, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG_TABLE_STATS (0)
Root page: 366, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
OPTYPES (138)
Primary pointer page: 239, Index root page: 240
Total formats: 1, used formats: 1
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 5.54
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 9%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OPTYPES_MCODE_UNQ (1)
Root page: 242, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 8.56, total dup: 0, max dup: 0
Average key length: 6.89, compression ratio: 0.73
Average prefix length: 0.44, average data length: 4.56
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_OPTYPES (0)
Root page: 241, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 6.11, total dup: 0, max dup: 0
Average key length: 5.00, compression ratio: 0.60
Average prefix length: 0.89, average data length: 2.11
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PDISTR (150)
Primary pointer page: 293, Index root page: 294
Total formats: 1, used formats: 1
Average record length: 31.55, total records: 322409
Average version length: 32.12, total versions: 130051, max versions: 12
Average fragment length: 33.09, total fragments: 54, max fragments: 1
Average unpacked length: 64.00, compression ratio: 2.03
Pointer pages: 3, data page slots: 3584
Data pages: 3584, average fill: 76%
Primary pages: 3541, secondary pages: 43, swept pages: 263
Empty pages: 4, full pages: 2652
Fill distribution:
0 - 19% = 30
20 - 39% = 21
40 - 59% = 314
60 - 79% = 1839
80 - 99% = 1380
Index PDISTR_AGENT_ID (4)
Root page: 3600, depth: 2, leaf buckets: 328, nodes: 322409
Average node length: 4.71, total dup: 322360, max dup: 28884
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 41153, ratio: 0.13
Fill distribution:
0 - 19% = 3
20 - 39% = 20
40 - 59% = 192
60 - 79% = 83
80 - 99% = 30
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4281, depth: 2, leaf buckets: 380, nodes: 322409
Average node length: 5.72, total dup: 288779, max dup: 45
Average key length: 3.02, compression ratio: 7.28
Average prefix length: 21.08, average data length: 0.92
Clustering factor: 50076, ratio: 0.16
Fill distribution:
0 - 19% = 2
20 - 39% = 38
40 - 59% = 167
60 - 79% = 109
80 - 99% = 64
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3974, depth: 2, leaf buckets: 386, nodes: 322409
Average node length: 5.73, total dup: 288779, max dup: 45
Average key length: 3.02, compression ratio: 7.28
Average prefix length: 21.08, average data length: 0.92
Clustering factor: 51659, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 33
40 - 59% = 196
60 - 79% = 104
80 - 99% = 53
Index PDISTR_SND_ID (1)
Root page: 4313, depth: 2, leaf buckets: 394, nodes: 322409
Average node length: 5.49, total dup: 288779, max dup: 45
Average key length: 2.79, compression ratio: 3.23
Average prefix length: 8.32, average data length: 0.68
Clustering factor: 50418, ratio: 0.16
Fill distribution:
0 - 19% = 3
20 - 39% = 54
40 - 59% = 202
60 - 79% = 101
80 - 99% = 34
PERF_ESTIMATED (160)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 27.87, total records: 226426
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 1.15
Pointer pages: 2, data page slots: 1936
Data pages: 1936, average fill: 64%
Primary pages: 1936, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 1931
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 1
60 - 79% = 1931
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 14036, depth: 2, leaf buckets: 187, nodes: 226426
Average node length: 4.43, total dup: 226235, max dup: 2761
Average key length: 2.00, compression ratio: 1.28
Average prefix length: 2.56, average data length: 0.00
Clustering factor: 51797, ratio: 0.23
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 64
60 - 79% = 97
80 - 99% = 26
PERF_ISQL_STAT (161)
Primary pointer page: 344, Index root page: 345
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PERF_ISQL_STAT_TRN (0)
Root page: 346, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PERF_LOG (162)
Primary pointer page: 348, Index root page: 349
Total formats: 2, used formats: 2
Average record length: 148.54, total records: 8059835
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: 1437.54, compression ratio: 9.68
Pointer pages: 116, data page slots: 188232
Data pages: 188232, average fill: 87%
Primary pages: 188232, secondary pages: 0, swept pages: 3
Empty pages: 5, full pages: 188226
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 188226
Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 59394, depth: 3, leaf buckets: 8658, nodes: 8059835
Average node length: 5.99, total dup: 3139634, max dup: 11
Average key length: 2.74, compression ratio: 2.92
Average prefix length: 7.32, average data length: 0.68
Clustering factor: 6333063, ratio: 0.79
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 3092
60 - 79% = 3207
80 - 99% = 2353
Index PERF_LOG_GDSCODE (3)
Root page: 157006, depth: 3, leaf buckets: 8506, nodes: 8059835
Average node length: 4.29, total dup: 8059830, max dup: 7747861
Average key length: 1.04, compression ratio: 0.19
Average prefix length: 0.19, average data length: 0.00
Clustering factor: 304046, ratio: 0.04
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 8480
60 - 79% = 1
80 - 99% = 24
Index PERF_LOG_TRN_DESC (2)
Root page: 43359, depth: 3, leaf buckets: 8796, nodes: 8059835
Average node length: 5.50, total dup: 7787790, max dup: 12102
Average key length: 2.25, compression ratio: 4.00
Average prefix length: 8.78, average data length: 0.22
Clustering factor: 4025760, ratio: 0.50
Fill distribution:
0 - 19% = 3
20 - 39% = 3
40 - 59% = 5161
60 - 79% = 1990
80 - 99% = 1639
Index PERF_LOG_UNIT (1)
Root page: 65474, depth: 3, leaf buckets: 9314, nodes: 8059835
Average node length: 5.48, total dup: 7905749, max dup: 868010
Average key length: 2.23, compression ratio: 16.84
Average prefix length: 37.40, average data length: 0.22
Clustering factor: 5859062, ratio: 0.73
Fill distribution:
0 - 19% = 35
20 - 39% = 5
40 - 59% = 6656
60 - 79% = 1361
80 - 99% = 1257
PHRASES (145)
Primary pointer page: 265, Index root page: 266
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_ID_DESC (3)
Root page: 279, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_NAME (2)
Root page: 278, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_UNQ (1)
Root page: 277, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_PHRASES (0)
Root page: 276, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PSTORNED (151)
Primary pointer page: 301, Index root page: 302
Total formats: 1, used formats: 1
Average record length: 52.22, total records: 295501
Average version length: 55.54, total versions: 14030, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.53
Pointer pages: 3, data page slots: 3528
Data pages: 3528, average fill: 75%
Primary pages: 3528, secondary pages: 0, swept pages: 1120
Empty pages: 3, full pages: 3177
Fill distribution:
0 - 19% = 7
20 - 39% = 9
40 - 59% = 44
60 - 79% = 3383
80 - 99% = 85
Index PSTORNED_RCV_ID (2)
Root page: 2296, depth: 2, leaf buckets: 378, nodes: 295501
Average node length: 5.93, total dup: 245809, max dup: 444
Average key length: 3.25, compression ratio: 2.77
Average prefix length: 7.92, average data length: 1.08
Clustering factor: 30662, ratio: 0.10
Fill distribution:
0 - 19% = 3
20 - 39% = 6
40 - 59% = 244
60 - 79% = 95
80 - 99% = 30
Index PSTORNED_SND_ID (1)
Root page: 2211, depth: 2, leaf buckets: 313, nodes: 295501
Average node length: 5.49, total dup: 264217, max dup: 342
Average key length: 2.81, compression ratio: 3.20
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 60867, ratio: 0.21
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 146
60 - 79% = 117
80 - 99% = 50
RULES_FOR_PDISTR (152)
Primary pointer page: 303, Index root page: 304
Total formats: 1, used formats: 1
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 336.00, compression ratio: 18.67
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 2%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_PDISTR_UNQ (0)
Root page: 308, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 11.50, total dup: 0, max dup: 0
Average key length: 10.25, compression ratio: 0.88
Average prefix length: 1.50, average data length: 7.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RULES_FOR_QDISTR (139)
Primary pointer page: 243, Index root page: 244
Total formats: 1, used formats: 1
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 332.00, compression ratio: 10.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_RCVOP (1)
Root page: 246, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 5.29, total dup: 2, max dup: 2
Average key length: 4.14, compression ratio: 0.72
Average prefix length: 1.43, average data length: 1.57
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_UNQ (0)
Root page: 245, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 10.14, total dup: 0, max dup: 0
Average key length: 8.86, compression ratio: 0.94
Average prefix length: 2.14, average data length: 6.14
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SEMAPHORES (156)
Primary pointer page: 315, Index root page: 316
Total formats: 1, used formats: 1
Average record length: 34.25, total records: 4
Average version length: 9.00, total versions: 7158, max versions: 3967
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 338.00, compression ratio: 9.87
Pointer pages: 1, data page slots: 32
Data pages: 32, average fill: 71%
Primary pages: 8, secondary pages: 24, swept pages: 0
Empty pages: 7, full pages: 24
Fill distribution:
0 - 19% = 7
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 24
Index PK_SEMAPHORES (0)
Root page: 327, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 12.50, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.50, average data length: 8.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SEMAPHORES_TASK_UNQ (1)
Root page: 328, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 22.50, total dup: 0, max dup: 0
Average key length: 21.00, compression ratio: 1.07
Average prefix length: 4.00, average data length: 18.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SETTINGS (137)
Primary pointer page: 236, Index root page: 237
Total formats: 1, used formats: 1
Average record length: 98.32, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1347.00, compression ratio: 13.70
Pointer pages: 1, data page slots: 2
Data pages: 2, average fill: 81%
Primary pages: 2, secondary pages: 0, swept pages: 2
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1
Index SETTINGS_MODE_CODE (0)
Root page: 238, depth: 1, leaf buckets: 1, nodes: 114
Average node length: 27.07, total dup: 0, max dup: 0
Average key length: 26.06, compression ratio: 1.70
Average prefix length: 21.23, average data length: 23.07
Clustering factor: 6, ratio: 0.05
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$RAND$CALLS (136)
Primary pointer page: 234, Index root page: 235
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$SOURCE (135)
Primary pointer page: 232, Index root page: 233
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$DEP_DOCS (129)
Primary pointer page: 198, Index root page: 199
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_DEP_DOCS_UNQ (0)
Root page: 200, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$IDX_RECALC (132)
Primary pointer page: 207, Index root page: 224
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0)
Root page: 226, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG (133)
Primary pointer page: 227, Index root page: 228
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG_TABLE_STATS (134)
Primary pointer page: 230, Index root page: 231
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_LOG (163)
Primary pointer page: 350, Index root page: 351
Total formats: 2, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Root page: 358, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_MON (131)
Primary pointer page: 205, Index root page: 206
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$RESULT_SET (130)
Primary pointer page: 201, Index root page: 202
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_DOC (1)
Root page: 204, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_WARE_DOC (0)
Root page: 203, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$SHOPPING_CART (128)
Primary pointer page: 193, Index root page: 194
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_SHOPCART_UNQ (0)
Root page: 197, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRACE_STAT (276)
Primary pointer page: 557, Index root page: 68921
Total formats: 1, used formats: 1
Average record length: 54.24, total records: 2397
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.51
Pointer pages: 1, data page slots: 32
Data pages: 32, average fill: 65%
Primary pages: 32, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 27
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 0
60 - 79% = 28
80 - 99% = 0
WARES (144)
Primary pointer page: 263, Index root page: 264
Total formats: 1, used formats: 1
Average record length: 77.53, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 448.00, compression ratio: 5.78
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 77%
Primary pages: 6, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2
Index FK_WARES_WARE_GROUPS (3)
Root page: 374, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 64
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 48, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARES (0)
Root page: 273, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 328, ratio: 0.82
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_ID_DESC (2)
Root page: 275, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 328, ratio: 0.82
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_NUMB_UNQ (1)
Root page: 504, depth: 2, leaf buckets: 3, nodes: 400
Average node length: 52.95, total dup: 0, max dup: 0
Average key length: 51.92, compression ratio: 0.99
Average prefix length: 2.65, average data length: 48.95
Clustering factor: 334, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 2
WARE_GROUPS (155)
Primary pointer page: 313, Index root page: 314
Total formats: 1, used formats: 1
Average record length: 32.13, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 352.00, compression ratio: 10.96
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 5%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARE_GROUPS (0)
Root page: 325, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 11.25, total dup: 0, max dup: 0
Average key length: 10.13, compression ratio: 0.89
Average prefix length: 1.75, average data length: 7.25
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index WARE_GROUPS_NAME_UNQ (1)
Root page: 326, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 19.88, total dup: 0, max dup: 0
Average key length: 18.13, compression ratio: 0.89
Average prefix length: 0.25, average data length: 15.88
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQD_1000_1200 (259)
Primary pointer page: 254, Index root page: 284
Total formats: 1, used formats: 1
Average record length: 0.77, total records: 331866
Average version length: 72.18, total versions: 328328, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 176.63
Pointer pages: 5, data page slots: 7048
Data pages: 4944, average fill: 87%
Primary pages: 4943, secondary pages: 1, swept pages: 159
Empty pages: 222, full pages: 4632
Fill distribution:
0 - 19% = 238
20 - 39% = 32
40 - 59% = 32
60 - 79% = 105
80 - 99% = 4537
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 117211, depth: 3, leaf buckets: 502, nodes: 331866
Average node length: 6.11, total dup: 289985, max dup: 29
Average key length: 3.30, compression ratio: 11.23
Average prefix length: 35.83, average data length: 1.17
Clustering factor: 52102, ratio: 0.16
Fill distribution:
0 - 19% = 100
20 - 39% = 3
40 - 59% = 133
60 - 79% = 261
80 - 99% = 5
XQD_1000_3300 (261)
Primary pointer page: 708, Index root page: 709
Total formats: 1, used formats: 1
Average record length: 62.11, total records: 1368958
Average version length: 71.23, total versions: 190591, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.19
Pointer pages: 13, data page slots: 20288
Data pages: 20288, average fill: 76%
Primary pages: 20288, secondary pages: 0, swept pages: 2266
Empty pages: 4, full pages: 17256
Fill distribution:
0 - 19% = 5
20 - 39% = 37
40 - 59% = 635
60 - 79% = 15939
80 - 99% = 3672
Index XQD_1000_3300_DOC (1)
Root page: 186874, depth: 3, leaf buckets: 1781, nodes: 1368958
Average node length: 5.16, total dup: 1330681, max dup: 129
Average key length: 2.21, compression ratio: 4.06
Average prefix length: 8.81, average data length: 0.19
Clustering factor: 284951, ratio: 0.21
Fill distribution:
0 - 19% = 32
20 - 39% = 120
40 - 59% = 1499
60 - 79% = 118
80 - 99% = 12
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 119038, depth: 3, leaf buckets: 2122, nodes: 1368958
Average node length: 6.29, total dup: 1193620, max dup: 33
Average key length: 3.34, compression ratio: 11.06
Average prefix length: 35.78, average data length: 1.22
Clustering factor: 360095, ratio: 0.26
Fill distribution:
0 - 19% = 15
20 - 39% = 243
40 - 59% = 1566
60 - 79% = 130
80 - 99% = 168
XQD_1200_2000 (260)
Primary pointer page: 705, Index root page: 706
Total formats: 1, used formats: 1
Average record length: 3.99, total records: 581948
Average version length: 71.90, total versions: 549753, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 34.12
Pointer pages: 8, data page slots: 11792
Data pages: 9888, average fill: 76%
Primary pages: 9886, secondary pages: 2, swept pages: 705
Empty pages: 831, full pages: 8146
Fill distribution:
0 - 19% = 1230
20 - 39% = 259
40 - 59% = 151
60 - 79% = 1266
80 - 99% = 6982
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 117066, depth: 3, leaf buckets: 851, nodes: 581948
Average node length: 5.97, total dup: 523776, max dup: 89
Average key length: 3.07, compression ratio: 12.03
Average prefix length: 36.02, average data length: 0.98
Clustering factor: 134972, ratio: 0.23
Fill distribution:
0 - 19% = 6
20 - 39% = 303
40 - 59% = 263
60 - 79% = 229
80 - 99% = 50
XQD_2000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 47.19, total records: 1917181
Average version length: 71.95, total versions: 663961, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.88
Pointer pages: 20, data page slots: 31768
Data pages: 31671, average fill: 71%
Primary pages: 31671, secondary pages: 0, swept pages: 1240
Empty pages: 140, full pages: 19848
Fill distribution:
0 - 19% = 584
20 - 39% = 1457
40 - 59% = 4502
60 - 79% = 10978
80 - 99% = 14150
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 107715, depth: 3, leaf buckets: 2937, nodes: 1917181
Average node length: 5.64, total dup: 1798522, max dup: 125
Average key length: 2.68, compression ratio: 13.82
Average prefix length: 36.38, average data length: 0.62
Clustering factor: 581291, ratio: 0.30
Fill distribution:
0 - 19% = 18
20 - 39% = 1036
40 - 59% = 1456
60 - 79% = 244
80 - 99% = 183
XQD_2100_3300 (263)
Primary pointer page: 734, Index root page: 735
Total formats: 1, used formats: 1
Average record length: 1.48, total records: 401282
Average version length: 71.79, total versions: 392708, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 91.82
Pointer pages: 6, data page slots: 8888
Data pages: 7091, average fill: 74%
Primary pages: 7091, secondary pages: 0, swept pages: 562
Empty pages: 747, full pages: 5608
Fill distribution:
0 - 19% = 951
20 - 39% = 174
40 - 59% = 168
60 - 79% = 1197
80 - 99% = 4601
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 86670, depth: 3, leaf buckets: 514, nodes: 401282
Average node length: 5.70, total dup: 372364, max dup: 131
Average key length: 2.81, compression ratio: 13.17
Average prefix length: 36.26, average data length: 0.74
Clustering factor: 52143, ratio: 0.13
Fill distribution:
0 - 19% = 3
20 - 39% = 50
40 - 59% = 262
60 - 79% = 179
80 - 99% = 20
XQD_3300_3400 (264)
Primary pointer page: 737, Index root page: 738
Total formats: 1, used formats: 1
Average record length: 64.30, total records: 2107635
Average version length: 71.15, total versions: 208171, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.12
Pointer pages: 19, data page slots: 30224
Data pages: 30224, average fill: 77%
Primary pages: 30224, secondary pages: 0, swept pages: 3351
Empty pages: 18, full pages: 27385
Fill distribution:
0 - 19% = 82
20 - 39% = 100
40 - 59% = 462
60 - 79% = 22375
80 - 99% = 7205
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 41262, depth: 3, leaf buckets: 4349, nodes: 2107635
Average node length: 6.96, total dup: 1688854, max dup: 29
Average key length: 3.99, compression ratio: 9.27
Average prefix length: 35.21, average data length: 1.79
Clustering factor: 594414, ratio: 0.28
Fill distribution:
0 - 19% = 7
20 - 39% = 2373
40 - 59% = 1560
60 - 79% = 229
80 - 99% = 180
XQS_1000_1200 (265)
Primary pointer page: 740, Index root page: 741
Total formats: 1, used formats: 1
Average record length: 82.41, total records: 3480164
Average version length: 83.99, total versions: 47956, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.65
Pointer pages: 34, data page slots: 53864
Data pages: 53864, average fill: 80%
Primary pages: 53864, secondary pages: 0, swept pages: 19755
Empty pages: 0, full pages: 53204
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 25
60 - 79% = 23172
80 - 99% = 30667
Index XQS_1000_1200_DOC_ID (0)
Root page: 54649, depth: 3, leaf buckets: 3374, nodes: 3480164
Average node length: 5.16, total dup: 3399774, max dup: 144
Average key length: 2.18, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 804663, ratio: 0.23
Fill distribution:
0 - 19% = 9
20 - 39% = 44
40 - 59% = 1279
60 - 79% = 1313
80 - 99% = 729
Index XQS_1000_1200_RCV_ID (2)
Root page: 78654, depth: 3, leaf buckets: 4562, nodes: 3480164
Average node length: 5.65, total dup: 3140079, max dup: 49
Average key length: 2.67, compression ratio: 3.37
Average prefix length: 8.43, average data length: 0.57
Clustering factor: 541660, ratio: 0.16
Fill distribution:
0 - 19% = 43
20 - 39% = 88
40 - 59% = 3603
60 - 79% = 367
80 - 99% = 461
Index XQS_1000_1200_SND_ID (1)
Root page: 48486, depth: 3, leaf buckets: 3793, nodes: 3480164
Average node length: 5.80, total dup: 3044388, max dup: 29
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.31, average data length: 0.69
Clustering factor: 851402, ratio: 0.24
Fill distribution:
0 - 19% = 2
20 - 39% = 47
40 - 59% = 1592
60 - 79% = 1232
80 - 99% = 920
XQS_1000_3300 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 76.72, total records: 1515274
Average version length: 82.67, total versions: 105013, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.77
Pointer pages: 15, data page slots: 23656
Data pages: 23656, average fill: 79%
Primary pages: 23656, secondary pages: 0, swept pages: 6802
Empty pages: 0, full pages: 22174
Fill distribution:
0 - 19% = 32
20 - 39% = 68
40 - 59% = 236
60 - 79% = 9988
80 - 99% = 13332
Index XQS_1000_3300_DOC_ID (0)
Root page: 75516, depth: 3, leaf buckets: 1618, nodes: 1515274
Average node length: 5.13, total dup: 1481141, max dup: 286
Average key length: 2.18, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 313834, ratio: 0.21
Fill distribution:
0 - 19% = 2
20 - 39% = 26
40 - 59% = 926
60 - 79% = 501
80 - 99% = 163
Index XQS_1000_3300_RCV_ID (2)
Root page: 127931, depth: 3, leaf buckets: 2748, nodes: 1515274
Average node length: 6.28, total dup: 1231696, max dup: 14
Average key length: 3.32, compression ratio: 2.71
Average prefix length: 7.87, average data length: 1.13
Clustering factor: 228980, ratio: 0.15
Fill distribution:
0 - 19% = 43
20 - 39% = 1244
40 - 59% = 1189
60 - 79% = 211
80 - 99% = 61
Index XQS_1000_3300_SND_ID (1)
Root page: 65477, depth: 3, leaf buckets: 1815, nodes: 1515274
Average node length: 5.75, total dup: 1334893, max dup: 44
Average key length: 2.80, compression ratio: 3.21
Average prefix length: 8.32, average data length: 0.68
Clustering factor: 340404, ratio: 0.22
Fill distribution:
0 - 19% = 9
20 - 39% = 31
40 - 59% = 1029
60 - 79% = 568
80 - 99% = 178
XQS_1200_2000 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 77.20, total records: 3937515
Average version length: 85.01, total versions: 304626, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.76
Pointer pages: 38, data page slots: 61928
Data pages: 61928, average fill: 80%
Primary pages: 61928, secondary pages: 0, swept pages: 9335
Empty pages: 6, full pages: 58050
Fill distribution:
0 - 19% = 15
20 - 39% = 169
40 - 59% = 804
60 - 79% = 22986
80 - 99% = 37954
Index XQS_1200_2000_DOC_ID (0)
Root page: 57323, depth: 3, leaf buckets: 4288, nodes: 3937515
Average node length: 5.03, total dup: 3916034, max dup: 632
Average key length: 2.05, compression ratio: 4.39
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 1054203, ratio: 0.27
Fill distribution:
0 - 19% = 5
20 - 39% = 266
40 - 59% = 2519
60 - 79% = 1186
80 - 99% = 312
Index XQS_1200_2000_RCV_ID (2)
Root page: 78658, depth: 3, leaf buckets: 5363, nodes: 3937515
Average node length: 5.50, total dup: 3642938, max dup: 49
Average key length: 2.52, compression ratio: 3.57
Average prefix length: 8.55, average data length: 0.45
Clustering factor: 850339, ratio: 0.22
Fill distribution:
0 - 19% = 23
20 - 39% = 1648
40 - 59% = 2710
60 - 79% = 430
80 - 99% = 552
Index XQS_1200_2000_SND_ID (1)
Root page: 49624, depth: 3, leaf buckets: 4786, nodes: 3937515
Average node length: 5.60, total dup: 3585597, max dup: 124
Average key length: 2.61, compression ratio: 3.44
Average prefix length: 8.48, average data length: 0.52
Clustering factor: 1127472, ratio: 0.29
Fill distribution:
0 - 19% = 9
20 - 39% = 250
40 - 59% = 2953
60 - 79% = 1216
80 - 99% = 358
XQS_2000_3300 (268)
Primary pointer page: 757, Index root page: 758
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_DOC_ID (0)
Root page: 760, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_RCV_ID (2)
Root page: 762, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_SND_ID (1)
Root page: 761, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQS_2100_3300 (269)
Primary pointer page: 763, Index root page: 764
Total formats: 1, used formats: 1
Average record length: 78.07, total records: 2530338
Average version length: 83.88, total versions: 159243, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.74
Pointer pages: 25, data page slots: 39744
Data pages: 39744, average fill: 79%
Primary pages: 39744, secondary pages: 0, swept pages: 9027
Empty pages: 13, full pages: 37297
Fill distribution:
0 - 19% = 75
20 - 39% = 87
40 - 59% = 215
60 - 79% = 16450
80 - 99% = 22917
Index XQS_2100_3300_DOC_ID (0)
Root page: 92030, depth: 3, leaf buckets: 2693, nodes: 2530338
Average node length: 5.02, total dup: 2517617, max dup: 1267
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 700812, ratio: 0.28
Fill distribution:
0 - 19% = 15
20 - 39% = 290
40 - 59% = 1311
60 - 79% = 717
80 - 99% = 360
Index XQS_2100_3300_RCV_ID (2)
Root page: 94869, depth: 3, leaf buckets: 4800, nodes: 2530338
Average node length: 6.30, total dup: 2052246, max dup: 14
Average key length: 3.33, compression ratio: 2.70
Average prefix length: 7.86, average data length: 1.14
Clustering factor: 549683, ratio: 0.22
Fill distribution:
0 - 19% = 167
20 - 39% = 2200
40 - 59% = 2105
60 - 79% = 226
80 - 99% = 102
Index XQS_2100_3300_SND_ID (1)
Root page: 78028, depth: 3, leaf buckets: 2880, nodes: 2530338
Average node length: 5.54, total dup: 2323641, max dup: 97
Average key length: 2.57, compression ratio: 3.50
Average prefix length: 8.51, average data length: 0.49
Clustering factor: 730874, ratio: 0.29
Fill distribution:
0 - 19% = 3
20 - 39% = 218
40 - 59% = 1321
60 - 79% = 954
80 - 99% = 384
XQS_3300_3400 (270)
Primary pointer page: 776, Index root page: 777
Total formats: 1, used formats: 1
Average record length: 65.44, total records: 498339
Average version length: 69.35, total versions: 26708, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.08
Pointer pages: 5, data page slots: 7080
Data pages: 7080, average fill: 75%
Primary pages: 7080, secondary pages: 0, swept pages: 3921
Empty pages: 0, full pages: 6047
Fill distribution:
0 - 19% = 40
20 - 39% = 102
40 - 59% = 265
60 - 79% = 5996
80 - 99% = 677
Index XQS_3300_3400_DOC_ID (0)
Root page: 382488, depth: 3, leaf buckets: 555, nodes: 498339
Average node length: 5.33, total dup: 466614, max dup: 150
Average key length: 2.49, compression ratio: 3.61
Average prefix length: 8.57, average data length: 0.43
Clustering factor: 43469, ratio: 0.09
Fill distribution:
0 - 19% = 0
20 - 39% = 50
40 - 59% = 263
60 - 79% = 169
80 - 99% = 73
Index XQS_3300_3400_SND_ID (1)
Root page: 332043, depth: 3, leaf buckets: 609, nodes: 498339
Average node length: 5.92, total dup: 425044, max dup: 29
Average key length: 3.08, compression ratio: 2.92
Average prefix length: 8.07, average data length: 0.93
Clustering factor: 51074, ratio: 0.10
Fill distribution:
0 - 19% = 1
20 - 39% = 61
40 - 59% = 260
60 - 79% = 206
80 - 99% = 81
ZDOC_DATA (229)
Primary pointer page: 632, Index root page: 633
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZDOC_LIST (228)
Primary pointer page: 630, Index root page: 631
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZINVNT_TURNOVER_LOG (230)
Primary pointer page: 634, Index root page: 635
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPDISTR (233)
Primary pointer page: 640, Index root page: 641
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPDISTR_ID (0)
Root page: 650, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPSTORNED (234)
Primary pointer page: 642, Index root page: 643
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPSTORNED_ID (0)
Root page: 651, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQDISTR (231)
Primary pointer page: 636, Index root page: 637
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_ID (0)
Root page: 644, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Root page: 645, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQSTORNED (232)
Primary pointer page: 638, Index root page: 639
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_DOC_ID (1)
Root page: 647, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_ID (0)
Root page: 646, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_RCV_ID (3)
Root page: 649, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_SND_ID (2)
Root page: 648, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_DEP_DOCS (227)
Primary pointer page: 628, Index root page: 629
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_SHOPPING_CART (226)
Primary pointer page: 625, Index root page: 626
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Z_USED_VIEWS (146)
Primary pointer page: 267, Index root page: 268
Total formats: 1, used formats: 1
Average record length: 29.38, total records: 29
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 99.00, compression ratio: 3.37
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 16%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index Z_USED_VIEWS_UNQ (0)
Root page: 280, depth: 1, leaf buckets: 1, nodes: 29
Average node length: 15.17, total dup: 0, max dup: 0
Average key length: 14.14, compression ratio: 1.44
Average prefix length: 9.17, average data length: 11.17
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Done for 20780 ms, from 7:05:01.79 to 7:05:22.57.
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
VERS_PERCENT |
AGENTS |
50 |
0 |
0.0000 |
BUSINESS_OPS |
19 |
0 |
0.0000 |
DOC_DATA |
1579444 |
47469 |
3.0054 |
DOC_LIST |
544338 |
46020 |
8.4543 |
DOC_STATES |
4 |
0 |
0.0000 |
FB_ERRORS |
758 |
0 |
0.0000 |
INVNT_SALDO |
400 |
784093 |
196023.2500 |
INVNT_TURNOVER_LOG |
223761 |
219984 |
98.3120 |
MONEY_SALDO |
49 |
46649 |
95202.0408 |
MONEY_TURNOVER_LOG |
10392 |
10346 |
99.5573 |
OPTYPES |
9 |
0 |
0.0000 |
PDISTR |
322409 |
130051 |
40.3372 |
PERF_ESTIMATED |
226426 |
0 |
0.0000 |
PERF_LOG |
8059835 |
0 |
0.0000 |
PSTORNED |
295501 |
14030 |
4.7478 |
RULES_FOR_PDISTR |
4 |
0 |
0.0000 |
RULES_FOR_QDISTR |
7 |
0 |
0.0000 |
SEMAPHORES |
4 |
7158 |
178950.0000 |
SETTINGS |
114 |
0 |
0.0000 |
TRACE_STAT |
2397 |
0 |
0.0000 |
WARES |
400 |
0 |
0.0000 |
WARE_GROUPS |
8 |
0 |
0.0000 |
XQD_1000_1200 |
331866 |
328328 |
98.9339 |
XQD_1000_3300 |
1368958 |
190591 |
13.9223 |
XQD_1200_2000 |
581948 |
549753 |
94.4677 |
XQD_2000_3300 |
1917181 |
663961 |
34.6321 |
XQD_2100_3300 |
401282 |
392708 |
97.8633 |
XQD_3300_3400 |
2107635 |
208171 |
9.8769 |
XQS_1000_1200 |
3480164 |
47956 |
1.3779 |
XQS_1000_3300 |
1515274 |
105013 |
6.9302 |
XQS_1200_2000 |
3937515 |
304626 |
7.7365 |
XQS_2100_3300 |
2530338 |
159243 |
6.2933 |
XQS_3300_3400 |
498339 |
26708 |
5.3594 |
Z_USED_VIEWS |
29 |
0 |
0.0000 |
Done for 2230 ms, from 7:05:33.52 to 7:05:35.75.
07:05:35.82 Validation started
07:05:35.82 Relation 140 (DOC_LIST)
07:05:35.82 process pointer page 0 of 5
07:05:35.93 process pointer page 1 of 5
07:05:36.00 process pointer page 2 of 5
07:05:36.04 process pointer page 3 of 5
07:05:36.09 process pointer page 4 of 5
07:05:36.10 Index 1 (PK_DOC_LIST)
07:05:36.18 Index 2 (DOC_LIST_ID_DESC)
07:05:36.27 Index 3 (FK_DOC_LIST_AGENTS)
07:05:36.48 Relation 140 (DOC_LIST) is ok
07:05:36.48 Relation 141 (DOC_DATA)
07:05:36.48 process pointer page 0 of 11
07:05:36.58 process pointer page 1 of 11
07:05:36.61 process pointer page 2 of 11
07:05:36.65 process pointer page 3 of 11
07:05:36.69 process pointer page 4 of 11
07:05:36.73 process pointer page 5 of 11
07:05:36.76 process pointer page 6 of 11
07:05:36.80 process pointer page 7 of 11
07:05:36.83 process pointer page 8 of 11
07:05:36.87 process pointer page 9 of 11
07:05:36.90 process pointer page 10 of 11
07:05:36.92 Index 2 (DOC_DATA_DOC_WARE_UNQ)
07:05:37.15 Index 3 (DOC_DATA_ID_DESC)
07:05:37.35 Index 4 (FK_DOC_DATA_DOC_LIST)
07:05:37.61 Relation 141 (DOC_DATA) is ok
07:05:37.61 Relation 147 (INVNT_SALDO)
07:05:37.61 process pointer page 0 of 3
07:05:38.79 process pointer page 1 of 3
07:05:38.80 process pointer page 2 of 3
07:05:38.80 Index 1 (PK_INVNT_SALDO)
07:05:38.80 Relation 147 (INVNT_SALDO) is ok
07:05:38.80 Relation 150 (PDISTR)
07:05:38.80 process pointer page 0 of 3
07:05:38.86 process pointer page 1 of 3
07:05:39.03 process pointer page 2 of 3
07:05:39.05 Index 2 (PDISTR_SND_ID)
07:05:39.09 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
07:05:39.13 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
07:05:39.17 Index 5 (PDISTR_AGENT_ID)
07:05:39.20 Relation 150 (PDISTR) is ok
07:05:39.20 Relation 151 (PSTORNED)
07:05:39.20 process pointer page 0 of 3
07:05:39.24 process pointer page 1 of 3
07:05:39.27 process pointer page 2 of 3
07:05:39.28 Index 2 (PSTORNED_SND_ID)
07:05:39.30 Index 3 (PSTORNED_RCV_ID)
07:05:39.33 Relation 151 (PSTORNED) is ok
07:05:39.33 Relation 156 (SEMAPHORES)
07:05:39.33 process pointer page 0 of 1
07:05:39.33 Index 1 (PK_SEMAPHORES)
07:05:39.33 Index 2 (SEMAPHORES_TASK_UNQ)
07:05:39.33 Relation 156 (SEMAPHORES) is ok
07:05:39.33 Relation 157 (INVNT_TURNOVER_LOG)
07:05:39.33 process pointer page 0 of 4
07:05:39.40 process pointer page 1 of 4
07:05:39.42 process pointer page 2 of 4
07:05:39.46 process pointer page 3 of 4
07:05:39.55 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
07:05:39.63 Relation 157 (INVNT_TURNOVER_LOG) is ok
07:05:39.63 Relation 160 (PERF_ESTIMATED)
07:05:39.63 process pointer page 0 of 2
07:05:39.66 process pointer page 1 of 2
07:05:39.67 Index 1 (PERF_EST_MINUTE_SINCE_START)
07:05:39.70 Relation 160 (PERF_ESTIMATED) is ok
07:05:39.70 Relation 161 (PERF_ISQL_STAT)
07:05:39.70 process pointer page 0 of 1
07:05:39.70 Index 1 (PERF_ISQL_STAT_TRN)
07:05:39.70 Relation 161 (PERF_ISQL_STAT) is ok
07:05:39.70 Relation 162 (PERF_LOG)
07:05:39.70 process pointer page 0 of 116
07:05:39.74 process pointer page 1 of 116
07:05:39.82 process pointer page 2 of 116
07:05:39.90 process pointer page 3 of 116
07:05:39.95 process pointer page 4 of 116
07:05:39.98 process pointer page 5 of 116
07:05:40.01 process pointer page 6 of 116
07:05:40.04 process pointer page 7 of 116
07:05:40.07 process pointer page 8 of 116
07:05:40.10 process pointer page 9 of 116
07:05:40.14 process pointer page 10 of 116
07:05:40.22 process pointer page 11 of 116
07:05:40.26 process pointer page 12 of 116
07:05:40.31 process pointer page 13 of 116
07:05:40.35 process pointer page 14 of 116
07:05:40.38 process pointer page 15 of 116
07:05:40.41 process pointer page 16 of 116
07:05:40.48 process pointer page 17 of 116
07:05:40.56 process pointer page 18 of 116
07:05:40.63 process pointer page 19 of 116
07:05:40.71 process pointer page 20 of 116
07:05:40.79 process pointer page 21 of 116
07:05:40.87 process pointer page 22 of 116
07:05:40.90 process pointer page 23 of 116
07:05:40.94 process pointer page 24 of 116
07:05:40.97 process pointer page 25 of 116
07:05:41.00 process pointer page 26 of 116
07:05:41.03 process pointer page 27 of 116
07:05:41.06 process pointer page 28 of 116
07:05:41.08 process pointer page 29 of 116
07:05:41.11 process pointer page 30 of 116
07:05:41.14 process pointer page 31 of 116
07:05:41.16 process pointer page 32 of 116
07:05:41.19 process pointer page 33 of 116
07:05:41.21 process pointer page 34 of 116
07:05:41.24 process pointer page 35 of 116
07:05:41.26 process pointer page 36 of 116
07:05:41.28 process pointer page 37 of 116
07:05:41.30 process pointer page 38 of 116
07:05:41.33 process pointer page 39 of 116
07:05:41.35 process pointer page 40 of 116
07:05:41.37 process pointer page 41 of 116
07:05:41.40 process pointer page 42 of 116
07:05:41.42 process pointer page 43 of 116
07:05:41.44 process pointer page 44 of 116
07:05:41.47 process pointer page 45 of 116
07:05:41.49 process pointer page 46 of 116
07:05:41.53 process pointer page 47 of 116
07:05:41.61 process pointer page 48 of 116
07:05:41.65 process pointer page 49 of 116
07:05:41.68 process pointer page 50 of 116
07:05:41.71 process pointer page 51 of 116
07:05:41.74 process pointer page 52 of 116
07:05:41.78 process pointer page 53 of 116
07:05:41.86 process pointer page 54 of 116
07:05:41.90 process pointer page 55 of 116
07:05:41.93 process pointer page 56 of 116
07:05:41.96 process pointer page 57 of 116
07:05:41.99 process pointer page 58 of 116
07:05:42.02 process pointer page 59 of 116
07:05:42.05 process pointer page 60 of 116
07:05:42.08 process pointer page 61 of 116
07:05:42.11 process pointer page 62 of 116
07:05:42.13 process pointer page 63 of 116
07:05:42.16 process pointer page 64 of 116
07:05:42.19 process pointer page 65 of 116
07:05:42.21 process pointer page 66 of 116
07:05:42.23 process pointer page 67 of 116
07:05:42.25 process pointer page 68 of 116
07:05:42.28 process pointer page 69 of 116
07:05:42.30 process pointer page 70 of 116
07:05:42.32 process pointer page 71 of 116
07:05:42.35 process pointer page 72 of 116
07:05:42.37 process pointer page 73 of 116
07:05:42.39 process pointer page 74 of 116
07:05:42.42 process pointer page 75 of 116
07:05:42.44 process pointer page 76 of 116
07:05:42.46 process pointer page 77 of 116
07:05:42.49 process pointer page 78 of 116
07:05:42.52 process pointer page 79 of 116
07:05:42.60 process pointer page 80 of 116
07:05:42.65 process pointer page 81 of 116
07:05:42.69 process pointer page 82 of 116
07:05:42.74 process pointer page 83 of 116
07:05:42.77 process pointer page 84 of 116
07:05:42.80 process pointer page 85 of 116
07:05:42.83 process pointer page 86 of 116
07:05:42.87 process pointer page 87 of 116
07:05:42.89 process pointer page 88 of 116
07:05:42.92 process pointer page 89 of 116
07:05:42.95 process pointer page 90 of 116
07:05:42.98 process pointer page 91 of 116
07:05:43.00 process pointer page 92 of 116
07:05:43.03 process pointer page 93 of 116
07:05:43.05 process pointer page 94 of 116
07:05:43.08 process pointer page 95 of 116
07:05:43.10 process pointer page 96 of 116
07:05:43.12 process pointer page 97 of 116
07:05:43.14 process pointer page 98 of 116
07:05:43.17 process pointer page 99 of 116
07:05:43.19 process pointer page 100 of 116
07:05:43.22 process pointer page 101 of 116
07:05:43.27 process pointer page 102 of 116
07:05:43.30 process pointer page 103 of 116
07:05:43.33 process pointer page 104 of 116
07:05:43.36 process pointer page 105 of 116
07:05:43.38 process pointer page 106 of 116
07:05:43.41 process pointer page 107 of 116
07:05:43.44 process pointer page 108 of 116
07:05:43.46 process pointer page 109 of 116
07:05:43.48 process pointer page 110 of 116
07:05:43.50 process pointer page 111 of 116
07:05:43.53 process pointer page 112 of 116
07:05:43.56 process pointer page 113 of 116
07:05:43.62 process pointer page 114 of 116
07:05:43.69 process pointer page 115 of 116
07:05:43.70 Index 1 (PERF_LOG_DTS_BEG_DESC)
07:05:44.96 Index 2 (PERF_LOG_UNIT)
07:05:47.88 Index 3 (PERF_LOG_TRN_DESC)
07:05:48.95 Index 4 (PERF_LOG_GDSCODE)
07:05:49.47 Relation 162 (PERF_LOG) is ok
07:05:49.47 Relation 166 (V_STOPTEST)
07:05:49.47 Relation 166 (V_STOPTEST) is ok
07:05:49.47 Relation 183 (V_QDISTR_SOURCE)
07:05:49.47 Relation 183 (V_QDISTR_SOURCE) is ok
07:05:49.47 Relation 184 (V_QSTORNED_SOURCE)
07:05:49.47 Relation 184 (V_QSTORNED_SOURCE) is ok
07:05:49.47 Relation 259 (XQD_1000_1200)
07:05:49.47 process pointer page 0 of 5
07:05:49.53 process pointer page 1 of 5
07:05:49.61 process pointer page 2 of 5
07:05:49.78 process pointer page 3 of 5
07:05:49.81 process pointer page 4 of 5
07:05:49.82 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
07:05:49.87 Relation 259 (XQD_1000_1200) is ok
07:05:49.87 Relation 260 (XQD_1200_2000)
07:05:49.87 process pointer page 0 of 8
07:05:49.94 process pointer page 1 of 8
07:05:50.01 process pointer page 2 of 8
07:05:50.08 process pointer page 3 of 8
07:05:50.14 process pointer page 4 of 8
07:05:50.18 process pointer page 5 of 8
07:05:50.23 process pointer page 6 of 8
07:05:50.27 process pointer page 7 of 8
07:05:50.27 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
07:05:50.33 Relation 260 (XQD_1200_2000) is ok
07:05:50.33 Relation 261 (XQD_1000_3300)
07:05:50.33 process pointer page 0 of 13
07:05:50.36 process pointer page 1 of 13
07:05:50.40 process pointer page 2 of 13
07:05:50.43 process pointer page 3 of 13
07:05:50.46 process pointer page 4 of 13
07:05:50.49 process pointer page 5 of 13
07:05:50.53 process pointer page 6 of 13
07:05:50.56 process pointer page 7 of 13
07:05:50.59 process pointer page 8 of 13
07:05:50.63 process pointer page 9 of 13
07:05:50.67 process pointer page 10 of 13
07:05:50.70 process pointer page 11 of 13
07:05:50.73 process pointer page 12 of 13
07:05:50.74 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
07:05:50.89 Index 2 (XQD_1000_3300_DOC)
07:05:51.03 Relation 261 (XQD_1000_3300) is ok
07:05:51.03 Relation 262 (XQD_2000_3300)
07:05:51.03 process pointer page 0 of 20
07:05:51.08 process pointer page 1 of 20
07:05:51.12 process pointer page 2 of 20
07:05:51.16 process pointer page 3 of 20
07:05:51.20 process pointer page 4 of 20
07:05:51.24 process pointer page 5 of 20
07:05:51.28 process pointer page 6 of 20
07:05:51.32 process pointer page 7 of 20
07:05:51.36 process pointer page 8 of 20
07:05:51.41 process pointer page 9 of 20
07:05:51.45 process pointer page 10 of 20
07:05:51.49 process pointer page 11 of 20
07:05:51.53 process pointer page 12 of 20
07:05:51.57 process pointer page 13 of 20
07:05:51.60 process pointer page 14 of 20
07:05:51.64 process pointer page 15 of 20
07:05:51.68 process pointer page 16 of 20
07:05:51.72 process pointer page 17 of 20
07:05:51.76 process pointer page 18 of 20
07:05:51.80 process pointer page 19 of 20
07:05:51.81 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
07:05:52.17 Relation 262 (XQD_2000_3300) is ok
07:05:52.17 Relation 263 (XQD_2100_3300)
07:05:52.17 process pointer page 0 of 6
07:05:52.24 process pointer page 1 of 6
07:05:52.39 process pointer page 2 of 6
07:05:52.49 process pointer page 3 of 6
07:05:52.57 process pointer page 4 of 6
07:05:52.68 process pointer page 5 of 6
07:05:52.72 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
07:05:52.78 Relation 263 (XQD_2100_3300) is ok
07:05:52.78 Relation 264 (XQD_3300_3400)
07:05:52.78 process pointer page 0 of 19
07:05:52.89 process pointer page 1 of 19
07:05:52.95 process pointer page 2 of 19
07:05:53.00 process pointer page 3 of 19
07:05:53.04 process pointer page 4 of 19
07:05:53.08 process pointer page 5 of 19
07:05:53.12 process pointer page 6 of 19
07:05:53.16 process pointer page 7 of 19
07:05:53.19 process pointer page 8 of 19
07:05:53.23 process pointer page 9 of 19
07:05:53.26 process pointer page 10 of 19
07:05:53.29 process pointer page 11 of 19
07:05:53.32 process pointer page 12 of 19
07:05:53.41 process pointer page 13 of 19
07:05:53.53 process pointer page 14 of 19
07:05:53.57 process pointer page 15 of 19
07:05:53.62 process pointer page 16 of 19
07:05:53.71 process pointer page 17 of 19
07:05:53.76 process pointer page 18 of 19
07:05:53.78 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
07:05:54.09 Relation 264 (XQD_3300_3400) is ok
07:05:54.09 Relation 265 (XQS_1000_1200)
07:05:54.09 process pointer page 0 of 34
07:05:54.12 process pointer page 1 of 34
07:05:54.14 process pointer page 2 of 34
07:05:54.17 process pointer page 3 of 34
07:05:54.20 process pointer page 4 of 34
07:05:54.22 process pointer page 5 of 34
07:05:54.25 process pointer page 6 of 34
07:05:54.31 process pointer page 7 of 34
07:05:54.35 process pointer page 8 of 34
07:05:54.40 process pointer page 9 of 34
07:05:54.45 process pointer page 10 of 34
07:05:54.49 process pointer page 11 of 34
07:05:54.52 process pointer page 12 of 34
07:05:54.56 process pointer page 13 of 34
07:05:54.59 process pointer page 14 of 34
07:05:54.63 process pointer page 15 of 34
07:05:54.73 process pointer page 16 of 34
07:05:54.76 process pointer page 17 of 34
07:05:54.80 process pointer page 18 of 34
07:05:54.84 process pointer page 19 of 34
07:05:54.87 process pointer page 20 of 34
07:05:54.90 process pointer page 21 of 34
07:05:54.94 process pointer page 22 of 34
07:05:54.97 process pointer page 23 of 34
07:05:55.00 process pointer page 24 of 34
07:05:55.03 process pointer page 25 of 34
07:05:55.06 process pointer page 26 of 34
07:05:55.08 process pointer page 27 of 34
07:05:55.11 process pointer page 28 of 34
07:05:55.14 process pointer page 29 of 34
07:05:55.16 process pointer page 30 of 34
07:05:55.19 process pointer page 31 of 34
07:05:55.21 process pointer page 32 of 34
07:05:55.25 process pointer page 33 of 34
07:05:55.25 Index 1 (XQS_1000_1200_DOC_ID)
07:05:55.77 Index 2 (XQS_1000_1200_SND_ID)
07:05:56.22 Index 3 (XQS_1000_1200_RCV_ID)
07:05:56.63 Relation 265 (XQS_1000_1200) is ok
07:05:56.63 Relation 266 (XQS_1200_2000)
07:05:56.63 process pointer page 0 of 38
07:05:56.66 process pointer page 1 of 38
07:05:56.69 process pointer page 2 of 38
07:05:56.72 process pointer page 3 of 38
07:05:56.75 process pointer page 4 of 38
07:05:56.78 process pointer page 5 of 38
07:05:56.81 process pointer page 6 of 38
07:05:56.84 process pointer page 7 of 38
07:05:56.86 process pointer page 8 of 38
07:05:56.89 process pointer page 9 of 38
07:05:56.92 process pointer page 10 of 38
07:05:56.95 process pointer page 11 of 38
07:05:56.98 process pointer page 12 of 38
07:05:57.02 process pointer page 13 of 38
07:05:57.06 process pointer page 14 of 38
07:05:57.09 process pointer page 15 of 38
07:05:57.12 process pointer page 16 of 38
07:05:57.15 process pointer page 17 of 38
07:05:57.18 process pointer page 18 of 38
07:05:57.21 process pointer page 19 of 38
07:05:57.24 process pointer page 20 of 38
07:05:57.26 process pointer page 21 of 38
07:05:57.30 process pointer page 22 of 38
07:05:57.37 process pointer page 23 of 38
07:05:57.41 process pointer page 24 of 38
07:05:57.44 process pointer page 25 of 38
07:05:57.49 process pointer page 26 of 38
07:05:57.60 process pointer page 27 of 38
07:05:57.70 process pointer page 28 of 38
07:05:57.81 process pointer page 29 of 38
07:05:57.91 process pointer page 30 of 38
07:05:57.96 process pointer page 31 of 38
07:05:58.00 process pointer page 32 of 38
07:05:58.05 process pointer page 33 of 38
07:05:58.09 process pointer page 34 of 38
07:05:58.13 process pointer page 35 of 38
07:05:58.17 process pointer page 36 of 38
07:05:58.21 process pointer page 37 of 38
07:05:58.24 Index 1 (XQS_1200_2000_DOC_ID)
07:05:58.62 Index 2 (XQS_1200_2000_SND_ID)
07:05:59.16 Index 3 (XQS_1200_2000_RCV_ID)
07:05:59.50 Relation 266 (XQS_1200_2000) is ok
07:05:59.50 Relation 267 (XQS_1000_3300)
07:05:59.50 process pointer page 0 of 15
07:05:59.53 process pointer page 1 of 15
07:05:59.56 process pointer page 2 of 15
07:05:59.59 process pointer page 3 of 15
07:05:59.62 process pointer page 4 of 15
07:05:59.65 process pointer page 5 of 15
07:05:59.68 process pointer page 6 of 15
07:05:59.71 process pointer page 7 of 15
07:05:59.74 process pointer page 8 of 15
07:05:59.78 process pointer page 9 of 15
07:05:59.82 process pointer page 10 of 15
07:05:59.92 process pointer page 11 of 15
07:05:59.96 process pointer page 12 of 15
07:06:00.00 process pointer page 13 of 15
07:06:00.08 process pointer page 14 of 15
07:06:00.12 Index 1 (XQS_1000_3300_DOC_ID)
07:06:00.32 Index 2 (XQS_1000_3300_SND_ID)
07:06:00.49 Index 3 (XQS_1000_3300_RCV_ID)
07:06:00.62 Relation 267 (XQS_1000_3300) is ok
07:06:00.62 Relation 268 (XQS_2000_3300)
07:06:00.62 process pointer page 0 of 1
07:06:00.62 Index 1 (XQS_2000_3300_DOC_ID)
07:06:00.62 Index 2 (XQS_2000_3300_SND_ID)
07:06:00.62 Index 3 (XQS_2000_3300_RCV_ID)
07:06:00.62 Relation 268 (XQS_2000_3300) is ok
07:06:00.62 Relation 269 (XQS_2100_3300)
07:06:00.62 process pointer page 0 of 25
07:06:00.66 process pointer page 1 of 25
07:06:00.69 process pointer page 2 of 25
07:06:00.73 process pointer page 3 of 25
07:06:00.76 process pointer page 4 of 25
07:06:00.83 process pointer page 5 of 25
07:06:00.88 process pointer page 6 of 25
07:06:00.91 process pointer page 7 of 25
07:06:00.95 process pointer page 8 of 25
07:06:00.99 process pointer page 9 of 25
07:06:01.02 process pointer page 10 of 25
07:06:01.05 process pointer page 11 of 25
07:06:01.09 process pointer page 12 of 25
07:06:01.12 process pointer page 13 of 25
07:06:01.15 process pointer page 14 of 25
07:06:01.18 process pointer page 15 of 25
07:06:01.20 process pointer page 16 of 25
07:06:01.23 process pointer page 17 of 25
07:06:01.27 process pointer page 18 of 25
07:06:01.33 process pointer page 19 of 25
07:06:01.37 process pointer page 20 of 25
07:06:01.40 process pointer page 21 of 25
07:06:01.43 process pointer page 22 of 25
07:06:01.47 process pointer page 23 of 25
07:06:01.50 process pointer page 24 of 25
07:06:01.50 Index 1 (XQS_2100_3300_DOC_ID)
07:06:01.75 Index 2 (XQS_2100_3300_SND_ID)
07:06:02.07 Index 3 (XQS_2100_3300_RCV_ID)
07:06:02.30 Relation 269 (XQS_2100_3300) is ok
07:06:02.30 Relation 270 (XQS_3300_3400)
07:06:02.30 process pointer page 0 of 5
07:06:02.33 process pointer page 1 of 5
07:06:02.35 process pointer page 2 of 5
07:06:02.38 process pointer page 3 of 5
07:06:02.41 process pointer page 4 of 5
07:06:02.42 Index 1 (XQS_3300_3400_DOC_ID)
07:06:02.46 Index 2 (XQS_3300_3400_SND_ID)
07:06:02.49 Relation 270 (XQS_3300_3400) is ok
07:06:02.49 Relation 276 (TRACE_STAT)
07:06:02.50 process pointer page 0 of 1
07:06:02.50 Relation 276 (TRACE_STAT) is ok
07:06:02.50 Validation finished
Done for 26720 ms, from 7:05:35.78 to 7:06:02.50.
Differences between old and current firebird.log
7:06:03.45. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2016-04-13 07:06 504 oltp30_fb_log_when_test_finished.log
End of gathering firebird.log AFTER test finish.
+++ Start of comparison +++
***** E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Wed Apr 13 07:05:35 2016
7: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Wed Apr 13 07:06:02 2016
12: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++
Remove 302 logs of every ISQL session if there were no serious errors.
Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp30\oltp30_*.*:
ERRORS_CHECKING_RESULT |
NO_SEVERE_ERRORS_FOUND |
ISQL logs are removed because no severe errors occured during test.
2016-04-13 7:06:07.96 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html