11.8. Exam Essentials

Know how to configure the Database Resource Manager. Be able to create, update, and delete DRM objects. Be aware of the pending area and the need to validate and submit objects to the data dictionary to make them active. Know that submitting the pending area enforces validation, so it isn't strictly necessary to validate as a separate step. Know the various methods of enabling DRM (through ALTER SYSTEM and through initialization parameters). Understand the various allocation methods.

Be able to assign users to Database Resource Manager groups. Know all the methods of assigning user sessions to DRM groups. Know the names of the DBMS_RESOURCE_MANAGER procedures for assigning groups. Be aware of the switch privilege and how it is granted. Be aware of the DBMS_SESSION procedure that users can use to change their own group.

Know how to create resource plans within groups. Understand all the steps involved in creating resource plans, both simple and complex. Know the difference between single- and multi-level resource plans. Understand the allocation methods used. Know what constitutes a top-level plan and a sub-plan.

Be able to specify directives for allocating resources to consumer groups. Know how to create and manage plan directives to allocate resources to consumer groups and sub-plans. Understand which allocation methods are available for directives to groups as opposed to directives to sub-plans.