Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
DBA_RSRC_PLAN_DIRECTIVES
displays information about all resource plan directives in the database.
Column | Datatype | Description |
---|---|---|
PLAN |
VARCHAR2(30) |
Name of the plan to which the directive belongs |
GROUP_OR_SUBPLAN |
VARCHAR2(30) |
Name of the consumer group or subplan referred to |
TYPE |
VARCHAR2(14) |
Indicates whether GROUP_OR_SUBPLAN refers to a consumer group (CONSUMER_GROUP ) or a plan (PLAN ) |
CPU_P1 |
NUMBER |
First parameter for the CPU resource allocation method |
CPU_P2 |
NUMBER |
Second parameter for the CPU resource allocation method |
CPU_P3 |
NUMBER |
Third parameter for the CPU resource allocation method |
CPU_P4 |
NUMBER |
Fourth parameter for the CPU resource allocation method |
CPU_P5 |
NUMBER |
Fifth parameter for the CPU resource allocation method |
CPU_P6 |
NUMBER |
Sixth parameter for the CPU resource allocation method |
CPU_P7 |
NUMBER |
Seventh parameter for the CPU resource allocation method |
CPU_P8 |
NUMBER |
Eighth parameter for the CPU resource allocation method |
ACTIVE_SESS_POOL_P1 |
NUMBER |
First parameter for the active session pool resource allocation method |
QUEUING_P1 |
NUMBER |
First parameter for the queuing resource allocation method |
PARALLEL_DEGREE_LIMIT_P1 |
NUMBER |
First parameter for the parallel degree limit resource allocation method |
SWITCH_GROUP |
VARCHAR2(30) |
Group to switch to once the switch time is reached |
SWITCH_TIME |
NUMBER |
Amount of run time before the session is automatically switched |
SWITCH_ESTIMATE |
VARCHAR2(5) |
Indicates whether estimated execution time should be used for switch criteria (TRUE ) or not (FALSE ) |
MAX_EST_EXEC_TIME |
NUMBER |
Maximum estimated execution time |
UNDO_POOL |
NUMBER |
Undo pool size for the consumer group |
MAX_IDLE_TIME |
NUMBER |
Maximum idle time for the session |
MAX_IDLE_BLOCKER_TIME |
NUMBER |
Maximum idle time for the session when blocking other sessions |
SWITCH_TIME_IN_CALL |
NUMBER |
Call switch time limit for execution in a group |
COMMENTS |
VARCHAR2(2000) |
Text comment on the plan directive |
STATUS |
VARCHAR2(30) |
PENDING, if directive is part of the pending area; NULL otherwise. |
MANDATORY |
VARCHAR2(3) |
Indicates whether the plan directive 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