The GET_PARAM function obtains the default values of parameters of procedures in the DBMS_STATS package.
Syntax
DBMS_STATS.GET_PARAM (
pname IN VARCHAR2)
RETURN VARCHAR2;
Parameters
The pname parameter specifies the name of the parameter whose default value is to be obtained.
Exceptions
The error code ORA-20001 indicates that the input value is invalid.
Examples
Obtain the default value of the METHOD_OPT parameter.
obclient> SELECT DBMS_STATS.GET_PARAM ('METHOD_OPT') FROM DUAL;
+-------------------------------------+
| DBMS_STATS.GET_PARAM ('METHOD_OPT') |
+-------------------------------------+
| FOR ALL COLUMNS SIZE AUTO |
+-------------------------------------+
1 row in set