V$RSRC_PLAN
displays the names of all currently active resource plans.
Column | Datatype | Description |
---|---|---|
|
|
Resource plan ID (a unique number, consistent across database shutdowns and startups). This is also the data dictionary object ID. |
|
|
Name of the resource plan |
|
|
Indicates whether the resource plan is the current top plan ( |
|
|
Indicates whether the resource plan has parameters that specify a policy for how the Resource Manager should schedule sessions to manage CPU usage ( |
|
|
Indicates whether instance caging is enabled ( |
|
|
Total number of active parallel servers on the instance |
|
|
The value of |
|
|
State of parallel statement queuing:
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
|
|
For internal use only |
|
|
For internal use only |
|
|
For internal use only |
|
|
For internal use only |
|
|
For internal use only |
|
|
For internal use only |
|
|
For internal use only |
The resource plan with CON_ID=ROOT
is the CDB resource plan.
See Also:
"DBA_RSRC_PLANS" for a listing of all plans in the database
"DBA_CDB_RSRC_PLANS" for information about CDB resource plans
"DBA_CDB_RSRC_PLAN_DIRECTIVES" for information about CDB resource plan directives
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