1"use strict";(globalThis.webpackChunkdbmarlin_kb=globalThis.webpackChunkdbmarlin_kb||[]).push([[5881],{94109(e,r,t){t.r(r),t.d(r,{assets:()=>c,contentTitle:()=>o,default:()=>m,frontMatter:()=>a,metadata:()=>s,toc:()=>l});const s=JSON.parse('{"id":"kb/wait-events/oracle/resmgr:become active","title":"resmgr:become active","description":"The session is waiting for a Resource Manager active session slot.","source":"@site/docs/kb/wait-events/oracle/resmgr become active 6b1adf3210fb4260b69a07301196be77.md","sourceDirName":"kb/wait-events/oracle","slug":"/kb/wait-events/oracle/resmgr:become active","permalink":"/docs/kb/wait-events/oracle/resmgr:become active","draft":false,"unlisted":false,"editUrl":"https://www.dbmarlin.com/knowledge-base-suggestion","tags":[],"version":"current","frontMatter":{"id":"resmgr:become active","slug":"resmgr:become active","title":"resmgr:become active","sidebar_label":"resmgr:become active","custom_edit_url":"https://www.dbmarlin.com/knowledge-base-suggestion"},"sidebar":"tutorialSidebar","previous":{"title":"resmgr:I/O rate limit","permalink":"/docs/kb/wait-events/oracle/resmgr:i-o rate limit"},"next":{"title":"resmgr:cpu quantum","permalink":"/docs/kb/wait-events/oracle/resmgr:cpu quantum"}}');var i=t(74848),n=t(28453);const a={id:"resmgr:become active",slug:"resmgr:become active",title:"resmgr:become active",sidebar_label:"resmgr:become active",custom_edit_url:"https://www.dbmarlin.com/knowledge-base-suggestion"},o=void 0,c={},l=[{value:"Detailed Description",id:"detailed-description",level:2},{value:"How to reduce this wait",id:"how-to-reduce-this-wait",level:2},{value:"Additional Links",id:"additional-links",level:2},{value:"Search online",id:"search-online",level:2}];function d(e){const r={a:"a",admonition:"admonition",code:"code",h2:"h2",li:"li",p:"p",strong:"strong",ul:"ul",...(0,n.R)(),...e.components};return(0,i.jsxs)(i.Fragment,{children:[(0,i.jsx)("iframe",{id:"top-banner",src:"https://docs.dbmarlin.com/img/html/top-banner.html",width:"100%",scrolling:"no"}),"\n",(0,i.jsx)(r.admonition,{title:"Short Description",type:"tip",children:(0,i.jsx)(r.p,{children:"The session is waiting for a Resource Manager active session slot."})}),"\n",(0,i.jsx)(r.h2,{id:"detailed-description",children:"Detailed Description"}),"\n",(0,i.jsx)(r.p,{children:"This event occurs when the resource manager is enabled and the number of active sessions in the session's current consumer group exceeds the current resource plan's active session limit for the consumer group."}),"\n",(0,i.jsx)(r.p,{children:"Oracle resource management allows the management of competing workloads within servers and databases. It is used to manage Pluggable Database (PDB) resource consumption within a Container Database (CDB). Control of resources within Maintenance Windows in Oracle is also controlled by the Resource Manager."}),"\n",(0,i.jsx)(r.h2,{id:"how-to-reduce-this-wait",children:"How to reduce this wait"}),"\n",(0,i.jsxs)(r.p,{children:["You may see ",(0,i.jsx)(r.code,{children:"resmgr"})," waits appearing if you have enabled scheduled maintenance window."]}),"\n",(0,i.jsx)(r.p,{children:"To reduce the occurrence of this wait event, review the resource manager configuration to see if you can increase the active session limit for the session's current consumer group."}),"\n",(0,i.jsx)(r.p,{children:"If server resources are not in short supply, look for throttling within the database for CPU, IO or parallel query resources."}),"\n",(0,i.jsx)(r.h2,{id:"additional-links",children:"Additional Links"}),"\n",(0,i.jsxs)(r.ul,{children:["\n",(0,i.jsx)(r.li,{children:(0,i.jsxs)(r.a,{href:"https://docs.oracle.com/en/database/oracle/oracle-database/21/refrn/descriptions-of-wait-events.html#GUID-A331F60C-79FA-44C1-9397-E3C11307A7FB",children:["Oracle Reference Manual - resmgr",":become"," active"]})}),"\n",(0,i.jsx)(r.li,{children:(0,i.jsx)(r.a,{href:"https://docs.oracle.com/en/database/oracle/oracle-database/21/admin/managing-resources-with-oracle-database-resource-manager.html#GUID-2BEF5482-CF97-4A85-BD90-9195E41E74EF",children:"Oracle Administrator's Guide - Managing Resources with Oracle Database Resource Manager"})}),"\n"]}),"\n",(0,i.jsx)(r.h2,{id:"search-online",children:"Search online"}),"\n",(0,i.jsxs)(r.p,{children:["If this article doesn't have the information you need you can try searching online. Remember, you can ",(0,i.jsx)(r.strong,{children:(0,i.jsx)(r.a,{href:"https://www.dbmarlin.com/knowledge-base-suggestion",children:"contribute suggestions to this page"})}),"."]}),"\n",(0,i.jsxs)(r.ul,{children:["\n",(0,i.jsx)(r.li,{children:(0,i.jsxs)(r.a,{href:"https://www.google.com/search?q=oracle+%27resmgr%3Abecome+active%27+wait",children:["Google Search for oracle - resmgr",":become"," active"]})}),"\n",(0,i.jsx)(r.li,{children:(0,i.jsxs)(r.a,{href:"https://www.ecosia.org/search?q=oracle+%27resmgr%3Abecome+active%27+wait",children:["Ecosia Search for oracle - resmgr",":become"," active"]})}),"\n",(0,i.jsx)(r.li,{children:(0,i.jsxs)(r.a,{href:"https://www.bing.com/search?q=oracle+%27resmgr%3Abecome+active%27+wait",children:["Bing Search for oracle - resmgr",":become"," active"]})}),"\n"]}),"\n",(0,i.jsx)("iframe",{id:"bottom-banner",src:"https://docs.dbmarlin.com/img/html/bottom-banner.html",width:"100%",scrolling:"no"})]})}function m(e={}){const{wrapper:r}={...(0,n.R)(),...e.components};return r?(0,i.jsx)(r,{...e,children:(0,i.jsx)(d,{...e})}):d(e)}},28453(e,r,t){t.d(r,{R:()=>a,x:()=>o});var s=t(96540);const i={},n=s.createContext(i);function a(e){const r=s.useContext(n);return s.useMemo(function(){return"function"==typeof e?e(r):{...r,...e}},[r,e])}function o(e){let r;return r=e.disableParentContext?"function"==typeof e.components?e.components(i):e.components||i:a(e.components),s.createElement(n.Provider,{value:r},e.children)}}}]);
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.