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