STATISTICS_NAME

VARCHAR2(64)

Name of the statistics/advisory

DESCRIPTION

VARCHAR2(4000)

Description of the statistics/advisory

SESSION_STATUS

VARCHAR2(8)

(ENABLED/DISABLED) Status of the statistics/advisory for this session

SYSTEM_STATUS

VARCHAR2(8)

(ENABLED/DISABLED) Status of the statistics/advisory system-wide

ACTIVATION_LEVEL

VARCHAR2(7)

Indicates the level of STATISTICS_LEVEL that enables this statistics/advisory (BASIC, TYPICAL, or ALL)

STATISTICS_VIEW_NAME

VARCHAR2(64)

If there is a single view externalizing this statistics/advisory, then this column contains the name of that view. If there is no such view, then this column is empty. If there are multiple views involved, then the DESCRIPTION column mentions the view names.

SESSION_SETTABLE

VARCHAR2(3)

Indicates whether this statistics/advisory can be set at the session level (YES) or not (NO)