select
  sequence#,                               -- SEQUENCE# NUMBER
  id,                                      -- ID NUMBER
  name,                                    -- NAME VARCHAR2(30)
  requests,                                -- REQUESTS NUMBER
  cpu_wait_time,                           -- CPU_WAIT_TIME NUMBER
  cpu_waits,                               -- CPU_WAITS NUMBER
  consumed_cpu_time,                       -- CONSUMED_CPU_TIME NUMBER
  yields,                                  -- YIELDS NUMBER
  cpu_decisions,                           -- CPU_DECISIONS NUMBER
  cpu_decisions_exclusive,                 -- CPU_DECISIONS_EXCLUSIVE NUMBER
  cpu_decisions_won,                       -- CPU_DECISIONS_WON NUMBER
  active_sess_limit_hit,                   -- ACTIVE_SESS_LIMIT_HIT NUMBER
  undo_limit_hit,                          -- UNDO_LIMIT_HIT NUMBER
  switches_in_cpu_time,                    -- SWITCHES_IN_CPU_TIME NUMBER
  switches_out_cpu_time,                   -- SWITCHES_OUT_CPU_TIME NUMBER
  switches_in_io_megabytes,                -- SWITCHES_IN_IO_MEGABYTES NUMBER
  switches_out_io_megabytes,               -- SWITCHES_OUT_IO_MEGABYTES NUMBER
  switches_in_io_requests,                 -- SWITCHES_IN_IO_REQUESTS NUMBER
  switches_out_io_requests,                -- SWITCHES_OUT_IO_REQUESTS NUMBER
  sql_canceled,                            -- SQL_CANCELED NUMBER
  active_sess_killed,                      -- ACTIVE_SESS_KILLED NUMBER
  idle_sess_killed,                        -- IDLE_SESS_KILLED NUMBER
  idle_blkr_sess_killed,                   -- IDLE_BLKR_SESS_KILLED NUMBER
  queued_time,                             -- QUEUED_TIME NUMBER
  queue_time_outs,                         -- QUEUE_TIME_OUTS NUMBER
  io_service_time,                         -- IO_SERVICE_TIME NUMBER
  io_service_waits,                        -- IO_SERVICE_WAITS NUMBER
  small_read_megabytes,                    -- SMALL_READ_MEGABYTES NUMBER
  small_write_megabytes,                   -- SMALL_WRITE_MEGABYTES NUMBER
  large_read_megabytes,                    -- LARGE_READ_MEGABYTES NUMBER
  large_write_megabytes,                   -- LARGE_WRITE_MEGABYTES NUMBER
  small_read_requests,                     -- SMALL_READ_REQUESTS NUMBER
  small_write_requests,                    -- SMALL_WRITE_REQUESTS NUMBER
  large_read_requests,                     -- LARGE_READ_REQUESTS NUMBER
  large_write_requests                     -- LARGE_WRITE_REQUESTS NUMBER
from
  gv$rsrc_cons_group_history
where
  inst_id = userenv('instance')