RV_MERGE_NODE_MEMSIZE Option
Sets the percentage of total RLV memory size as a merge threshold for the node.
0 - 100 (percent)
75 (percent)
Option can be set at the database (PUBLIC) level only.
Requires the SET ANY SYSTEM OPTION system privilege to set this option. Takes effect immediately.
If the total RLV memory size surpasses the threshold, the merge condition evaluator determines which table(s) to merge. If multiple tables must be merged to satisfy the node threshold, parallel merges are triggered for each table to be merged.
An automated merge of the row-level versioned (RLV) store and IQ main stores occurs based on the merge thresholds, including RV_MERGE_NODE_MEMSIZE. When this node threshold is exceeded, a merge will be triggered.