The SET_GLOBAL_PREFS procedure is used to set global statistics preferences.
Syntax
DBMS_STATS.SET_GLOBAL_PREFS (
pname IN VARCHAR2,
pvalue IN VARCHAR2);
Parameters
Parameter |
Description |
|---|---|
| pname | The name of the Prefs. |
| pvalue | The value of Prefs. |
Exceptions
Error Code |
Description |
|---|---|
| HY000 |
|
Usage instructions
To call this procedure, you must have the
SYSDBAprivilege.Both parameters in this procedure are of the
VARCHAR2type, and their values must be enclosed in quotation marks.
Examples
The global default value of APPROXIMATE_NDV is set to FALSE.
obclient> CALL DBMS_STATS.SET_GLOBAL_PREFS ('APPROXIMATE_NDV', 'FALSE');
Query OK, 0 rows affected