27 Managing Resources with Oracle Database Resource Manager

In this chapter:

• About Oracle Database Resource Manager

• Assigning Sessions to Resource Consumer Groups

• The Types of Resources Managed by the Resource Manager

• Creating a Simple Resource Plan

• Creating a Complex Resource Plan

• 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. For instructions about administering Resource Manager with Enterprise Manager, see Oracle Database 2 Day DBA.