V$RSRC_PLAN

V$RSRC_PLAN displays the names of all currently active resource plans.

Column	Datatype	Description
`ID`	`NUMBER`	Resource plan ID (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 whether the resource plan is a subplan of the current top plan (`FALSE`)
`CPU_MANAGED`	`VARCHAR2(3)`	Indicates whether the resource plan has parameters that specify a policy for how the Resource Manager should schedule sessions to manage CPU usage (`ON`) or whether Resource Manager is not managing CPU usage (`OFF`)