10g (linux red had 3) I passed all over this but i think resource manager is not supported in Standard edition. what about the profiles ?? thanks -----Original Message----- From: Carel-Jan Engel [mailto:cjpengel.dbalert@xxxxxxxxx] Sent: Friday, November 26, 2004 4:13 PM To: chadi@xxxxxxxxxxxxxxxxxx Cc: ORACLE-L (E-mail) Subject: Re: CPU % usage per user What's your version? It's not as simple as just slicing your CPU. Some background knowledge might help you. Take a tour through the concepts quide. E.g. for 9.2: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c10rsmgr .htm Best regards, Carel-Jan Engel === If you think education is expensive, try ignorance. (Derek Bok) === On Fri, 2004-11-26 at 21:59, Chadi Kassan 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 > 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 > > > Thanks alot. > -- > //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l