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

home |  up  |  mailbox