Note
For V2.2.77, this parameter is available starting with V2.2.77.
Description
enable_tcp_keepalive specifies whether to enable the keepalive mechanism for client connections.
Privilege requirements
Query the parameter
You can use the
SHOW PARAMETERSstatement or theGV$OB_PARAMETERSview to query this parameter in thesystenant and all user tenants.Modify the parameter
Only the
systenant can modify this parameter. User tenants cannot modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Bool |
| Default value | True |
| Value range |
|
| 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
The keepalive mechanism for client connections can be used to check the status of a client. After a client unexpectedly exits, the system can release the resources on the server side. In addition, some network devices, such as load balancers or gateways, maintain connections and check their status. If a connection remains idle for a long time, the device may disconnect or release the connection. This will cause unexpected disconnections between the client and the server. The keepalive mechanism for client connections can avoid such unexpected disconnections caused by network devices.
Examples
Enable the keepalive mechanism for client connections.
obclient> ALTER SYSTEM SET enable_tcp_keepalive = True;