Home » RDBMS Server » Server Administration » Resource Manager (11.1.7.0 Solaris)
Resource Manager [message #532231] Mon, 21 November 2011 11:04 Go to next message
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.
Re: Resource Manager [message #532235 is a reply to message #532231] Mon, 21 November 2011 11:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Resource Manager [message #532236 is a reply to message #532235] Mon, 21 November 2011 11:36 Go to previous messageGo to next message
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.

Re: Resource Manager [message #532237 is a reply to message #532236] Mon, 21 November 2011 11:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Resource Manager [message #532238 is a reply to message #532236] Mon, 21 November 2011 11:42 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: Resource Manager [message #532260 is a reply to message #532240] Mon, 21 November 2011 12:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Resource Manager [message #532448 is a reply to message #532260] Tue, 22 November 2011 13:12 Go to previous messageGo to next message
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;
/

Re: Resource Manager [message #532450 is a reply to message #532448] Tue, 22 November 2011 13:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you read the white paper I pointed you to?

Regards
Michel
Re: Resource Manager [message #532451 is a reply to message #532450] Tue, 22 November 2011 13:26 Go to previous messageGo to next message
BeefStu
Messages: 208
Registered: October 2011
Senior Member
Yes I did but I cant seem to tie that part together
Re: Resource Manager [message #532452 is a reply to message #532451] Tue, 22 November 2011 13:37 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Yes I did but I cant seem to tie that part together
Above is not our problem to solve.

http://search.oracle.com/search/search?start=1&search_p_main_operator=all&q=DBMS_RESOURCE_MANAGER&group=Technology+Networ k
Re: Resource Manager [message #532453 is a reply to message #532451] Tue, 22 November 2011 13:40 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
BeefStu wrote on Tue, 22 November 2011 20:26
Yes I did but I cant seem to tie that part together


Maybe you skipped "Step 3: Create Consumer Groups" and/or "Step 4: Map Sessions to Consumer Groups"...

Regads
Michel

[Updated on: Tue, 22 November 2011 13:40]

Report message to a moderator

Previous Topic: upgrade db 10.2.0.1 to 10.2.0.4 (2 merged)
Next Topic: What can be the maximum size of Data file
Goto Forum:
  


Current Time: Fri Mar 29 01:39:09 CDT 2024