Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Sunday, October 4, 2015

Administer Resource Manager using dbconsole:

Administer Resource Manager using dbconsole:

[oracle@collabn1 ~]$ emctl status dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
http://collabn1.shaiksameer:5501/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0.2/SHAIKPROD/collabn1_SHAIKDB/sysman/log


Go to Server → Resource Manager


Delete a PLAN:

Click Plans:






Create Consumer Group:

Go to Server → Resource Manager → Consumer Group:

Delete consumer Group “MEDIUM”




Create Consumer Groups:



Create Groups “LOW” & “MEDIUM”


Create CRITICAL_PLAN & Add the Consumer Groups “CRITICAL”,”MEDIUM”,”LOW” to “CRITICAL_PLAN”

Go to Server → Resource Manager → Plans → Create




Modify CPU %:



Change Parallelism Settings:



Change Session details:



Click “OK”
Summary:

Modify the PLAN to different CPU level:



Assign the consumer groups to the users TEST1 & TEST2:

Before Assignments:
SHAIKDB>SELECT SID,SERIAL#,USERNAME,RESOURCE_CONSUMER_GROUP FROM V$SESSION where username in ('TEST1','TEST2');

no rows selected

SHAIKDB>/

      SID    SERIAL# USERNAME                RESOURCE_CONSUMER_GROUP
---------- ---------- ------------------------------ --------------------------------
   38     2646 TEST1                OTHER_GROUPS
   65     4887 TEST2                OTHER_GROUPS


Map consumer groups to Users:



Regroup/Prioritize the groups for Oracle OS User:




Add consumer group CRITICAL to TEST1:


Add consumer group MIDDLE to TEST2:


Activate the PLAN → CRITICAL_PLAN

 

SHAIKDB>SELECT SID,SERIAL#,USERNAME,RESOURCE_CONSUMER_GROUP FROM V$SESSION where username in ('TEST1','TEST2');

       SID    SERIAL# USERNAME                 RESOURCE_CONSUMER_GROUP
---------- ---------- ------------------------------ --------------------------------
    38     2646 TEST1                 CRITICAL
    65     4887 TEST2                 MEDIUM 


 Documentation:
Oracle® Database PL/SQL Packages and Types Reference --> 116 DBMS_RESOURCE_MANAGER

Oracle® Database Administrator's Guide 11g Release 2 (11.2) -->
26 Managing Resource Allocation with Oracle Database Resource Manager

No comments: