OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Resource Manager (11.1.7.0 Solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Resource Manager [message #532231]

Mon, 21 November 2011 11:04

BeefStu
Messages: 208
Registered: October 2011

Senior Member

I have a new group "reporting" that will require access to
my database.

However, before I give them access, I need to ensure they can only use a percentage of the database resources and not drag the DB to a halt. I was thinking about using the "resource manager"
and was wondering if anybody had any feedback on this postitive
or negative or is there a better way to go?

In addition, how can I test if a particular plan is really
using UPTO 30% of the CPU.

Report message to a moderator

Re: Resource Manager [message #532235 is a reply to message #532231]

Mon, 21 November 2011 11:14

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The most important thing you have to know about resource manager is that it comes into play ONLY when your total CPU usage is 100%.
Is this your case?

Regards
Michel

Report message to a moderator

Resource Manager [message #532236 is a reply to message #532235]

Mon, 21 November 2011 11:36

BeefStu
Messages: 208
Registered: October 2011

Senior Member

Michel, no I did not know that thanks for pointing it out.

Actually, the requirement is not clear yet and I am trying to
get feedback on what exactly needs to be done. From the sound
of things, it looks like the group I am supporting wants to
prevent the CPU from being pegged at 100% based on all the new
users that will have access to the DB.

Is there some method I can use to prevent this from happening?
I was looking into profiles but dont think meets my requirement
either.

Report message to a moderator

Re: Resource Manager [message #532237 is a reply to message #532236]

Mon, 21 November 2011 11:41

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

CPU is made for being used.
If you don't reach 100% why do you care if someelse will use the rest?
This is why resource manager was not designed to come into play when the CPU usage is less than 100%.

So you can create a resource plan with these new users in a group limited to 30% knowing that there will be limited to this percentage only when your CPU will be overloaded, otherwise they will can take as much as cpu they want.

Regards
Michel

Report message to a moderator

Re: Resource Manager [message #532238 is a reply to message #532236]

Mon, 21 November 2011 11:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>prevent the CPU from being pegged at 100%
why would anyone buy something & decide to NOT use all of it?
It is like putting 16 GB RAM in a system then decide to only ever use 12GB.
Why have idle resources go to waste?
If CPU cycles are not consumed, then they are paid for & simply wasted!

[Updated on: Mon, 21 November 2011 11:43]

Report message to a moderator

Resource Manager [message #532240 is a reply to message #532238]

Mon, 21 November 2011 11:57

BeefStu
Messages: 208
Registered: October 2011

Senior Member

All:
Now that yhou stated the obvious it now makes sense...

Have either of you have experience with resoure manager? Are there things I need to watch out for? Are there ways to see
it's actually working? (queries....)

I am reading through the documentation now and trying to setup
a simple case to test this and familairize myself with this tool.

Thanks for your input.. All the moderators on this
forum really seem to be on top of thier game. You all have
been a big help

Report message to a moderator

Re: Resource Manager [message #532260 is a reply to message #532240]

Mon, 21 November 2011 12:29

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Have either of you have experience with resoure manager? Are there things I need to watch out for?

Is this not what I showed in my last sentence?

Start with Overview of the Database Resource Manager
Then read the links in this section.

You have also the following white paper: Using Oracle Database Resource Manager which detailed an example of use of it.

Regards
Michel

Report message to a moderator

Resource Manager [message #532448 is a reply to message #532260]

Tue, 22 November 2011 13:12

BeefStu
Messages: 208
Registered: October 2011

Senior Member

can somebody point me in the right direction?

BEGIN
  DBMS_RESOURCE_MANAGER.clear_pending_area;
  DBMS_RESOURCE_MANAGER.create_pending_area;

  -- Create a new plan
  DBMS_RESOURCE_MANAGER.create_plan(
    plan    => 'reporting',
    comment => 'Plan suitable for reporting users.');

I have a plan called reporting. Now for all people
who login into the DB as "report" I want to assign them
up 80% of the CPU and for the rest of the users I want 
let them use 100% of the CPU.
  
  DBMS_RESOURCE_MANAGER.create_plan_directive (
    plan             => 'reporting',
    group_or_subplan => '???????',      #### Does a new group or plan go here?
    comment          => 'Give report users lower priority - level 1',
    cpu_p1           => 80);

  DBMS_RESOURCE_MANAGER.create_plan_directive(
    plan             => 'reporting',
    group_or_subplan => 'OTHER_GROUPS',
    comment          => 'all other users - level 2',
    cpu_p2           => 100);

  DBMS_RESOURCE_MANAGER.validate_pending_area;
  DBMS_RESOURCE_MANAGER.submit_pending_area;
END;
/

Report message to a moderator