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