11.7. Summary

In this chapter, you learned about the Oracle Database Resource Manager (DRM) and how to configure it to manage resources on your Oracle database. You learned about setting up a pending area to hold all of the DRM objects as they are created or modified. You learned that objects in the pending area need to be validated before moving them into the data dictionary. You also learned the requirements that each object must pass before being declared valid by DRM. You learned that submitting the pending area activates all the objects therein and moves them into the data dictionary.

We taught you how to create and manage consumer resource groups and how these groups are used by DRM. You saw that consumer resource groups can be assigned to sessions based on a variety of session attributes. You learned that applications as well as users can be defined through these attributes. You also learned the different methods that can be used to switch the consumer group for a session. You learned to grant switch privileges to users and roles so that users can switch to specific groups themselves.

Next, we showed you how to create and manage resource plans. You learned about simple plans, which allow up to eight levels of CPU resources to be allocated to consumer groups. You also learned that simple plans can also create consumer groups and resource plan directives all in one procedure. You learned that complex resource plan definitions only define the CPU allocation resource method (either RATIO or EMPHASIS), and the real power lies in the resource plan directives.

You learned about resource plan directives and how they connect consumer groups to resource plans as well as define the resource allocation for the consumer group. We showed you that plan directives can allocate resources at up to eight levels and can allocate resources to sub-plans as well as to consumer groups. You learned the various resource allocation methods available, including CPU methods, active session pool with queuing, degree of parallelism limit, automatic consumer group switching, canceling SQL and terminating sessions, execution time limit, undo pool, and idle time limit (blocking and non-blocking).

Lastly, you learned to put all of the elements together to build a complex resource plan schema using PL/SQL packages. Then you learned to enable the plan on the database.