From oracle-l-bounce@freelists.org Wed Apr 21 05:49:23 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i3LAn8707404 for ; Wed, 21 Apr 2004 05:49:18 -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 i3LAmw607377 for ; Wed, 21 Apr 2004 05:49:08 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BB26072C990; Wed, 21 Apr 2004 05:42:01 -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 19509-16; Wed, 21 Apr 2004 05:42:01 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AE46172CA8A; Wed, 21 Apr 2004 05:41:40 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 21 Apr 2004 05:40:22 -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 A94C072C9D4 for ; Wed, 21 Apr 2004 05:40:20 -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 18678-65 for ; Wed, 21 Apr 2004 05:40:20 -0500 (EST) Received: from robeco84.robeco.nl (smtp.robeco.nl [145.61.26.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F0ED272C997 for ; Wed, 21 Apr 2004 05:40:17 -0500 (EST) Received: from rott_mta_1b_2.robeco.nl (robeco.robeco.nl [145.61.28.1]) by robeco84.robeco.nl (Switch-3.0.5/Switch-3.0.0) with ESMTP id i3LApn7v005338 for ; Wed, 21 Apr 2004 12:51:50 +0200 (MEST) Subject: RE: looking for tool to help consolidate Oracle schemas within Or acle instances and Oracle instances on AIX servers To: oracle-l@freelists.org X-Mailer: Lotus Notes Release 5.0.10 March 22, 2002 Message-ID: From: J.Polet@Robeco.nl Date: Wed, 21 Apr 2004 12:51:44 +0200 X-MIMETrack: Serialize by Router on ROTT_MTA_1B_2/Server/Robeco Group(Release 5.0.12 |February 13, 2003) at 21-04-2004 12:51:50 MIME-Version: 1.0 Content-type: text/plain Content-Disposition: inline X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 3427 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: J.Polet@Robeco.nl Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Dennis, It is very interesting to hear that you are tending to go the opposite direction based on your experience. The benefits we are hoping the achieve is easier database management and less hardware resources. We know that management will become complexer when consolidating schemas in instances but we think we can handle that by using the right tools in the right way. In our envirmont we do have same vendor applications with specific Oracle requirements but most of our application are just looking for a set of tables to store their data without extra requirements about the oracle version or oracle features. Even some vendor applications, as a result of their database indepency, are using the database for basic datastore. That is the reason why we think that we can consolidate most of our applications in a minimum number of instances. We are in fact already doing that in some instances for applications for which there are no special requirements and for which there are no risks of conflicts between application schema's as a result of for example usage of public synonyms or user definitions. Our idea is to set up a consolidated database environment consisting of a minimum number of instances running two oracle versions. When an application schema meets our requirements it can be added to this enviroment. If it doesn't meet our requirements it will end up in a dedicated instances and in some cases even on a dedicated UNIX server. The costs for database management in the consolidated environment will be the lowest. This idea can only work when their is a management commitment on all levels, Could that be the reason why this didn't work in your situation? In order to create a stable consolidated database environment we need tools voor monitoring en managing resource usage. Jaco (Embedded image moved to NL Telephone: +31 (0) 10 224 2045 file: pic05705.gif) E-mail: J.Polet@robeco.nl Jaco Polet Corporate ICT/BS DBA DENNIS WILLIAMS CH.COM> cc: Sent by: Subject: RE: looking for tool to help consolidate Oracle schemas within Or acle oracle-l-bounce@fr instances and Oracle instances on AIX servers eelists.org 20-04-2004 15:58 Please respond to oracle-l Jaco What are the benefits you hope to achieve by consolidating schemas within an instance? I can see several potential problems, especially if these are vendor-supported applications. It may be difficult to upgrade to new Oracle versions because different vendors will provide support for a new Oracle version at different times. Another issue is that each schema may support a different group of users, and one group of users may be eager to move to a new Oracle version while another group of users doesn't see this as a priority. After years of trying to consolidate schemas as much as possible, I've tended to go the opposite direction in recent years. Dennis Williams DBA Lifetouch, Inc. dwilliams@lifetouch.com -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of J.Polet@Robeco.nl Sent: Tuesday, April 20, 2004 3: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 -------------------------------------------------------------------------- The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in relation to the contents of this information is strictly prohibited and may be unlawful. Neither the sender nor the represented institution are liable for the correct and complete transmission of the contents of an e-mail, or for its timely receipt. -------------------------------------------------------------------------- ---------------------------------------------------------------- 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 ----------------------------------------------------------------- -- Binary/unsupported file stripped by Ecartis -- -- Type: image/gif -- File: pic05705.gif ---------------------------------------------------------------- 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 -----------------------------------------------------------------