This option configures the evaluation period used to determine when an automated merge of the row-level versioned (RLV) and IQ main stores should occur.
1 – MAX_UINT (minutes)
15 (minutes)
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.
This option is be used to configure the period of wait time, in minutes, between activations of the merge evaluator. The merge evaluator examines the merge parameters of each row-level versioning (RLV) enabled table against configured threshold values to determine whether a non-blocking (background) merge of the RLV table to IQ main stores should occur.
If the interval ends while the evaluator is active, or when a merge is already in progress, the interval re-sets.
Any new value for the interval is used when the merge evaluator is next activated.