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