GV$RSRC_CONSUMER_GROUP

select
inst_id,                 -- INST_ID NUMBER
name_kgskcft,            -- NAME VARCHAR2(32)
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
from
x$kgskcft
home |  up  |  mailbox