Managing a Mixed Workload

Objectives

Overview

Database Resource Management Concepts

Resource Consumer Groups

Resource Plan Directives

Database Resource Management Example

Steps in Database Resource Management

Assigning the Resource Manager Privilege

Creating Database Resource
Manager Objects

Creating Database Resource Manager Objects

Creating Database Resource Manager Objects

Assigning Users to Consumer Groups

Setting the Resource Plan for an Instance

Changing a Consumer Group
Within a Session

Changing Consumer Groups for Sessions

Database Resource Manager Information

Current Database Resource
Manager Settings

Summary