5.306 DBA_RSRC_PLANS
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 |
---|---|---|---|
|
|
|
ID number of the resource plan |
|
|
|
Name of the resource plan |
|
|
|
Number of plan directives for the plan |
|
|
|
CPU resource allocation method for the plan |
|
|
|
Resource allocation method for the plan |
|
|
|
Active session pool resource allocation method for the plan |
|
|
|
Parallel degree limit resource allocation method for the plan |
|
|
|
Queuing resource allocation method for the plan |
|
|
|
Indicates whether the plan is a subplan ( |
|
|
|
Text comment on the plan |
|
|
|
Indicates whether the plan is part of the pending area ( |
|
|
|
Indicates whether the plan is mandatory ( |
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