Script: statistics_prefs.sql
( Download Script )
-- ----------------------------------------------------------------------------------- -- File Name : https://oracle-base.com/dba/monitoring/statistics_prefs.sql -- Author : Tim Hall -- Description : Displays current statistics preferences. -- Requirements : Access to the DBMS_STATS package. -- Call Syntax : @statistics_prefs -- Last Modified: 06-DEC-2013 -- ----------------------------------------------------------------------------------- SET LINESIZE 250 COLUMN autostats_target FORMAT A20 COLUMN cascade FORMAT A25 COLUMN degree FORMAT A10 COLUMN estimate_percent FORMAT A30 COLUMN method_opt FORMAT A25 COLUMN no_invalidate FORMAT A30 COLUMN granularity FORMAT A15 COLUMN publish FORMAT A10 COLUMN incremental FORMAT A15 COLUMN stale_percent FORMAT A15 SELECT DBMS_STATS.GET_PREFS('AUTOSTATS_TARGET') AS autostats_target, DBMS_STATS.GET_PREFS('CASCADE') AS cascade, DBMS_STATS.GET_PREFS('DEGREE') AS degree, DBMS_STATS.GET_PREFS('ESTIMATE_PERCENT') AS estimate_percent, DBMS_STATS.GET_PREFS('METHOD_OPT') AS method_opt, DBMS_STATS.GET_PREFS('NO_INVALIDATE') AS no_invalidate, DBMS_STATS.GET_PREFS('GRANULARITY') AS granularity, DBMS_STATS.GET_PREFS('PUBLISH') AS publish, DBMS_STATS.GET_PREFS('INCREMENTAL') AS incremental, DBMS_STATS.GET_PREFS('STALE_PERCENT') AS stale_percent FROM dual;