10gocm->session5-> Database Management Experiment-> Introduction to GC Resource Manager resource consumption group

Source: Internet
Author: User
Tags sessions

The GC Explorer
Official document: Administrator ' s guide->24 Using the Database Resource Manager
Usage: Less used in the actual production environment
Action: Restrict the use of database resources. CPU Undo Table Space IO session
Occasions: When there are multiple apps using a database and resources are strained, you can use the Explorer to adjust
Implementation: can be completed using the GC can also be finished with EM. can also use the package to complete
UI way: Simple, fast, not easy error
Commend mode: Set complex, command very long. High failure rate. Dbms_resource_manager_privs Package Processing
Requirements:
1. Define 2 resource consumption groups (OLTP transaction resource consumption Group and DSS data Warehouse resource consumption group)
2. Create a Schedule plan schedule
3. For OLTP resource consumption groups. We cannot have more than 50 active sessions at most. Assuming that there are more than 50 active sessions, then you should abort 120 seconds before requesting
4. For DSS resource consumption groups, we cannot exceed the maximum number of 10 active sessions, assuming that more than 10 active sessions should be aborted for 300 seconds before requesting
5. Set up an OLTP DSS other_groups 3 Group CPU hit rates of 50% 30% 20% respectively
6.DSS resource consumption group with a maximum degree of parallelism of 20
7. The time to query a DML statement for an OLTP session cannot exceed 100 seconds
8. Specify the instance default schedule "schedule Schedule" activation


Experiment
Declaration: OLTP Transaction Resource Consumption Group
DSS Data Warehouse resource consumption group
Other_groups Other resource consumption groups
Different resource consumption Group Policies
Log in GC input Sysman passwordoracle1216
Ocm01->administration->consumer group-> Input Syspasswordsys Login
CREATE->OLTP resource Consumption Group, click Add to join OCM01 user will check box selected, click OK to
CREATE->DSS resource Consumption Group, click Add to join ocm0102 user to select the check box. Click OK to


Database instance:ocmdb > Object type:resource plan->create-> a plan name Schedule_plan
Click Modify to join Consumer Groups (OLTP and DSS)
Leo1->administration->plans Creating a Schedule plan




Session Pool 10 300
50 120


In the General option, level 30 50 20


Setting DSS parallelism in the parallelism option 20


Setting the "Max Idle time" setting in the "idle" option limits the OLTP session to query a DML statement for no more than 100 seconds


General, select "Activate this plan", apply activation can be, click OK to create complete

Summary of self-OCM experiment selection and talk


"Log in GC"

"Click Targets"

"Click Databases->ocmdb"

"Click Administration->resource manager->consumer Groups"

watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvqmlzyw5xyw5nu2hpsmll/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma== /dissolve/70/gravity/center ">

"Input Sysusernamepassword"

"Click Create to join the resource user group"

"Join DSS, and OLTP resource user group"

"Join a user for a resource user group"

"Click on select after Tick"


"Click OK"

"Click Resource Manager->plans to join the program"

"Click Create to join the program"

"Join the program"

--==

No

Plan:schedule_plan

Description:schedule_plan

A second option tick

--==

Select a resource user group for the schedule

"Set up OLTP DSS other_groups 3-group CPU hit rate 50% 30% 20%, respectively"

"Click Edit"

"Maximum degree of parallelism for DSS resource consumption group is 20"

"The time to query a DML statement for an OLTP session cannot exceed 100 seconds"

"Click General->activate this Plan activation program"

watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvqmlzyw5xyw5nu2hpsmll/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma== /dissolve/70/gravity/center ">

"Click Apply"

Finished

watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvqmlzyw5xyw5nu2hpsmll/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma== /dissolve/70/gravity/center ">

Copyright notice: This article blog original article. Blogs, without consent, may not be reproduced.

10gocm->session5-> Database Management Experiment-> Introduction to GC Resource Manager resource consumption group

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.