Instance caging is one of the best ways to allocate resources from a database standpoint. It really takes it one step further from products like the IBM Workload Manager but is far superior.
One of my favorite articles on instance caging
Oracle's White Paper on Instance Caging