select
  inst_id,                                 -- INST_ID NUMBER
  seq_kgskscs,                             -- SEQUENCE# NUMBER
  consumer_group_id_kgskscs,               -- ID NUMBER
  name_kgskscs,                            -- NAME VARCHAR2(30)
  requests_kgskscs,                        -- REQUESTS NUMBER
  cpu_wait_time_kgskscs,                   -- CPU_WAIT_TIME NUMBER
  cpu_waits_kgskscs,                       -- CPU_WAITS NUMBER
  consumed_cpu_time_kgskscs,               -- CONSUMED_CPU_TIME NUMBER
  yields_kgskscs,                          -- YIELDS NUMBER
  decode(                                  -- CPU_DECISIONS NUMBER
    total_lotteries_kgskscs, 0, 0, floor((100 * lottery_presents_kgskscs) / total_lotteries_kgskscs)),
  decode(                                  -- CPU_DECISIONS_EXCLUSIVE NUMBER
    total_lotteries_kgskscs, 0, 0, floor((100 * lottery_alones_kgskscs) / total_lotteries_kgskscs)),
  decode(                                  -- CPU_DECISIONS_WON NUMBER
    total_runs_kgskscs, 0, 0, floor((100 * lottery_runs_kgskscs) / total_runs_kgskscs)),
  active_sess_limit_hit_kgskscs,           -- ACTIVE_SESS_LIMIT_HIT NUMBER
  undo_limit_hit_kgskscs,                  -- UNDO_LIMIT_HIT NUMBER
  swch_in_time_kgskscs,                    -- SWITCHES_IN_CPU_TIME NUMBER
  swch_out_time_kgskscs,                   -- SWITCHES_OUT_CPU_TIME NUMBER
  swch_in_mb_kgskscs,                      -- SWITCHES_IN_IO_MEGABYTES NUMBER
  swch_out_mb_kgskscs,                     -- SWITCHES_OUT_IO_MEGABYTES NUMBER
  swch_in_reqs_kgskscs,                    -- SWITCHES_IN_IO_REQUESTS NUMBER
  swch_out_reqs_kgskscs,                   -- SWITCHES_OUT_IO_REQUESTS NUMBER
  sql_canceled_kgskscs,                    -- SQL_CANCELED NUMBER
  active_sess_killed_kgskscs,              -- ACTIVE_SESS_KILLED NUMBER
  idle_sess_killed_kgskscs,                -- IDLE_SESS_KILLED NUMBER
  idle_blkr_sess_killed_kgskscs,           -- IDLE_BLKR_SESS_KILLED NUMBER
  queued_time_kgskscs,                     -- QUEUED_TIME NUMBER
  queue_time_outs_kgskscs,                 -- QUEUE_TIME_OUTS NUMBER
  wtime_kgskscs,                           -- IO_SERVICE_TIME NUMBER
  wreqs_kgskscs,                           -- IO_SERVICE_WAITS NUMBER
  round(sbrdata_kgskscs / 2048),           -- SMALL_READ_MEGABYTES NUMBER
  round(sbwdata_kgskscs / 2048),           -- SMALL_WRITE_MEGABYTES NUMBER
  round(mbrdata_kgskscs / 2048),           -- LARGE_READ_MEGABYTES NUMBER
  round(mbwdata_kgskscs / 2048),           -- LARGE_WRITE_MEGABYTES NUMBER
  sbrreqs_kgskscs,                         -- SMALL_READ_REQUESTS NUMBER
  sbwreqs_kgskscs,                         -- SMALL_WRITE_REQUESTS NUMBER
  mbrreqs_kgskscs,                         -- LARGE_READ_REQUESTS NUMBER
  mbwreqs_kgskscs                          -- LARGE_WRITE_REQUESTS NUMBER
from
  x$kgskscs