Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2016-11-17 2:27:36.41.
Server version: WI-T4.0.0.452 Firebird 4.0 Unstable
Server implementation: Firebird/Windows/AMD/Intel/x64
FB_ARCHITECTURE |
DB_NAME |
FORCED_WRITES |
SWEEP_INT |
PAGE_BUFFERS |
PAGE_SIZE |
SuperServer 4.0.0 |
D:\OLTP-EMUL\OLTP40-SMALL.FDB |
ON |
0 |
786432 |
8192 |
Test configuration settings
File: E:\OLTP-EMUL\src\oltp40_config.win
PARAM_NAME |
PARAM_VALUE |
fbc |
E:\FB40.TMPINSTANCE |
dbnm |
D:\OLTP-EMUL\oltp40-small.fdb |
host |
localhost |
port |
3400 |
usr |
SYSDBA |
pwd |
masterkey |
tmpdir |
e:\temp\logs.oltp40 |
working_mode |
small_03 |
warm_time |
10 |
test_time |
180 |
idle_time |
0 |
use_mtee |
0 |
is_embed |
0 |
remove_isql_logs |
if_no_severe_errors |
no_auto_undo |
1 |
detailed_info |
0 |
mon_unit_perf |
0 |
trc_unit_perf |
1 |
init_buff |
32768 |
create_with_fw |
sync |
create_with_sweep |
0 |
wait_if_not_exists |
0 |
wait_after_create |
1 |
init_docs |
50000 |
wait_for_copy |
1 |
create_with_debug_objects |
1 |
create_with_split_heavy_tabs |
1 |
create_with_separate_qdistr_idx |
0 |
create_with_compound_columns_order |
most_selective_first |
make_html |
1 |
run_db_statistics |
1 |
run_db_validation |
1 |
file_name_with_test_params |
regular |
file_name_this_host_info |
ak40 |
upload_report |
1 |
max_snapshots_to_store |
180 |
replace_instance |
1 |
FINISH_STATE |
DTS_END |
FB_GDSCODE |
FB_MNEMONA |
STACK |
IP |
TRN_ID |
ATT_ID |
EXC_UNIT |
NORMAL: TEST_TIME EXPIRED. |
2016-11-17 02:26:08.1760 |
-1 |
<null> |
|
::1/55787 |
357243 |
8452 |
2 |
CATEGORY |
SETTING |
VAL |
COMMON |
TRACED_UNITS |
,, |
COMMON |
ENABLE_MON_QUERY |
0 |
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 |
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: |
474.59 |
409 |
85426 |
2016-11-16 23:26 |
2016-11-17 02:26 |
customer order: creation |
250.38 |
258 |
45068 |
2016-11-16 23:26 |
2016-11-17 02:26 |
customer order: refuse |
21.24 |
139 |
3824 |
2016-11-16 23:26 |
2016-11-17 02:26 |
order to supplier: creation |
<null> |
<null> |
<null> |
2016-11-16 23:26 |
2016-11-17 02:26 |
order to supplier: removal |
<null> |
<null> |
<null> |
2016-11-16 23:26 |
2016-11-17 02:26 |
invoice (draft): creation |
<null> |
<null> |
<null> |
2016-11-16 23:26 |
2016-11-17 02:26 |
invoice (draft): removal |
<null> |
<null> |
<null> |
2016-11-16 23:26 |
2016-11-17 02:26 |
invoice accept: apply |
<null> |
<null> |
<null> |
2016-11-16 23:26 |
2016-11-17 02:26 |
invoice accept: cancel |
<null> |
<null> |
<null> |
2016-11-16 23:26 |
2016-11-17 02:26 |
customer reserve: creation |
11.51 |
88 |
2071 |
2016-11-16 23:26 |
2016-11-17 02:26 |
customer reserve: removal |
<null> |
<null> |
<null> |
2016-11-16 23:26 |
2016-11-17 02:26 |
realization accept: apply |
<null> |
<null> |
<null> |
2016-11-16 23:26 |
2016-11-17 02:26 |
realization accept: cancel |
<null> |
<null> |
<null> |
2016-11-16 23:26 |
2016-11-17 02:26 |
payment from customer: creation |
83.55 |
114 |
15039 |
2016-11-16 23:26 |
2016-11-17 02:26 |
payment from customer: removal |
8.38 |
55 |
1508 |
2016-11-16 23:26 |
2016-11-17 02:26 |
payment to supplier: creation |
69.27 |
122 |
12469 |
2016-11-16 23:26 |
2016-11-17 02:26 |
payment to supplier: removal |
4.91 |
56 |
879 |
2016-11-16 23:26 |
2016-11-17 02:26 |
service: total inventory turnovers |
14.34 |
359 |
2582 |
2016-11-16 23:26 |
2016-11-17 02:26 |
service: total monetary turnovers |
10.97 |
16 |
1975 |
2016-11-16 23:26 |
2016-11-17 02:26 |
service: refresh index statistics |
0.07 |
2880 |
11 |
2016-11-16 23:26 |
2016-11-17 02:26 |
Done for 4360 ms, from 2:27:44.67 to 2:27:49.03.
ACTION |
ITRV_NO |
CNT_OK_PER_MINUTE |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
ITRV_BEG |
ITRV_END |
interval # 1, overall |
1 |
624 |
16605 |
11236 |
5369 |
32.33 |
23:26:09 |
23:44:09 |
interval # 2, overall |
2 |
567 |
14990 |
10209 |
4781 |
31.89 |
23:44:10 |
00:02:10 |
interval # 3, overall |
3 |
545 |
14218 |
9812 |
4406 |
30.99 |
00:02:11 |
00:20:11 |
interval # 4, overall |
4 |
504 |
13125 |
9074 |
4051 |
30.86 |
00:20:12 |
00:38:12 |
interval # 5, overall |
5 |
449 |
11889 |
8083 |
3806 |
32.01 |
00:38:13 |
00:56:13 |
interval # 6, overall |
6 |
453 |
11777 |
8155 |
3622 |
30.75 |
00:56:14 |
01:14:14 |
interval # 7, overall |
7 |
434 |
11203 |
7811 |
3392 |
30.28 |
01:14:15 |
01:32:15 |
interval # 8, overall |
8 |
413 |
10622 |
7435 |
3187 |
30.00 |
01:32:16 |
01:50:16 |
interval # 9, overall |
9 |
387 |
10092 |
6966 |
3126 |
30.98 |
01:50:17 |
02:08:17 |
interval # 10, overall |
10 |
369 |
9618 |
6645 |
2973 |
30.91 |
02:08:18 |
02:26:18 |
Done for 10200 ms, from 2:27:59.95 to 2:28:10.15.
TEST_PHASE |
MINUTE_SINCE_TEST_START |
AVG_ESTIMATED |
MIN_TO_AVG_RATIO |
MAX_TO_AVG_RATIO |
ROWS_AGGREGATED |
DISTINCT_ATTACHMENTS |
WARM_TIME |
1 |
866.59 |
0.5423 |
1.4805 |
1514 |
100 |
WARM_TIME |
2 |
868.24 |
0.7428 |
1.2548 |
1546 |
100 |
WARM_TIME |
3 |
849.09 |
0.8562 |
1.1533 |
1384 |
100 |
WARM_TIME |
4 |
826.14 |
0.8899 |
1.1084 |
1327 |
100 |
WARM_TIME |
5 |
810.92 |
0.9036 |
1.0972 |
1408 |
100 |
WARM_TIME |
6 |
811.23 |
0.9146 |
1.0839 |
1445 |
100 |
WARM_TIME |
7 |
800.88 |
0.9418 |
1.0606 |
1238 |
100 |
WARM_TIME |
8 |
784.70 |
0.9474 |
1.0546 |
1264 |
100 |
WARM_TIME |
9 |
775.34 |
0.9491 |
1.0514 |
1276 |
100 |
WARM_TIME |
10 |
765.17 |
0.9588 |
1.0389 |
1147 |
100 |
TEST_TIME |
11 |
750.35 |
0.9635 |
1.0376 |
1188 |
100 |
TEST_TIME |
12 |
742.88 |
0.9610 |
1.0379 |
1229 |
100 |
TEST_TIME |
13 |
739.17 |
0.9630 |
1.0377 |
1273 |
100 |
TEST_TIME |
14 |
737.81 |
0.9655 |
1.0355 |
1271 |
100 |
TEST_TIME |
15 |
732.46 |
0.9736 |
1.0250 |
1113 |
100 |
TEST_TIME |
16 |
722.94 |
0.9737 |
1.0261 |
1136 |
100 |
TEST_TIME |
17 |
716.59 |
0.9745 |
1.0260 |
1138 |
100 |
TEST_TIME |
18 |
711.40 |
0.9762 |
1.0231 |
1113 |
100 |
TEST_TIME |
19 |
705.04 |
0.9781 |
1.0225 |
1109 |
100 |
TEST_TIME |
20 |
699.10 |
0.9797 |
1.0210 |
1104 |
100 |
TEST_TIME |
21 |
695.79 |
0.9770 |
1.0226 |
1157 |
100 |
TEST_TIME |
22 |
692.29 |
0.9811 |
1.0180 |
1051 |
100 |
TEST_TIME |
23 |
687.16 |
0.9812 |
1.0188 |
1097 |
100 |
TEST_TIME |
24 |
682.93 |
0.9834 |
1.0165 |
1018 |
99 |
TEST_TIME |
25 |
680.85 |
0.9788 |
1.0210 |
1195 |
15 |
TEST_TIME |
26 |
679.33 |
0.9839 |
1.0164 |
1021 |
21 |
TEST_TIME |
27 |
676.28 |
0.9832 |
1.0172 |
1093 |
29 |
TEST_TIME |
28 |
674.98 |
0.9827 |
1.0171 |
1117 |
30 |
TEST_TIME |
29 |
672.53 |
0.9857 |
1.0163 |
993 |
91 |
TEST_TIME |
30 |
669.58 |
0.9868 |
1.0129 |
1020 |
100 |
TEST_TIME |
31 |
665.72 |
0.9860 |
1.0135 |
1028 |
100 |
TEST_TIME |
32 |
662.64 |
0.9864 |
1.0127 |
1011 |
100 |
TEST_TIME |
33 |
660.55 |
0.9851 |
1.0153 |
1107 |
100 |
TEST_TIME |
34 |
658.73 |
0.9882 |
1.0121 |
996 |
99 |
TEST_TIME |
35 |
655.78 |
0.9876 |
1.0131 |
1020 |
98 |
TEST_TIME |
36 |
654.04 |
0.9876 |
1.0119 |
1000 |
100 |
TEST_TIME |
37 |
651.92 |
0.9878 |
1.0114 |
996 |
99 |
TEST_TIME |
38 |
649.28 |
0.9888 |
1.0111 |
990 |
98 |
TEST_TIME |
39 |
646.11 |
0.9902 |
1.0098 |
953 |
100 |
TEST_TIME |
40 |
643.33 |
0.9888 |
1.0118 |
996 |
100 |
TEST_TIME |
41 |
640.83 |
0.9911 |
1.0094 |
966 |
100 |
TEST_TIME |
42 |
638.20 |
0.9896 |
1.0104 |
992 |
100 |
TEST_TIME |
43 |
636.60 |
0.9895 |
1.0099 |
1041 |
100 |
TEST_TIME |
44 |
634.88 |
0.9896 |
1.0103 |
1029 |
100 |
TEST_TIME |
45 |
633.55 |
0.9900 |
1.0102 |
1035 |
100 |
TEST_TIME |
46 |
632.39 |
0.9901 |
1.0095 |
1015 |
100 |
TEST_TIME |
47 |
630.80 |
0.9906 |
1.0092 |
989 |
100 |
TEST_TIME |
48 |
629.27 |
0.9906 |
1.0096 |
1044 |
100 |
TEST_TIME |
49 |
628.25 |
0.9906 |
1.0096 |
1052 |
100 |
TEST_TIME |
50 |
627.36 |
0.9908 |
1.0087 |
998 |
100 |
TEST_TIME |
51 |
625.75 |
0.9916 |
1.0080 |
962 |
100 |
TEST_TIME |
52 |
624.17 |
0.9911 |
1.0078 |
960 |
100 |
TEST_TIME |
53 |
622.03 |
0.9922 |
1.0083 |
953 |
100 |
TEST_TIME |
54 |
621.02 |
0.9913 |
1.0085 |
1010 |
100 |
TEST_TIME |
55 |
619.85 |
0.9920 |
1.0077 |
967 |
100 |
TEST_TIME |
56 |
618.65 |
0.9918 |
1.0076 |
979 |
100 |
TEST_TIME |
57 |
616.54 |
0.9934 |
1.0063 |
857 |
100 |
TEST_TIME |
58 |
615.03 |
0.9914 |
1.0082 |
1025 |
99 |
TEST_TIME |
59 |
613.87 |
0.9930 |
1.0067 |
889 |
79 |
TEST_TIME |
60 |
612.04 |
0.9929 |
1.0069 |
910 |
50 |
TEST_TIME |
61 |
610.67 |
0.9926 |
1.0075 |
938 |
35 |
TEST_TIME |
62 |
609.61 |
0.9929 |
1.0075 |
933 |
32 |
TEST_TIME |
63 |
608.76 |
0.9929 |
1.0065 |
949 |
32 |
TEST_TIME |
64 |
607.48 |
0.9929 |
1.0073 |
976 |
30 |
TEST_TIME |
65 |
606.19 |
0.9939 |
1.0063 |
862 |
24 |
TEST_TIME |
66 |
604.92 |
0.9932 |
1.0071 |
961 |
17 |
TEST_TIME |
67 |
603.97 |
0.9936 |
1.0068 |
873 |
37 |
TEST_TIME |
68 |
602.92 |
0.9937 |
1.0064 |
917 |
42 |
TEST_TIME |
69 |
601.76 |
0.9937 |
1.0062 |
871 |
44 |
TEST_TIME |
70 |
600.66 |
0.9936 |
1.0059 |
877 |
62 |
TEST_TIME |
71 |
599.45 |
0.9937 |
1.0062 |
871 |
97 |
TEST_TIME |
72 |
597.51 |
0.9955 |
1.0048 |
781 |
100 |
TEST_TIME |
73 |
595.67 |
0.9941 |
1.0058 |
926 |
100 |
TEST_TIME |
74 |
594.41 |
0.9944 |
1.0053 |
868 |
100 |
TEST_TIME |
75 |
592.94 |
0.9944 |
1.0055 |
876 |
100 |
TEST_TIME |
76 |
591.94 |
0.9941 |
1.0058 |
918 |
100 |
TEST_TIME |
77 |
590.87 |
0.9947 |
1.0054 |
902 |
100 |
TEST_TIME |
78 |
589.58 |
0.9947 |
1.0054 |
881 |
100 |
TEST_TIME |
79 |
588.52 |
0.9944 |
1.0056 |
927 |
100 |
TEST_TIME |
80 |
587.42 |
0.9949 |
1.0052 |
872 |
100 |
TEST_TIME |
81 |
585.92 |
0.9954 |
1.0046 |
802 |
100 |
TEST_TIME |
82 |
584.14 |
0.9954 |
1.0046 |
800 |
100 |
TEST_TIME |
83 |
582.46 |
0.9953 |
1.0047 |
839 |
100 |
TEST_TIME |
84 |
581.30 |
0.9948 |
1.0051 |
867 |
100 |
TEST_TIME |
85 |
580.22 |
0.9952 |
1.0048 |
822 |
100 |
TEST_TIME |
86 |
578.85 |
0.9955 |
1.0046 |
844 |
100 |
TEST_TIME |
87 |
577.38 |
0.9955 |
1.0042 |
793 |
100 |
TEST_TIME |
88 |
575.69 |
0.9957 |
1.0042 |
800 |
100 |
TEST_TIME |
89 |
574.34 |
0.9953 |
1.0045 |
833 |
100 |
TEST_TIME |
90 |
573.19 |
0.9954 |
1.0044 |
860 |
100 |
TEST_TIME |
91 |
571.75 |
0.9958 |
1.0043 |
805 |
100 |
TEST_TIME |
92 |
570.43 |
0.9957 |
1.0038 |
782 |
100 |
TEST_TIME |
93 |
568.61 |
0.9962 |
1.0038 |
770 |
100 |
TEST_TIME |
94 |
567.25 |
0.9955 |
1.0043 |
817 |
100 |
TEST_TIME |
95 |
566.14 |
0.9956 |
1.0038 |
813 |
100 |
TEST_TIME |
96 |
564.74 |
0.9959 |
1.0047 |
782 |
100 |
TEST_TIME |
97 |
563.54 |
0.9965 |
1.0039 |
797 |
100 |
TEST_TIME |
98 |
562.19 |
0.9961 |
1.0038 |
776 |
100 |
TEST_TIME |
99 |
560.78 |
0.9962 |
1.0039 |
804 |
100 |
TEST_TIME |
100 |
559.83 |
0.9956 |
1.0040 |
834 |
100 |
TEST_TIME |
101 |
558.85 |
0.9959 |
1.0044 |
860 |
100 |
TEST_TIME |
102 |
557.95 |
0.9962 |
1.0034 |
760 |
100 |
TEST_TIME |
103 |
556.63 |
0.9961 |
1.0036 |
797 |
100 |
TEST_TIME |
104 |
555.74 |
0.9956 |
1.0043 |
879 |
100 |
TEST_TIME |
105 |
555.15 |
0.9958 |
1.0037 |
810 |
100 |
TEST_TIME |
106 |
553.99 |
0.9964 |
1.0042 |
796 |
100 |
TEST_TIME |
107 |
553.34 |
0.9960 |
1.0041 |
818 |
94 |
TEST_TIME |
108 |
552.88 |
0.9957 |
1.0043 |
848 |
77 |
TEST_TIME |
109 |
552.35 |
0.9960 |
1.0040 |
794 |
74 |
TEST_TIME |
110 |
551.49 |
0.9964 |
1.0034 |
742 |
78 |
TEST_TIME |
111 |
550.56 |
0.9960 |
1.0039 |
796 |
88 |
TEST_TIME |
112 |
549.69 |
0.9965 |
1.0033 |
738 |
97 |
TEST_TIME |
113 |
548.54 |
0.9965 |
1.0032 |
736 |
98 |
TEST_TIME |
114 |
547.35 |
0.9965 |
1.0033 |
741 |
99 |
TEST_TIME |
115 |
546.60 |
0.9960 |
1.0040 |
866 |
99 |
TEST_TIME |
116 |
545.68 |
0.9971 |
1.0028 |
664 |
99 |
TEST_TIME |
117 |
544.42 |
0.9965 |
1.0034 |
763 |
99 |
TEST_TIME |
118 |
543.48 |
0.9967 |
1.0032 |
727 |
99 |
TEST_TIME |
119 |
542.64 |
0.9963 |
1.0035 |
787 |
99 |
TEST_TIME |
120 |
541.75 |
0.9967 |
1.0033 |
731 |
99 |
TEST_TIME |
121 |
540.74 |
0.9968 |
1.0032 |
735 |
99 |
TEST_TIME |
122 |
539.78 |
0.9968 |
1.0031 |
749 |
100 |
TEST_TIME |
123 |
539.09 |
0.9963 |
1.0035 |
815 |
99 |
TEST_TIME |
124 |
538.60 |
0.9963 |
1.0035 |
799 |
99 |
TEST_TIME |
125 |
537.75 |
0.9970 |
1.0032 |
719 |
99 |
TEST_TIME |
126 |
537.19 |
0.9962 |
1.0037 |
846 |
100 |
TEST_TIME |
127 |
536.57 |
0.9970 |
1.0031 |
739 |
99 |
TEST_TIME |
128 |
535.68 |
0.9969 |
1.0032 |
749 |
98 |
TEST_TIME |
129 |
534.77 |
0.9971 |
1.0030 |
718 |
97 |
TEST_TIME |
130 |
533.74 |
0.9972 |
1.0028 |
694 |
97 |
TEST_TIME |
131 |
532.66 |
0.9972 |
1.0027 |
692 |
99 |
TEST_TIME |
132 |
531.94 |
0.9965 |
1.0034 |
825 |
95 |
TEST_TIME |
133 |
531.20 |
0.9972 |
1.0029 |
710 |
92 |
TEST_TIME |
134 |
530.26 |
0.9971 |
1.0028 |
716 |
92 |
TEST_TIME |
135 |
529.35 |
0.9971 |
1.0030 |
709 |
88 |
TEST_TIME |
136 |
528.66 |
0.9969 |
1.0029 |
729 |
86 |
TEST_TIME |
137 |
527.85 |
0.9971 |
1.0030 |
725 |
87 |
TEST_TIME |
138 |
526.68 |
0.9979 |
1.0020 |
565 |
81 |
TEST_TIME |
139 |
525.66 |
0.9967 |
1.0032 |
805 |
78 |
TEST_TIME |
140 |
525.06 |
0.9972 |
1.0028 |
736 |
74 |
TEST_TIME |
141 |
524.30 |
0.9972 |
1.0029 |
750 |
66 |
TEST_TIME |
142 |
523.69 |
0.9970 |
1.0028 |
749 |
61 |
TEST_TIME |
143 |
522.90 |
0.9973 |
1.0026 |
689 |
57 |
TEST_TIME |
144 |
521.84 |
0.9977 |
1.0023 |
604 |
51 |
TEST_TIME |
145 |
520.80 |
0.9974 |
1.0025 |
635 |
50 |
TEST_TIME |
146 |
519.96 |
0.9973 |
1.0026 |
704 |
47 |
TEST_TIME |
147 |
519.28 |
0.9971 |
1.0029 |
746 |
47 |
TEST_TIME |
148 |
518.76 |
0.9971 |
1.0027 |
730 |
43 |
TEST_TIME |
149 |
518.21 |
0.9970 |
1.0028 |
743 |
42 |
TEST_TIME |
150 |
517.75 |
0.9971 |
1.0029 |
740 |
41 |
TEST_TIME |
151 |
517.04 |
0.9977 |
1.0023 |
629 |
41 |
TEST_TIME |
152 |
516.23 |
0.9973 |
1.0027 |
720 |
42 |
TEST_TIME |
153 |
515.72 |
0.9972 |
1.0027 |
735 |
41 |
TEST_TIME |
154 |
515.22 |
0.9972 |
1.0026 |
730 |
41 |
TEST_TIME |
155 |
514.29 |
0.9980 |
1.0019 |
579 |
46 |
TEST_TIME |
156 |
513.32 |
0.9974 |
1.0024 |
690 |
46 |
TEST_TIME |
157 |
512.35 |
0.9980 |
1.0019 |
593 |
38 |
TEST_TIME |
158 |
511.32 |
0.9976 |
1.0024 |
676 |
36 |
TEST_TIME |
159 |
510.61 |
0.9974 |
1.0024 |
669 |
32 |
TEST_TIME |
160 |
509.87 |
0.9976 |
1.0023 |
669 |
28 |
TEST_TIME |
161 |
509.18 |
0.9974 |
1.0026 |
711 |
27 |
TEST_TIME |
162 |
508.45 |
0.9978 |
1.0020 |
620 |
25 |
TEST_TIME |
163 |
507.71 |
0.9974 |
1.0025 |
726 |
21 |
TEST_TIME |
164 |
507.02 |
0.9978 |
1.0021 |
637 |
16 |
TEST_TIME |
165 |
506.26 |
0.9975 |
1.0024 |
689 |
15 |
TEST_TIME |
166 |
505.67 |
0.9975 |
1.0023 |
667 |
14 |
TEST_TIME |
167 |
505.10 |
0.9974 |
1.0025 |
715 |
13 |
TEST_TIME |
168 |
504.58 |
0.9976 |
1.0023 |
678 |
11 |
TEST_TIME |
169 |
504.00 |
0.9976 |
1.0024 |
688 |
11 |
TEST_TIME |
170 |
503.40 |
0.9977 |
1.0022 |
664 |
14 |
TEST_TIME |
171 |
502.63 |
0.9978 |
1.0020 |
624 |
19 |
TEST_TIME |
172 |
501.82 |
0.9978 |
1.0022 |
637 |
18 |
TEST_TIME |
173 |
501.05 |
0.9980 |
1.0019 |
620 |
16 |
TEST_TIME |
174 |
500.08 |
0.9981 |
1.0018 |
585 |
14 |
TEST_TIME |
175 |
499.39 |
0.9975 |
1.0025 |
712 |
14 |
TEST_TIME |
176 |
498.89 |
0.9978 |
1.0021 |
652 |
14 |
TEST_TIME |
177 |
498.07 |
0.9981 |
1.0018 |
592 |
15 |
TEST_TIME |
178 |
497.34 |
0.9977 |
1.0023 |
696 |
17 |
TEST_TIME |
179 |
496.84 |
0.9978 |
1.0021 |
655 |
17 |
TEST_TIME |
180 |
496.15 |
0.9979 |
1.0021 |
646 |
17 |
TEST_TIME |
181 |
495.52 |
0.9978 |
1.0020 |
645 |
17 |
TEST_TIME |
182 |
494.86 |
0.9978 |
1.0022 |
663 |
17 |
TEST_TIME |
183 |
494.18 |
0.9981 |
1.0020 |
613 |
16 |
TEST_TIME |
184 |
493.47 |
0.9979 |
1.0020 |
635 |
16 |
TEST_TIME |
185 |
492.85 |
0.9978 |
1.0021 |
654 |
14 |
TEST_TIME |
186 |
492.28 |
0.9978 |
1.0022 |
685 |
13 |
TEST_TIME |
187 |
491.72 |
0.9980 |
1.0018 |
602 |
14 |
TEST_TIME |
188 |
491.02 |
0.9979 |
1.0020 |
657 |
18 |
TEST_TIME |
189 |
490.27 |
0.9982 |
1.0017 |
565 |
22 |
TEST_TIME |
190 |
488.66 |
0.9997 |
1.0002 |
107 |
22 |
Done for 11060 ms, from 2:28:11.27 to 2:28:22.33.
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 |
90069 |
130758 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
81235 |
<null> |
<null> |
<null> |
85737 |
<null> |
82770 |
<null> |
242459 |
<null> |
<null> |
23:26:09 |
23:44:09 |
fetches per second |
2 |
49690 |
56334 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
21966 |
<null> |
<null> |
<null> |
30825 |
90503 |
21516 |
218600 |
219521 |
198888 |
<null> |
23:44:10 |
00:02:10 |
fetches per second |
3 |
70847 |
91477 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
83222 |
<null> |
<null> |
<null> |
72633 |
<null> |
65011 |
99909 |
209031 |
185883 |
<null> |
00:02:11 |
00:20:11 |
fetches per second |
4 |
77487 |
55950 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
68967 |
111728 |
69959 |
<null> |
44037 |
<null> |
<null> |
00:20:12 |
00:38:12 |
fetches per second |
5 |
75053 |
152453 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
97209 |
<null> |
<null> |
<null> |
77671 |
136729 |
73508 |
<null> |
278676 |
462666 |
<null> |
00:38:13 |
00:56:13 |
fetches per second |
6 |
40315 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
6251 |
<null> |
<null> |
<null> |
59771 |
<null> |
29866 |
<null> |
<null> |
<null> |
<null> |
00:56:14 |
01:14:14 |
fetches per second |
7 |
3440 |
5634 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
2554 |
<null> |
<null> |
<null> |
3719 |
6099 |
3394 |
<null> |
8875 |
31559 |
<null> |
01:14:15 |
01:32:15 |
fetches per second |
8 |
10099 |
21044 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
7123 |
<null> |
<null> |
<null> |
11266 |
19068 |
8298 |
4943 |
18407 |
96016 |
<null> |
01:32:16 |
01:50:16 |
marks per second |
1 |
16594 |
14943 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
7370 |
<null> |
<null> |
<null> |
15027 |
<null> |
13245 |
<null> |
25120 |
<null> |
<null> |
23:26:09 |
23:44:09 |
marks per second |
2 |
8889 |
6602 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
2075 |
<null> |
<null> |
<null> |
5825 |
9753 |
3509 |
21800 |
19260 |
18833 |
<null> |
23:44:10 |
00:02:10 |
marks per second |
3 |
13312 |
10490 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
9222 |
<null> |
<null> |
<null> |
12689 |
<null> |
9649 |
10363 |
26937 |
16733 |
<null> |
00:02:11 |
00:20:11 |
marks per second |
4 |
14073 |
6750 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
11988 |
11591 |
11853 |
<null> |
4822 |
<null> |
<null> |
00:20:12 |
00:38:12 |
marks per second |
5 |
13736 |
17834 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
8692 |
<null> |
<null> |
<null> |
13304 |
15133 |
11247 |
<null> |
29295 |
60666 |
<null> |
00:38:13 |
00:56:13 |
marks per second |
6 |
7601 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
497 |
<null> |
<null> |
<null> |
10006 |
<null> |
5037 |
<null> |
<null> |
<null> |
<null> |
00:56:14 |
01:14:14 |
marks per second |
7 |
587 |
609 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
191 |
<null> |
<null> |
<null> |
628 |
635 |
562 |
<null> |
785 |
2525 |
<null> |
01:14:15 |
01:32:15 |
marks per second |
8 |
1834 |
2133 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
604 |
<null> |
<null> |
<null> |
1952 |
1896 |
1257 |
501 |
641 |
6515 |
<null> |
01:32:16 |
01:50:16 |
reads/fetches*100 |
1 |
0 |
0 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
0 |
<null> |
<null> |
<null> |
0 |
<null> |
0 |
<null> |
0 |
<null> |
<null> |
23:26:09 |
23:44:09 |
reads/fetches*100 |
2 |
0 |
0 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
0 |
<null> |
<null> |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
23:44:10 |
00:02:10 |
reads/fetches*100 |
3 |
0 |
0 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
0 |
<null> |
<null> |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
<null> |
00:02:11 |
00:20:11 |
reads/fetches*100 |
4 |
0 |
0 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
0 |
0 |
0 |
<null> |
0 |
<null> |
<null> |
00:20:12 |
00:38:12 |
reads/fetches*100 |
5 |
0 |
0 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
0 |
<null> |
<null> |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
00:38:13 |
00:56:13 |
reads/fetches*100 |
6 |
0 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
0 |
<null> |
<null> |
<null> |
0 |
<null> |
0 |
<null> |
<null> |
<null> |
<null> |
00:56:14 |
01:14:14 |
reads/fetches*100 |
7 |
0 |
0 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
0 |
<null> |
<null> |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
01:14:15 |
01:32:15 |
reads/fetches*100 |
8 |
0 |
0 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
0 |
<null> |
<null> |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
01:32:16 |
01:50:16 |
writes/marks*100 |
1 |
0 |
0 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
1 |
<null> |
<null> |
<null> |
0 |
<null> |
0 |
<null> |
0 |
<null> |
<null> |
23:26:09 |
23:44:09 |
writes/marks*100 |
2 |
0 |
0 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
0 |
<null> |
<null> |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
23:44:10 |
00:02:10 |
writes/marks*100 |
3 |
0 |
0 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
1 |
<null> |
<null> |
<null> |
0 |
<null> |
1 |
3 |
0 |
0 |
<null> |
00:02:11 |
00:20:11 |
writes/marks*100 |
4 |
0 |
0 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
0 |
1 |
0 |
<null> |
0 |
<null> |
<null> |
00:20:12 |
00:38:12 |
writes/marks*100 |
5 |
0 |
0 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
0 |
<null> |
<null> |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
00:38:13 |
00:56:13 |
writes/marks*100 |
6 |
0 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
1 |
<null> |
<null> |
<null> |
0 |
<null> |
0 |
<null> |
<null> |
<null> |
<null> |
00:56:14 |
01:14:14 |
writes/marks*100 |
7 |
0 |
0 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
0 |
<null> |
<null> |
<null> |
1 |
0 |
0 |
<null> |
0 |
0 |
<null> |
01:14:15 |
01:32:15 |
writes/marks*100 |
8 |
0 |
0 |
<null> |
<null> |
<null> |
<null> |
<null> |
<null> |
1 |
<null> |
<null> |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
01:32:16 |
01:50:16 |
Done for 6570 ms, from 2:28:22.47 to 2:28:29.04.
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 |
123855 |
123855 |
0 |
0.00 |
0 |
15070 |
34 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
doc_list_biud |
123855 |
123855 |
0 |
0.00 |
0 |
1716 |
7 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
sp_add_invoice_to_stock |
10935 |
0 |
10935 |
100.00 |
<null> |
<null> |
<null> |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
sp_cancel_adding_invoice |
870 |
0 |
870 |
100.00 |
<null> |
<null> |
<null> |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
sp_cancel_client_order |
3824 |
3824 |
0 |
0.00 |
0 |
1887 |
139 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
sp_cancel_customer_reserve |
1480 |
0 |
1480 |
100.00 |
<null> |
<null> |
<null> |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
sp_cancel_pay_from_customer |
1508 |
1508 |
0 |
0.00 |
0 |
437 |
55 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
sp_cancel_pay_to_supplier |
879 |
879 |
0 |
0.00 |
0 |
624 |
56 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
sp_cancel_supplier_invoice |
890 |
0 |
890 |
100.00 |
<null> |
<null> |
<null> |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
sp_cancel_supplier_order |
875 |
0 |
875 |
100.00 |
<null> |
<null> |
<null> |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
sp_cancel_write_off |
2091 |
0 |
2091 |
100.00 |
<null> |
<null> |
<null> |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
sp_client_order |
45068 |
45068 |
0 |
0.00 |
0 |
59235 |
258 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
sp_customer_reserve |
2071 |
2071 |
0 |
0.00 |
0 |
1263 |
88 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
sp_fill_shopping_cart |
45068 |
45068 |
0 |
0.00 |
0 |
2122 |
45 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
sp_fill_shopping_cart_clo_res |
2071 |
2071 |
0 |
0.00 |
0 |
296 |
19 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
sp_kill_cost_storno |
2387 |
2387 |
0 |
0.00 |
0 |
187 |
4 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
sp_kill_qty_storno |
3824 |
3824 |
0 |
0.00 |
0 |
1685 |
64 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
sp_lock_selected_doc |
6211 |
6211 |
0 |
0.00 |
0 |
172 |
5 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
sp_make_cost_storno |
27508 |
27508 |
0 |
0.00 |
0 |
3526 |
22 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
sp_multiply_rows_for_pdistr |
27508 |
27508 |
0 |
0.00 |
0 |
7160 |
19 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
sp_multiply_rows_for_qdistr |
45068 |
45068 |
0 |
0.00 |
0 |
28969 |
82 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
sp_pay_from_customer |
15039 |
15039 |
0 |
0.00 |
0 |
19547 |
114 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
sp_pay_to_supplier |
12469 |
12469 |
0 |
0.00 |
0 |
4415 |
122 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
sp_payment_common |
27508 |
27508 |
0 |
0.00 |
0 |
6819 |
44 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
sp_qd_handle_on_cancel_clo |
3824 |
3824 |
0 |
0.00 |
0 |
1653 |
56 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
sp_reserve_write_off |
21572 |
0 |
21572 |
100.00 |
<null> |
<null> |
<null> |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
srv_find_qd_qs_mism |
48892 |
48892 |
0 |
0.00 |
0 |
13696 |
44 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
srv_make_invnt_saldo |
2582 |
2582 |
0 |
0.00 |
0 |
5570 |
359 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
srv_make_money_saldo |
1975 |
1975 |
0 |
0.00 |
0 |
234 |
16 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
srv_recalc_idx_stat |
11 |
11 |
0 |
0.00 |
468 |
9032 |
2880 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
t$perf-abend:sp_add_invoice_to_stock |
10935 |
10935 |
0 |
0.00 |
0 |
2325 |
13 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
t$perf-abend:sp_cancel_adding_invoice |
870 |
870 |
0 |
0.00 |
0 |
421 |
13 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
t$perf-abend:sp_cancel_customer_reserve |
1480 |
1480 |
0 |
0.00 |
0 |
234 |
13 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
t$perf-abend:sp_cancel_supplier_invoice |
890 |
890 |
0 |
0.00 |
0 |
156 |
12 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
t$perf-abend:sp_cancel_supplier_order |
875 |
875 |
0 |
0.00 |
0 |
219 |
12 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
t$perf-abend:sp_cancel_write_off |
2091 |
2091 |
0 |
0.00 |
0 |
218 |
12 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
t$perf-abend:sp_reserve_write_off |
21574 |
21574 |
0 |
0.00 |
0 |
2090 |
13 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
t$perf-norm:sp_cancel_client_order |
3824 |
3824 |
0 |
0.00 |
0 |
468 |
8 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
t$perf-norm:sp_cancel_pay_from_customer |
1508 |
1508 |
0 |
0.00 |
0 |
218 |
7 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
t$perf-norm:sp_cancel_pay_to_supplier |
879 |
879 |
0 |
0.00 |
0 |
78 |
6 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
t$perf-norm:sp_client_order |
45068 |
45068 |
0 |
0.00 |
0 |
7036 |
12 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
t$perf-norm:sp_customer_reserve |
2071 |
2071 |
0 |
0.00 |
0 |
344 |
5 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
t$perf-norm:sp_pay_from_customer |
15039 |
15039 |
0 |
0.00 |
0 |
1014 |
8 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
t$perf-norm:sp_pay_to_supplier |
12469 |
12469 |
0 |
0.00 |
0 |
2184 |
9 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
t$perf-norm:srv_make_invnt_saldo |
2582 |
2582 |
0 |
0.00 |
0 |
1466 |
2 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
t$perf-norm:srv_make_money_saldo |
1975 |
1975 |
0 |
0.00 |
0 |
406 |
1 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
t$perf-norm:srv_recalc_idx_stat |
11 |
11 |
0 |
0.00 |
0 |
156 |
42 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
v_add_invoice_to_stock |
21870 |
0 |
21870 |
100.00 |
<null> |
<null> |
<null> |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
v_all_customers |
97598 |
97598 |
0 |
0.00 |
0 |
1607 |
4 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
v_all_suppliers |
24938 |
24938 |
0 |
0.00 |
0 |
265 |
5 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
v_all_wares |
90136 |
90136 |
0 |
0.00 |
0 |
312 |
5 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
v_cancel_adding_invoice |
1740 |
0 |
1740 |
100.00 |
<null> |
<null> |
<null> |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
v_cancel_client_order |
7648 |
7648 |
0 |
0.00 |
0 |
234 |
3 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
v_cancel_customer_prepayment |
3016 |
3016 |
0 |
0.00 |
0 |
156 |
4 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
v_cancel_customer_reserve |
2960 |
0 |
2960 |
100.00 |
<null> |
<null> |
<null> |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
v_cancel_payment_to_supplier |
1758 |
1758 |
0 |
0.00 |
0 |
312 |
5 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
v_cancel_supplier_invoice |
1780 |
0 |
1780 |
100.00 |
<null> |
<null> |
<null> |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
v_cancel_supplier_order |
1750 |
0 |
1750 |
100.00 |
<null> |
<null> |
<null> |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
v_cancel_write_off |
4182 |
0 |
4182 |
100.00 |
<null> |
<null> |
<null> |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
v_max_id_clo_res |
2071 |
2071 |
0 |
0.00 |
0 |
234 |
9 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
v_min_id_clo_res |
2071 |
2071 |
0 |
0.00 |
0 |
94 |
5 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
v_min_non_paid_invoice |
12469 |
12469 |
0 |
0.00 |
0 |
343 |
4 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
v_min_non_paid_realizn |
15039 |
15039 |
0 |
0.00 |
0 |
608 |
4 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
v_our_firm |
22616 |
22616 |
0 |
0.00 |
0 |
297 |
5 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
v_reserve_write_off |
43144 |
0 |
43144 |
100.00 |
<null> |
<null> |
<null> |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
x_make_qstorno_2100_3300 |
2071 |
2071 |
0 |
0.00 |
0 |
514 |
26 |
0 |
2016-11-16 23:26 |
2016-11-17 02:26 |
Done for 39110 ms, from 2:29:02.85 to 2:29:41.96.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
DTS_BEG |
DTS_END |
user_exc |
10935 |
v_add_invoice_to_stock |
335544517 |
2016-11-16 23:26 |
2016-11-17 02:26 |
user_exc |
870 |
v_cancel_adding_invoice |
335544517 |
2016-11-16 23:26 |
2016-11-17 02:25 |
user_exc |
1480 |
v_cancel_customer_reserve |
335544517 |
2016-11-16 23:26 |
2016-11-17 02:26 |
user_exc |
890 |
v_cancel_supplier_invoice |
335544517 |
2016-11-16 23:26 |
2016-11-17 02:26 |
user_exc |
875 |
v_cancel_supplier_order |
335544517 |
2016-11-16 23:26 |
2016-11-17 02:25 |
user_exc |
2091 |
v_cancel_write_off |
335544517 |
2016-11-16 23:26 |
2016-11-17 02:26 |
user_exc |
21572 |
v_reserve_write_off |
335544517 |
2016-11-16 23:26 |
2016-11-17 02:26 |
Done for 3800 ms, from 2:29:44.19 to 2:29:47.99.
MON$DATABASE_NAME D:\OLTP-EMUL\OLTP40-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 13
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 357917
MON$OLDEST_ACTIVE 357918
MON$OLDEST_SNAPSHOT 357918
MON$NEXT_TRANSACTION 357918
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 2016-11-03 20:35:24.9530
MON$PAGES 161432
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-T4.0.0.452 Firebird 4.0 Unstable
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.452 Firebird 4.0 Unstable"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T4.0.0.452 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P14"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T4.0.0.452 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P14"
on disk structure version 13.0
Database "D:\OLTP-EMUL\OLTP40-SMALL.FDB"
Database header page information:
Flags 0
Generation 357954
System Change Number 0
Page size 8192
ODS version 13.0
Oldest transaction 357919
Oldest active 357920
Oldest snapshot 357920
Next transaction 357921
Sequence number 0
Next attachment ID 8685
Implementation HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Nov 3, 2016 20:35:24
Attributes force write
Variable header data:
Sweep interval: 0
*END*
Database file sequence:
File D:\OLTP-EMUL\OLTP40-SMALL.FDB is the only file
Analyzing database pages ...
AGENTS (154)
Primary pointer page: 314, Index root page: 315
Total formats: 1, used formats: 1
Average record length: 33.48, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 344.00, compression ratio: 10.27
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_ID_DESC (2)
Root page: 325, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_OUR_FIRM (4)
Root page: 327, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 48
Average key length: 2.04, compression ratio: 0.50
Average prefix length: 0.96, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_SUPPLIER (3)
Root page: 326, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 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: 324, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.14, total dup: 0, max dup: 0
Average key length: 15.84, compression ratio: 0.92
Average prefix length: 1.36, average data length: 13.14
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_AGENTS (0)
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BUSINESS_OPS (158)
Primary pointer page: 335, Index root page: 336
Total formats: 1, used formats: 1
Average record length: 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: 339, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 18.00, total dup: 0, max dup: 0
Average key length: 16.95, compression ratio: 1.25
Average prefix length: 7.21, average data length: 14.00
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BUSINESS_OPS_RND_WGTH (2)
Root page: 340, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 4.05, total dup: 7, max dup: 3
Average key length: 3.00, compression ratio: 0.75
Average prefix length: 1.42, average data length: 0.84
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$1 (0)
Root page: 338, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 5.26, total dup: 0, max dup: 0
Average key length: 4.21, compression ratio: 0.64
Average prefix length: 1.05, average data length: 1.63
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DOC_DATA (141)
Primary pointer page: 254, Index root page: 255
Total formats: 1, used formats: 1
Average record length: 45.98, total records: 437633
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.39
Pointer pages: 3, data page slots: 4608
Data pages: 4608, average fill: 73%
Primary pages: 4608, secondary pages: 0, swept pages: 0
Empty pages: 2, full pages: 4605
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 1
60 - 79% = 4605
80 - 99% = 0
Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 25023, depth: 3, leaf buckets: 2042, nodes: 437633
Average node length: 18.16, total dup: 0, max dup: 0
Average key length: 15.40, compression ratio: 1.75
Average prefix length: 14.60, average data length: 12.40
Clustering factor: 16061, ratio: 0.04
Fill distribution:
0 - 19% = 640
20 - 39% = 0
40 - 59% = 829
60 - 79% = 0
80 - 99% = 573
Index DOC_DATA_ID_DESC (2)
Root page: 66726, depth: 3, leaf buckets: 1302, nodes: 437633
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 9.06, compression ratio: 0.99
Average prefix length: 2.94, average data length: 6.06
Clustering factor: 5285, ratio: 0.01
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1301
60 - 79% = 0
80 - 99% = 1
Index FK_DOC_DATA_DOC_LIST (3)
Root page: 1499, depth: 2, leaf buckets: 345, nodes: 437633
Average node length: 6.08, total dup: 358264, max dup: 9
Average key length: 3.32, compression ratio: 2.71
Average prefix length: 7.86, average data length: 1.14
Clustering factor: 5379, ratio: 0.01
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 13
60 - 79% = 0
80 - 99% = 326
DOC_LIST (140)
Primary pointer page: 249, Index root page: 250
Total formats: 1, used formats: 1
Average record length: 56.83, total records: 126448
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: 96.00, compression ratio: 1.69
Pointer pages: 1, data page slots: 1528
Data pages: 1528, average fill: 75%
Primary pages: 1528, secondary pages: 0, swept pages: 1398
Empty pages: 3, full pages: 1523
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1525
80 - 99% = 0
Index DOC_LIST_ID_DESC (1)
Root page: 1812, depth: 2, leaf buckets: 381, nodes: 126448
Average node length: 11.45, total dup: 0, max dup: 0
Average key length: 9.17, compression ratio: 0.98
Average prefix length: 2.83, average data length: 6.17
Clustering factor: 2245, ratio: 0.02
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 379
60 - 79% = 0
80 - 99% = 1
Index FK_DOC_LIST_AGENTS (2)
Root page: 3346, depth: 2, leaf buckets: 105, nodes: 126448
Average node length: 4.29, total dup: 126398, max dup: 19839
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 54333, ratio: 0.43
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 72
60 - 79% = 9
80 - 99% = 24
Index PK_DOC_LIST (0)
Root page: 1809, depth: 2, leaf buckets: 185, nodes: 126448
Average node length: 11.44, total dup: 0, max dup: 0
Average key length: 9.16, compression ratio: 0.98
Average prefix length: 2.83, average data length: 6.17
Clustering factor: 2245, ratio: 0.02
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 4
60 - 79% = 0
80 - 99% = 181
DOC_STATES (153)
Primary pointer page: 312, Index root page: 313
Total formats: 1, used formats: 1
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 650.00, compression ratio: 9.63
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_MCODE_UNQ (1)
Root page: 321, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 17.75, total dup: 0, max dup: 0
Average key length: 16.50, compression ratio: 1.08
Average prefix length: 4.00, average data length: 13.75
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_NAME_UNQ (2)
Root page: 322, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 33.25, total dup: 0, max dup: 0
Average key length: 32.00, compression ratio: 0.99
Average prefix length: 2.50, average data length: 29.25
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_DOC_STATES (0)
Root page: 320, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 4.75, total dup: 0, max dup: 0
Average key length: 3.50, compression ratio: 0.86
Average prefix length: 1.50, average data length: 1.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
FB_ERRORS (159)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 148.00, compression ratio: 1.86
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 56%
Primary pages: 16, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 11
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7
Index FB_ERRORS_GDS_CODE (0)
Root page: 343, depth: 1, leaf buckets: 1, nodes: 758
Average node length: 4.24, total dup: 0, max dup: 0
Average key length: 3.04, compression ratio: 1.64
Average prefix length: 3.97, average data length: 1.03
Clustering factor: 353, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
INVNT_SALDO (147)
Primary pointer page: 273, Index root page: 274
Total formats: 1, used formats: 1
Average record length: 30.31, 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: 104.00, compression ratio: 3.43
Pointer pages: 1, data page slots: 4
Data pages: 4, average fill: 58%
Primary pages: 4, secondary pages: 0, swept pages: 4
Empty pages: 0, full pages: 3
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 3
80 - 99% = 0
Index PK_INVNT_SALDO (0)
Root page: 285, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 263, 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: 333, Index root page: 334
Total formats: 1, used formats: 1
Average record length: 67.86, 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: 96.00, compression ratio: 1.41
Pointer pages: 1, data page slots: 8
Data pages: 8, average fill: 2%
Primary pages: 8, secondary pages: 0, swept pages: 6
Empty pages: 7, full pages: 0
Fill distribution:
0 - 19% = 8
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 62157, depth: 2, leaf buckets: 1, nodes: 7
Average node length: 29.14, total dup: 0, max dup: 0
Average key length: 28.00, compression ratio: 0.96
Average prefix length: 1.86, average data length: 25.14
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MONEY_SALDO (143)
Primary pointer page: 265, Index root page: 266
Total formats: 1, used formats: 1
Average record length: 15.14, total records: 49
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 2.11
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 20%
Primary pages: 1, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MONEY_SALDO (0)
Root page: 276, depth: 1, leaf buckets: 1, nodes: 49
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MONEY_TURNOVER_LOG (142)
Primary pointer page: 263, Index root page: 264
Total formats: 1, used formats: 1
Average record length: 0.00, total records: 36
Average version length: 39.86, total versions: 36, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 33%
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 MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 275, depth: 1, leaf buckets: 1, nodes: 36
Average node length: 15.92, total dup: 10, max dup: 8
Average key length: 14.89, compression ratio: 1.28
Average prefix length: 6.81, average data length: 12.19
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG (165)
Primary pointer page: 356, Index root page: 357
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_DTS (4)
Root page: 367, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_GDSCODE (2)
Root page: 365, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_ROWSET_DESC (1)
Root page: 364, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_UNIT (3)
Root page: 366, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG (0)
Root page: 363, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG_TABLE_STATS (166)
Primary pointer page: 369, Index root page: 370
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_DTS (4)
Root page: 376, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_GDSCODE (2)
Root page: 374, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_ROWSET (1)
Root page: 373, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_TN_UNIT (3)
Root page: 375, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG_TABLE_STATS (0)
Root page: 372, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
OPTYPES (138)
Primary pointer page: 241, Index root page: 242
Total formats: 1, used formats: 1
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 5.54
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 9%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OPTYPES_MCODE_UNQ (1)
Root page: 244, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 8.56, total dup: 0, max dup: 0
Average key length: 6.89, compression ratio: 0.73
Average prefix length: 0.44, average data length: 4.56
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_OPTYPES (0)
Root page: 243, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 6.11, total dup: 0, max dup: 0
Average key length: 5.00, compression ratio: 0.60
Average prefix length: 0.89, average data length: 2.11
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PDISTR (150)
Primary pointer page: 296, Index root page: 297
Total formats: 1, used formats: 1
Average record length: 41.60, total records: 479380
Average version length: 41.24, total versions: 46, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.54
Pointer pages: 3, data page slots: 4832
Data pages: 4832, average fill: 71%
Primary pages: 4832, secondary pages: 0, swept pages: 1378
Empty pages: 3, full pages: 4824
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4829
80 - 99% = 0
Index PDISTR_AGENT_ID (4)
Root page: 1583, depth: 2, leaf buckets: 481, nodes: 479380
Average node length: 4.78, total dup: 479331, max dup: 144608
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 37464, ratio: 0.08
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 419
60 - 79% = 39
80 - 99% = 23
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 139884, depth: 3, leaf buckets: 507, nodes: 479380
Average node length: 5.72, total dup: 432296, max dup: 13
Average key length: 2.95, compression ratio: 7.45
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 15704, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 307
60 - 79% = 1
80 - 99% = 199
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 94555, depth: 3, leaf buckets: 772, nodes: 479380
Average node length: 5.73, total dup: 432296, max dup: 13
Average key length: 2.96, compression ratio: 7.42
Average prefix length: 21.13, average data length: 0.87
Clustering factor: 23851, ratio: 0.05
Fill distribution:
0 - 19% = 0
20 - 39% = 19
40 - 59% = 751
60 - 79% = 1
80 - 99% = 1
Index PDISTR_SND_ID (1)
Root page: 1502, depth: 2, leaf buckets: 356, nodes: 479380
Average node length: 5.49, total dup: 432296, max dup: 13
Average key length: 2.72, compression ratio: 3.30
Average prefix length: 8.37, average data length: 0.63
Clustering factor: 11144, ratio: 0.02
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 16
60 - 79% = 0
80 - 99% = 339
PERF_ESTIMATED (160)
Primary pointer page: 344, Index root page: 345
Total formats: 1, used formats: 1
Average record length: 27.20, total records: 164014
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.18
Pointer pages: 1, data page slots: 1344
Data pages: 1344, average fill: 66%
Primary pages: 1344, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 1343
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 1343
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 158394, depth: 2, leaf buckets: 118, nodes: 164014
Average node length: 4.19, total dup: 163823, max dup: 1545
Average key length: 2.00, compression ratio: 1.27
Average prefix length: 2.54, average data length: 0.00
Clustering factor: 50875, ratio: 0.31
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 29
60 - 79% = 50
80 - 99% = 38
PERF_ISQL_STAT (161)
Primary pointer page: 347, Index root page: 348
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PERF_ISQL_STAT_TRN (0)
Root page: 349, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PERF_LOG (163)
Primary pointer page: 352, Index root page: 353
Total formats: 1, used formats: 1
Average record length: 137.85, total records: 1908116
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: 1456.00, compression ratio: 10.56
Pointer pages: 26, data page slots: 41976
Data pages: 41976, average fill: 86%
Primary pages: 41976, secondary pages: 0, swept pages: 3
Empty pages: 6, full pages: 41969
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 41970
Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 43646, depth: 3, leaf buckets: 2735, nodes: 1908116
Average node length: 5.68, total dup: 1377961, max dup: 54
Average key length: 2.71, compression ratio: 2.95
Average prefix length: 7.49, average data length: 0.50
Clustering factor: 343569, ratio: 0.18
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2734
60 - 79% = 1
80 - 99% = 0
Index PERF_LOG_GDSCODE (3)
Root page: 117488, depth: 3, leaf buckets: 1597, nodes: 1908116
Average node length: 4.08, total dup: 1908113, max dup: 1713462
Average key length: 1.10, compression ratio: 0.46
Average prefix length: 0.51, average data length: 0.00
Clustering factor: 74771, ratio: 0.04
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 1476
60 - 79% = 1
80 - 99% = 119
Index PERF_LOG_TRN_DESC (2)
Root page: 31965, depth: 3, leaf buckets: 2706, nodes: 1908116
Average node length: 5.80, total dup: 1691205, max dup: 37
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 177433, ratio: 0.09
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2649
60 - 79% = 57
80 - 99% = 0
Index PERF_LOG_UNIT (1)
Root page: 56336, depth: 3, leaf buckets: 2110, nodes: 1908116
Average node length: 5.15, total dup: 1883028, max dup: 176872
Average key length: 2.17, compression ratio: 17.11
Average prefix length: 37.04, average data length: 0.16
Clustering factor: 1227677, ratio: 0.64
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 1675
60 - 79% = 225
80 - 99% = 204
PHRASES (145)
Primary pointer page: 269, Index root page: 270
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_ID_DESC (3)
Root page: 283, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_NAME (2)
Root page: 282, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_UNQ (1)
Root page: 281, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_PHRASES (0)
Root page: 280, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PSTORNED (151)
Primary pointer page: 303, Index root page: 304
Total formats: 1, used formats: 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 PSTORNED_RCV_ID (2)
Root page: 309, 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 PSTORNED_SND_ID (1)
Root page: 308, 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
RULES_FOR_PDISTR (152)
Primary pointer page: 305, Index root page: 306
Total formats: 1, used formats: 1
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 336.00, compression ratio: 18.67
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 2%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_PDISTR_UNQ (0)
Root page: 310, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 11.50, total dup: 0, max dup: 0
Average key length: 10.25, compression ratio: 0.88
Average prefix length: 1.50, average data length: 7.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RULES_FOR_QDISTR (139)
Primary pointer page: 245, Index root page: 246
Total formats: 1, used formats: 1
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 332.00, compression ratio: 10.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_RCVOP (1)
Root page: 248, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 5.29, total dup: 2, max dup: 2
Average key length: 4.14, compression ratio: 0.72
Average prefix length: 1.43, average data length: 1.57
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_UNQ (0)
Root page: 247, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 10.14, total dup: 0, max dup: 0
Average key length: 8.86, compression ratio: 0.94
Average prefix length: 2.14, average data length: 6.14
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SEMAPHORES (156)
Primary pointer page: 318, Index root page: 319
Total formats: 1, used formats: 1
Average record length: 34.25, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 338.00, compression ratio: 9.87
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 3%
Primary pages: 1, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_SEMAPHORES (0)
Root page: 330, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 12.50, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.50, average data length: 8.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SEMAPHORES_TASK_UNQ (1)
Root page: 331, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 22.50, total dup: 0, max dup: 0
Average key length: 21.00, compression ratio: 1.07
Average prefix length: 4.00, average data length: 18.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SETTINGS (137)
Primary pointer page: 238, Index root page: 239
Total formats: 1, used formats: 1
Average record length: 98.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: 80%
Primary pages: 2, secondary pages: 0, swept pages: 2
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1
Index SETTINGS_MODE_CODE (0)
Root page: 240, depth: 1, leaf buckets: 1, nodes: 114
Average node length: 27.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: 236, Index root page: 237
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$SOURCE (135)
Primary pointer page: 234, Index root page: 235
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$DEP_DOCS (129)
Primary pointer page: 216, Index root page: 217
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_DEP_DOCS_UNQ (0)
Root page: 218, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$IDX_RECALC (132)
Primary pointer page: 226, Index root page: 227
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0)
Root page: 229, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG (133)
Primary pointer page: 230, Index root page: 231
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG_TABLE_STATS (134)
Primary pointer page: 232, Index root page: 233
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_LOG (164)
Primary pointer page: 354, Index root page: 355
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_MON (131)
Primary pointer page: 224, Index root page: 225
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$RESULT_SET (130)
Primary pointer page: 219, Index root page: 220
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_DOC (1)
Root page: 222, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_WARE_DOC (0)
Root page: 221, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$SHOPPING_CART (128)
Primary pointer page: 211, Index root page: 212
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_SHOPCART_UNQ (0)
Root page: 215, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRACE_STAT (162)
Primary pointer page: 350, Index root page: 351
Total formats: 1, used formats: 1
Average record length: 52.99, total records: 1198
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.57
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 64%
Primary pages: 16, secondary pages: 0, swept pages: 0
Empty pages: 2, full pages: 13
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 1
60 - 79% = 13
80 - 99% = 0
WARES (144)
Primary pointer page: 267, Index root page: 268
Total formats: 1, used formats: 1
Average record length: 77.58, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 448.00, compression ratio: 5.77
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 77%
Primary pages: 6, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 5
80 - 99% = 1
Index FK_WARES_WARE_GROUPS (3)
Root page: 380, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 66
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: 277, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 342, ratio: 0.85
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_ID_DESC (2)
Root page: 279, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 342, ratio: 0.85
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_NUMB_UNQ (1)
Root page: 585, depth: 2, leaf buckets: 4, nodes: 400
Average node length: 53.16, total dup: 0, max dup: 0
Average key length: 52.13, compression ratio: 1.00
Average prefix length: 2.79, average data length: 49.16
Clustering factor: 333, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3
80 - 99% = 0
WARE_GROUPS (155)
Primary pointer page: 316, Index root page: 317
Total formats: 1, used formats: 1
Average record length: 32.13, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 352.00, compression ratio: 10.96
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 5%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARE_GROUPS (0)
Root page: 328, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 11.25, total dup: 0, max dup: 0
Average key length: 10.13, compression ratio: 0.89
Average prefix length: 1.75, average data length: 7.25
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index WARE_GROUPS_NAME_UNQ (1)
Root page: 329, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 19.88, total dup: 0, max dup: 0
Average key length: 18.13, compression ratio: 0.89
Average prefix length: 0.25, average data length: 15.88
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQD_1000_1200 (260)
Primary pointer page: 298, Index root page: 307
Total formats: 1, used formats: 1
Average record length: 69.12, total records: 3315758
Average version length: 69.13, total versions: 24, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.97
Pointer pages: 28, data page slots: 44736
Data pages: 44736, average fill: 78%
Primary pages: 44736, secondary pages: 0, swept pages: 3933
Empty pages: 5, full pages: 44717
Fill distribution:
0 - 19% = 5
20 - 39% = 1
40 - 59% = 6
60 - 79% = 44722
80 - 99% = 2
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 8825, depth: 3, leaf buckets: 4839, nodes: 3315758
Average node length: 6.29, total dup: 2900999, max dup: 14
Average key length: 3.31, compression ratio: 11.17
Average prefix length: 35.81, average data length: 1.19
Clustering factor: 459474, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 4525
60 - 79% = 160
80 - 99% = 153
XQD_1000_3300 (262)
Primary pointer page: 782, Index root page: 783
Total formats: 1, used formats: 1
Average record length: 69.12, total records: 2485581
Average version length: 69.16, total versions: 32, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.97
Pointer pages: 21, data page slots: 33536
Data pages: 33536, average fill: 78%
Primary pages: 33536, secondary pages: 0, swept pages: 2941
Empty pages: 5, full pages: 33517
Fill distribution:
0 - 19% = 5
20 - 39% = 1
40 - 59% = 6
60 - 79% = 33522
80 - 99% = 2
Index XQD_1000_3300_DOC (1)
Root page: 49697, depth: 3, leaf buckets: 1914, nodes: 2485581
Average node length: 5.14, total dup: 2429149, max dup: 131
Average key length: 2.17, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 53058, ratio: 0.02
Fill distribution:
0 - 19% = 9
20 - 39% = 3
40 - 59% = 446
60 - 79% = 28
80 - 99% = 1428
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 11441, depth: 3, leaf buckets: 3589, nodes: 2485581
Average node length: 6.28, total dup: 2174661, max dup: 14
Average key length: 3.32, compression ratio: 11.16
Average prefix length: 35.81, average data length: 1.19
Clustering factor: 343422, ratio: 0.14
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 3288
60 - 79% = 165
80 - 99% = 135
XQD_1200_2000 (261)
Primary pointer page: 777, Index root page: 778
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 XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 779, 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
XQD_2000_3300 (263)
Primary pointer page: 786, Index root page: 787
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 XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 788, 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
XQD_2100_3300 (264)
Primary pointer page: 789, Index root page: 790
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 XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 791, 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
XQD_3300_3400 (265)
Primary pointer page: 801, Index root page: 802
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 XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 803, 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_1000_1200 (266)
Primary pointer page: 805, Index root page: 806
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_1000_1200_DOC_ID (0)
Root page: 807, 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_1000_1200_RCV_ID (2)
Root page: 809, 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_1000_1200_SND_ID (1)
Root page: 808, 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_1000_3300 (268)
Primary pointer page: 815, Index root page: 816
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_1000_3300_DOC_ID (0)
Root page: 818, 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_1000_3300_RCV_ID (2)
Root page: 820, 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_1000_3300_SND_ID (1)
Root page: 819, 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_1200_2000 (267)
Primary pointer page: 810, Index root page: 811
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_1200_2000_DOC_ID (0)
Root page: 812, 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_1200_2000_RCV_ID (2)
Root page: 814, 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_1200_2000_SND_ID (1)
Root page: 813, 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_2000_3300 (269)
Primary pointer page: 821, Index root page: 822
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_DOC_ID (0)
Root page: 823, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_RCV_ID (2)
Root page: 825, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_SND_ID (1)
Root page: 824, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQS_2100_3300 (270)
Primary pointer page: 826, Index root page: 827
Total formats: 1, used formats: 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_2100_3300_DOC_ID (0)
Root page: 828, 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_2100_3300_RCV_ID (2)
Root page: 830, 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_2100_3300_SND_ID (1)
Root page: 829, 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_3300_3400 (271)
Primary pointer page: 831, Index root page: 832
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_3300_3400_DOC_ID (0)
Root page: 833, 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_3300_3400_SND_ID (1)
Root page: 834, 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
ZDOC_DATA (230)
Primary pointer page: 674, Index root page: 675
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZDOC_LIST (229)
Primary pointer page: 672, Index root page: 673
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZINVNT_TURNOVER_LOG (231)
Primary pointer page: 676, Index root page: 677
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPDISTR (234)
Primary pointer page: 682, Index root page: 683
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPDISTR_ID (0)
Root page: 692, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPSTORNED (235)
Primary pointer page: 684, Index root page: 685
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPSTORNED_ID (0)
Root page: 693, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQDISTR (232)
Primary pointer page: 678, Index root page: 679
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_ID (0)
Root page: 686, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Root page: 687, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQSTORNED (233)
Primary pointer page: 680, Index root page: 681
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_DOC_ID (1)
Root page: 689, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_ID (0)
Root page: 688, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_RCV_ID (3)
Root page: 691, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_SND_ID (2)
Root page: 690, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_DEP_DOCS (228)
Primary pointer page: 622, Index root page: 623
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_SHOPPING_CART (227)
Primary pointer page: 620, Index root page: 621
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Z_USED_VIEWS (146)
Primary pointer page: 271, Index root page: 272
Total formats: 1, used formats: 1
Average record length: 29.56, total records: 16
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.35
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 10%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index Z_USED_VIEWS_UNQ (0)
Root page: 284, depth: 1, leaf buckets: 1, nodes: 16
Average node length: 17.00, total dup: 0, max dup: 0
Average key length: 15.94, compression ratio: 1.29
Average prefix length: 7.56, average data length: 13.00
Clustering factor: 1, ratio: 0.06
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Done for 11310 ms, from 2:29:48.46 to 2:29:59.77.
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
VERS_PERCENT |
AGENTS |
50 |
0 |
0.0000 |
BUSINESS_OPS |
19 |
0 |
0.0000 |
DOC_DATA |
437633 |
0 |
0.0000 |
DOC_LIST |
126448 |
0 |
0.0000 |
DOC_STATES |
4 |
0 |
0.0000 |
FB_ERRORS |
758 |
0 |
0.0000 |
INVNT_SALDO |
400 |
0 |
0.0000 |
INVNT_TURNOVER_LOG |
7 |
0 |
0.0000 |
MONEY_SALDO |
49 |
0 |
0.0000 |
MONEY_TURNOVER_LOG |
36 |
36 |
100.0000 |
OPTYPES |
9 |
0 |
0.0000 |
PDISTR |
479380 |
46 |
0.0095 |
PERF_ESTIMATED |
164014 |
0 |
0.0000 |
PERF_LOG |
1908116 |
0 |
0.0000 |
RULES_FOR_PDISTR |
4 |
0 |
0.0000 |
RULES_FOR_QDISTR |
7 |
0 |
0.0000 |
SEMAPHORES |
4 |
0 |
0.0000 |
SETTINGS |
114 |
0 |
0.0000 |
TRACE_STAT |
1198 |
0 |
0.0000 |
WARES |
400 |
0 |
0.0000 |
WARE_GROUPS |
8 |
0 |
0.0000 |
XQD_1000_1200 |
3315758 |
24 |
0.0007 |
XQD_1000_3300 |
2485581 |
32 |
0.0012 |
Z_USED_VIEWS |
16 |
0 |
0.0000 |
Done for 1790 ms, from 2:30:07.95 to 2:30:09.74.
02:30:09.83 Validation started
02:30:09.83 Relation 140 (DOC_LIST)
02:30:09.83 process pointer page 0 of 1
02:30:09.86 Index 1 (PK_DOC_LIST)
02:30:09.88 Index 2 (DOC_LIST_ID_DESC)
02:30:09.90 Index 3 (FK_DOC_LIST_AGENTS)
02:30:09.91 Relation 140 (DOC_LIST) is ok
02:30:09.91 Relation 141 (DOC_DATA)
02:30:09.91 process pointer page 0 of 3
02:30:09.94 process pointer page 1 of 3
02:30:09.97 process pointer page 2 of 3
02:30:10.01 Index 2 (DOC_DATA_DOC_WARE_UNQ)
02:30:10.18 Index 3 (DOC_DATA_ID_DESC)
02:30:10.30 Index 4 (FK_DOC_DATA_DOC_LIST)
02:30:10.40 Relation 141 (DOC_DATA) is ok
02:30:10.40 Relation 147 (INVNT_SALDO)
02:30:10.40 process pointer page 0 of 1
02:30:10.40 Index 1 (PK_INVNT_SALDO)
02:30:10.40 Relation 147 (INVNT_SALDO) is ok
02:30:10.40 Relation 150 (PDISTR)
02:30:10.40 process pointer page 0 of 3
02:30:10.50 process pointer page 1 of 3
02:30:10.60 process pointer page 2 of 3
02:30:10.69 Index 2 (PDISTR_SND_ID)
02:30:10.79 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
02:30:10.91 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
02:30:10.97 Index 5 (PDISTR_AGENT_ID)
02:30:11.10 Relation 150 (PDISTR) is ok
02:30:11.10 Relation 151 (PSTORNED)
02:30:11.10 process pointer page 0 of 1
02:30:11.10 Index 2 (PSTORNED_SND_ID)
02:30:11.10 Index 3 (PSTORNED_RCV_ID)
02:30:11.10 Relation 151 (PSTORNED) is ok
02:30:11.10 Relation 156 (SEMAPHORES)
02:30:11.10 process pointer page 0 of 1
02:30:11.10 Index 1 (PK_SEMAPHORES)
02:30:11.10 Index 2 (SEMAPHORES_TASK_UNQ)
02:30:11.10 Relation 156 (SEMAPHORES) is ok
02:30:11.10 Relation 157 (INVNT_TURNOVER_LOG)
02:30:11.10 process pointer page 0 of 1
02:30:11.10 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
02:30:11.10 Relation 157 (INVNT_TURNOVER_LOG) is ok
02:30:11.10 Relation 160 (PERF_ESTIMATED)
02:30:11.10 process pointer page 0 of 1
02:30:11.18 Index 1 (PERF_EST_MINUTE_SINCE_START)
02:30:11.24 Relation 160 (PERF_ESTIMATED) is ok
02:30:11.24 Relation 161 (PERF_ISQL_STAT)
02:30:11.24 process pointer page 0 of 1
02:30:11.24 Index 1 (PERF_ISQL_STAT_TRN)
02:30:11.24 Relation 161 (PERF_ISQL_STAT) is ok
02:30:11.24 Relation 162 (TRACE_STAT)
02:30:11.24 process pointer page 0 of 1
02:30:11.24 Relation 162 (TRACE_STAT) is ok
02:30:11.24 Relation 163 (PERF_LOG)
02:30:11.24 process pointer page 0 of 26
02:30:11.32 process pointer page 1 of 26
02:30:11.39 process pointer page 2 of 26
02:30:11.47 process pointer page 3 of 26
02:30:11.55 process pointer page 4 of 26
02:30:11.63 process pointer page 5 of 26
02:30:11.72 process pointer page 6 of 26
02:30:11.80 process pointer page 7 of 26
02:30:11.88 process pointer page 8 of 26
02:30:11.96 process pointer page 9 of 26
02:30:12.03 process pointer page 10 of 26
02:30:12.11 process pointer page 11 of 26
02:30:12.19 process pointer page 12 of 26
02:30:12.27 process pointer page 13 of 26
02:30:12.33 process pointer page 14 of 26
02:30:12.36 process pointer page 15 of 26
02:30:12.44 process pointer page 16 of 26
02:30:12.52 process pointer page 17 of 26
02:30:12.55 process pointer page 18 of 26
02:30:12.61 process pointer page 19 of 26
02:30:12.69 process pointer page 20 of 26
02:30:12.77 process pointer page 21 of 26
02:30:12.84 process pointer page 22 of 26
02:30:12.92 process pointer page 23 of 26
02:30:13.02 process pointer page 24 of 26
02:30:13.09 process pointer page 25 of 26
02:30:13.16 Index 1 (PERF_LOG_DTS_BEG_DESC)
02:30:13.73 Index 2 (PERF_LOG_UNIT)
02:30:14.67 Index 3 (PERF_LOG_TRN_DESC)
02:30:15.11 Index 4 (PERF_LOG_GDSCODE)
02:30:15.43 Relation 163 (PERF_LOG) is ok
02:30:15.43 Relation 167 (V_STOPTEST)
02:30:15.43 Relation 167 (V_STOPTEST) is ok
02:30:15.43 Relation 184 (V_QDISTR_SOURCE)
02:30:15.43 Relation 184 (V_QDISTR_SOURCE) is ok
02:30:15.43 Relation 185 (V_QSTORNED_SOURCE)
02:30:15.43 Relation 185 (V_QSTORNED_SOURCE) is ok
02:30:15.43 Relation 260 (XQD_1000_1200)
02:30:15.43 process pointer page 0 of 28
02:30:15.53 process pointer page 1 of 28
02:30:15.57 process pointer page 2 of 28
02:30:15.62 process pointer page 3 of 28
02:30:15.71 process pointer page 4 of 28
02:30:15.75 process pointer page 5 of 28
02:30:15.78 process pointer page 6 of 28
02:30:15.84 process pointer page 7 of 28
02:30:15.93 process pointer page 8 of 28
02:30:16.03 process pointer page 9 of 28
02:30:16.12 process pointer page 10 of 28
02:30:16.20 process pointer page 11 of 28
02:30:16.29 process pointer page 12 of 28
02:30:16.39 process pointer page 13 of 28
02:30:16.48 process pointer page 14 of 28
02:30:16.57 process pointer page 15 of 28
02:30:16.65 process pointer page 16 of 28
02:30:16.74 process pointer page 17 of 28
02:30:16.84 process pointer page 18 of 28
02:30:16.93 process pointer page 19 of 28
02:30:17.01 process pointer page 20 of 28
02:30:17.04 process pointer page 21 of 28
02:30:17.07 process pointer page 22 of 28
02:30:17.12 process pointer page 23 of 28
02:30:17.15 process pointer page 24 of 28
02:30:17.23 process pointer page 25 of 28
02:30:17.32 process pointer page 26 of 28
02:30:17.40 process pointer page 27 of 28
02:30:17.45 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
02:30:18.04 Relation 260 (XQD_1000_1200) is ok
02:30:18.04 Relation 261 (XQD_1200_2000)
02:30:18.04 process pointer page 0 of 1
02:30:18.04 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
02:30:18.04 Relation 261 (XQD_1200_2000) is ok
02:30:18.04 Relation 262 (XQD_1000_3300)
02:30:18.04 process pointer page 0 of 21
02:30:18.07 process pointer page 1 of 21
02:30:18.10 process pointer page 2 of 21
02:30:18.20 process pointer page 3 of 21
02:30:18.23 process pointer page 4 of 21
02:30:18.29 process pointer page 5 of 21
02:30:18.38 process pointer page 6 of 21
02:30:18.48 process pointer page 7 of 21
02:30:18.57 process pointer page 8 of 21
02:30:18.66 process pointer page 9 of 21
02:30:18.76 process pointer page 10 of 21
02:30:18.79 process pointer page 11 of 21
02:30:18.82 process pointer page 12 of 21
02:30:18.87 process pointer page 13 of 21
02:30:18.90 process pointer page 14 of 21
02:30:18.93 process pointer page 15 of 21
02:30:18.96 process pointer page 16 of 21
02:30:19.01 process pointer page 17 of 21
02:30:19.04 process pointer page 18 of 21
02:30:19.07 process pointer page 19 of 21
02:30:19.08 process pointer page 20 of 21
02:30:19.12 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
02:30:19.74 Index 2 (XQD_1000_3300_DOC)
02:30:20.18 Relation 262 (XQD_1000_3300) is ok
02:30:20.18 Relation 263 (XQD_2000_3300)
02:30:20.18 process pointer page 0 of 1
02:30:20.18 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
02:30:20.18 Relation 263 (XQD_2000_3300) is ok
02:30:20.18 Relation 264 (XQD_2100_3300)
02:30:20.18 process pointer page 0 of 1
02:30:20.18 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
02:30:20.18 Relation 264 (XQD_2100_3300) is ok
02:30:20.18 Relation 265 (XQD_3300_3400)
02:30:20.18 process pointer page 0 of 1
02:30:20.18 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
02:30:20.18 Relation 265 (XQD_3300_3400) is ok
02:30:20.18 Relation 266 (XQS_1000_1200)
02:30:20.18 process pointer page 0 of 1
02:30:20.18 Index 1 (XQS_1000_1200_DOC_ID)
02:30:20.18 Index 2 (XQS_1000_1200_SND_ID)
02:30:20.18 Index 3 (XQS_1000_1200_RCV_ID)
02:30:20.18 Relation 266 (XQS_1000_1200) is ok
02:30:20.18 Relation 267 (XQS_1200_2000)
02:30:20.18 process pointer page 0 of 1
02:30:20.18 Index 1 (XQS_1200_2000_DOC_ID)
02:30:20.18 Index 2 (XQS_1200_2000_SND_ID)
02:30:20.18 Index 3 (XQS_1200_2000_RCV_ID)
02:30:20.18 Relation 267 (XQS_1200_2000) is ok
02:30:20.18 Relation 268 (XQS_1000_3300)
02:30:20.18 process pointer page 0 of 1
02:30:20.18 Index 1 (XQS_1000_3300_DOC_ID)
02:30:20.18 Index 2 (XQS_1000_3300_SND_ID)
02:30:20.18 Index 3 (XQS_1000_3300_RCV_ID)
02:30:20.18 Relation 268 (XQS_1000_3300) is ok
02:30:20.18 Relation 269 (XQS_2000_3300)
02:30:20.18 process pointer page 0 of 1
02:30:20.18 Index 1 (XQS_2000_3300_DOC_ID)
02:30:20.18 Index 2 (XQS_2000_3300_SND_ID)
02:30:20.18 Index 3 (XQS_2000_3300_RCV_ID)
02:30:20.18 Relation 269 (XQS_2000_3300) is ok
02:30:20.18 Relation 270 (XQS_2100_3300)
02:30:20.18 process pointer page 0 of 1
02:30:20.18 Index 1 (XQS_2100_3300_DOC_ID)
02:30:20.18 Index 2 (XQS_2100_3300_SND_ID)
02:30:20.18 Index 3 (XQS_2100_3300_RCV_ID)
02:30:20.18 Relation 270 (XQS_2100_3300) is ok
02:30:20.18 Relation 271 (XQS_3300_3400)
02:30:20.18 process pointer page 0 of 1
02:30:20.18 Index 1 (XQS_3300_3400_DOC_ID)
02:30:20.18 Index 2 (XQS_3300_3400_SND_ID)
02:30:20.18 Relation 271 (XQS_3300_3400) is ok
02:30:20.18 Validation finished
Done for 10420 ms, from 2:30:09.76 to 2:30:20.18.
Differences between old and current firebird.log
2:30:20.54. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2016-11-17 02:30 509 oltp40_fb_log_when_test_finished.log
End of gathering firebird.log AFTER test finish.
+++ Start of comparison +++
Comparing files E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Thu Nov 17 02:30:09 2016
7: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Thu Nov 17 02:30:20 2016
12: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++
Remove 401 logs of every ISQL session if there were no serious errors.
Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp40\oltp40_*.*:
ERRORS_CHECKING_RESULT |
NO_SEVERE_ERRORS_FOUND |
ISQL logs are removed because no severe errors occured during test.
2016-11-17 2:30:23.27 - end of report, text file: e:\temp\logs.oltp40\oltp40.report.txt, html: e:\temp\logs.oltp40\oltp40.report.html