--

-- List Plan Directives

--

SET PAUSE ON

SET PAUSE 'Press Return to Continue'

SET PAGESIZE 60

SET LINESIZE 300

SELECT plan,

       group_or_subplan,

       cpu_p1,

       cpu_p2,

       cpu_p3,

       cpu_p4

FROM   dba_rsrc_plan_directives

WHERE  plan = DECODE(UPPER('&plan_name'), 'ALL', plan, UPPER('&plan_name'))

ORDER BY plan, cpu_p1 DESC, cpu_p2 DESC, cpu_p3 DESC

/