DBA_RSRC_PLAN_DIRECTIVES

DBA_RSRC_PLAN_DIRECTIVES displays information about all resource plan directives in the database.

Column Datatype NULL 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
MGMT_P1 NUMBER   First parameter for the resource allocation method
MGMT_P2 NUMBER   Second parameter for the resource allocation method
MGMT_P3 NUMBER   Third parameter for the resource allocation method
MGMT_P4 NUMBER   Fourth parameter for the resource allocation method
MGMT_P5 NUMBER   Fifth parameter for the resource allocation method
MGMT_P6 NUMBER   Sixth parameter for the resource allocation method
MGMT_P7 NUMBER   Seventh parameter for the resource allocation method
MGMT_P8 NUMBER   Eighth parameter for the 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_FOR_CALL VARCHAR2(5)   Indicates whether to switch back to the initial consumer group once the top call has completed (TRUE) or not (FALSE)
SWITCH_TIME NUMBER   Amount of run time before the session is automatically switched
SWITCH_IO_MEGABYTES NUMBER   Maximum megabytes of I/O within a group
SWITCH_IO_REQS NUMBER   Maximum I/O requests within a group
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)   Indicates whether the plan directive is part of the pending area (PENDING) or not (NULL)
MANDATORY VARCHAR2(3)   Indicates whether the plan directive is mandatory (YES) or not (NO)

See Also: