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) |
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 for information on defining resource allocation methods for consumer groups with the DBMS_RESOURCE_MANAGER package