TIDY UP BY USING DATABASE CONTROL TO ACTIVATE THE DEFAULT PLAN

19. Tidy up by using Database Control to activate the Default Plan.

Two-Minute Drill

Understand the Database Resource Manager

• The Resource Manager enables you to prioritize sessions.• Users are assigned to consumer groups, and plans allocate resources to these groups.• Resources can be controlled by emphasis (CPU usage) and absolute methods (such as parallelism or execution time).• Sessions can be switched between groups manually, or automatically according to execution time or various session attributes.

Create and Use Database Resource Manager

Components

• A pending area must be created in memory before working with the Resource Manager.• Users must be granted membership of consumer groups.• A plan can be activated by setting the RESOURCE_MANAGER_PLAN parameter manually, or with the DBMS_RESOURCE_MANAGER.SWITCH_PLAN procedure call, or automatically by the Scheduler.• All sessions must have an active consumer group, which defaults to DEFAULT_CONSUMER_GROUP.• Every plan must have a directive for the consumer group OTHER_GROUPS.

Self Test