select
  inst_id,                                 -- INST_ID NUMBER
  sid_kgskvft,                             -- SID NUMBER
  class_id_kgskvft,                        -- CURRENT_CONSUMER_GROUP_ID NUMBER
  orig_class_id_kgskvft,                   -- ORIG_CONSUMER_GROUP_ID NUMBER
  orig_class_map_kgskvft,                  -- MAPPING_ATTRIBUTE VARCHAR2(32)
  mapped_cg_name_kgskvft,                  -- MAPPED_CONSUMER_GROUP VARCHAR2(32)
  state_kgskvft,                           -- STATE VARCHAR2(32)
  decode(                                  -- ACTIVE VARCHAR2(5)
    active_kgskvft, 1, 'TRUE', 0, 'FALSE', ''),
  idle_time_kgskvft,                       -- CURRENT_IDLE_TIME NUMBER
  cur_cpu_wait_time_kgskvft,               -- CURRENT_CPU_WAIT_TIME NUMBER
  tot_cpu_wait_time_kgskvft,               -- CPU_WAIT_TIME NUMBER
  cur_cpu_waits_kgskvft,                   -- CURRENT_CPU_WAITS NUMBER
  tot_cpu_waits_kgskvft,                   -- CPU_WAITS NUMBER
  cur_cpu_time_kgskvft,                    -- CURRENT_CONSUMED_CPU_TIME NUMBER
  tot_cpu_time_kgskvft,                    -- CONSUMED_CPU_TIME NUMBER
  cur_active_time_kgskvft,                 -- CURRENT_ACTIVE_TIME NUMBER
  tot_active_time_kgskvft,                 -- ACTIVE_TIME NUMBER
  cur_queued_time_kgskvft,                 -- CURRENT_QUEUED_TIME NUMBER
  tot_queued_time_kgskvft,                 -- QUEUED_TIME NUMBER
  cur_yields_kgskvft,                      -- CURRENT_YIELDS NUMBER
  tot_yields_kgskvft,                      -- YIELDS NUMBER
  cur_undo_kgskvft,                        -- CURRENT_UNDO_CONSUMPTION NUMBER
  max_undo_kgskvft,                        -- MAX_UNDO_CONSUMPTION NUMBER
  call_aborted_kgskvft,                    -- SQL_CANCELED NUMBER
  queue_timeouts_kgskvft,                  -- QUEUE_TIME_OUTS NUMBER
  est_exec_lmt_hit_kgskvft,                -- ESTIMATED_EXECUTION_LIMIT_HIT NUMBER
  cur_io_service_time_kgskvft,             -- CURRENT_IO_SERVICE_TIME NUMBER
  tot_io_service_time_kgskvft,             -- IO_SERVICE_TIME NUMBER
  cur_io_service_waits_kgskvft,            -- CURRENT_IO_SERVICE_WAITS NUMBER
  tot_io_service_waits_kgskvft,            -- IO_SERVICE_WAITS NUMBER
  round(cur_sbrdata_kgskvft / 2048),       -- CURRENT_SMALL_READ_MEGABYTES NUMBER
  round(tot_sbrdata_kgskvft / 2048),       -- SMALL_READ_MEGABYTES NUMBER
  round(cur_mbrdata_kgskvft / 2048),       -- CURRENT_LARGE_READ_MEGABYTES NUMBER
  round(tot_mbrdata_kgskvft / 2048),       -- LARGE_READ_MEGABYTES NUMBER
  round(cur_sbwdata_kgskvft / 2048),       -- CURRENT_SMALL_WRITE_MEGABYTES NUMBER
  round(tot_sbwdata_kgskvft / 2048),       -- SMALL_WRITE_MEGABYTES NUMBER
  round(cur_mbwdata_kgskvft / 2048),       -- CURRENT_LARGE_WRITE_MEGABYTES NUMBER
  round(tot_mbwdata_kgskvft / 2048),       -- LARGE_WRITE_MEGABYTES NUMBER
  cur_sbrreqs_kgskvft,                     -- CURRENT_SMALL_READ_REQUESTS NUMBER
  tot_sbrreqs_kgskvft,                     -- SMALL_READ_REQUESTS NUMBER
  cur_sbwreqs_kgskvft,                     -- CURRENT_SMALL_WRITE_REQUESTS NUMBER
  tot_sbwreqs_kgskvft,                     -- SMALL_WRITE_REQUESTS NUMBER
  cur_mbrreqs_kgskvft,                     -- CURRENT_LARGE_READ_REQUESTS NUMBER
  tot_mbrreqs_kgskvft,                     -- LARGE_READ_REQUESTS NUMBER
  cur_mbwreqs_kgskvft,                     -- CURRENT_LARGE_WRITE_REQUESTS NUMBER
  tot_mbwreqs_kgskvft                      -- LARGE_WRITE_REQUESTS NUMBER
from
  x$kgskvft