V$STATISTICS_LEVEL

V$STATISTICS_LEVEL displays the status of the statistics/advisories controlled by STATISTICS_LEVEL.

Column Datatype Description
STATISTICS_NAME VARCHAR2(64) Name of the statistic/advisory
DESCRIPTION VARCHAR2(4000) Description of the statistic/advisory
SESSION_STATUS VARCHAR2(8) Status of the statistic/advisory for the session:

  • ENABLED

  • DISABLED
SYSTEM_STATUS VARCHAR2(8) System-wide status of the statistic/advisory:

  • ENABLED

  • DISABLED
ACTIVATION_LEVEL VARCHAR2(7) Indicates the level of STATISTICS_LEVEL that enables the statistic/advisory:

  • BASIC

  • TYPICAL

  • ALL
STATISTICS_VIEW_NAME VARCHAR2(64) If there is a single view externalizing the statistic/advisory, then this column contains the name of that view. If there is no such view, then this column is null. If there are multiple views involved, then the DESCRIPTION column mentions the view names.
SESSION_SETTABLE VARCHAR2(3) Indicates whether the statistic/advisory can be set at the session level (YES) or not (NO)

See Also:

"STATISTICS_LEVEL"