Appropriate Resources to Each Query
•CPU
–Business-critical
processes receive more CPU
–Database Resource
Manager allows DBA to assign CPU resources to groups of users
•Memory
–Oracle9i dynamically
allocates runtime memory based on current available memory and each query’s requirements
•Parallelism
–Degree of parallelism is
dynamically chosen based on available resources and each query’s requirements