RESET_PARAM_DEFAULTS

2026-02-02 07:28:28  Updated

The RESET_PARAM_DEFAULTS procedure resets the default values of all parameters to the recommended values.

Applicability

This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.

Syntax

DBMS_STATS.RESET_PARAM_DEFAULTS;

Examples

obclient> CALL DBMS_STATS.RESET_PARAM_DEFAULTS;
Query OK, 0 rows affected

Contact Us