The SET_SCHEMA_PREFS procedure is used to set the statistics preferences for a specified schema.
Syntax
DBMS_STATS.SET_SCHEMA_PREFS (
ownname IN VARCHAR2,
pname IN VARCHAR2,
pvalue IN VARCHAR2);
Parameters
Parameter |
Description |
|---|---|
| ownname | The name of the schema. |
| pname | Prefs name. |
| pvalue | Prefs value. |
Exceptions
Error Code |
Description |
|---|---|
| HY000 |
|
Usage instructions
To perform this procedure, you must be connected as the specified user or have the
SYSDBAprivilege.All parameters in this process are of the
VARCHAR2type, and their values must be enclosed in quotes.
Examples
obclient> CALL DBMS_STATS.SET_SCHEMA_PREFS('hr', 'DEGREE','10');
Query OK, 0 rows affected