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

See Also:

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)