select
  A.inst_id,                               -- INST_ID NUMBER
  A.name_kgskcft,                          -- NAME VARCHAR2(32)
  A.class_id_kgskcft,                      -- ID NUMBER
  A.current_count_kgskcft,                 -- ACTIVE_SESSIONS NUMBER
  A.runnable_count_kgskcft,                -- EXECUTION_WAITERS NUMBER
  A.total_count_kgskcft,                   -- REQUESTS NUMBER
  A.cpu_wait_kgskcft,                      -- CPU_WAIT_TIME NUMBER
  A.cpu_waits_kgskcft,                     -- CPU_WAITS NUMBER
  A.total_used_kgskcft,                    -- CONSUMED_CPU_TIME NUMBER
  A.yields_kgskcft,                        -- YIELDS NUMBER
  decode(                                  -- CPU_DECISIONS NUMBER
    A.total_lotteries_kgskcft, 0, 0, floor((100 * A.lottery_presents_kgskcft) / A.total_lotteries_kgskcft)),
  decode(                                  -- CPU_DECISIONS_EXCLUSIVE NUMBER
    A.total_lotteries_kgskcft, 0, 0, floor((100 * A.lottery_alones_kgskcft) / A.total_lotteries_kgskcft)),
  decode(                                  -- CPU_DECISIONS_WON NUMBER
    A.total_runs_kgskcft, 0, 0, floor((100 * A.lottery_runs_kgskcft) / A.total_runs_kgskcft)),
  A.num_queued_kgskcft,                    -- QUEUE_LENGTH NUMBER
  A.undo_consump_kgskcft,                  -- CURRENT_UNDO_CONSUMPTION NUMBER
  A.active_limit_hit_kgskcft,              -- ACTIVE_SESSION_LIMIT_HIT NUMBER
  A.undo_limit_hit_kgskcft,                -- UNDO_LIMIT_HIT NUMBER
  A.swch_in_time_kgskcft,                  -- SWITCHES_IN_CPU_TIME NUMBER
  A.swch_out_time_kgskcft,                 -- SWITCHES_OUT_CPU_TIME NUMBER
  A.swch_in_mb_kgskcft,                    -- SWITCHES_IN_IO_MEGABYTES NUMBER
  A.swch_out_mb_kgskcft,                   -- SWITCHES_OUT_IO_MEGABYTES NUMBER
  A.swch_in_reqs_kgskcft,                  -- SWITCHES_IN_IO_REQUESTS NUMBER
  A.swch_out_reqs_kgskcft,                 -- SWITCHES_OUT_IO_REQUESTS NUMBER
  A.call_aborted_kgskcft,                  -- SQL_CANCELED NUMBER
  A.actv_sess_killed_kgskcft,              -- ACTIVE_SESSIONS_KILLED NUMBER
  A.idle_sess_killed_kgskcft,              -- IDLE_SESSIONS_KILLED NUMBER
  A.idlblkr_sess_kld_kgskcft,              -- IDLE_BLKR_SESSIONS_KILLED NUMBER
  A.queued_time_kgskcft,                   -- QUEUED_TIME NUMBER
  A.queue_timeouts_kgskcft,                -- QUEUE_TIME_OUTS NUMBER
  B.wtime_ksfdstcg,                        -- IO_SERVICE_TIME NUMBER
  B.wreqs_ksfdstcg,                        -- IO_SERVICE_WAITS NUMBER
  round(B.sbrdata_ksfdstcg / 2048),        -- SMALL_READ_MEGABYTES NUMBER
  round(B.sbwdata_ksfdstcg / 2048),        -- SMALL_WRITE_MEGABYTES NUMBER
  round(B.mbrdata_ksfdstcg / 2048),        -- LARGE_READ_MEGABYTES NUMBER
  round(B.mbwdata_ksfdstcg / 2048),        -- LARGE_WRITE_MEGABYTES NUMBER
  B.sbrreqs_ksfdstcg,                      -- SMALL_READ_REQUESTS NUMBER
  B.sbwreqs_ksfdstcg,                      -- SMALL_WRITE_REQUESTS NUMBER
  B.mbrreqs_ksfdstcg,                      -- LARGE_READ_REQUESTS NUMBER
  B.mbwreqs_ksfdstcg                       -- LARGE_WRITE_REQUESTS NUMBER
from
  x$kgskcft A,
  x$ksfdstcg B
where
  A.class_id_kgskcft = B.consumer_group_id_ksfdstcg and B.pool_ksfdstcg = 1