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 | Using Resource Manager 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 OLTP More resources DSS user OLTP user Database resource manager DSS Less resources Oracle9i Overview Manage mixed workload Control system performance Overview By using the Database Resource Manager, the database administrator (DBA) has more control over certain resource utilization than is normally possible through operating system resource management alone. With the Oracle database it is possible to have control over CPU utilization and the degree of parallelism. If resource management decisions are left in the hands of the operating system, then this can cause inefficient scheduling or the rescheduling of Oracle servers while latches are being held. With the Database Resource Manager, the DBA can: Guarantee groups of users a minimum amount of processing resources . | Using Resource Manager 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 OLTP More resources DSS user OLTP user Database resource manager DSS Less resources Oracle9i Overview Manage mixed workload Control system performance Overview By using the Database Resource Manager, the database administrator (DBA) has more control over certain resource utilization than is normally possible through operating system resource management alone. With the Oracle database it is possible to have control over CPU utilization and the degree of parallelism. If resource management decisions are left in the hands of the operating system, then this can cause inefficient scheduling or the rescheduling of Oracle servers while latches are being held. With the Database Resource Manager, the DBA can: Guarantee groups of users a minimum amount of processing resources regardless of the load on the system and the number of users. Distribute available processing resources, by allocating percentages of CPU time to different users and applications. In an OLTP environment, a higher priority can be given to OLTP applications than to DSS applications during normal business hours. Limit the degree of parallelism that a set of users can use. Configure an instance to use a particular plan for allocating resources. A DBA can dynamically change the method, for example, from a daytime setup to a nighttime setup, without having to shut down and restart the instance. Resource plan directives Database Resource Management Concepts 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 Resource consumer group Resource plan Database Resource Manager Concepts Administering systems using the database resource management involves the use of resource plans, .
