| oracle resource plan [message #251388] |
Fri, 13 July 2007 07:10  |
majid tahir
Messages: 39
Registered: July 2007
Location: Pakistan
|
Member |
|
|
Dear ALL,
Anyone plz help me to oracle resource manager plan, I have created a plan but it is not working according to my requirement. any example script. I have to use it for single PC. when i run a script it always consume 100% CPU, I have to minimize this thing using reource plan. This is NOT very urgent, so please take your time.
I shall be very thankful to you
Thanks
[Updated on: Fri, 13 July 2007 07:57] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
| Re: oracle resource plan [message #251683 is a reply to message #251478] |
Mon, 16 July 2007 01:29  |
majid tahir
Messages: 39
Registered: July 2007
Location: Pakistan
|
Member |
|
|
The plan that i create is
EXEC DBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA;
EXEC DBMS_RESOURCE_MANAGER.CREATE_PLAN (PLAN => 'BOND', COMMENT => 'JAMES BOND');
EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GROUP =>'RED EYE',COMMENT => 'G1');
EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GROUP =>'BLUE EYE',COMMENT => 'G2');
EXECUTE DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE (plan =>'BOND', group_or_subplan =>'RED EYE',comment =>'G1', cpu_p1 =>50,cpu_p2=>0, parallel_degree_limit_p1 =>12);
EXECUTE DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE (plan =>'BOND', group_or_subplan =>'BLUE EYE', comment =>'G2', cpu_p1 =>0,cpu_p2=>50, parallel_degree_limit_p1 =>6);
EXECUTE DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE (plan =>'BOND', group_or_subplan =>'OTHER_GROUPS', comment =>'THIS IS DEFAULT', cpu_p1 =>0,cpu_p2=>0,cpu_p3=>100);
EXEC DBMS_RESOURCE_MANAGER.VALIDATE_PENDING_AREA;
EXEC DBMS_RESOURCE_MANAGER.SUBMIT_PENDING_AREA;
BEGIN
DBMS_RESOURCE_MANAGER.SET_CONSUMER_GROUP_MAPPING
(DBMS_RESOURCE_MANAGER.ORACLE_USER, 'scott', 'RED EYE');
END;
Plz identify mistake in the plan
|
|
|
|
|
|
|
|
|
|
|
|
| Re: oracle resource plan [message #251744 is a reply to message #251696] |
Mon, 16 July 2007 08:10 |
majid tahir
Messages: 39
Registered: July 2007
Location: Pakistan
|
Member |
|
|
I am using 10G. Now I want that when I map a group with user e.g. (scott). it will not cross 50% cpu.
75% is my requirement but I want to check it using different scenarios. I have map the scott with group Red Eye which is using 50%. but when i run a heavy querey it reaches 100%
thanks
|
|
|
|
| Re: oracle resource plan [message #251747 is a reply to message #251744] |
Mon, 16 July 2007 08:40 |
 |
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
If you don't want it exceeds 50% you have to put him in a group with 50% with concurrent groups for the other 50% or in a lower priority group.
You have to define the other groups and their priority and resource consumption. You can't just say I want this user consumes less than 50% of CPU.
Resource manager is a global policy.
Regards
Michel
[Updated on: Mon, 16 July 2007 08:44] Report message to a moderator |
|
|
|
| Re: oracle resource plan [message #251808 is a reply to message #251747] |
Mon, 16 July 2007 13:21 |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
Somehow I have the feeling, this whole thread boils down to Michel's first reply..
Do you think your server is used too heavily? Is that the reason for the plans? You want Oracle only to use max 50% of the server's cpu?
|
|
|
|
| Re: oracle resource plan [message #251887 is a reply to message #251808] |
Tue, 17 July 2007 01:47 |
majid tahir
Messages: 39
Registered: July 2007
Location: Pakistan
|
Member |
|
|
Dear Frank
We have hundreds of data entry transactions that continuously use the db server. So the server is used too heavily that other application stop responding. I need to create a plan. Can u send me any sample or a file that help me.
|
|
|
|
| Re: oracle resource plan [message #251889 is a reply to message #251747] |
Tue, 17 July 2007 01:54 |
majid tahir
Messages: 39
Registered: July 2007
Location: Pakistan
|
Member |
|
|
|
Could u plz give any example to clear ur point. Where can i set the priority according to my knowledge its a procedure provided by oracle in which we map priorities. Did u mean that
|
|
|
|
|
|
|
|
|
|
| Re: oracle resource plan [message #251916 is a reply to message #251905] |
Tue, 17 July 2007 02:39 |
majid tahir
Messages: 39
Registered: July 2007
Location: Pakistan
|
Member |
|
|
|
The Resource Manager well suit in our environment. I want to restrict oracle process for each group at application level to 50%. No matter what the user wishes. its our internal process or policy.
|
|
|
|
|
|
| Re: oracle resource plan [message #251943 is a reply to message #251927] |
Tue, 17 July 2007 04:00 |
majid tahir
Messages: 39
Registered: July 2007
Location: Pakistan
|
Member |
|
|
Well I have created two groups but they are consuming full 100% cpu.
As far as Resource Manager is concern I have a very clear concept of Resource Manager. I told you that I want to check the cpu utilization by making different resource limit such as (50%,70% etc). Before implementing it on the real database server I want to check different scenarios whether it works or not. I think u not clearly understand my problem.
Plz see my plan again that i post and guide me accordingly
regards
Majid
|
|
|
|
|
|
| Re: oracle resource plan [message #251954 is a reply to message #251950] |
Tue, 17 July 2007 04:20 |
majid tahir
Messages: 39
Registered: July 2007
Location: Pakistan
|
Member |
|
|
I think u mind it. Ok very fine I say sorry but try to understand my problem, I want to implement a plan, thats why I post it because I am facing problems
regards
Majid
|
|
|
|
|
|
|
|
| Re: oracle resource plan [message #252158 is a reply to message #252156] |
Wed, 18 July 2007 00:52 |
|
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
It is useless FOR YOUR CASE.
Not useless in general (although...).
And for the question why Oracle add something. It is more a marketing question.
For myself, I ask why Oracle delivers new features when it did not still fix the known bugs.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
