GV$STATISTICS_LEVEL definition in Oracle Database 11.2
GV$STATISTICS_LEVEL
select
inst_id, -- INST_ID NUMBER
name, -- STATISTICS_NAME VARCHAR2(64)
description, -- DESCRIPTION VARCHAR2(4000)
decode( -- SESSION_STATUS VARCHAR2(8)
session_status, 0, 'DISABLED', 1, 'ENABLED', 'UNKNOWN'),
decode( -- SYSTEM_STATUS VARCHAR2(8)
system_status, 0, 'DISABLED', 1, 'ENABLED', 'UNKNOWN'),
decode( -- ACTIVATION_LEVEL VARCHAR2(7)
activation_level, 0, 'BASIC', 1, 'TYPICAL', 'ALL'),
view_name, -- STATISTICS_VIEW_NAME VARCHAR2(64)
decode( -- SESSION_SETTABLE VARCHAR2(3)
session_changeable, 0, 'NO', 'YES')
from
x$prmsltyx