Instant Instance Caging


I found a quick and simple way to implement Instance Caging.

References

  • Oracle® Database Administrator’s Guide 11g Release 2 (11.2)
  • Oracle® Database Reference 11g Release 2 (11.2)
  • Definition

    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.

    Procedure

    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;
    

    Conclusion

    I had always been put by the procedure that required a detailed grouping of resources, and resoure allocations. The default_plan is good enough.

    Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s