GV$RSRC_PLAN_HISTORY definition in Oracle Database 11.2
GV$RSRC_PLAN_HISTORY
select
inst_id, -- INST_ID NUMBER
plw.seq_kskplw, -- SEQUENCE# NUMBER
decode( -- ID NUMBER
plw.id_kskplw, 0, to_number(null), plw.id_kskplw),
plw.name_kskplw, -- NAME VARCHAR2(30)
plw.start_tm_kskplw, -- START_TIME DATE
plw.end_tm_kskplw, -- END_TIME DATE
decode( -- ENABLED_BY_SCHEDULER VARCHAR2(5)
plw.window_id_kskplw, 0, 'FALSE', 'TRUE'),
o.name, -- WINDOW_NAME VARCHAR2(30)
decode( -- ALLOWED_AUTOMATED_SWITCHES VARCHAR2(5)
plw.auto_switch_kskplw, 0, 'FALSE', 'TRUE'),
decode( -- CPU_MANAGED VARCHAR2(3)
plw.cpu_rm_kskplw, 0, 'OFF', 'ON')
from
x$kskplw plw,
obj$ o
where
plw.window_id_kskplw = o.obj#(+)