Introduced in 8i

Create resource groups and assign resource limits to the groups. Then assign users to the groups

3 components

Resource consumer groups - A group of users that have similar needs for database resources

Resource Plan - A collecion of rsource plan directives that are used to to implement resource management

Resource Plan directives - The specific number of CPU and parallel query resources that are allocated to each resource consumer group

Resource Manager controls the following resources:

1. Amount of CPU allocated to each user who is a member of the resource consumer group

2. The degree of parallelism allowed for parallel queries performed by a user who is a member of the resource consumer group

CPU resources are allocated based on the emphasis method, a value between 1 and 100

Parallel query resources are assigned using the absolute method. The maximum degree of aparallelism is an absolute specified value