GV$RSRC_SESSION_INFO

select
inst_id,                 -- INST_ID NUMBER
sid_kgskvft,             -- SID NUMBER
decode                   -- CURRENT_CONSUMER_GROUP_ID VARCHAR2(40)
  (class_id_kgskvft, 0, NULL, class_id_kgskvft),
decode                   -- ORIG_CONSUMER_GROUP_ID VARCHAR2(40)
  (orig_class_id_kgskvft, 0, NULL, orig_class_id_kgskvft),
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
  
from
x$kgskvft
home |  up  |  mailbox