DELETE_CATALOG_GLOBAL_PREFS is used to delete global preferences from the catalog.
Note
This subprogram is available starting with V5.0.1.
Syntax
DBMS_STATS.DELETE_CATALOG_GLOBAL_PREFS (
pname VARCHAR(65535)
);
Parameters
Parameter |
Explanation |
|---|---|
| pname | Specifies the name of the preference to delete. Valid values:
|
Examples
Delete the global parameter CATALOG_STATS_BATCH_SIZE.
obclient> CALL DBMS_STATS.DELETE_CATALOG_GLOBAL_PREFS('CATALOG_STATS_BATCH_SIZE');