ALTER SYSTEM PARAMETER

ALTER SYSTEM SET parameter_name = expression;

obclient> SHOW PARAMETERS LIKE 'clog_max_unconfirmed_log_count';
+-------+----------+----------------+----------+--------------------------------+-----------+-------+-----------------------------------------------------------------+---------+--------+---------+-------------------+
 ZONE   SVR_TYPE  SVR_IP          SVR_PORT  NAME                            DATA_TYPE  VALUE  INFO                                                             SECTION  SCOPE   SOURCE   EDIT_LEVEL        
+-------+----------+----------------+----------+--------------------------------+-----------+-------+-----------------------------------------------------------------+---------+--------+---------+-------------------+
 zone1  observer  172.30.135.217      2882  clog_max_unconfirmed_log_count  NULL       1500   maximum of unconfirmed logs in clog module. Range: [100, 50000]  TRANS    TENANT  DEFAULT  DYNAMIC_EFFECTIVE 
+-------+----------+----------------+----------+--------------------------------+-----------+-------+-----------------------------------------------------------------+---------+--------+---------+-------------------+
1 row in set

obclient> ALTER SYSTEM SET clog_max_unconfirmed_log_count = 2000;
Query OK, 0 rows affected

obclient> SHOW PARAMETERS LIKE 'clog_max_unconfirmed_log_count';
+-------+----------+----------------+----------+--------------------------------+-----------+-------+-----------------------------------------------------------------+---------+--------+---------+-------------------+
 ZONE   SVR_TYPE  SVR_IP          SVR_PORT  NAME                            DATA_TYPE  VALUE  INFO                                                             SECTION  SCOPE   SOURCE   EDIT_LEVEL        
+-------+----------+----------------+----------+--------------------------------+-----------+-------+-----------------------------------------------------------------+---------+--------+---------+-------------------+
 zone1  observer  172.30.135.217      2882  clog_max_unconfirmed_log_count  NULL       2000   maximum of unconfirmed logs in clog module. Range: [100, 50000]  TRANS    TENANT  DEFAULT  DYNAMIC_EFFECTIVE 
+-------+----------+----------------+----------+--------------------------------+-----------+-------+-----------------------------------------------------------------+---------+--------+---------+-------------------+
1 row in set