25 Managing Resource Allocation with Oracle Database Resource Manager

Oracle Database Resource Manager (the Resource Manager) enables you to configure your database for optimal resource allocation among the many concurrent user sessions. This chapter provides background information and instructions for using the Resource Manager. It includes the following topics:

• 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

• 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.