select
  sequence#,                               -- SEQUENCE# NUMBER
  id,                                      -- ID NUMBER
  name,                                    -- NAME VARCHAR2(30)
  start_time,                              -- START_TIME DATE
  end_time,                                -- END_TIME DATE
  enabled_by_scheduler,                    -- ENABLED_BY_SCHEDULER VARCHAR2(5)
  window_name,                             -- WINDOW_NAME VARCHAR2(30)
  allowed_automated_switches,              -- ALLOWED_AUTOMATED_SWITCHES VARCHAR2(5)
  cpu_managed                              -- CPU_MANAGED VARCHAR2(3)
from
  gv$rsrc_plan_history
where
  inst_id = userenv('instance')