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') 
from
x$kskplw plw,
obj$ o 
where
plw.window_id_kskplw = o.obj# (+)
home |  up  |  mailbox