Instance caging is another small but useful feature of Oracle Database 11g Release 2. Thanks to it the database resource manager is able, to limit the number of CPUs that can be used by a given instance simultaneously. This feature allows Oracle DBAs to easily manage Oracle Instance CPU consumption.
There are two typical approaches to instance caging for a server:
- Over-provisioning:
In this approach, the sum of the CPU limits for each instance exceeds the actual number of CPUs on the system.
- Partitioning:In this approach, the sum of allocate CPUs for each instance is equal to the number of CPUs on the server
