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

Thread: Resource manager

  1. #1
    Join Date
    May 2005

    Lightbulb Resource manager

    I have a requirement to limit the resources used by Database users so that I can limit the resource crunch faced by online users when heavy reports are run in our production database. I am planning to create 2 users and each will exclusively handle the report requests and online requests. The report request users must be limited to use 50 percent of the CPU and only 1 GB RAM. Can I achive this through the resource manager. I want the process to run at 50 percent CPU , not to stop when 50 percent is reached. Any help will be greatly appreciated.

  2. #2
    Join Date
    Sep 2002
    yes you can use resource manage to give them a percentage of the cpu and it wont kick them off, just limit them to an amount.

    You cant control memory with resource manager, you could do it with some alter sessions through controlling sort areas and the like.

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