--

-- 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

/