Xem mẫu
Using Resource Manager
Copyright © Oracle Corporation, 2002. 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
18-2 Copyright © Oracle Corporation, 2002. All rights reserved.
Overview
• Manage mixed workload
• Control system performance
Database resource manager
OLTP user
DSS user
OLTP More resources
DSS
Less resources Oracle9i
18-3 Copyright © Oracle Corporation, 2002. All rights reserved.
Database Resource Management Concepts
Resource consumer group
Resource plan
Resource plan directives
User groups with similar resource needs (one active resource consumer group per session)
Allocates CPU and PQ servers (one active plan)
Assigns groups and resources to plans
18-4 Copyright © Oracle Corporation, 2002. All rights reserved.
Using Sub-Plans to Limit CPU Utilization
MYDB PLAN
30% @ L1 70% @ L1
MAILDB PLAN
100% @ L3
BUGDB PLAN
40% @ L1 100% @ L3 80% @ L1 100% @ L2
100% @ L2 20% @ L1
POSTMAN Group
MAIL MAINT OTHER Group Groups
ONLINE BATCH Group Group
BUG MAINT Group
18-5 Copyright © Oracle Corporation, 2002. All rights reserved.
...
- tailieumienphi.vn
nguon tai.lieu . vn