GV$RSRC_CONS_GROUP_HISTORY

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
active_sess_limit_hit_kgskscs, -- ACTIVE_SESS_LIMIT_HIT NUMBER
undo_limit_hit_kgskscs,  -- UNDO_LIMIT_HIT NUMBER
session_switches_in_kgskscs, -- SESSION_SWITCHES_IN NUMBER
session_switches_out_kgskscs, -- SESSION_SWITCHES_OUT 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
from
x$kgskscs
home |  up  |  mailbox