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