From oracle-l-bounce@freelists.org Fri Nov 26 15:06:06 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iAQL66A25531 for ; Fri, 26 Nov 2004 15:06:06 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id iAQL66x25526 for ; Fri, 26 Nov 2004 15:06:06 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EC9C672C608; Fri, 26 Nov 2004 16:12:26 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 24708-65; Fri, 26 Nov 2004 16:12:26 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 47E5E72C5D5; Fri, 26 Nov 2004 16:12:20 -0500 (EST) Subject: Re: CPU % usage per user From: Carel-Jan Engel To: chadi@myvirtualmodel.com Cc: "ORACLE-L (E-mail)" In-Reply-To: <2C605DDCFE30504F82EB1DE0A5EB981E1175B3@ntexccrp01.mvm.com> References: <2C605DDCFE30504F82EB1DE0A5EB981E1175B3@ntexccrp01.mvm.com> Content-type: text/plain Organization: DBA!ert Message-Id: <1101503576.6918.17.camel@dbalert199.dbalert.nl> Mime-Version: 1.0 Date: Fri, 26 Nov 2004 22:12:56 +0100 Content-Transfer-Encoding: 8bit X-archive-position: 12824 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: cjpengel.dbalert@xs4all.nl Precedence: normal Reply-To: cjpengel.dbalert@xs4all.nl X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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. > -- > http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l