Good to user with Enterprise Manager Cloud Control.
“Oracle Database Resource Manager (the Resource Manager) enables you to manage multiple workloads within a database that are contending for system and database resources.”
“You can examine these statistics using real-time SQL monitoring and the Resource Manager dynamic performance views (the V$RSRC_* views).”
“Oracle Database provides a procedure (CREATE_SIMPLE_PLAN) that enables you to quickly create a simple resource plan.”
Views:
V$SESSION
V$RSRC_* views)
Steps to create a complex plan:
Step 1: Create a pending area.
Step 2: Create, modify, or delete consumer groups.
Step 3: Map sessions to consumer groups.
Step 4: Create the resource plan.
Step 5: Create resource plan directives.
Step 6: Validate the pending area.
Step 7: Submit the pending area.
Step to activate the plan:
— By command :
ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = ‘mydb_plan’;
“You can also activate or deactivate the Resource Manager, or change the current top plan, using the DBMS_RESOURCE_MANAGER.SWITCH_PLAN package procedure or the ALTER SYSTEM statement.”-
You use procedures in the DBMS_RESOURCE_MANAGER PL/SQL package to complete these steps.
Database Administrator’s Guide -> 27 Managing Resources with Oracle Database Resource Manager
Hi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, AI, Programming, Software Engineering, and data in general.
(Continue reading)