The SET_PARAM procedure sets the default value for a parameter of procedures in the DBMS_STATS package. You can call the GET_PARAM function to obtain the current default value of a parameter.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_STATS.SET_PARAM (
pname IN VARCHAR2,
pval IN VARCHAR2);
Parameters
| Parameter | Description |
|---|---|
| pname | The name of the parameter. |
| pvalue | The value of the parameter. |
Exceptions
| Error code | Description |
|---|---|
| ORA-20000 | The object does not exist, or you do not have the required privileges. |
| ORA-20001 | Input values are invalid. |
Considerations
The two parameters of this procedure are of the
VARCHAR2type and their values must be enclosed with parentheses.NULLand'NULL'are different.NULLspecifies to set the parameter to the recommended value and'NULL'specifies to set the parameter toNULL.
Examples
Set the default value of the DEGREE parameter.
obclient> CALL DBMS_STATS.SET_PARAM('DEGREE','20');
Query OK, 0 rows affected