{"id":7267,"date":"2016-03-10T15:15:40","date_gmt":"2016-03-10T14:15:40","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/resource-manager-plan-from-oem-vs-command-line\/"},"modified":"2016-03-10T15:15:40","modified_gmt":"2016-03-10T14:15:40","slug":"resource-manager-plan-from-oem-vs-command-line","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/resource-manager-plan-from-oem-vs-command-line\/","title":{"rendered":"Resource Manager plan from OEM vs. command line"},"content":{"rendered":"<h2>By Franck Pachot<\/h2>\n<p>.<br \/>\nYou are rather GUI or command line? Let&#8217;s compare what you can do with them when you want to create a Resource Manager plan, and what is missing in the GUI.<\/p>\n<p>I&#8217;m using EM13<em>c<\/em> here on a 12<em>c<\/em> database. Doc for command line API is <a href=\"https:\/\/docs.oracle.com\/database\/121\/ARPLS\/d_resmgr.htm#ARPLS67609\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>.<\/p>\n<p>I&#8217;ll explain what you can set in the GUI and the matching arguments generated by OEM:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Screenshot-2016-03-10-13.36.19.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Screenshot-2016-03-10-13.36.19.png\" alt=\"Screenshot 2016-03-10 13.36.19\" width=\"1920\" height=\"1080\" class=\"alignnone size-full wp-image-7385\" \/><\/a><\/p>\n<p>Here we have the name and description (comment):<\/p>\n<pre><code>DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE (\n   plan                      IN VARCHAR2, \n   comment                   IN VARCHAR2 DEFAULT NULL, <\/code><\/pre>\n<p>When the &#8216;Activate this plan&#8217; is checked, it calls the dbms_resource_manager.switch_plan, with the allow_scheduler_plan_switches=&gt;false if you uncheck &#8216;Automatic Plan Switching Enabled&#8217;<\/p>\n<p>The CREATE_PLAN_DIRECTIVE is called for each group or sub plan:<\/p>\n<pre><code>   group_or_subplan          IN VARCHAR2, \n<\/code><\/pre>\n<p>The &#8216;Utilization limit %&#8217; defines the max_utilization_limit wich is now utilization_limit:<\/p>\n<pre><code>   max_utilization_limit        IN NUMBER   DEFAULT NULL,  -- deprecated\n   utilization_limit            IN NUMBER   DEFAULT NULL,<\/code><\/pre>\n<p>The number or shares that we set are converted to percentage of total shares in order to define the cpu_p1 which is now mgmt_p1.<\/p>\n<pre><code>\n   cpu_p1                    IN NUMBER   DEFAULT NULL, -- deprecated\n   mgmt_p1                   IN NUMBER   DEFAULT NULL,<\/code><\/pre>\n<p>Actually, OEM put the share number and not the percentage when generating the SQL, but that&#8217;s ok.<\/p>\n<h3>Parallel Query DOP and queuing<\/h3>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Screenshot-2016-03-10-13.36.56.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Screenshot-2016-03-10-13.36.56.png\" alt=\"Screenshot 2016-03-10 13.36.56\" width=\"1920\" height=\"1080\" class=\"alignnone size-full wp-image-7384\" \/><\/a><\/p>\n<p>Here are the parallel settings. &#8216;bypass queue&#8217; sets parallel_stmt_critical to &#8216;bypass_queue&#8217; to avoid statement queuing for this consumer group.<\/p>\n<pre><code>   parallel_stmt_critical       IN VARCHAR2 DEFAULT NULL);\n<\/code><\/pre>\n<p>and the settings (using the deprecated parallel_target_percentage instead of parallel_sever_limit )<\/p>\n<pre><code>   parallel_degree_limit_p1  IN NUMBER   DEFAULT NULL,\n   parallel_target_percentage   IN NUMBER   DEFAULT NULL,  -- deprecated \n   parallel_queue_timeout       IN NUMBER   DEFAULT NULL,<\/code><\/pre>\n<p>The timeout is the number of seconds the statement can remain queued.<\/p>\n<h3>Per session or per-call limits<\/h3>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Screenshot-2016-03-10-13.37.03.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Screenshot-2016-03-10-13.37.03.png\" alt=\"Screenshot 2016-03-10 13.37.03\" width=\"1920\" height=\"1080\" class=\"alignnone size-full wp-image-7383\" \/><\/a><\/p>\n<p>The limits set the following arguments (in respective order):<\/p>\n<pre><code>   switch_elapsed_time          IN NUMBER   DEFAULT NULL,\n   switch_time                  IN NUMBER   DEFAULT NULL,\n   switch_io_megabytes          IN NUMBER   DEFAULT NULL,\n   switch_io_logical            IN NUMBER   DEFAULT NULL,\n   switch_io_reqs               IN NUMBER   DEFAULT NULL,<\/code><\/pre>\n<p>The actions sets a consumer group to switch to, or KILL_SESSION or CANCEL_SQL:<\/p>\n<pre><code>   switch_group              IN VARCHAR2 DEFAULT NULL,\n<\/code><\/pre>\n<p>The &#8216;track by statement&#8217; sets to true the switch_for_call (it switches to group only until the end of the call) and the &#8216;use estimate&#8217; sets switch_estimate to true:<\/p>\n<pre><code>   switch_for_call           IN BOOLEAN  DEFAULT NULL,\n   switch_estimate           IN BOOLEAN  DEFAULT FALSE,<\/code><\/pre>\n<h3>Idle time limits<\/h3>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Screenshot-2016-03-10-13.37.11.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Screenshot-2016-03-10-13.37.11.png\" alt=\"Screenshot 2016-03-10 13.37.11\" width=\"1920\" height=\"1080\" class=\"alignnone size-full wp-image-7382\" \/><\/a><\/p>\n<p>This sets the following time in seconds:<\/p>\n<pre><code>   max_idle_time                IN NUMBER   DEFAULT NULL,\n   max_idle_blocker_time        IN NUMBER   DEFAULT NULL,<\/code><\/pre>\n<h3>What is missing?<\/h3>\n<p>It seems that we cannot set here the limit based on CBO estimation:<\/p>\n<pre><code>   max_est_exec_time         IN NUMBER   DEFAULT NULL,<\/code><\/pre>\n<p>Same for the maximum number of active sessions limit<\/p>\n<pre><code>   active_sess_pool_p1       IN NUMBER   DEFAULT NULL,\n<\/code><\/pre>\n<p>And the transaction undo size limit:<\/p>\n<pre><code>   undo_pool                 IN NUMBER   DEFAULT NULL,\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>By Franck Pachot . You are rather GUI or command line? Let&#8217;s compare what you can do with them when you want to create a Resource Manager plan, and what is missing in the GUI. I&#8217;m using EM13c here on a 12c database. Doc for command line API is here. I&#8217;ll explain what you can&hellip;&nbsp;<\/p>\n","protected":false},"author":27,"featured_media":7272,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4133],"tags":[],"class_list":["post-7267","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.8) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Resource Manager plan from OEM vs. command line - dbi services | 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\/resource-manager-plan-from-oem-vs-command-line\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Resource Manager plan from OEM vs. command line\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . You are rather GUI or command line? Let&#8217;s compare what you can do with them when you want to create a Resource Manager plan, and what is missing in the GUI. I&#8217;m using EM13c here on a 12c database. Doc for command line API is here. I&#8217;ll explain what you can&hellip;&nbsp;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/resource-manager-plan-from-oem-vs-command-line\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services | Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-03-10T14:15:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Capture0041.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1295\" \/>\n\t<meta property=\"og:image:height\" content=\"539\" \/>\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:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\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=\"2 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\\\/resource-manager-plan-from-oem-vs-command-line\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/resource-manager-plan-from-oem-vs-command-line\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/bf7c7eb0bec165183207237c9d0ee1d5\"},\"headline\":\"Resource Manager plan from OEM vs. command line\",\"datePublished\":\"2016-03-10T14:15:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/resource-manager-plan-from-oem-vs-command-line\\\/\"},\"wordCount\":338,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/resource-manager-plan-from-oem-vs-command-line\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/Capture0041.png\",\"articleSection\":[\"Database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/resource-manager-plan-from-oem-vs-command-line\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/resource-manager-plan-from-oem-vs-command-line\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/resource-manager-plan-from-oem-vs-command-line\\\/\",\"name\":\"Resource Manager plan from OEM vs. command line - dbi services | Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/resource-manager-plan-from-oem-vs-command-line\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/resource-manager-plan-from-oem-vs-command-line\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/Capture0041.png\",\"datePublished\":\"2016-03-10T14:15:40+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/resource-manager-plan-from-oem-vs-command-line\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/resource-manager-plan-from-oem-vs-command-line\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/resource-manager-plan-from-oem-vs-command-line\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/Capture0041.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/Capture0041.png\",\"width\":1295,\"height\":539},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/resource-manager-plan-from-oem-vs-command-line\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Resource Manager plan from OEM vs. command line\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"alternateName\":\"dbi Blog\",\"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\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\",\"name\":\"dbi services\",\"alternateName\":\"dbi\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/bf7c7eb0bec165183207237c9d0ee1d5\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/oracle-square.png\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/oracle-square.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/oracle-square.png\",\"caption\":\"Oracle Team\"},\"description\":\"Posts published under the Oracle Team account are collective contributions by the dbi services Oracle consultants. The practice covers the full Oracle Database lifecycle: architecture, migration and upgrade, high availability with RAC and Data Guard, backup and recovery, performance tuning, and engineered systems such as Oracle Database Appliance and Exadata. The team holds Oracle certifications up to Certified Master level and operates customer platforms under service level agreements.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/oracle-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Resource Manager plan from OEM vs. command line - dbi services | 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\/resource-manager-plan-from-oem-vs-command-line\/","og_locale":"en_US","og_type":"article","og_title":"Resource Manager plan from OEM vs. command line","og_description":"By Franck Pachot . You are rather GUI or command line? Let&#8217;s compare what you can do with them when you want to create a Resource Manager plan, and what is missing in the GUI. I&#8217;m using EM13c here on a 12c database. Doc for command line API is here. I&#8217;ll explain what you can&hellip;&nbsp;","og_url":"https:\/\/www.dbi-services.com\/blog\/resource-manager-plan-from-oem-vs-command-line\/","og_site_name":"dbi services | Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2016-03-10T14:15:40+00:00","og_image":[{"width":1295,"height":539,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Capture0041.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/resource-manager-plan-from-oem-vs-command-line\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/resource-manager-plan-from-oem-vs-command-line\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bf7c7eb0bec165183207237c9d0ee1d5"},"headline":"Resource Manager plan from OEM vs. command line","datePublished":"2016-03-10T14:15:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/resource-manager-plan-from-oem-vs-command-line\/"},"wordCount":338,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/resource-manager-plan-from-oem-vs-command-line\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Capture0041.png","articleSection":["Database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/resource-manager-plan-from-oem-vs-command-line\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/resource-manager-plan-from-oem-vs-command-line\/","url":"https:\/\/www.dbi-services.com\/blog\/resource-manager-plan-from-oem-vs-command-line\/","name":"Resource Manager plan from OEM vs. command line - dbi services | Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/resource-manager-plan-from-oem-vs-command-line\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/resource-manager-plan-from-oem-vs-command-line\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Capture0041.png","datePublished":"2016-03-10T14:15:40+00:00","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/resource-manager-plan-from-oem-vs-command-line\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/resource-manager-plan-from-oem-vs-command-line\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/resource-manager-plan-from-oem-vs-command-line\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Capture0041.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Capture0041.png","width":1295,"height":539},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/resource-manager-plan-from-oem-vs-command-line\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Resource Manager plan from OEM vs. command line"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"alternateName":"dbi Blog","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":"Organization","@id":"https:\/\/www.dbi-services.com\/blog\/#organization","name":"dbi services","alternateName":"dbi","url":"https:\/\/www.dbi-services.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bf7c7eb0bec165183207237c9d0ee1d5","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/12\/oracle-square.png","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/12\/oracle-square.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/12\/oracle-square.png","caption":"Oracle Team"},"description":"Posts published under the Oracle Team account are collective contributions by the dbi services Oracle consultants. The practice covers the full Oracle Database lifecycle: architecture, migration and upgrade, high availability with RAC and Data Guard, backup and recovery, performance tuning, and engineered systems such as Oracle Database Appliance and Exadata. The team holds Oracle certifications up to Certified Master level and operates customer platforms under service level agreements.","url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/7267","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=7267"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/7267\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/7272"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=7267"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=7267"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=7267"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}