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

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

****************I am authoring a Book on Oracle Database Cloud Services.......More details to follow.***************

Title : Oracle Database Cloud Revealed
Publisher : Apress
Release Date : Jan-2019

**********************************************************************************


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]


My Cloud Certifications:

AWS Certified Solutions Architect Associate

Oracle Cloud Infrastructure 2018 Certified Architect Associate.

Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.

Oracle Database Cloud Administrator Certified Professional.

Oracle Database Cloud Service Operations Certified Associate.

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: