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