BOOTSTRAP

    1. alter_system_bootstrap_stmt:
    2.     ALTER SYSTEM BOOTSTRAP region_zone_server_list;
    4. region_zone_server_list:
    5.     region_zone_server [, region_zone_server ...]
    7. region_zone_server:
    8.     [region] zone server
    10. region:
    11.     REGION [=] region_name
    13. zone:
    14.     ZONE [=] zone_name
    16. server:
    17.     SERVER [=] ip_port
    19. ip_port:
    20.     'STR_VALUE:INT_VALUE'

    JOB

    1. alter_system_job_stmt:
    2.     ALTER SYSTEM RUN JOB job_name
    3.     {zone | server};

    MERGE

    1. alter_system_merge_stmt:
    2.     ALTER SYSTEM merge_action;
    4. merge_action:
    5.       MAJOR FREEZE
    6.       [IGNORE ip_port_list]
    7.     | MINOR FREEZE
    8.       [tenant_list | replica] [server_list] [zone]
    9.     | START MERGE
    10.       zone
    11.     | {SUSPEND | RESUME} MERGE
    12.       [zone]
    13.     | CLEAN MERGE ERROR
    15. tenant_list:
    16.     TENANT [=] (tenant_name_list)
    18. tenant_name_list:
    19.     tenant_name [, tenant_name ...]
    21. replica:
    22.     PARTITION_ID [=] 'partition_idx%partition_count@table_id'
    24. server_list:
    25.     SERVER [=] ip_port_list

    PARAMETER

    1. alter_system_parameter_stmt:
    2.     ALTER SYSTEM [SET]
    3.     parameter_name = expression [SCOPE = {MEMORY | SPFILE | BOTH}] [comment];

    REFRESH

    1. alter_system_refresh_stmt:
    2.     ALTER SYSTEM refresh_action;
    4. refresh_action:
    5.       REFRESH SCHEMA
    6.       [zone | server]
    7.     | REFRESH TIME_ZONE_INFO
    8.     | FLUSH cache_type CACHE
    9.       [tenant_list] [GLOBAL]
    10.     | FLUSH KVCACHE
    11.       [tenant] [CACHE [=] cache_name]
    13. cache_type:
    14.       ALL
    15.     | LOCATION
    16.     | CLOG
    17.     | ILOG
    18.     | COLUMN_STAT
    19.     | BLOCK_INDEX
    20.     | BLOCK
    21.     | ROW
    22.     | BLOOM_FILTER
    23.     | SCHEMA
    24.     | PLAN
    26. tenant:
    27.     TENANT [=] tenant_name
    29. cache_name:

    RELOAD

    1. alter_system_reload_stmt:
    2.     ALTER SYSTEM RELOAD {SERVER | ZONE | UNIT};

    REPLICA

    1. alter_system_replica_stmt:
    2.     ALTER SYSTEM replica_action;
    4. replica_action:
    5.       SWITCH REPLICA
    6.       {LEADER | FOLLOWER}
    7.       {replica server | server [tenant_name] | zone [tenant_name]}
    8.     | DROP REPLICA
    9.       replica server [create_timestamp] [zone] [FORCE]
    10.     | {MOVE | COPY} REPLICA
    11.       replica source destination
    12.     | REPORT REPLICA
    13.       {zone | server}
    14.     | RECYCLE REPLICA
    15.       {zone | server}
    16.     | {ALTER | CHANGE | MODIFY} REPLICA  
    17.       replica server [set] REPLICA_TYPE = replica_type
    19. source:
    20.     SOURCE [=] 'ip:port'
    22. destination:
    23.     DESTINATION [=] 'ip:port'
    25. partition_idx | partition_count | table_id | task_id:
    26.     INT_VALUE
    28. create_timestamp:
    29.     CREATE_TIMESTAMP [=] INT_VALUE
    31. tenant_name_list:
    32.     tenant_name [, tenant_name ...]
    34. replica_type:
    35.       {FULL | F}
    36.     | {READONLY | R}
    37.     | {LOGONLY | L}

    ROOTSERVICE

    1. alter_system_rootservice_stmt:
    2.     ALTER SYSTEM SWITCH ROOTSERVICE {LEADER | FOLLOWER} {zone | server};

    ROOTTABLE

    1. alter_system_roottable_stmt:
    2.     ALTER SYSTEM CLEAR ROOTTABLE [tenant];

    SESSION

    1. alter_system_session_stmt:
    2.     ALTER SYSTEM KILL [GLOBAL|LOCAL] [CONNECTION] session_id;
    4. session_id:
    5.     INT_VALUE

    SERVER

    1. alter_system_server_stmt:
    2.     ALTER SYSTEM server_action SERVER ip_port_list [zone];
    4. server_action:
    5.       ADD
    6.     | DELETE
    7.     | CANCEL DELETE
    8.     | START
    9.     | STOP
    10.     | FORCE STOP
    12. ip_port_list:
    13.     ip_port [, ip_port ...]

    THROTTLE

    1. alter_system_throttle_stmt:
    2.     ALTER SYSTEM throttle_action;
    4. throttle_action:
    5.       ENABLE SQL
    6.     | DISABLE SQL THROTTLE [priority_option] [using_metric_option_list]
    8. priority_option:
    9.     FOR PRIORITY <= INT_VALUE
    11. using_metric_option_list:
    12.     USING metric_option_list
    14. metric_option_list:
    15.     metric_option [metric_option ...]
    17. metric_option:
    18.       RT = {INT_VALUE | DECIMAL_VALUE}
    19.     | CPU = {INT_VALUE | DECIMAL_VALUE}
    20.     | IO = INT_VALUE
    21.     | NETWORK = {INT_VALUE | DECIMAL_VALUE}
    22.     | LOGICAL_READS = {INT_VALUE | DECIMAL_VALUE}

    UNIT

    1. alter_system_unit_stmt:
    2.     ALTER SYSTEM MIGRATE
    3.     UNIT [=] unit_id DESTINATION [=] ip_port
    5. unit_id:
    6.     INT_VALUE

    UPGRADE

    1. alter_system_upgrade_stmt:
    2.     ALTER SYSTEM upgrade_action;
    4. upgrade_action:
    5.       {BEGIN | END} UPGRADE
    6.     | UPGRADE VIRTUAL SCHEMA

    ZONE

    1. alter_system_zone_stmt:
    2.       ADD ZONE zone_name
    3.       [zone_option_list]
    4.     | {ALTER | CHANGE | MODIFY} ZONE zone_name
    5.       [SET] zone_option_list
    6.     | {DELETE | START | STOP | FORCE STOP} ZONE zone_name
    8. zone_option_list:
    9.     zone_option [, zone_option ...]
    11. zone_option:
    12.       region
    13.     | idc
    14.     | ZONE_TYPE {READONLY | READWRITE}
    16. idc:
    17.     STR_VALUE