Note
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 execute the
SHOW PARAMETERSstatement or query 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 the client. If the client unexpectedly exits, the system can release the resources on the server. In addition, some network devices, such as load balancers or gateways, maintain and check the status of the connections. If a connection is idle for a long time, the device may close or release the connection. This will cause an unexpected disconnection between the client and the server. The keepalive mechanism for client connections can avoid unexpected disconnections caused by such network devices.
Examples
Enable the keepalive mechanism for client connections.
obclient> ALTER SYSTEM SET enable_tcp_keepalive = True;