ODC Appreciation Day : Instance Caging

Hello

Following Tim Hall’s challenge (on this post) again this year, here goes one of my favorite features of Oracle Database : Instance Caging.

Starting in the Enterprise Edition of oracle database version 11.2 we are able to control cpu usage in multi-database or consolidated environments. For that we just have to :

1) Set the cpu_control parameter to the number of cores we want to limit the usage (in this case 12 cores)  :

SYS@> alter system set cpu_count=12 scope=both sid='*';

SYS@> show parameter cpu_count

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cpu_count integer 12

2) Enable Resource Manager by choosing the DEFAULT_PLAN.

SYS@> alter system set resource_manager_plan='DEFAULT_PLAN' scope=both sid='*'; 

SYS@> show parameter resource

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
resource_manager_plan string DEFAULT_PLAN

Of course you can now detail your resource manager plan as you wish.

 

See you next year ! Regards.

#ThanksODC #ThanksOTN

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