GV$RSRC_CONSUMER_GROUP

select
inst_id,                 -- INST_ID NUMBER
name_kgskcft,            -- NAME VARCHAR2(32)
class_id_kgskcft,        -- ID NUMBER
current_count_kgskcft,   -- ACTIVE_SESSIONS NUMBER
runnable_count_kgskcft,  -- EXECUTION_WAITERS NUMBER
total_count_kgskcft,     -- REQUESTS NUMBER
cpu_wait_kgskcft,        -- CPU_WAIT_TIME NUMBER
cpu_waits_kgskcft,       -- CPU_WAITS NUMBER
total_used_kgskcft,      -- CONSUMED_CPU_TIME NUMBER
yields_kgskcft,          -- YIELDS NUMBER
num_queued_kgskcft,      -- QUEUE_LENGTH NUMBER
undo_consump_kgskcft,    -- CURRENT_UNDO_CONSUMPTION NUMBER
active_limit_hit_kgskcft, -- ACTIVE_SESSION_LIMIT_HIT NUMBER
swch_in_kgskcft,         -- SESSION_SWITCHES_IN NUMBER
swch_out_kgskcft,        -- SESSION_SWITCHES_OUT NUMBER
undo_limit_hit_kgskcft,  -- UNDO_LIMIT_HIT NUMBER
call_aborted_kgskcft,    -- SQL_CANCELED NUMBER
actv_sess_killed_kgskcft, -- ACTIVE_SESSIONS_KILLED NUMBER
idle_sess_killed_kgskcft, -- IDLE_SESSIONS_KILLED NUMBER
idlblkr_sess_kld_kgskcft, -- IDLE_BLKR_SESSIONS_KILLED NUMBER
queued_time_kgskcft,     -- QUEUED_TIME NUMBER
queue_timeouts_kgskcft   -- QUEUE_TIME_OUTS NUMBER
from
x$kgskcft
home |  up  |  mailbox