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