V$RSRC_PLAN

This view displays the names of all currently active resource plans.

See Also: "DBA_RSRC_PLANS" for a listing of all plans in the database Oracle Database Administrator's Guide for information on resource plans PL/SQL Packages and Types Reference on defining resource allocation methods for consumer groups with the DBMS_RESOURCE_MANAGER package

Column	Datatype	Description
NAME	VARCHAR2(32)	Name of the resource plan
IS_TOP_PLAN	VARCHAR2(5)	Indicates whether the resource plan is the current top plan (TRUE) or the resource plan is a subplan of the current top plan (FALSE)