GV$STATISTICS_LEVEL definition in Oracle Database 11.2
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