Pour connaître les infos des stats dans la base Oracle.
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','INDG') AS autostats_target,
DBMS_STATS.GET_PREFS('CASCADE','INDG') AS cascade,
DBMS_STATS.GET_PREFS('DEGREE','INDG') AS degree,
DBMS_STATS.GET_PREFS('ESTIMATE_PERCENT','INDG') AS estimate_percent,
DBMS_STATS.GET_PREFS('METHOD_OPT','INDG') AS method_opt,
DBMS_STATS.GET_PREFS('NO_INVALIDATE') AS no_invalidate,
DBMS_STATS.GET_PREFS('GRANULARITY','INDG') AS granularity,
DBMS_STATS.GET_PREFS('PUBLISH','INDG') AS publish,
DBMS_STATS.GET_PREFS('INCREMENTAL','INDG') AS incremental,
DBMS_STATS.GET_PREFS('STALE_PERCENT','INDG') AS stale_percent
FROM dual;