SET_GLOBAL_PREFS

The SET_GLOBAL_PREFS procedure is used to set global statistics Prefs.

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 the Prefs.

Exceptions

Error Code	Description
HY000	Insufficient privileges. Invalid value or illegal input value.

Usage

• Both parameters of this procedure are of the VARCHAR2 type. You must enclose their values in double quotation marks.

Examples

Set the global default value of APPROXIMATE_NDV to FALSE.

CALL DBMS_STATS.SET_GLOBAL_PREFS ('APPROXIMATE_NDV', 'FALSE');
Query OK, 0 rows affected