The GET_CATALOG_PREFS statement is used to retrieve the values of table-level preferences from the catalog.
Note
This subprogram is available starting with V5.0.1.
Syntax
DBMS_STATS.GET_CATALOG_PREFS (
pname VARCHAR(65535),
catname VARCHAR(65535),
dbname VARCHAR(65535),
tabname VARCHAR(65535)
) RETURN VARCHAR(65535);
Parameters
Parameter |
Explanation |
|---|---|
| pname | Specifies the name of the preference to retrieve. Valid values:
|
| catname | Specifies the catalog name. |
| dbname | Specify the database name. |
| tabname | Specifies the table name. |
Examples
obclient> SELECT DBMS_STATS.GET_CATALOG_PREFS (
'CATALOG_STATS_BATCH_SIZE',
'hive_catalog',
'test_oss',
'lineitem'
);