Overview
trx_2pc_retry_interval specifies the time interval for automatic retries when a two-phase commit fails.
Privilege requirements
Query parameters
Both the
systenant and all user tenants can query this parameter using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify parameters
Only the
systenant can modify this parameter. User tenants cannot modify it.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | Time |
| Default Value | 100ms |
| Value range | [1ms, 5000ms] |
| Modifiable | Yes, you can use the following methods:ALTER SYSTEM SETStatement modification. |
| Whether to Restart the OBServer Node for the Change to Take Effect | No, the setting takes effect immediately. |
Configuration example
Set the automatic retry interval to 100 ms in case of a two-phase commit failure.
obclient> ALTER SYSTEM SET trx_2pc_retry_interval = '100ms';