From oracle-l-bounce@freelists.org Tue Jun 15 08:29:52 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5FDTbH14246 for ; Tue, 15 Jun 2004 08:29:47 -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 i5FDTQ614168 for ; Tue, 15 Jun 2004 08:29:36 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 136AD72C50F; Tue, 15 Jun 2004 08:14:10 -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 08652-66; Tue, 15 Jun 2004 08:14:09 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F269872C24F; Tue, 15 Jun 2004 08:14:08 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 15 Jun 2004 08:12:46 -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 24CB972C049 for ; Tue, 15 Jun 2004 08:12:46 -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 08458-63 for ; Tue, 15 Jun 2004 08:12:46 -0500 (EST) Received: from ahmler3.mail.eds.com (ahmler3.mail.eds.com [192.85.154.74]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id ABF8C72C027 for ; Tue, 15 Jun 2004 08:12:45 -0500 (EST) Received: from ahmlir3.mail.eds.com (ahmlir3-2.mail.eds.com [192.85.154.133]) by ahmler3.mail.eds.com (8.12.10/8.12.10) with ESMTP id i5FDX1Lk026357 for ; Tue, 15 Jun 2004 09:33:03 -0400 Received: from ahmlir3.mail.eds.com (localhost [127.0.0.1]) by ahmlir3.mail.eds.com (8.12.10/8.12.10) with ESMTP id i5FDW9im005107 for ; Tue, 15 Jun 2004 09:32:09 -0400 Received: from USAHM101.amer.corp.eds.com (usahm101.exmi01.exch.eds.com [207.37.138.189]) by ahmlir3.mail.eds.com (8.12.10/8.12.10) with ESMTP id i5FDW9YV005102 for ; Tue, 15 Jun 2004 09:32:09 -0400 Received: by usahm101.exmi01.exch.eds.com with Internet Mail Service (5.5.2657.72) id ; Tue, 15 Jun 2004 09:32:09 -0400 Message-ID: <564DE4477544D411AD2C00508BDF0B6A1CE0AB8C@usahm018.exmi01.exch.eds.com> From: "Powell, Mark D" To: "'oracle-l@freelists.org'" Subject: RE: SAP Reorgs Date: Tue, 15 Jun 2004 09:32:07 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2748 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mark.powell@eds.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org The version 8 DB2 UDB manual and the SQL Server 2000 training materials I have been using both recommend object reorganization for performance purposes. The emphasis is on index reorganizations and in a multi-database organization what is a good idea in one db may seem to be a good idea in the others. There is no substitute for in-depth knowledge of your tool set, but knowledge takes time to accumulate and it can be an uphill battle to convince co-workers to change procedures. IMHO -- Mark D Powell -- -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Michael Fontana Sent: Monday, June 14, 2004 5:28 PM To: oracle-l@freelists.org Subject: RE: SAP Reorgs Because of what are mainly RDBMS architectural differences, SAP recommends frequent reorgs, and even offers programs to do so, for their DB2 implementations. When I was a db2/Oracle database consultant for a major oil company, the manager of the group read a document by SAP and IBM recommending frequent reorgs. Because of that fact, to this day, my comrades at this company spend one full weekend a month reorging the Oracle implementations of SAP, even though, in fact, the vendor does not specifically recommend it for Oracle, nor do they measure to determine if they receive any gains from the exercise. I think this falls amound the category of "urban legend" - that a Reorg of all tablespaces will actually help SAP Oracle performance has never been proved. Michael Fontana Sr. DBA NTT/Verio ---------------------------------------------------------------- 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 -----------------------------------------------------------------