Récupérer les infos de stats en base

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;