Example Scenario
•Power
Users
–Up to 70% of the CPU resources
–Any degree of parallelism
–Any query which is expected to take
over one hour will be migrated to background
•Report
Users
–Up to 20% of the CPU resources
–No parallelism
–Limit of 40 concurrent queries
–Any query which is expected to take
over 20 minutes will be aborted
•Background
Jobs
–Up to 10% of the CPU resources
–Any degree of parallelism
–Limit of 5 concurrent queries