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 )
|