26 Managing Resource Allocation with Oracle Database Resource Manager

In this chapter:

• About Oracle Database Resource Manager

• Creating a Simple Resource Plan

• Creating a Complex Resource Plan

• Assigning Sessions to Resource Consumer Groups

• Enabling Oracle Database Resource Manager and Switching Plans

• Putting It All Together: Oracle Database Resource Manager Examples

• Managing Multiple Database Instances on a Single Server

• Maintaining Consumer Groups, Plans, and Directives

• Viewing Database Resource Manager Configuration and Status

• Monitoring Oracle Database Resource Manager

• Interacting with Operating-System Resource Control

• Oracle Database Resource Manager Reference

  Note:

  This chapter discusses using PL/SQL package procedures to administer the Resource Manager. An easier way to administer the Resource Manager is with the graphical user interface of Enterprise Manager.

  To administer the Resource Manager in Enterprise Manager:

  1. Access the Database Home page.

     See Oracle Database 2 Day DBA for instructions.

  2. At the top of the page, click Server to display the Server page.

  3. In the Resource Manager section, click Getting Started.