Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 09.03.2021 19:27
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.26
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17345148 kB
MemAvailable 31559400 kB
Buffers 0 kB
Cached 14284512 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-09 19:27:22
DTS_END                         2021-03-09 19:27:22.0580
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/54538
TRN_ID                          240558
ATT_ID                          685
EXC_UNIT                        2


Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 120 minutes: 9030.98 21386 1083717
customer order: creation 170.23 343 20427
customer order: refuse 15.28 339 1834
order to supplier: creation 45.58 1298 5470
order to supplier: removal 3.29 101718 395
invoice (draft): creation 46.38 3774 5566
invoice (draft): removal 50.29 839 6035
invoice accept: apply 42.31 18121 5077
invoice accept: cancel 45.58 889 5470
customer reserve: creation 3827.96 181 459355
customer reserve: removal 4485.38 58 538245
realization accept: apply 84.89 176 10187
realization accept: cancel 82.85 119 9942
payment from customer: creation 59.25 126 7110
payment from customer: removal 5.88 74 705
payment to supplier: creation 49.39 132 5927
payment to supplier: removal 3.33 87 399
service: total inventory turnovers 5.14 1126 617
service: total monetary turnovers 7.10 38 852
service: aggregate perf. data 0.83 17932 100
service: refresh index statistics 0.03 280355 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 09-03-2021 19:28:19 to 09-03-2021 19:28:21.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5511
TEST_TIME 2 6126
TEST_TIME 3 6570
TEST_TIME 4 7684
TEST_TIME 5 7288
TEST_TIME 6 6989
TEST_TIME 7 7286
TEST_TIME 8 7272
TEST_TIME 9 7287
TEST_TIME 10 7269
TEST_TIME 11 7501
TEST_TIME 12 7523
TEST_TIME 13 7671
TEST_TIME 14 7940
TEST_TIME 15 8311
TEST_TIME 16 8529
TEST_TIME 17 8503
TEST_TIME 18 8450
TEST_TIME 19 8538
TEST_TIME 20 8680
TEST_TIME 21 8848
TEST_TIME 22 8810
TEST_TIME 23 9000
TEST_TIME 24 9197
TEST_TIME 25 9524
TEST_TIME 26 9574
TEST_TIME 27 9775
TEST_TIME 28 10420
TEST_TIME 29 10339
TEST_TIME 30 10763
TEST_TIME 31 11226
TEST_TIME 32 10985
TEST_TIME 33 10855
TEST_TIME 34 10806
TEST_TIME 35 10666
TEST_TIME 36 10547
TEST_TIME 37 10369
TEST_TIME 38 10211
TEST_TIME 39 10170
TEST_TIME 40 10158
TEST_TIME 41 10080
TEST_TIME 42 9945
TEST_TIME 43 9904
TEST_TIME 44 9860
TEST_TIME 45 9736
TEST_TIME 46 9642
TEST_TIME 47 9589
TEST_TIME 48 9557
TEST_TIME 49 9467
TEST_TIME 50 9353
TEST_TIME 51 9342
TEST_TIME 52 9338
TEST_TIME 53 9300
TEST_TIME 54 9216
TEST_TIME 55 9127
TEST_TIME 56 9061
TEST_TIME 57 9189
TEST_TIME 58 9153
TEST_TIME 59 9162
TEST_TIME 60 9117
TEST_TIME 61 9164
TEST_TIME 62 9171
TEST_TIME 63 9138
TEST_TIME 64 9231
TEST_TIME 65 9244
TEST_TIME 66 9260
TEST_TIME 67 9251
TEST_TIME 68 9287
TEST_TIME 69 9282
TEST_TIME 70 9262
TEST_TIME 71 9344
TEST_TIME 72 9310
TEST_TIME 73 9342
TEST_TIME 74 9361
TEST_TIME 75 9253
TEST_TIME 76 9197
TEST_TIME 77 9164
TEST_TIME 78 9187
TEST_TIME 79 9149
TEST_TIME 80 9119
TEST_TIME 81 9075
TEST_TIME 82 9031
TEST_TIME 83 8959
TEST_TIME 84 9030
TEST_TIME 85 9000
TEST_TIME 86 8971
TEST_TIME 87 8968
TEST_TIME 88 8977
TEST_TIME 89 9068
TEST_TIME 90 9080
TEST_TIME 91 9093
TEST_TIME 92 9108
TEST_TIME 93 9178
TEST_TIME 94 9145
TEST_TIME 95 9216
TEST_TIME 96 9241
TEST_TIME 97 9207
TEST_TIME 98 9179
TEST_TIME 99 9227
TEST_TIME 100 9148
TEST_TIME 101 9095
TEST_TIME 102 9079
TEST_TIME 103 9062
TEST_TIME 104 9008
TEST_TIME 105 9000
TEST_TIME 106 8988
TEST_TIME 107 8959
TEST_TIME 108 8915
TEST_TIME 109 8926
TEST_TIME 110 8911
TEST_TIME 111 8919
TEST_TIME 112 8913
TEST_TIME 113 8984
TEST_TIME 114 9028
TEST_TIME 115 8999
TEST_TIME 116 9012
TEST_TIME 117 9094
TEST_TIME 118 9083
TEST_TIME 119 9071
TEST_TIME 120 9037

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 09-03-2021 19:28:23 to 09-03-2021 19:28:26.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1507787 1507787 0 0.00 0 23692 6 0 0
doc_list_biud 1507785 1507785 0 0.00 0 28008 27 0 0
sp_add_invoice_to_stock 5173 5077 96 1.85 34 228863 18122 0 96
sp_cancel_adding_invoice 5470 5470 0 0.00 5 49398 890 0 0
sp_cancel_client_order 1834 1834 0 0.00 4 10100 339 0 0
sp_cancel_customer_reserve 538245 538245 0 0.00 1 22756 58 0 0
sp_cancel_pay_from_customer 705 705 0 0.00 3 4576 74 0 0
sp_cancel_pay_to_supplier 399 399 0 0.00 3 4164 87 0 0
sp_cancel_supplier_invoice 6041 6035 6 0.09 1 23001 840 0 6
sp_cancel_supplier_order 395 395 0 0.00 22 1029912 101718 0 0
sp_cancel_write_off 9942 9942 0 0.00 1 16112 119 0 0
sp_client_order 20427 20427 0 0.00 3 15689 343 0 0
sp_customer_reserve 459355 459355 0 0.00 0 38110 182 0 0
sp_fill_shopping_cart 31460 31460 0 0.00 1 15426 44 0 0
sp_fill_shopping_cart_clo_res 459346 459346 0 0.00 0 10437 13 0 0
sp_get_clo_for_invoice 5068 5068 0 0.00 0 12818 301 0 0
sp_kill_cost_storno 16516 16516 0 0.00 0 7146 58 0 0
sp_kill_qstorno_ret_qs2qd 1092862 1092862 0 0.00 0 25973 32 0 0
sp_kill_qty_storno 577175 577175 0 0.00 0 28005 70 0 0
sp_lock_selected_doc 21093 21093 0 0.00 0 7804 4 0 0
sp_make_cost_storno 28292 28292 0 0.00 0 21024 56 0 0
sp_multiply_rows_for_pdistr 28292 28292 0 0.00 0 11953 30 0 0
sp_multiply_rows_for_qdistr 20427 20427 0 0.00 0 15680 159 0 0
sp_pay_from_customer 7110 7110 0 0.00 4 20921 127 0 0
sp_pay_to_supplier 5927 5927 0 0.00 4 18398 133 0 0
sp_payment_common 13037 13037 0 0.00 1 20877 27 0 0
sp_qd_handle_on_cancel_clo 1834 1834 0 0.00 0 10095 315 0 0
sp_qd_handle_on_invoice_upd_sts 10538 10538 0 0.00 0 28002 375 0 0
sp_qd_handle_on_reserve_upd_sts 10186 10186 0 0.00 0 21090 65 0 0
sp_reserve_write_off 10187 10187 0 0.00 6 21124 177 0 0
sp_supplier_invoice 5566 5566 0 0.00 6 86230 3775 0 0
sp_supplier_order 5470 5470 0 0.00 5 31018 1298 0 0
srv_aggregate_perf_data 100 100 0 0.00 2829 146989 17933 0 0
srv_fill_mon_cache_memory 168 168 0 0.00 1386 128714 30038 0 0
srv_find_qd_qs_mism 1035414 1035414 0 0.00 0 23690 6 0 0
srv_make_invnt_saldo 617 617 0 0.00 34 68586 1127 0 0
srv_make_money_saldo 852 852 0 0.00 1 3926 38 0 0
srv_recalc_idx_stat 4 4 0 0.00 124171 419270 280355 0 0
t$perf-abend:sp_add_invoice_to_stock 96 96 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5077 5077 0 0.00 0 18471 196 0 0
t$perf-norm:sp_cancel_adding_invoice 420 420 0 0.00 0 20327 166 0 0
t$perf-norm:sp_cancel_client_order 1834 1834 0 0.00 0 8814 18 0 0
t$perf-norm:sp_cancel_customer_reserve 715 715 0 0.00 0 824 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 705 705 0 0.00 0 9880 20 0 0
t$perf-norm:sp_cancel_pay_to_supplier 399 399 0 0.00 0 229 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 389 389 0 0.00 0 1252 18 0 0
t$perf-norm:sp_cancel_supplier_order 395 395 0 0.00 0 29661 2001 0 0
t$perf-norm:sp_cancel_write_off 982 982 0 0.00 0 425 3 0 0
t$perf-norm:sp_client_order 20427 20427 0 0.00 0 15929 25 0 0
t$perf-norm:sp_customer_reserve 990 990 0 0.00 0 8951 28 0 0
t$perf-norm:sp_pay_from_customer 7110 7110 0 0.00 0 10770 16 0 0
t$perf-norm:sp_pay_to_supplier 5927 5927 0 0.00 0 9783 16 0 0
t$perf-norm:sp_reserve_write_off 10187 10187 0 0.00 0 17925 12 0 0
t$perf-norm:sp_supplier_invoice 5566 5566 0 0.00 0 6989 20 0 0
t$perf-norm:sp_supplier_order 5470 5470 0 0.00 0 10917 24 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 361 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 168 168 0 0.00 0 4192 49 0 0
t$perf-norm:srv_make_invnt_saldo 617 617 0 0.00 0 921 25 0 0
t$perf-norm:srv_make_money_saldo 852 852 0 0.00 0 6493 28 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 51 14 0 0
v_add_invoice_to_stock 10328 10136 192 1.85 0 8549 20 0 192
v_all_customers 37054 37054 0 0.00 0 19 1 0 0
v_all_suppliers 30048 30048 0 0.00 0 101 1 0 0
v_all_wares 40854 40854 0 0.00 0 69 1 0 0
v_cancel_adding_invoice 840 840 0 0.00 0 403 7 0 0
v_cancel_client_order 3668 3668 0 0.00 0 2151 4 0 0
v_cancel_customer_prepayment 1410 1410 0 0.00 0 2002 7 0 0
v_cancel_customer_reserve 1430 1430 0 0.00 0 324 3 0 0
v_cancel_payment_to_supplier 798 798 0 0.00 0 473 4 0 0
v_cancel_supplier_invoice 790 778 12 1.51 0 1183 18 0 12
v_cancel_supplier_order 790 790 0 0.00 0 224 3 0 0
v_cancel_write_off 1964 1964 0 0.00 0 3111 14 0 0
v_max_id_clo_ord 5469 5469 0 0.00 0 7800 3 0 0
v_max_id_clo_res 990 990 0 0.00 0 2193 9 0 0
v_max_id_ord_sup 5564 5564 0 0.00 0 6010 3 0 0
v_max_non_paid_invoice 1936 1936 0 0.00 0 193 2 0 0
v_max_non_paid_realizn 3889 3889 0 0.00 0 858 3 0 0
v_min_id_clo_ord 5469 5469 0 0.00 0 15280 11 0 0
v_min_id_clo_res 990 990 0 0.00 0 2413 7 0 0
v_min_id_ord_sup 5564 5564 0 0.00 0 5916 9 0 0
v_min_non_paid_invoice 5927 5927 0 0.00 0 5200 14 0 0
v_min_non_paid_realizn 7110 7110 0 0.00 0 20872 17 0 0
v_our_firm 10242 10242 0 0.00 0 15 1 0 0
v_reserve_write_off 20372 20372 0 0.00 0 8637 6 0 0
x_lock_depdocs_on_canc_invoice 11116 11116 0 0.00 0 15508 125 0 0
x_lock_depdocs_on_canc_sup_ord 395 395 0 0.00 0 19838 404 0 0
x_make_qstorno_1000_1200 5470 5470 0 0.00 1 30964 1200 0 0
x_make_qstorno_1200_2000 5566 5566 0 0.00 2 86212 3625 0 0
x_make_qstorno_2100_3300 459355 459355 0 0.00 0 38108 166 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-03-2021 19:28:27 to 09-03-2021 19:28:31.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:25 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:32 24426 8192000000 10246212784 10556661760 1051202512 11.372 82 58 117 1 1073654608 2858432 19593664
16:58:04 28827 8192000000 10348765056 10665963520 1394705232 14.548 100 84 168 0 1426276224 4734528 26836464
16:58:43 22978 8192000000 10385538752 10704494592 1428024048 14.844 100 89 178 0 1463706272 6221600 29460624
16:59:17 13458 8192000000 10393100640 10720653312 1454887392 15.081 100 93 185 1 1492550416 7403296 30259728
16:59:43 31407 8192000000 10425219760 10754641920 1476260336 15.269 100 93 186 1 1514160064 7939632 29960096
17:00:23 17223 8192000000 10439672240 10768232448 1492884096 15.414 100 91 182 2 1531093808 8616064 29593648
17:00:55 23542 8192000000 10461760112 10797387776 1510523312 15.568 100 83 167 0 1545897808 9024176 26350320
17:01:29 19919 8192000000 10492374816 10834010112 1542885456 15.849 100 90 178 0 1580878576 9940128 28052992
17:01:57 21345 8192000000 10506206448 10855313408 1560221536 15.998 100 82 164 0 1596328224 10599616 25507072
17:02:26 14172 8192000000 10531655216 10882904064 1586105632 16.220 100 78 156 1 1620612752 10619024 23888096
17:02:48 14996 8192000000 10555211600 10914971648 1608799056 16.414 100 70 139 0 1640196080 10813520 20583504
17:03:13 14296 8192000000 10589567840 10947063808 1647844496 16.746 100 92 184 3 1687771264 12284960 27641808
17:03:38 9567 8192000000 10597103536 10958946304 1656530032 16.820 100 79 158 1 1692838352 12760576 23547744
17:03:56 10915 8192000000 10623366800 10991083520 1680097168 17.018 100 77 153 4 1714697728 12112928 22487632
17:04:16 7684 8192000000 10646374512 11011035136 1698435056 17.172 100 76 152 1 1733209120 12030560 22743504
17:04:31 7325 8192000000 10650905248 11019980800 1713064464 17.294 100 80 160 0 1748587888 12120480 23402944
17:04:46 6316 8192000000 10666651600 11036647424 1719487152 17.348 100 72 144 1 1751965376 11772832 20705392
17:04:59 6995 8192000000 10679944416 11050258432 1738958160 17.510 100 88 175 2 1776404080 12302448 25143472
17:05:13 6442 8192000000 10684123888 11060023296 1747432992 17.580 100 76 152 0 1781172928 12109776 21630160
17:05:27 5190 8192000000 10686265888 11066736640 1754678096 17.640 100 77 154 1 1789690304 12610176 22402032
17:05:39 5621 8192000000 10706472624 11082260480 1763167312 17.711 100 78 156 1 1798010352 12546320 22296720
17:05:52 4897 8192000000 10710920848 11091881984 1773277696 17.794 100 67 134 1 1803886592 12194928 18413968
17:06:04 3973 8192000000 10728350304 11107446784 1790200960 17.933 100 81 161 0 1825682528 12549312 22932256
17:06:14 4893 8192000000 10736406608 11114782720 1795463712 17.977 100 91 183 1 1835509392 14433136 25612544
17:06:26 4267 8192000000 10745545856 11123974144 1802482592 18.034 100 86 171 0 1840478464 13880688 24115184
17:06:37 3039 8192000000 10746517856 11128692736 1806526544 18.067 100 87 175 2 1844515808 13757984 24231280
17:06:47 4166 8192000000 10753261488 11136839680 1814211440 18.130 100 86 172 0 1852212032 14178112 23822480
17:06:57 8947 8192000000 10759064672 11148849152 1819105904 18.170 100 85 170 2 1857302720 14753776 23443040
17:07:14 4685 8192000000 10762641536 11149393920 1821614336 18.191 100 85 171 1 1859670192 14917808 23138048
17:07:25 3376 8192000000 10784963328 11166449664 1836958560 18.316 100 91 182 1 1877402528 15415920 25028048
17:07:34 1976 8192000000 10783959232 11166879744 1840131600 18.342 100 94 189 0 1882453888 15558064 26764224
17:07:43 2726 8192000000 10790441120 11173355520 1845025424 18.382 100 85 170 1 1882631344 13572960 24032960
17:07:52 1972 8192000000 10797176112 11184201728 1850209504 18.424 100 95 190 3 1890598320 13839792 26549024
17:08:01 1960 8192000000 10797596272 11182829568 1850983168 18.430 100 91 182 0 1891201152 14911232 25306752
17:08:09 1829 8192000000 10800840896 11188248576 1857852736 18.486 100 93 184 1 1895731856 11988848 25890272
17:08:17 2519 8192000000 10797986048 11185975296 1859009536 18.495 100 90 180 2 1895725920 11919104 24797280
17:08:26 1484 8192000000 10806141888 11193241600 1860888464 18.510 100 94 186 1 1901681312 14133008 26659840
17:08:34 2196 8192000000 10808450352 11196510208 1864235440 18.538 100 91 182 0 1902387664 12683280 25468944
17:08:42 2077 8192000000 10809898720 11198963712 1865421872 18.547 100 91 183 2 1905299904 13051920 26826112
17:08:51 1649 8192000000 10807580016 11196956672 1866916352 18.559 100 89 176 1 1904730880 11951376 25863152
17:09:00 3516 8192000000 10818270896 11204321280 1866659968 18.557 100 81 162 0 1902498464 13096880 22741616
17:09:09 1580 8192000000 10819794016 11207536640 1877142624 18.642 100 84 169 2 1914597840 14102880 23352336
17:09:17 2963 8192000000 10812760832 11205099520 1871461552 18.596 100 65 129 1 1902004016 12625840 17916624
17:09:27 2620 8192000000 10802128768 11207806976 1872712736 18.606 100 67 133 2 1903499296 12689488 18097072
17:09:36 6050 8192000000 10794290912 11208691712 1873847392 18.615 100 56 112 1 1900617488 10894928 15875168
17:09:48 47303 8192000000 10780991632 11205054464 1870680752 18.590 100 40 79 2 1888670192 6243696 11745744
17:10:42 7773 8192000000 10777354320 11204673536 1871856624 18.599 100 22 43 2 1883454112 6117232 5480256
17:10:56 6731 8192000000 10789832032 11214024704 1875536560 18.629 100 25 51 0 1889448304 6581600 7330144
17:11:09 4578 8192000000 10784972560 11213889536 1877766464 18.647 100 21 42 0 1889922160 6448608 5707088
17:11:21 8861 8192000000 10787423072 11222380544 1882828320 18.688 100 21 41 0 1898066768 9912016 5326432
17:11:38 11030 8192000000 10791375344 11220434944 1885562048 18.710 100 25 50 5 1899737840 6038960 8136832
17:11:55 12520 8192000000 10793413616 11226533888 1887399536 18.725 100 19 38 0 1898532800 6006096 5127168
17:12:14 6443 8192000000 10800337808 11229708288 1890254976 18.748 100 22 44 2 1902542576 6462576 5825024
17:12:27 12066 8192000000 10796780192 11227426816 1894656192 18.783 100 26 52 1 1908125152 6013088 7455872
17:12:45 11647 8192000000 10798203904 11229843456 1892826128 18.769 100 17 34 0 1903182768 5773616 4583024
17:13:03 12002 8192000000 10801224896 11237683200 1899642544 18.823 100 15 30 1 1909619792 6010992 3966256
17:13:22 7564 8192000000 10808869072 11242909696 1901714336 18.840 100 17 34 3 1911795200 5562304 4518560
17:13:41 9204 8192000000 10809318432 11243741184 1901604736 18.839 100 9 18 0 1909791456 5537632 2649088
17:13:57 7058 8192000000 10815053984 11249496064 1905324672 18.869 100 15 30 1 1915847200 6449056 4073472
17:14:11 17222 8192000000 10840229776 11259719680 1910278640 18.909 100 29 60 0 1928102688 10394176 7429872
17:14:34 64357 8192000000 10866380896 11269599232 1914981552 18.947 100 47 94 3 1934495408 5002976 14510880
17:15:45 5900 8192000000 10830133376 11267784704 1916466256 18.959 100 27 54 1 1930913232 6930256 7516720
17:15:58 6923 8192000000 10825890080 11270025216 1918720192 18.977 100 26 52 2 1935970320 10361536 6888592
17:16:14 5150 8192000000 10844118688 11273240576 1926532000 19.039 100 35 70 1 1942609248 6447664 9629584
17:16:26 6460 8192000000 10833013312 11264303104 1918176944 18.972 100 28 56 0 1932527056 5691120 8658992
17:16:40 5878 8192000000 10837543504 11264458752 1899078816 18.819 99 41 82 2 1917635216 7419856 11136544
17:16:55 7655 8192000000 10838056096 11262853120 1900375680 18.829 99 34 66 1 1915837120 4962128 10499312
17:17:09 6571 8192000000 10839235856 11267039232 1914095664 18.940 100 30 60 1 1929666544 5637248 9933632
17:17:22 8531 8192000000 10814802176 11248746496 1876953856 18.641 98 30 60 3 1892176720 6586688 8636176
17:17:40 7308 8192000000 10769376880 11196293120 1833198752 18.285 97 29 58 1 1847672848 6471200 8002896
17:17:53 10510 8192000000 10772561936 11206303744 1823315456 18.205 97 20 40 0 1835709952 6605856 5788640
17:18:10 9580 8192000000 10781201472 11195211776 1839144416 18.334 98 21 42 0 1850231840 5362608 5724816
17:18:27 54975 8192000000 10781928688 11201880064 1807316096 18.074 96 31 62 1 1821459248 5135952 9007200
17:19:30 15541 8192000000 10738031424 11166457856 1726756784 17.409 93 15 30 3 1736277328 4860304 4660240
17:19:52 9558 8192000000 10717082592 11128139776 1771859136 17.782 96 22 44 0 1784414912 6535088 6020688
17:20:08 4685 8192000000 10719444400 11140100096 1791547648 17.945 98 32 64 3 1807700864 7301792 8851424
17:20:19 8268 8192000000 10705450960 11118919680 1744278000 17.554 96 31 62 1 1759470512 6487072 8705440
17:20:35 9751 8192000000 10706720608 11117342720 1695240960 17.145 94 31 58 3 1709004912 5358448 8405504
17:20:51 7349 8192000000 10687205184 11097423872 1727780656 17.417 96 23 46 0 1739002688 4673888 6548144
17:21:10 11080 8192000000 10722140656 11142840320 1805892512 18.062 100 24 48 1 1819191696 5964016 7335168
17:21:29 4054 8192000000 10718245280 11132764160 1803416800 18.042 100 30 60 2 1817495328 5791040 8287488
17:21:39 5734 8192000000 10704853552 11113766912 1725194496 17.395 95 38 75 0 1742152992 6155296 10803200
17:21:52 7451 8192000000 10712968768 11126173696 1792684944 17.954 100 31 62 2 1807780720 6294880 8800896
17:22:06 11385 8192000000 10722334032 11147345920 1815427424 18.140 100 21 42 1 1827207120 5526336 6253360
17:22:25 9076 8192000000 10725274112 11135696896 1791622336 17.945 99 34 66 2 1807621440 5102416 10896688
17:22:42 12531 8192000000 10731296640 11155431424 1805784368 18.061 99 29 58 2 1820368992 5805824 8778800
17:23:05 64822 8192000000 10752200064 11171565568 1818641680 18.167 99 24 49 0 1830512464 5167584 6703200
17:24:20 5127 8192000000 10756602528 11179229184 1841696064 18.355 100 34 68 2 1857296448 5728800 9871584
17:24:34 8932 8192000000 10752248768 11179999232 1841483136 18.353 100 26 52 1 1854779280 5782112 7514032
17:24:52 6444 8192000000 10768182880 11186298880 1841700512 18.355 100 31 62 2 1856575408 5710720 9164176
17:25:04 6897 8192000000 10761214432 11192934400 1852941776 18.446 100 25 49 1 1867406192 7486432 6977984
17:25:18 6203 8192000000 10782743264 11202375680 1855720096 18.469 100 27 54 0 1869997504 6900576 7376832
17:25:32 8444 8192000000 10772672832 11195760640 1856936720 18.478 100 29 57 1 1871152480 6575904 7639856
17:25:46 8067 8192000000 10781811776 11205591040 1862375728 18.523 100 31 62 0 1876851344 6044288 8431328
17:26:04 8618 8192000000 10777997616 11204378624 1860149984 18.504 100 19 38 1 1870723856 4745936 5827936
17:26:21 12774 8192000000 10772247104 11205742592 1863159152 18.529 100 18 36 0 1873762352 5600480 5002720
17:26:40 7639 8192000000 10780108016 11210993664 1873543680 18.613 100 26 51 2 1886592000 5558064 7490256
17:26:58 8817 8192000000 10783921344 11214905344 1873902464 18.616 100 21 42 1 1885237104 5253120 6081520
17:27:14 10787 8192000000 10810351408 11236777984 1887986416 18.730 100 14 28 0 1896528416 4482592 4059408
17:27:38 24935 8192000000 10836011024 11253977088 1904884736 18.866 100 38 73 0 1920890000 5846448 10158816
17:28:10 2312 8192000000 10866964864 11275067392 1921253280 18.997 100 67 131 1 1948701776 9387536 18060960
17:28:21 53194 8192000000 10859028064 11285127168 1926556752 19.039 100 62 124 0 1956598464 12627200 17414512
17:29:25 4464 8192000000 10862059472 11285340160 1930055248 19.067 100 48 95 1 1957322672 13008304 14259120
17:29:37 7610 8192000000 10873426368 11296231424 1936356496 19.118 100 57 111 3 1966539552 14524000 15659056
17:29:55 3735 8192000000 10881484192 11301953536 1939685040 19.144 100 58 114 0 1970737584 14052416 17000128
17:30:06 4480 8192000000 10875822304 11302928384 1943606608 19.176 100 66 133 6 1976746912 14161568 18978736
17:30:17 8068 8192000000 10879947808 11307307008 1945041152 19.187 100 51 102 1 1973558144 14203200 14313792
17:30:33 15295 8192000000 10881739696 11312435200 1946453760 19.198 100 48 96 1 1975179312 14998896 13726656
17:30:56 7734 8192000000 10888944784 11314999296 1954177888 19.260 100 60 119 1 1986219696 15020992 17020816
17:31:15 13175 8192000000 10897590592 11323133952 1952094256 19.243 100 44 88 0 1980359136 15673248 12591632
17:31:35 6879 8192000000 10903714896 11326136320 1959126688 19.299 100 59 118 0 1992351520 16342144 16882688
17:31:50 1780 8192000000 10912187856 11329773568 1964242272 19.340 100 66 128 1 1997653248 15372944 18038032
17:32:00 2530 8192000000 10913050288 11332136960 1964747872 19.344 100 64 128 0 1998177104 15156240 18272992
17:32:10 29592 8192000000 10903991760 11334512640 1967259424 19.364 100 51 102 1 2002179120 20223760 14695936
17:32:46 9520 8192000000 10904018064 11334823936 1962193888 19.323 100 50 99 1 1993292496 16501248 14597360
17:33:08 6631 8192000000 10907103840 11335237632 1970479200 19.389 100 61 120 0 2004833104 15011104 19342800
17:33:36 7815 8192000000 10917726176 11337949184 1957190608 19.284 99 56 112 0 1990632752 17014256 16427888
17:33:53 4026 8192000000 10917677136 11346452480 1976122704 19.434 100 60 120 0 2011964640 17417344 18424592
17:34:08 12018 8192000000 10926010032 11354968064 1980371952 19.468 100 60 113 2 2016002448 18857184 16773312
17:34:27 10409 8192000000 10930030736 11363741696 1984374528 19.499 100 55 110 1 2020203584 19825808 16003248
17:34:45 14358 8192000000 10923501104 11368820736 1990540336 19.548 100 57 113 0 2024064560 16647104 16877120
17:35:07 10115 8192000000 10940040240 11366158336 1994707696 19.581 100 62 123 0 2026689584 14383024 17598864
17:35:24 11556 8192000000 10924973872 11354832896 1982686752 19.486 100 52 101 1 2012584608 14923856 14974000
17:35:50 5297 8192000000 10915145120 11341180928 1961828336 19.321 99 48 96 0 1991605456 15622224 14154896
17:36:03 12384 8192000000 10905961648 11333513216 1954511120 19.262 99 67 132 2 1990404752 15927584 19966048
17:36:26 10776 8192000000 10893807104 11325001728 1952880064 19.249 99 48 95 0 1982131264 15471984 13779216
17:36:46 12892 8192000000 10910877472 11340414976 1954822320 19.265 99 48 96 1 1985006784 15124000 15060464
17:37:07 8037 8192000000 10920454400 11341934592 1955128496 19.267 99 59 117 0 1990589104 16593728 18866880
17:37:22 5310 8192000000 10929523808 11348951040 1975517408 19.429 100 64 128 1 2012046864 17366464 19162992
17:37:41 11551 8192000000 10918346864 11340201984 1963809888 19.336 99 52 104 2 1996148896 16747008 15592000
17:38:00 4097 8192000000 10929577840 11351556096 1976077072 19.434 100 68 136 0 2015707088 19451040 20178976
17:38:13 12839 8192000000 10933157680 11353038848 1976389568 19.436 100 73 141 1 2018664752 21934720 20340464
17:38:32 12202 8192000000 10917261808 11350110208 1960265520 19.308 99 60 120 1 2000728576 22126192 18336864
17:39:02 8667 8192000000 10910565552 11344834560 1959027056 19.298 99 57 115 1 1994158144 17643312 17487776
17:39:20 18370 8192000000 10901354416 11338403840 1939054352 19.139 99 40 80 1 1972820880 21719008 12047520
17:39:51 2318 8192000000 10920037504 11346087936 1958054928 19.291 99 57 113 1 1997636736 21937504 17644304
17:40:09 11825 8192000000 10912410032 11334914048 1938158416 19.132 98 69 137 2 1983958112 25243760 20555936
17:40:29 6205 8192000000 10929582224 11353071616 1968071968 19.370 100 62 121 1 2012899024 26860848 17966208
17:40:41 8840 8192000000 10935896880 11361550336 1956792720 19.281 99 71 142 1 2007039088 28781680 21464688
17:41:01 5718 8192000000 10929007200 11350499328 1948288288 19.213 99 76 150 1 2001822496 29935664 23598544
17:41:15 3720 8192000000 10929563696 11347517440 1949931456 19.226 99 68 134 2 2000237488 29701616 20604416
17:41:29 4239 8192000000 10946095984 11355127808 1965927184 19.353 100 78 155 3 2020503472 30849296 23726992
17:41:41 5315 8192000000 10929819360 11351027712 1949710704 19.224 99 72 142 2 2003037232 31315296 22011232
17:41:54 4489 8192000000 10933406960 11361472512 1966732448 19.360 100 66 130 0 2018438880 32193360 19513072
17:42:09 2545 8192000000 10936350960 11365433344 1970470080 19.389 100 76 149 1 2026888992 33907232 22511680
17:42:19 2668 8192000000 10941831584 11360088064 1959040544 19.298 99 70 140 0 2012866272 32615088 21210640
17:42:30 8614 8192000000 10934076464 11352551424 1949786272 19.225 99 70 139 0 2002285152 31192208 21306672
17:42:46 7197 8192000000 10898086592 11318820864 1909387488 18.902 97 62 123 1 1959649648 31703744 18558416
17:43:00 10300 8192000000 10917315504 11339378688 1946745296 19.201 100 61 122 2 1997863936 32224752 18893888
17:43:20 2148 8192000000 10925639296 11355381760 1966971440 19.361 100 57 114 0 2016707488 32120688 17615360
17:43:30 12824 8192000000 10909033632 11336830976 1892476720 18.766 96 59 117 0 1939966240 29892176 17597344
17:43:52 3746 8192000000 10931385648 11356315648 1961882496 19.321 100 64 127 0 2011567360 30139312 19545552
17:44:03 4123 8192000000 10925156928 11349618688 1962621952 19.327 100 67 131 4 2013043728 29190816 21230960
17:44:19 2398 8192000000 10939660672 11351097344 1965220288 19.348 100 74 147 0 2016492896 28643024 22629584
17:44:29 2793 8192000000 10940900000 11352473600 1951639952 19.240 99 79 158 3 2005506816 29979968 23886896
17:44:38 3152 8192000000 10932525104 11344580608 1953614032 19.255 99 77 154 4 2008661392 30939824 24107536
17:44:50 3251 8192000000 10936175168 11348410368 1960597952 19.311 100 76 151 4 2014870784 31513152 22759680
17:45:01 4564 8192000000 10946525504 11358232576 1965152432 19.347 100 78 156 3 2022175520 32718928 24304160
17:45:12 6132 8192000000 10926313440 11352424448 1951223168 19.236 99 69 138 1 2005450928 33367488 20860272
17:45:26 2736 8192000000 10931106864 11343511552 1948428416 19.214 99 74 146 2 2004647840 33546928 22672496
17:45:37 5303 8192000000 10940882304 11361026048 1967682416 19.367 100 73 146 0 2025224992 34678736 22863840
17:45:50 3209 8192000000 10929567216 11344994304 1949396688 19.222 99 76 153 1 2007800144 35108608 23294848
17:46:00 3862 8192000000 10935446736 11346116608 1954766448 19.264 99 78 156 0 2015228112 34942416 25519248
17:46:11 6881 8192000000 10946088848 11353911296 1945651152 19.192 99 80 160 2 2003663232 33266928 24745152
17:46:25 2399 8192000000 10932738400 11341377536 1948939312 19.218 100 81 162 1 2008528288 35098832 24490144
17:46:38 2510 8192000000 10941273680 11345764352 1955419424 19.270 100 88 175 2 2019622528 37695584 26507520
17:46:47 1384 8192000000 10938702912 11345305600 1942120592 19.164 99 88 175 2 2005472032 37389280 25962160
17:46:56 4702 8192000000 10950123872 11360399360 1963735680 19.336 100 84 166 2 2027403856 38609808 25058368
17:47:08 4459 8192000000 10936762896 11351924736 1945579680 19.191 99 78 156 0 2008651856 38632928 24439248
17:47:19 4093 8192000000 10944770224 11350843392 1951692592 19.240 100 82 162 0 2015623600 39216336 24714672
17:47:31 4390 8192000000 10934852464 11339141120 1951844544 19.241 100 87 175 2 2018720144 40706208 26169392
17:47:42 2073 8192000000 10939711456 11345539072 1957916464 19.289 100 87 174 1 2025856016 42005104 25934448
17:47:51 2911 8192000000 10938280864 11351871488 1951843344 19.241 100 74 149 0 2016455568 41473776 23138448
17:48:02 3423 8192000000 10912868816 11324096512 1931000176 19.075 99 73 146 0 1994021984 40146512 22875296
17:48:14 2665 8192000000 10925121168 11342020608 1943563584 19.175 100 77 152 1 2005809344 40255824 21989936
17:48:27 2349 8192000000 10940257952 11348365312 1956287232 19.277 100 84 166 2 2022200944 39834144 26079568
17:48:39 3624 8192000000 10932999456 11351941120 1953869328 19.257 100 72 144 0 2019168032 42605616 22693088
17:48:52 9035 8192000000 10916539120 11351842816 1951390768 19.238 100 40 79 0 2005123408 40982800 12749840
17:49:09 9868 8192000000 10899672336 11335229440 1931822336 19.081 99 37 74 2 1982751456 39087536 11841584
17:49:30 4609 8192000000 10928915344 11343392768 1943156224 19.172 100 56 110 0 2001432352 40682672 17593456
17:49:42 3535 8192000000 10953330720 11364974592 1960958688 19.314 100 83 165 1 2030742000 43925248 25858064
17:49:52 11277 8192000000 10940364352 11373232128 1961637984 19.319 100 48 96 0 2024975952 47861984 15475984
17:50:10 18461 8192000000 10939090720 11381882880 1967933760 19.369 100 38 74 0 2025658544 45532144 12192640
17:50:35 5149 8192000000 10936987328 11383357440 1966263744 19.356 100 31 62 0 2022277664 46059472 9954448
17:50:58 5298 8192000000 10962842912 11382984704 1971083248 19.394 100 71 144 2 2043224528 49384080 22757200
17:51:11 11234 8192000000 10941280208 11380408320 1965693376 19.351 100 37 73 2 2025556624 47483248 12380000
17:51:41 14636 8192000000 10962234096 11397861376 1974983072 19.425 100 42 85 1 2041905664 52902272 14020320
17:52:25 7063 8192000000 10963929376 11394797568 1981051616 19.473 100 61 123 1 2051927504 50766800 20109088
17:52:41 10984 8192000000 10952414000 11396517888 1974009456 19.417 100 38 75 0 2040409712 52235648 14164608
17:53:05 9067 8192000000 10958001728 11395358720 1977280976 19.443 100 38 76 0 2040844864 50457680 13106208
17:53:21 8026 8192000000 10970452352 11407015936 1983636448 19.493 100 58 116 0 2057498928 54128624 19733856
17:53:43 10020 8192000000 10956710880 11399798784 1955281472 19.269 99 44 88 0 2024733088 54058384 15393232
17:54:04 8374 8192000000 10941931520 11381665792 1950825984 19.233 99 33 67 0 2012645440 50264640 11554816
17:54:22 26612 8192000000 10944673440 11393835008 1963122816 19.331 100 33 65 2 2026809248 51852688 11833744
17:54:59 28891 8192000000 10939475936 11404062720 1954398336 19.261 100 23 46 0 2025574368 62642400 8533632
17:55:34 22121 8192000000 10910299616 11370840064 1937785744 19.129 99 27 55 0 1999479840 51206512 10487584
17:57:11 30768 8192000000 10939350224 11378081792 1958154400 19.291 100 50 99 3 2015888928 41874048 15860480
17:57:48 12802 8192000000 10930013776 11371945984 1959371152 19.301 100 52 102 2 2006191776 31525200 15295424
17:58:10 14068 8192000000 10884368368 11358593024 1952454640 19.246 100 17 34 2 1981903024 24019888 5428496
17:58:56 22666 8192000000 10901989344 11355750400 1971076080 19.394 100 22 43 3 1994259056 16660320 6522656
17:59:29 83873 8192000000 10892492224 11361533952 1965325232 19.348 100 10 20 0 1982055008 14191984 2537792
18:02:20 5416 8192000000 10915389168 11361271808 1974554560 19.422 100 48 96 1 2000661152 12188624 13917968
18:02:44 24842 8192000000 10899538672 11368558592 1976568480 19.438 100 15 30 0 1994442480 13482352 4391648
18:03:23 81103 8192000000 10902492496 11367378944 1955426048 19.270 99 19 38 1 1971103072 10488384 5188640
18:04:57 105459 8192000000 10899949648 11368214528 1948697056 19.216 98 35 70 0 1973787616 14760176 10330384
18:06:55 80952 8192000000 10899583312 11376898048 1978897008 19.456 100 16 31 1 1994436144 10851536 4687600
18:08:27 27919 8192000000 10902230688 11371245568 1980938704 19.472 100 11 22 1 1994007968 9584768 3484496
18:09:06 45894 8192000000 10917364800 11379130368 1990695056 19.549 100 39 78 1 2011738816 8800752 12243008
18:11:09 99957 8192000000 10894069856 11360260096 1932290848 19.085 97 14 28 0 1945093072 8320944 4481280
18:13:53 86396 8192000000 10907206464 11365507072 1917301040 18.965 97 24 48 0 1931914688 8072560 6541088
18:15:28 73660 8192000000 10887532608 11370496000 1960792096 19.312 99 16 32 0 1975652048 9875232 4984720
18:17:47 25800 8192000000 10899531040 11374153728 1983054832 19.489 100 41 81 0 2003862656 9159632 11648192
18:18:48 55805 8192000000 10882392208 11369369600 1974986816 19.425 100 26 52 0 1991248224 8155184 8106224
18:20:00 75426 8192000000 10894971488 11375775744 1939380128 19.142 98 12 24 0 1955916144 13098656 3437360
18:21:22 35147 8192000000 10887734464 11368284160 1955957584 19.274 99 12 24 0 1971900800 12506576 3436640
18:22:10 110769 8192000000 10906355792 11386081280 1975227488 19.427 100 12 25 1 1990103728 11617808 3258432
18:24:19 69326 8192000000 10889733184 11388416000 1947671344 19.208 98 9 18 0 1966556960 16224864 2660752
18:25:34 57842 8192000000 10869192608 11343151104 1897932592 18.810 96 21 42 0 1914979088 11140992 5905504
18:26:40 48682 8192000000 10892073344 11366248448 1934463376 19.103 98 20 40 1 1947067936 7281376 5323184
18:27:34 53781 8192000000 10907883664 11372847104 1959673376 19.303 99 30 60 2 1976279824 8424320 8182128
18:28:34 35901 8192000000 10867717360 11338403840 1892942480 18.769 96 25 50 0 1908246640 8780192 6523968
18:29:23 59285 8192000000 10871113264 11344506880 1861981824 18.519 95 12 24 0 1872999696 7962768 3055104
18:30:30 57425 8192000000 10847972416 11321503744 1848456176 18.410 95 12 24 1 1865938880 13504384 3978320
18:31:43 50986 8192000000 10871754352 11314302976 1834217824 18.294 95 19 38 1 1853298656 13465632 5615200
18:32:44 85233 8192000000 10879791584 11353051136 1898403568 18.813 98 19 38 0 1913692976 10455744 4833664
18:34:20 53280 8192000000 10893232048 11367215104 1952161792 19.244 100 12 24 2 1968927856 13398944 3367120
18:35:27 57903 8192000000 10870843424 11327184896 1855099552 18.464 95 25 51 1 1873277072 11197808 6979712
18:36:32 43307 8192000000 10877512336 11342934016 1926688048 19.040 99 42 84 1 1949303952 11440480 11175424
18:37:23 128713 8192000000 10860999392 11325886464 1841299264 18.351 95 11 22 1 1858725600 14394976 3031360
18:39:37 33111 8192000000 10883797024 11345461248 1920045568 18.987 99 21 42 1 1934633728 8816192 5771968
18:40:17 104735 8192000000 10847571392 11328016384 1862758928 18.526 96 7 14 0 1878706352 14009264 1938160
18:42:45 85081 8192000000 10840961616 11312357376 1903960256 18.858 98 17 34 0 1915471376 6809328 4701792
18:44:33 20865 8192000000 10855703072 11317055488 1911480480 18.919 99 23 46 1 1926677184 8584080 6612624
18:45:34 55285 8192000000 10850369872 11327541248 1900403968 18.830 98 14 28 0 1912755296 8431472 3919856
18:46:35 45713 8192000000 10856648672 11330568192 1934615360 19.104 100 6 12 0 1945968480 8893824 2459296
18:47:29 43517 8192000000 10847983568 11313246208 1915409568 18.950 99 10 20 1 1930923456 12453504 3060384
18:48:28 79812 8192000000 10855308704 11328110592 1893295712 18.772 97 22 44 0 1911950416 12321472 6333232
18:49:59 94252 8192000000 10859766592 11346972672 1943882032 19.178 100 15 31 0 1962910480 14674256 4354192
18:51:46 39009 8192000000 10878741952 11353600000 1954232736 19.260 100 19 36 0 1966450720 6813584 5404400
18:52:36 62313 8192000000 10894747328 11364548608 1949423936 19.222 99 11 22 1 1966214496 13727232 3063328
18:53:44 31687 8192000000 10896313056 11358035968 1930295728 19.069 98 20 40 0 1950933568 14847504 5790336
18:54:24 59675 8192000000 10885506704 11359027200 1927337264 19.046 98 16 32 0 1949083600 17280752 4465584
18:55:42 61136 8192000000 10891811936 11376570368 1958309408 19.293 100 15 30 0 1979869152 17407312 4152432
18:56:58 117993 8192000000 10895942928 11360374784 1894582624 18.783 96 14 28 1 1908496720 10840784 3073312
18:59:07 45910 8192000000 10903818976 11371106304 1951071360 19.235 99 17 34 1 1973590928 17227600 5291968
19:00:05 124285 8192000000 10892731312 11359383552 1849225136 18.416 94 8 16 0 1869632144 18372768 2034240
19:02:15 123798 8192000000 10871403440 11327692800 1850589008 18.427 95 13 27 1 1871713648 17622752 3501888
19:04:26 25684 8192000000 10895314560 11343044608 1947467248 19.206 100 45 90 1 1968677008 8708336 12501424
19:05:08 21301 8192000000 10919315472 11357417472 1962156016 19.323 100 50 96 0 1986366688 10361536 13849136
19:05:38 33251 8192000000 10917575456 11375366144 1972985040 19.409 100 42 84 0 1995798304 11282416 11530848
19:06:18 96220 8192000000 10881703968 11353636864 1932738752 19.089 98 34 68 0 1958717440 16421088 9557600
19:10:04 74317 8192000000 10875326608 11364732928 1933273568 19.093 99 4 8 0 1947501456 13191104 1036784
19:11:39 55534 8192000000 10883025296 11357954048 1957315936 19.285 100 15 30 2 1974320128 12571088 4433104
19:12:44 49679 8192000000 10898925872 11363426304 1970162560 19.387 100 18 36 0 1983785312 8556176 5066576
19:13:40 56578 8192000000 10886824064 11375759360 1972601904 19.406 100 11 22 1 1986401776 10355440 3444432
19:14:49 51678 8192000000 10869669392 11353059328 1928031728 19.051 98 14 28 1 1942123328 10227984 3863616
19:15:47 48448 8192000000 10876997728 11359887360 1950085168 19.227 100 8 16 0 1964039360 11354000 2600192
19:16:49 74586 8192000000 10861555440 11335397376 1844034784 18.374 94 17 33 1 1858321968 8871216 5415968
19:18:10 61602 8192000000 10873752352 11354800128 1916852592 18.962 98 22 44 0 1932352384 9140224 6359568
19:19:18 38531 8192000000 10893629888 11360718848 1939282672 19.141 99 13 26 0 1951854688 8731744 3840272
19:20:06 77666 8192000000 10880442896 11381727232 1945468416 19.190 99 24 48 0 1967557008 14931600 7156992
19:21:30 69389 8192000000 10886628000 11349995520 1863700688 18.533 95 17 34 2 1882354576 13890208 4763680
19:22:54 106907 8192000000 10899725488 11388801024 1923919552 19.018 98 20 40 0 1952873200 22893456 6060192
19:24:47 81080 8192000000 10865879552 11347566592 1824940896 18.218 93 9 16 0 1838499664 11472384 2086384
19:26:21 48647 8192000000 10900835008 11355889664 1910392416 18.910 98 31 61 2 1936161488 16727984 9041088
19:27:16 24712 8192000000 9208161184 9463816192 359526224 4.204 19 3 6 0 365903392 5976960 400208

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 09-03-2021 19:28:33 to 09-03-2021 19:29:05.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 96 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 09-03-2021 19:29:06 to 09-03-2021 19:29:08.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          240145
MON$OLDEST_ACTIVE               240828
MON$OLDEST_SNAPSHOT             240828
MON$NEXT_TRANSACTION            240828
MON$PAGE_BUFFERS                1000000
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               2020-04-03 16:41:55.3470
MON$PAGES                       2044832
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33423 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33423 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33423 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33423 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:222: 
:223: mscs-test-161.budzdorov.ru    Tue Mar  9 19:27:51 2021
:224:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:225: 
:226: 
:227: mscs-test-161.budzdorov.ru    Tue Mar  9 19:27:51 2021
:228:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:229: 
:230: 
:231: mscs-test-161.budzdorov.ru    Tue Mar  9 19:27:51 2021
:232:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:233: 
:234: 
:235: mscs-test-161.budzdorov.ru    Tue Mar  9 19:27:51 2021
:236:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:237: 
--- end of diff output ---

Final processing ISQL logs in /var/tmp/logs-oltp30 according to config parameter 'remove_isql_logs'

09.03.21 19:29:09. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2021-03-09 19:29:12 No severe PSQL-related problems occured
09.03.21 19:29:13. End of report.