From oracle-l-bounce@freelists.org Tue Apr 20 08:48:05 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i3KDm5327500 for ; Tue, 20 Apr 2004 08:48:05 -0500 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 i3KDm5627495 for ; Tue, 20 Apr 2004 08:48:05 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DCD9F72DA0A; Tue, 20 Apr 2004 08:38: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 28289-37; Tue, 20 Apr 2004 08:38:26 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B4EE572DA2A; Tue, 20 Apr 2004 08:35:16 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 20 Apr 2004 08:33:59 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5776D72D957 for ; Tue, 20 Apr 2004 08:33:58 -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 27243-89 for ; Tue, 20 Apr 2004 08:33:57 -0500 (EST) Received: from smtpgate.vicr.com (smtpgate.vicr.com [207.141.187.5]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4339972D809 for ; Tue, 20 Apr 2004 08:31:17 -0500 (EST) Received: from 25exch1.vicorpower.vicr.com ([172.20.20.30]) by exchgate.vicorpower.vicr.com with Microsoft SMTPSVC(5.0.2195.5329); Tue, 20 Apr 2004 09:42:42 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Subject: RE: looking for tool to help consolidate Oracle schemas within Oracle instances and Oracle instances on AIX servers Date: Tue, 20 Apr 2004 09:42:42 -0400 Message-ID: <4001DEAF7DF9BD498B58B45051FBEA6506D98B@25exch1.vicorpower.vicr.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: looking for tool to help consolidate Oracle schemas within Oracle instances and Oracle instances on AIX servers Thread-Index: AcQmsI2NXeeoBiQsQg+CM3eH1EGu9QAK0NIQ From: "Goulet, Dick" To: X-OriginalArrivalTime: 20 Apr 2004 13:42:42.0490 (UTC) FILETIME=[5AB8B9A0:01C426DD] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 3393 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: DGoulet@vicr.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Jaco, Unless your application forces everyone using data from a particular = schema to log on as that schema Resource Manager is not going to help = you. Resource Manager is based on who you logged onto the database as. = Wish it worked otherwise since it could then help us with PeopleSoft. = But since everyone using PeopleSoft connects to the database as the = PeopleSoft owner, we're stuck. Also, most of the tools in this area today set an upper limit which = under normal circumstances a process/user should not exceed. Problem is = that when a user/process starts up these tools acquire a snapshot of how = the system/instance is loaded & then allow the user/process to run with = that. Therefore, even though you don't want a specific user to exceed = 25% utilization of the system, they will on occasion exceed that by a = significant amount & the software is somewhat slow at adjusting them = back down, because it may well be just a "spurt" that goes away by = itself. Therefore adjust your expectations accordingly. OEM's Performance pack will provide you insight into how much resources = a schema is using from a particular instance. IBM should have some = performance management stuff, or else you can acquire it from CA(yeah, I = know bad thing to say). You want to measure instances against each = other, and schema's against each other within an instance. Don't try = crossing schema's between instances, you'll get only odd results, mostly = bad. (BTDT) Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -----Original Message----- From: J.Polet@Robeco.nl [mailto:J.Polet@Robeco.nl] Sent: Tuesday, April 20, 2004 4:21 AM To: oracle-l@freelists.org Subject: looking for tool to help consolidate Oracle schemas within Oracle instances and Oracle instances on AIX servers Hi all, I am currently working on a consolidation project. Within this project we want to consolidate Oracle schemas within Oracle 8.1.7.4/ 10g instances and Oracle instances on AIX 5.2 servers. We see 3 potential problems: 1. How do we prevent instances and schema's influencing each others performance? 2. How do we determine which schemas can be consolidated within the same instance from a resource usage point of view? 3. How do we determine which instances can be consolidated on the same server from a resource usage point of view? To address our first problem we are looking at the Oracle Resource = Manager for controlling the resource usage of schemas within the same instance = and AIX Workload Manager to control resource usage of instances on the same server. For our second and third problem we want to create a shortlist of 3 (combination of) tools to evaluate which should be able to: - Measure the usage of instance resources like buffer cache, redo/undo blocks, open cursors etc. on a schema level. - Measure the available instance resources within an instance - Measure the usage of server resources (CPU, Memory, Disk IO, Network = IO) on a schema level and on an instance level. - Measure the available server resources within a server Does anyone has an idea of which (combination of) tools I should put on this shortlist? Thanks... Jaco = -------------------------------------------------------------------------= -=20 The information contained in this communication is confidential and may = be=20 legally privileged. It is intended solely for the use of the individual = or=20 entity to whom it is addressed and others authorised to receive it. If = you=20 are not the intended recipient you are hereby notified that any = =20 disclosure, copying, distribution or taking any action in relation to = the =20 contents of this information is strictly prohibited and may be = unlawful. =20 Neither the sender nor the represented institution are liable for the = =20 correct and complete transmission of the contents of an e-mail, or for = its=20 timely receipt. = =20 = -------------------------------------------------------------------------= -=20 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------