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