The SET_PARAM procedure allows you to set default values for parameters in procedures of the DBMS_STATS system package. You can use the GET_PARAM function to retrieve the default value of a parameter.
Syntax
DBMS_STATS.SET_PARAM (
pname IN VARCHAR2,
pval IN VARCHAR2);
Parameters
Parameter |
Description |
|---|---|
| pname | The name of the parameter. |
| pvalue | Parameter value. |
Exceptions
Error Code |
Description |
|---|---|
| HY000 |
|
Usage instructions
To perform this procedure, you must have the
SYSDBArole.Both parameters in this procedure are of the
VARCHAR2type, and their values must be enclosed in quotation marks.NULLand'NULL'are different. WhenNULLis used without quotes, it means the parameter will be set to its recommended value; whereas'NULL'means the parameter's value will be set toNULL.
Examples
Sets the default value of the DEGREE parameter.
obclient> CALL DBMS_STATS.SET_PARAM('DEGREE','20');
Query OK, 0 rows affected