The GET_CATALOG_GLOBAL_PREFS statement is used to retrieve the value of global preferences from the catalog.
Note
This subprogram is available starting with V5.0.1.
Syntax
DBMS_STATS.GET_CATALOG_GLOBAL_PREFS (
pname VARCHAR(65535)
) RETURN VARCHAR(65535);
Parameters
Parameter |
Explanation |
|---|---|
| pname | Specifies the name of the preference to retrieve. Valid values:
|
Examples
Gets the global preference value from the catalog.
obclient> SELECT DBMS_STATS.GET_CATALOG_GLOBAL_PREFS('CATALOG_STATS_BATCH_SIZE');
The return result is as follows:
+-----------------------------------------------------------------+
| DBMS_STATS.GET_CATALOG_GLOBAL_PREFS('CATALOG_STATS_BATCH_SIZE') |
+-----------------------------------------------------------------+
| 100 |
+-----------------------------------------------------------------+
1 row in set