List Plan Directives 
--
-- 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
/


Clipboard IE Only

Related Scripts

List Active Resource Plan
List Consumer Groups
List Resource Plans
List Information on Consumer Groups Usage

directivesplansql
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License