V$RSRC_PLAN definition in Oracle Database 11.2

V$RSRC_PLAN

select
  id,                                      -- ID NUMBER
  name,                                    -- NAME VARCHAR2(32)
  is_top_plan,                             -- IS_TOP_PLAN VARCHAR2(5)
  cpu_managed                              -- CPU_MANAGED VARCHAR2(3)
from
  gv$rsrc_plan
where
  inst_id = userenv('instance')

home | up