SET_CATALOG_GLOBAL_PREFS is used to set global preference values in the catalog.
Note
This subprogram is available starting with V5.0.1.
Syntax
DBMS_STATS.SET_CATALOG_GLOBAL_PREFS (
pname VARCHAR(65535),
pvalue VARCHAR(65535)
);
Parameters
Parameter |
Explanation |
|---|---|
| pname | Specifies the name of the preference to be set. Valid values:
|
| pvalue | Specifies the value of the preference. |
Examples
Set the global-level CATALOG_STATS_BATCH_SIZE value in the catalog to 100.
obclient> CALL DBMS_STATS.SET_CATALOG_GLOBAL_PREFS ('CATALOG_STATS_BATCH_SIZE', 100);