37 lines
989 B
SQL
Executable File
37 lines
989 B
SQL
Executable File
SET SERVEROUTPUT ON
|
|
DECLARE
|
|
PROCEDURE display(p_param IN VARCHAR2) AS
|
|
l_result VARCHAR2(50);
|
|
BEGIN
|
|
l_result := DBMS_STATS.get_prefs (pname => p_param);
|
|
DBMS_OUTPUT.put_line(RPAD(p_param, 30, ' ') || ' : ' || l_result);
|
|
END;
|
|
BEGIN
|
|
display('APPROXIMATE_NDV_ALGORITHM');
|
|
display('AUTO_STAT_EXTENSIONS');
|
|
display('AUTO_TASK_STATUS');
|
|
display('AUTO_TASK_MAX_RUN_TIME');
|
|
display('AUTO_TASK_INTERVAL');
|
|
display('CASCADE');
|
|
display('CONCURRENT');
|
|
display('DEGREE');
|
|
display('ESTIMATE_PERCENT');
|
|
display('GLOBAL_TEMP_TABLE_STATS');
|
|
display('GRANULARITY');
|
|
display('INCREMENTAL');
|
|
display('INCREMENTAL_STALENESS');
|
|
display('INCREMENTAL_LEVEL');
|
|
display('METHOD_OPT');
|
|
display('NO_INVALIDATE');
|
|
display('OPTIONS');
|
|
display('PREFERENCE_OVERRIDES_PARAMETER');
|
|
display('PUBLISH');
|
|
display('STALE_PERCENT');
|
|
display('STAT_CATEGORY');
|
|
display('TABLE_CACHED_BLOCKS');
|
|
display('STALE_PERCENT');
|
|
display('WAIT_TIME_TO_UPDATE_STATS');
|
|
END;
|
|
/
|
|
|