DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle Resource Manager

  1. #1
    Join Date
    Jan 2001
    Posts
    515

    Oracle Resource Manager

    I have a question about Oracle Resource Manager in 10.2.0.4. We have a server with 4 databases on it. Each one hosts a different application.

    Is it possible to create Resource Plans in each one to only allow each one access to 25% of the CPU? I know I can control the amount of CPU allocated to different groups within one database but I was wondering if I created a main group in each one to have 25% and then subplans under that.

    Has anyon done this before?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    no, you cannot

    you should have one database with 4 schemas in it

  3. #3
    Join Date
    Jan 2001
    Posts
    515

    Thanks Dave

    Thanks for your reply. By the way I think I found a solution if anyone else is interested

    http://download.oracle.com/docs/cd/E...95/dbrm007.htm

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by lesstjm View Post
    Thanks for your reply. By the way I think I found a solution if anyone else is interested

    http://download.oracle.com/docs/cd/E...95/dbrm007.htm
    Nice research. Isn't instance caging an Ora11g feature?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    Quote Originally Posted by lesstjm View Post
    Thanks for your reply. By the way I think I found a solution if anyone else is interested

    http://download.oracle.com/docs/cd/E...95/dbrm007.htm

    well

    1) it's 11g

    2) it's a poor solution because when you want the extra resource for the database, you cannot have it as you have specified a maximum

    the only real solution is one instance with 4 schema so you can control it properly

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width