Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-15
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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
QUEUEING_P1 NUMBER   First parameter for the queuing resource allocation method
PARALLEL_TARGET_PERCENTAGEFoot 1  NUMBER   Maximum percentage of the target number of parallel servers that the consumer group can use
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
MAX_UTILIZATION_LIMIT NUMBER   Maximum percentage of CPU that the consumer group or subplan can utilize
PARALLEL_QUEUE_TIMEOUTFootref 1 NUMBER   Time (in seconds) that a query may remain in the parallel statement queue for the consumer group before it is removed and terminated with error ORA-07454
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)

Footnote 1 This column is available starting with Oracle Database 11g Release 2 (11.2.0.2).

See Also: