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#(+)

home |  up