Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Limiting CPU percentage usage per user

RE: Limiting CPU percentage usage per user

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Mon, 29 Nov 2004 16:25:00 +0100
Message-ID: <2CF83791A616BB4DA203FFD13007824A01E6AC7C@MSXVS02.trivadis.com>


Hi=20

>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

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 29 2004 - 09:23:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US