List Active Resource Plan 
--
-- List Active Resource Plan
--
 
SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300
 
SELECT name,
       is_top_plan
FROM   v$rsrc_plan
ORDER BY name
/


Clipboard IE Only

Related Scripts

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

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