Lesson 7 | Use Database Resource Manager in Oracle |
Objective | Use Database Resource Manager to limit resource usage. |
Use Database Resource Manager to limit resource usage
The previous lesson described how to design a resource management plan. This lesson shows you how to implement the plan.
Implementing a resource management plan means loading information into the database using several procedures stored in the DBMS_RESOURCE_MANAGER package.
This package is installed with all Oracle Enterprise Edition databases.
Look at the SlideShow for syntax and examples of each step. The code shown here can be executed in SQL*Plus.
The SlideShow uses the same example that was described in the previous lesson.
Using these commands is easy. The most important part of using the Database Resource Manager is to define a plan or set of plans appropriate for your system. Look in the Oracle Administrator's Guide for examples of a variety of system scenarios and plans.
DB Resource Manager - Exercise
Click the Exercise link below to practice creating a plan directive, defining a consumer group, and assigning a user to the group.
The next lesson wraps up this module.
DB Resource Manager - Exercise