GV$RSRC_CONSUMER_GROUP definition in Oracle Database 10.2 / www.oracledba.ru
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