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