PARAMETER
Description
-
The
ALTER SYSTEM [SET] parameter_name = expressionstatement is used to modify the value of a parameter. -
The
ALTER SYSTEM [RESET] parameter_name = expressionstatement is used to reset the value of a parameter.
Limitations and Considerations
The effectiveness of parameters is generally divided into two types: dynamic effectiveness and restart effectiveness. Most parameters are effective dynamically, meaning they take effect without the need to restart seekdb. Before modifying a parameter, you can use the SHOW PARAMETERS LIKE statement to confirm the effectiveness of the parameter. For more information about how to view the effectiveness of a parameter, see Parameters.
Permissions
To execute the ALTER SYSTEM [SET | RESET] parameter_name = expression statement, the current user must have the ALTER SYSTEM permission. For more information about seekdb permissions, see seekdb Permission Classification.
Syntax
Modify the value of a parameter
ALTER SYSTEM [SET] alter_system_set_parameter_action [, alter_system_set_parameter_action...]
alter_system_set_parameter_action:
parameter_name = expression [COMMENT [=] 'text']
Parameter Description
| Parameter | Description |
|---|---|
| parameter_name | Specifies the name of the parameter to be modified. |
| expression | Specifies the new value of the parameter. |
| COMMENT | Adds a comment about the modification. This parameter is optional, and it is recommended not to omit it. |
Reset the value of a parameter
ALTER SYSTEM [RESET] alter_system_set_parameter_action [, alter_system_set_parameter_action...]
alter_system_set_parameter_action:
parameter_name = expression
Parameter Description
| Parameter | Description |
|---|---|
| parameter_name | Specifies the name of the parameter to be reset. |
| expression | Specifies the parameter to be reset. |
Examples
Modify the value of a parameter
Modify the value of the connection_control_max_connection_delay parameter.
ALTER SYSTEM SET connection_control_max_connection_delay = 2147483646;
Reset the value of a parameter
The following example shows how to reset the log_disk_utilization_threshold parameter:
ALTER SYSTEM RESET log_disk_utilization_threshold;