I found a quick and simple way to implement Instance Caging.
- Oracle® Database Administrator’s Guide 11g Release 2 (11.2)
- Chapter 27 Managing Resources with Oracle Database Resource Manager
- Oracle® Database Reference 11g Release 2 (11.2)
In “About Instance Caging”,
A simple way to limit CPU consumption for each database instance is to use instance caging. Instance caging is a method that uses an initialization parameter to limit the number of CPUs that an instance can use simultaneously.
Following the procedure in “Enabling Instance Caging”, run the following commands as DBA:
ALTER SYSTEM SET cpu_count=2; ALTER SYSTEM SET resource_manager_plan=default_plan;
I had always been put by the procedure that required a detailed grouping of resources, and resoure allocations. The
default_plan is good enough.