Note
For V2.2.50, this parameter is available starting with V2.2.50.
Description
dead_socket_detection_timeout specifies the detection interval for failed sockets.
Privilege requirements
Query the parameter
The
systenant and all user tenants can execute theSHOW PARAMETERSstatement or query theGV$OB_PARAMETERSview to query this parameter.Modify the parameter
Only the
systenant can modify this parameter. User tenants cannot modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Time |
| Default value | 3s
NoteStarting from V4.0.0, the default value of this parameter is adjusted from 10s to 3s. |
| Value range | [0s, 2h] |
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No. The setting takes effect immediately. |
Considerations
When the value of
dead_socket_detection_timeoutis 0, Socket-level failure detection is disabled.When the value of
dead_socket_detection_timeoutis greater than 0, Socket-level failure detection is enabled. If the sender has not received a response from the other party after the set time has passed, it is considered that the current Socket is unavailable.
Examples
Set the detection interval for failed sockets to 3s.
obclient> ALTER SYSTEM SET dead_socket_detection_timeout= 3s;