select
  sid,                                     -- SID NUMBER
  current_consumer_group_id,               -- CURRENT_CONSUMER_GROUP_ID NUMBER
  orig_consumer_group_id,                  -- ORIG_CONSUMER_GROUP_ID NUMBER
  mapping_attribute,                       -- MAPPING_ATTRIBUTE VARCHAR2(32)
  mapped_consumer_group,                   -- MAPPED_CONSUMER_GROUP VARCHAR2(32)
  state,                                   -- STATE VARCHAR2(32)
  active,                                  -- ACTIVE VARCHAR2(5)
  current_idle_time,                       -- CURRENT_IDLE_TIME NUMBER
  current_cpu_wait_time,                   -- CURRENT_CPU_WAIT_TIME NUMBER
  cpu_wait_time,                           -- CPU_WAIT_TIME NUMBER
  current_cpu_waits,                       -- CURRENT_CPU_WAITS NUMBER
  cpu_waits,                               -- CPU_WAITS NUMBER
  current_consumed_cpu_time,               -- CURRENT_CONSUMED_CPU_TIME NUMBER
  consumed_cpu_time,                       -- CONSUMED_CPU_TIME NUMBER
  current_active_time,                     -- CURRENT_ACTIVE_TIME NUMBER
  active_time,                             -- ACTIVE_TIME NUMBER
  current_queued_time,                     -- CURRENT_QUEUED_TIME NUMBER
  queued_time,                             -- QUEUED_TIME NUMBER
  current_yields,                          -- CURRENT_YIELDS NUMBER
  yields,                                  -- YIELDS NUMBER
  current_undo_consumption,                -- CURRENT_UNDO_CONSUMPTION NUMBER
  max_undo_consumption,                    -- MAX_UNDO_CONSUMPTION NUMBER
  sql_canceled,                            -- SQL_CANCELED NUMBER
  queue_time_outs,                         -- QUEUE_TIME_OUTS NUMBER
  estimated_execution_limit_hit,           -- ESTIMATED_EXECUTION_LIMIT_HIT NUMBER
  current_io_service_time,                 -- CURRENT_IO_SERVICE_TIME NUMBER
  io_service_time,                         -- IO_SERVICE_TIME NUMBER
  current_io_service_waits,                -- CURRENT_IO_SERVICE_WAITS NUMBER
  io_service_waits,                        -- IO_SERVICE_WAITS NUMBER
  current_small_read_megabytes,            -- CURRENT_SMALL_READ_MEGABYTES NUMBER
  small_read_megabytes,                    -- SMALL_READ_MEGABYTES NUMBER
  current_large_read_megabytes,            -- CURRENT_LARGE_READ_MEGABYTES NUMBER
  large_read_megabytes,                    -- LARGE_READ_MEGABYTES NUMBER
  current_small_write_megabytes,           -- CURRENT_SMALL_WRITE_MEGABYTES NUMBER
  small_write_megabytes,                   -- SMALL_WRITE_MEGABYTES NUMBER
  current_large_write_megabytes,           -- CURRENT_LARGE_WRITE_MEGABYTES NUMBER
  large_write_megabytes,                   -- LARGE_WRITE_MEGABYTES NUMBER
  current_small_read_requests,             -- CURRENT_SMALL_READ_REQUESTS NUMBER
  small_read_requests,                     -- SMALL_READ_REQUESTS NUMBER
  current_small_write_requests,            -- CURRENT_SMALL_WRITE_REQUESTS NUMBER
  small_write_requests,                    -- SMALL_WRITE_REQUESTS NUMBER
  current_large_read_requests,             -- CURRENT_LARGE_READ_REQUESTS NUMBER
  large_read_requests,                     -- LARGE_READ_REQUESTS NUMBER
  current_large_write_requests,            -- CURRENT_LARGE_WRITE_REQUESTS NUMBER
  large_write_requests                     -- LARGE_WRITE_REQUESTS NUMBER
from
  gv$rsrc_session_info
where
  inst_id = userenv('instance')