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