DBA_RSRC_PLANS
displays information about all resource plans in the database. For a list of currently active plans, see "V$RSRC_PLAN".
Column | Datatype | NULL | Description |
---|---|---|---|
PLAN |
VARCHAR2(30) |
Name of the resource plan | |
NUM_PLAN_DIRECTIVES |
NUMBER |
Number of plan directives for the plan | |
CPU_METHOD |
VARCHAR2(30) |
CPU resource allocation method for the plan | |
ACTIVE_SESS_POOL_MTH |
VARCHAR2(30) |
Active session pool resource allocation method for the plan | |
PARALLEL_DEGREE_LIMIT_MTH |
VARCHAR2(30) |
Parallel degree limit resource allocation method for the plan | |
QUEUING_MTH |
VARCHAR2(30) |
Queuing resource allocation method for the plan | |
COMMENTS |
VARCHAR2(2000) |
Text comment on the plan | |
STATUS |
VARCHAR2(30) |
PENDING . if plan is part of the pending area; NULL otherwise. |
|
MANDATORY |
VARCHAR2(3) |
Indicates whether the plan is mandatory (YES ) or not (NO ) |
See Also:
Oracle Database Administrator's Guide for information on resource plans in general
Oracle Database PL/SQL Packages and Types Reference for more information on creating resource plans with the DBMS_RESOURCE_MANAGER
package