On Mon, 29 Nov 2004 10:03:28 -0500, Chadi Kassan
<chadi_at_myvirtualmodel.com> wrote:
> 1- Would anyone please confirm if "database resource manage" comes only with
> Enterprise Edition or can run on Standard Edition ?
>
> 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)
according to the documentation the profile parameter CPU_PER_SESSION
limits the time any session can use expressed in hundreths of a
second. i don't see any option for limiting by percentage.
--
--
Bill "Shrek" Thater ORACLE DBA
shrekdba_at_gmail.com
------------------------------------------------------------------------
I am my beloved's, and my beloved is mine (Song of
Solomon 6:3)
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 29 2004 - 09:09:49 CST
