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 querys
requirements
Parallelism
Degree of parallelism is dynamically chosen based
on available resources and each querys
requirements