{"id":8263,"date":"2016-06-12T16:38:24","date_gmt":"2016-06-12T14:38:24","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/"},"modified":"2016-06-12T16:38:24","modified_gmt":"2016-06-12T14:38:24","slug":"instance-caging-and-multitenant-do-the-right-setting","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/","title":{"rendered":"Instance Caging and multitenant: do the right setting"},"content":{"rendered":"

When you want to do instance caging, you have to set manually CPU_COUNT and to set a resource manager plan. If you <\/p>\n

By Franck Pachot<\/h2>\n

.
\n only the CPU_COUNT no instance caging will occur. Except during the maintenance window where the maintenance plan is set internally. You don’t want that kind of unpredictable behavior, so the recommandation is to always set a resource plan when you set manually CPU_COUNT. Here is another reason for such an unpredictable behavior.
\n
\nI’ve run 16 sessions running CPU. I’m in multitenant and they are connected to CDB$ROOT.
\n
\n[oracle@CDB ~]$ jobs
\n[1] Running sqlplus \/ as sysdba <<< "exec loop null; end loop;" &
\n[2] Running sqlplus \/ as sysdba <<< "exec loop null; end loop;" &
\n[3] Running sqlplus \/ as sysdba <<< "exec loop null; end loop;" &
\n[4] Running sqlplus \/ as sysdba <<< "exec loop null; end loop;" &
\n[5] Running sqlplus \/ as sysdba <<< "exec loop null; end loop;" &
\n[6] Running sqlplus \/ as sysdba <<< "exec loop null; end loop;" &
\n[7] Running sqlplus \/ as sysdba <<< "exec loop null; end loop;" &
\n[8] Running sqlplus \/ as sysdba <<< "exec loop null; end loop;" &
\n[9] Running sqlplus \/ as sysdba <<< "exec loop null; end loop;" &
\n[10] Running sqlplus \/ as sysdba <<< "exec loop null; end loop;" &
\n[11] Running sqlplus \/ as sysdba <<< "exec loop null; end loop;" &
\n[12] Running sqlplus \/ as sysdba <<< "exec loop null; end loop;" &
\n[13] Running sqlplus \/ as sysdba <<< "exec loop null; end loop;" &
\n[14] Running sqlplus \/ as sysdba <<< "exec loop null; end loop;" &
\n[15]- Running sqlplus \/ as sysdba <<< "exec loop null; end loop;" &
\n[16]+ Running sqlplus \/ as sysdba <<< "exec loop null; end loop;" &
\n<\/code>
\nI’ve set CPU_COUNT to 8:
\n
\nSQL> show spparameter cpu_count
\n 
\nSID NAME TYPE VALUE
\n-------- ----------------------------- ----------- ----------------------------
\n* cpu_count integer 8
\n<\/code>
\nbut no resource manager plan:
\n
\nSQL> show parameter resource_manager_plan
\n 
\nNAME TYPE VALUE
\n------------------------------------ ----------- ------------------------------
\nresource_manager_plan string
\n<\/code><\/p>\n

However, instance caging occurs:
\n
\nSQL> connect \/ as sysdba
\nConnected.
\nSQL> select count(*),con_id,session_state,event from v$active_session_history
\n 2 where sample_time>sysdate-1\/24\/60\/60 group by con_id,session_state,event;
\n 
\n COUNT(*) CON_ID SESSION EVENT
\n---------- ---------- ------- ------------------------------
\n 20 1 WAITING resmgr:cpu quantum
\n 12 1 ON CPU
\n<\/code>
\nHere you can see on the left that CPU usage has been limited to 8 user processes.
\n\"CaptureRESMGR005\"<\/a><\/p>\n

Any idea why instance caging occurred when there are no visible resource plan? And what did I do at 08:57 PM in order to stop instance caging?
\nWell, I did:
\n
\nSQL> alter pluggable database pdb close;
\n<\/code><\/p>\n

Now you understand. A resource plan was set for the PDB:
\n
\nSQL> alter session set container=PDB;
\n 
\nSession altered.
\n 
\nSQL> show con_id
\n 
\nCON_ID
\n------------------------------
\n3
\nSQL>
\nSQL> show spparameter cpu_count
\n 
\nSID NAME TYPE VALUE
\n-------- ----------------------------- ----------- ----------------------------
\n* cpu_count integer
\nSQL>
\nSQL> show parameter resource_manager_plan
\n 
\nNAME TYPE VALUE
\n------------------------------------ ----------- ------------------------------
\nresource_manager_plan string DEFAULT_PLAN
\n<\/code><\/p>\n

So be careful if you set CPU_COUNT manually, any settings that activates the Resource Manager. And setting a resource manager plan in a PDB activates the Resource manager for the instance as soon as the PDB is open (read\/write or read only).<\/p>\n

So the recommandation is: when you set CPU_COUNT in a CDB, then always set a Resource Manager Plan at CDB level. CDB_DEFAULT_PLAN is there for that:
\nhttps:\/\/twitter.com\/MarisElsins\/status\/741738199257612294
\n(by the way, more information about resource manager and 12c in Maris Elsins presentation<\/a>)<\/p>\n

If you are in Standard Edition, or Enterprise Edition without the multitenant option, you have only one PDB per CDB. This means that you have probably multiple instances on one server and instance caging is of crucial importance there. Setting the resource_manager_plan to CDB_DEFAULT_PLAN is sufficient to activate instance caging in a single-tenant instance:<\/p>\n

\"CaptureRESMGR006\"<\/a><\/p>\n

With multitenant option, you may create a custom plan with multiple directives. Instance caging is important even when you have only one instance on the server because the database scheduler is more efficient than the OS one. But that’s probably for a future blog post.<\/p>\n","protected":false},"excerpt":{"rendered":"

When you want to do instance caging, you have to set manually CPU_COUNT and to set a resource manager plan. If you By Franck Pachot . only the CPU_COUNT no instance caging will occur. Except during the maintenance window where the maintenance plan is set internally. You don’t want that kind of unpredictable behavior, so […]<\/p>\n","protected":false},"author":27,"featured_media":8266,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[60,853,64,96],"type_dbi":[],"class_list":["post-8263","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-12c","tag-instance-caging","tag-multitenant","tag-oracle"],"acf":[],"yoast_head":"\nInstance Caging and multitenant: do the right setting - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Instance Caging and multitenant: do the right setting\" \/>\n<meta property=\"og:description\" content=\"When you want to do instance caging, you have to set manually CPU_COUNT and to set a resource manager plan. If you By Franck Pachot . only the CPU_COUNT no instance caging will occur. Except during the maintenance window where the maintenance plan is set internally. You don’t want that kind of unpredictable behavior, so […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-06-12T14:38:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureRESMGR005-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1282\" \/>\n\t<meta property=\"og:image:height\" content=\"571\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Instance Caging and multitenant: do the right setting\",\"datePublished\":\"2016-06-12T14:38:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/\"},\"wordCount\":373,\"commentCount\":1,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureRESMGR005-1.png\",\"keywords\":[\"12c\",\"Instance caging\",\"multitenant\",\"Oracle\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/\",\"name\":\"Instance Caging and multitenant: do the right setting - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureRESMGR005-1.png\",\"datePublished\":\"2016-06-12T14:38:24+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureRESMGR005-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureRESMGR005-1.png\",\"width\":1282,\"height\":571},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Instance Caging and multitenant: do the right setting\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Instance Caging and multitenant: do the right setting - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/","og_locale":"en_US","og_type":"article","og_title":"Instance Caging and multitenant: do the right setting","og_description":"When you want to do instance caging, you have to set manually CPU_COUNT and to set a resource manager plan. If you By Franck Pachot . only the CPU_COUNT no instance caging will occur. Except during the maintenance window where the maintenance plan is set internally. You don’t want that kind of unpredictable behavior, so […]","og_url":"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/","og_site_name":"dbi Blog","article_published_time":"2016-06-12T14:38:24+00:00","og_image":[{"width":1282,"height":571,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureRESMGR005-1.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Instance Caging and multitenant: do the right setting","datePublished":"2016-06-12T14:38:24+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/"},"wordCount":373,"commentCount":1,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureRESMGR005-1.png","keywords":["12c","Instance caging","multitenant","Oracle"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/","url":"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/","name":"Instance Caging and multitenant: do the right setting - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureRESMGR005-1.png","datePublished":"2016-06-12T14:38:24+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureRESMGR005-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureRESMGR005-1.png","width":1282,"height":571},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/instance-caging-and-multitenant-do-the-right-setting\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Instance Caging and multitenant: do the right setting"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/8263","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=8263"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/8263\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/8266"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=8263"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=8263"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=8263"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=8263"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}