{"id":5204,"date":"2015-08-23T19:23:40","date_gmt":"2015-08-23T17:23:40","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/"},"modified":"2015-08-23T19:23:40","modified_gmt":"2015-08-23T17:23:40","slug":"configure-the-resource-manager-with-sql-developer","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/","title":{"rendered":"Configure the Resource Manager with SQL Developer"},"content":{"rendered":"<h2>By Franck Pachot<\/h2>\n<p>.<br \/>\nYes, the topics for the OCM 12c upgrade are <a href=\"https:\/\/education.oracle.com\/pls\/web_prod-plq-dad\/db_pages.getpage?page_id=5001&amp;get_params=p_exam_id:12COCMU\" title=\"OCM 12c upgrade\">online<\/a> and I&#8217;m already looking at the topics. I&#8217;m talking about the &#8216;Configure the Resource Manager&#8217; one here. Configuring Resource Manager in commandline is not easy. At the OCM exam you can do things faster when you have a GUI. Of course, you need to know where to find the command line API in case no GUI is available. In 11g, even if no Cloud Control is set up, you can install the dbconsole which can be used to configure Resource manager. But in 12c, there&#8217;s no dbconsole and EM Express don&#8217;t that that feature. But in the Oracle Home, you have SQL Developer (version 3.2 in the 12.1.0.2 installation).<br \/>\n<!--more--> <\/p>\n<p>The feature is in the &#8216;DBA&#8217; view of SQL Developer. Let&#8217;s show a quick example.<\/p>\n<h1>Consumer Groups<\/h1>\n<p>Consumer groups are users sessions that are grouped together based on resource processing requirements. Each Consumer Group definition specifies the users and roles that are allowed to switch into this Consumer Group.<\/p>\n<p>You can create one with the &#8216;Create new&#8217; action:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-001.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-001.jpg\" alt=\"Capture12COCMU-ResourceManager-001\" width=\"300\" height=\"154\" class=\"alignnone size-medium wp-image-3085\" \/><\/a><\/p>\n<p>round robin scheduler distribute resources equally. &#8216;run-to-completion&#8217; is to schedule long sessions ahead.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-002.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-002.jpg\" alt=\"Capture12COCMU-ResourceManager-002\" width=\"300\" height=\"145\" class=\"alignnone size-medium wp-image-3086\" \/><\/a><\/p>\n<p>don&#8217;t hesitate to look at the &#8216;SQL&#8217; tab to see the generated statement.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-003.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-003.jpg\" alt=\"Capture12COCMU-ResourceManager-003\" width=\"300\" height=\"182\" class=\"alignnone size-medium wp-image-3084\" \/><\/a><\/p>\n<p>Of course, you can copy-paste the code to a script in case you need to re-run everything quickly later.<\/p>\n<pre><code>\nBEGIN\n    DBMS_RESOURCE_MANAGER.CLEAR_PENDING_AREA();\n    DBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA();\n    DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP(\n        CONSUMER_GROUP =&gt; 'SmartUsers',\n        COMMENT =&gt; 'this is the group for users I find very smart',\n        CPU_MTH =&gt; 'ROUND-ROBIN');\n    DBMS_RESOURCE_MANAGER.SUBMIT_PENDING_AREA();\nEND;\n<\/code><\/pre>\n<p>And here is my &#8216;SMARTUSERS&#8217; group created:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-004.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-004.jpg\" alt=\"Capture12COCMU-ResourceManager-004\" width=\"300\" height=\"68\" class=\"alignnone size-medium wp-image-3089\" \/><\/a><\/p>\n<h1>Resource plans directive<\/h1>\n<p>I&#8217;ll use the DEFAULT plan. <\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-005.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-005.jpg\" alt=\"Capture12COCMU-ResourceManager-005\" width=\"300\" height=\"95\" class=\"alignnone size-medium wp-image-3091\" \/><\/a><\/p>\n<p>At level 1 it reserves 90% of resource for SYS_GROUPAt level 2 I&#8217;ll give and add a group directive to give 80% for my smart users<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-006.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-006.jpg\" alt=\"Capture12COCMU-ResourceManager-006\" width=\"300\" height=\"146\" class=\"alignnone size-medium wp-image-3093\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-007.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-007.jpg\" alt=\"Capture12COCMU-ResourceManager-007\" width=\"300\" height=\"199\" class=\"alignnone size-medium wp-image-3092\" \/><\/a><\/p>\n<p>So I add a group directive and allow 80 to my smart users in level 2. Here is the result:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-007a.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-007a.jpg\" alt=\"Capture12COCMU-ResourceManager-007a\" width=\"300\" height=\"70\" class=\"alignnone size-medium wp-image-3105\" \/><\/a><\/p>\n<h1>Consumer group mapping<\/h1>\n<p>Now I have to map sessions to groups. Here I add the BI user to my SMARTUSERS group.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-010.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-010.jpg\" alt=\"Capture12COCMU-ResourceManager-010\" width=\"300\" height=\"230\" class=\"alignnone size-medium wp-image-3103\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-011.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-011.jpg\" alt=\"Capture12COCMU-ResourceManager-011\" width=\"300\" height=\"143\" class=\"alignnone size-medium wp-image-3102\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-012.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-012.jpg\" alt=\"Capture12COCMU-ResourceManager-012\" width=\"300\" height=\"128\" class=\"alignnone size-medium wp-image-3101\" \/><\/a><\/p>\n<p>I can add other users like this:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-013.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-013.jpg\" alt=\"Capture12COCMU-ResourceManager-013\" width=\"300\" height=\"124\" class=\"alignnone size-medium wp-image-3100\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-014.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-014.jpg\" alt=\"Capture12COCMU-ResourceManager-014\" width=\"300\" height=\"171\" class=\"alignnone size-medium wp-image-3099\" \/><\/a><\/p>\n<h1>Active Plan<\/h1>\n<p>Now, I&#8217;m currently in the maintenance window. I have to make the DEFAULT plan active in order to test it.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-015.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-015.jpg\" alt=\"Capture12COCMU-ResourceManager-015\" width=\"300\" height=\"254\" class=\"alignnone size-medium wp-image-3098\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-016.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-016.jpg\" alt=\"Capture12COCMU-ResourceManager-016\" width=\"300\" height=\"159\" class=\"alignnone size-medium wp-image-3097\" \/><\/a><\/p>\n<p>My new plan is now active, leaving 80% of CPU for SYS and 90% of the remaining for my BI, HR and IX users. When the system is busy with all those users, only the remaining 20% of the remaining 10% will be available to other users.<\/p>\n<h1>Statistics<\/h1>\n<p>In order to show the result, and the graphs that are provided in SQL Developer, I&#8217;ll run a CPU bound session with the following users:<\/p>\n<ul>\n<li>from 22:58 to 23:08 : BI (belongs to SMARTUSERS)\n<\/li>\n<li>from 22:59 to 23:02 : SYS (belongs to SYS_GROUP)\n<\/li>\n<li>from 23:00 to 23:16 : DEMO (belongs to OTHER_GROUPS)\n<\/li>\n<\/ul>\n<p>Let&#8217;s check the CPU consumption:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-018.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-018.jpg\" alt=\"Capture12COCMU-ResourceManager-018\" width=\"300\" height=\"141\" class=\"alignnone size-medium wp-image-3095\" \/><\/a><\/p>\n<p>Here we see that SYS had most of the resources. When SYS job has finished then BI was able to use most of the resources. Other user were limited.<\/p>\n<p>We can check the sessions who had to wait:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-019.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-019.jpg\" alt=\"Capture12COCMU-ResourceManager-019\" width=\"300\" height=\"144\" class=\"alignnone size-medium wp-image-3094\" \/><\/a><\/p>\n<p>Waiting for SYS was always limited. SMARTUSERS had to wait while SYS was running, and then had most of the resources<\/p>\n<h1>Resource Manager<\/h1>\n<p>Resource Manager is clearly a feature that is under-used. If you are in Enterprise Edition, you should use it. No need to build complex plans. Simple plans can allow some group of users to connect to production without taking the risk to exhaust all resources. In my opinion, every OLTP database should have a plan that gives priority to the application. Then you can allow some developers to query on it with a lower priority.<\/p>\n<p>It&#8217;s easy to set from Cloud Control or SQL Developer. Of course, better to use the latest <a href=\"http:\/\/www.oracle.com\/technetwork\/developer-tools\/sql-developer\/downloads\/index.html\">SQLDev<\/a>.<\/p>\n<p>If you don&#8217;t have access to any GUI and have documentation without search box, the documentation is in <a href=\"\/ORADOC\/E50529_01\/ADMIN\/dbrm.htm#i1010776\">Administrator&#8217;s Guide \/ Managing Resources with Oracle Database Resource Manager<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>By Franck Pachot . Yes, the topics for the OCM 12c upgrade are online and I&#8217;m already looking at the topics. I&#8217;m talking about the &#8216;Configure the Resource Manager&#8217; one here. Configuring Resource Manager in commandline is not easy. At the OCM exam you can do things faster when you have a GUI. Of course, [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":5222,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,59],"tags":[607,96,609],"type_dbi":[],"class_list":["post-5204","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-oracle","tag-ocm","tag-oracle","tag-sqldeveloper"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Configure the Resource Manager with SQL Developer - dbi Blog<\/title>\n<meta name=\"description\" content=\"Configure the Resource Manager with SQL Developer\" \/>\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\/configure-the-resource-manager-with-sql-developer\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Configure the Resource Manager with SQL Developer\" \/>\n<meta property=\"og:description\" content=\"Configure the Resource Manager with SQL Developer\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-08-23T17:23:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-003-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"661\" \/>\n\t<meta property=\"og:image:height\" content=\"401\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"3 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\/configure-the-resource-manager-with-sql-developer\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Configure the Resource Manager with SQL Developer\",\"datePublished\":\"2015-08-23T17:23:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/\"},\"wordCount\":625,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-003-1.jpg\",\"keywords\":[\"OCM\",\"Oracle\",\"SQLDeveloper\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/\",\"name\":\"Configure the Resource Manager with SQL Developer - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-003-1.jpg\",\"datePublished\":\"2015-08-23T17:23:40+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"Configure the Resource Manager with SQL Developer\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-003-1.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-003-1.jpg\",\"width\":661,\"height\":401},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Configure the Resource Manager with SQL Developer\"}]},{\"@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":"Configure the Resource Manager with SQL Developer - dbi Blog","description":"Configure the Resource Manager with SQL Developer","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\/configure-the-resource-manager-with-sql-developer\/","og_locale":"en_US","og_type":"article","og_title":"Configure the Resource Manager with SQL Developer","og_description":"Configure the Resource Manager with SQL Developer","og_url":"https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/","og_site_name":"dbi Blog","article_published_time":"2015-08-23T17:23:40+00:00","og_image":[{"width":661,"height":401,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-003-1.jpg","type":"image\/jpeg"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Configure the Resource Manager with SQL Developer","datePublished":"2015-08-23T17:23:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/"},"wordCount":625,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-003-1.jpg","keywords":["OCM","Oracle","SQLDeveloper"],"articleSection":["Database Administration &amp; Monitoring","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/","url":"https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/","name":"Configure the Resource Manager with SQL Developer - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-003-1.jpg","datePublished":"2015-08-23T17:23:40+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"Configure the Resource Manager with SQL Developer","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-003-1.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture12COCMU-ResourceManager-003-1.jpg","width":661,"height":401},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/configure-the-resource-manager-with-sql-developer\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Configure the Resource Manager with SQL Developer"}]},{"@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\/5204","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=5204"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5204\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/5222"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=5204"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=5204"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=5204"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=5204"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}