RE: Limiting CPU percentage usage per user

  • From: Chadi Kassan <chadi@xxxxxxxxxxxxxxxxxx>
  • To: 'Christian Antognini' <Christian.Antognini@xxxxxxxxxxxx>
  • Date: Mon, 29 Nov 2004 10:29:17 -0500

thanks for your reply, but would please tell me how to do this (point 2) :)



-----Original Message-----
From: Christian Antognini [mailto:Christian.Antognini@xxxxxxxxxxxx]
Sent: Monday, November 29, 2004 10:25 AM
To: chadi@xxxxxxxxxxxxxxxxxx
Cc: ORACLE-L (E-mail)
Subject: RE: Limiting CPU percentage usage per user


Hi 

>1- Would anyone please confirm if "database resource manage" comes only
with
>Enterprise Edition or can run on Standard Edition ?

AFAIK yes.

>2- How can I set a profile for a user in a way that he/she uses only a
>certain
>percentage of the CPU. In other word, I need to have 3 differents profiles
>for 3 differents users
>and need to limit each to cpu usage:
>
>user1 (profile1): 50 % CPU Usage
>user2 (profile2): 30 % CPU Usage
>user2 (profile3): 20 % CPU Usage
>
>we ran standard Edition 10g (linux red had 3)

Basically yes, but be careful, the limitation only works when the CPU is
used at 100%. This means that when user1 is working alone he will be able to
use 100% of the CPU.


Chris
--
//www.freelists.org/webpage/oracle-l

Other related posts: