Received: (qmail 13990 invoked from network); 13 Oct 2011 16:14:25 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.ip-pool.com with SMTP; 13 Oct 2011 16:14:16 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AA385E4A9C4; Thu, 13 Oct 2011 17:14:13 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1318540453; bh=aG1n6zSm/uCz56Xm5g5DjkS38wSqzUdX0o5Nj4LM q3Q=; h=Message-ID:Content-type:From:To:Subject:Date:MIME-Version: Content-Transfer-Encoding:Sender:Reply-To:List-help: List-unsubscribe:List-Id:List-subscribe:List-owner:List-post: List-archive; b=BlzULM846u0jGUTyT2T/CLxr4HUVlqfEk7Pp1eD71bbgHIG7cE 3QL7E4VWpcItwwM+yla4A6vSeq07ltb1thE2CKMN4KiixXQ8zAqZi+OosRoayCZk+E5 51x1Gb+kaGdgX5cfne72gZcef0j9awsAnJeQ6/fRZqwlcfYYTCO9UI= X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id WhXkCACwvGnD; Thu, 13 Oct 2011 17:14:13 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A2026E4A94A; Thu, 13 Oct 2011 17:13:29 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 13 Oct 2011 17:12:47 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 851DAE4A989 for ; Thu, 13 Oct 2011 17:12:47 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id sMu4dpCr+Skz for ; Thu, 13 Oct 2011 17:12:47 -0400 (EDT) Received: from blu0-omc4-s7.blu0.hotmail.com (blu0-omc4-s7.blu0.hotmail.com [65.55.111.146]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4F455E4A987 for ; Thu, 13 Oct 2011 17:12:46 -0400 (EDT) Received: from BLU129-W12 ([65.55.111.136]) by blu0-omc4-s7.blu0.hotmail.com with Microsoft SMTPSVC(6.0.3790.4675); Thu, 13 Oct 2011 14:12:46 -0700 Message-ID: Content-type: text/plain X-Originating-IP: [67.191.183.246] From: Upendra N To: Oracle-L Subject: What is the best way to estimate capacity? Date: Thu, 13 Oct 2011 17:12:45 -0400 MIME-Version: 1.0 X-OriginalArrivalTime: 13 Oct 2011 21:12:46.0708 (UTC) FILETIME=[DB0A6340:01CC89EC] Content-Transfer-Encoding: 8bit X-archive-position: 39268 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: nupendra@hotmail.com Precedence: normal Reply-To: nupendra@hotmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l Hello all, If a server is running multiple databases (ranges from 8.1.7.4 to 10.2). Is there a way to estimate the CPU capacity that are used by each of the database which will relate to the OS system load? We do have AWR (tuning/diagnostic packs) for 10.2 databases, but we may have to rely on other methods for 8i databases. I'm trying to arrive at something like this: Database-1 = 30% Database-2 = 20% Database-3 = 10% Database-4 = 40% The hardware platform is Sun Sparc Solaris 9. I'm trying to relocate a few databases to newer platform. With the move I'd like to recoup some of the Oracle licenses by reducing CPU capacity (turning the CPUs off or physically pull them out ) on the legacy servers. Your suggestions are greatly appreciated. Thanks -Upendra -- http://www.freelists.org/webpage/oracle-l