5.305 DBA_RSRC_PLAN_DIRECTIVES
DBA_RSRC_PLAN_DIRECTIVES
displays information about all resource plan directives in the database.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Name of the plan to which the directive belongs |
|
|
|
Name of the consumer group or subplan referred to |
|
|
|
Indicates whether |
|
|
|
This column is deprecated. Use the |
|
|
|
This column is deprecated. Use the |
|
|
|
This column is deprecated. Use the |
|
|
|
This column is deprecated. Use the |
|
|
|
This column is deprecated. Use the |
|
|
|
This column is deprecated. Use the |
|
|
|
This column is deprecated. Use the |
|
|
|
This column is deprecated. Use the |
|
|
|
Resource allocation at level 1. For share-based plans, indicates the number of shares. |
|
|
|
Resource allocation at level 2. |
|
|
|
Resource allocation at level 3. |
|
|
|
Resource allocation at level 4. |
|
|
|
Resource allocation at level 5. |
|
|
|
Resource allocation at level 6. |
|
|
|
Resource allocation at level 7. |
|
|
|
Resource allocation at level 8. |
|
|
|
Maximum number of calls this consumer group can run concurrently |
|
|
|
Timeout in seconds for waits in the Active Session Limit queue |
|
|
|
This column is deprecated. Use the |
|
|
|
Sessions in this consumer group are limited to this maximum degree of parallelism for all parallel operations |
|
|
|
Group to switch to once the switch time is reached |
|
|
|
Indicates whether to switch back to the initial consumer group once the top call has completed ( |
|
|
|
Amount of run time (in seconds) within a group before the session is automatically switched. As with other switch directives, if |
|
|
|
The maximum megabytes of I/O within a group that will trigger the action specified by |
|
|
|
The maximum I/O requests within a group that will trigger the action specified by |
|
|
|
Indicates whether estimated execution time should be used for switch criteria ( |
|
|
|
Maximum estimated execution time |
|
|
|
Undo pool size for the consumer group |
|
|
|
Maximum idle time for the session |
|
|
|
Maximum idle time for the session when blocking other sessions |
|
|
|
This column is deprecated. Use |
|
|
|
Time (in seconds) that a query can remain in the parallel statement queue for the consumer group before it is removed from the queue. The |
|
|
|
This column is deprecated. Specify the time in the |
|
|
|
The number of logical I/Os that will trigger the action specified by |
|
|
|
The elapsed time that will trigger the action specified by |
|
|
|
Maximum percentage of the parallel target used before queuing subsequent parallel queries |
|
|
|
Maximum resource utilization allowed, expressed in percentage |
|
|
|
Indicates whether parallel statements from this consumer group are eligible for queuing in the parallel statement queue:
|
|
|
|
The maximum amount of untunable PGA in MB that sessions in this consumer group can allocate before being terminated |
|
|
|
Indicates the action to be taken on a parallel query in the parallel queue when its queue time exceeds the limit set by the Resource Manager plan’s
|
|
|
|
Text comment on the plan directive |
|
|
|
Indicates whether the plan directive is part of the pending area ( Note: PDB resource plans must be single-level, they cannot contain subplans, and they must have 8 or fewer consumer groups. If a resource plan is imported into a PDB and it violates any of these PDB requirements, then the import will automatically convert the resource plan to a compliant version. The original, unmodified resource plan will be stored with a |
|
|
|
Indicates whether the plan directive is mandatory ( |
Footnote 1 This column is available starting with Oracle Database 18c.
See Also:
-
Oracle Database Administrator’s Guide for information on resource plans in general
-
Oracle Database PL/SQL Packages and Types Reference for information about specifying Resource Manager directive values using the
DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE
procedure parameters