List Resource Plans 
--
-- List Resource Plans
--
 
SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300
 
SELECT plan,
       status,
       comments
FROM   dba_rsrc_plans
ORDER BY plan
/


Clipboard IE Only

Related Scripts

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

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