16
Copyright © 2004, Oracle. All rights reserved.
Managing Resources
16-2
Copyright © 2004, Oracle. All rights reserved.
Objectives
After completing this lesson, you should be able to do
the following:
•
Set up Database Resource Manager
•
Assign users to Resource Manager groups
•
Create resource plans within groups
16-3
Copyright © 2004, Oracle. All rights reserved.
OLTP
More resources
DSS
user
OLTP
user
Database
resource manager
DSS
Less resources
Oracle
Database
Overview
•
Manage mixed workload
•
Control system performance
16-4
Copyright © 2004, Oracle. All rights reserved.
Resource plan
directives
Database Resource
Manager Concepts
User groups or sessions
with similar resource
needs
A blueprint for resource
allocation among resource
consumer groups (one
active plan)
Specifies how a resource
is divided among the
resource consumer
groups
Resource
consumer
group
Resource plan
16-5
Copyright © 2004, Oracle. All rights reserved.
Resource Manager Configurations
•
You can manage database and operating system
resources, such as:
–
CPU usage
–
Number of active sessions
–
Degree of parallelism
–
Undo generation
–
Operation execution time
–
Idle time
•
You can also specify criteria that, if met, causes
the automatic switching of sessions to another
consumer group.