V$STATISTICS_LEVEL definition in Oracle Database 11.2
V$STATISTICS_LEVEL

select
  statistics_name,                         -- STATISTICS_NAME VARCHAR2(64)
  description,                             -- DESCRIPTION VARCHAR2(4000)
  session_status,                          -- SESSION_STATUS VARCHAR2(8)
  system_status,                           -- SYSTEM_STATUS VARCHAR2(8)
  activation_level,                        -- ACTIVATION_LEVEL VARCHAR2(7)
  statistics_view_name,                    -- STATISTICS_VIEW_NAME VARCHAR2(64)
  session_settable                         -- SESSION_SETTABLE VARCHAR2(3)
from
  gv$statistics_level
where
  inst_id = USERENV('Instance')

home |  up