Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-03
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
View PDF

DBA_RSRC_PLAN_DIRECTIVES

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: