Re: Limiting CPU percentage usage per user
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: chadi@xxxxxxxxxxxxxxxxxx
- Date: Mon, 29 Nov 2004 16:49:14 +0000
On Mon, 29 Nov 2004 10:03:28 -0500, Chadi Kassan
<chadi@xxxxxxxxxxxxxxxxxx> wrote:
> 1- Would anyone please confirm if "database resource manage" comes only with
> Enterprise Edition or can run on Standard Edition ?
EE only I'm about 99% sure, You can check in the 10g docs licensing
guide online at otn. This is an excellent guide to licensing.
> 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)
I don't believe that you can in SE. Do you want to reserve any CPU for
Oracle itself?
--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
