[OCM 12C] Configuring the Resource Manager

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

Related posts

Leave a Comment