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
Oracle Database PL/SQL Packages and Types Reference on defining resource allocation methods for consumer groups with the DBMS_RESOURCE_MANAGER package

Column	Datatype	Description
`ID`	`NUMBER`	The resource plan object ID. It is a unique number, consistent across database shutdowns and startups. This is also the data dictionary object ID.
`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`)