From oracle-l-bounce@freelists.org Wed Jul 7 17:18:48 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i67MINh02050 for ; Wed, 7 Jul 2004 17:18:33 -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 i67MID602027 for ; Wed, 7 Jul 2004 17:18:23 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DDC0C72C486; Wed, 7 Jul 2004 16:59:34 -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 19019-82; Wed, 7 Jul 2004 16:59:34 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 69CEA72C68A; Wed, 7 Jul 2004 16:59:31 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 07 Jul 2004 16:58:06 -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 6611472C23D for ; Wed, 7 Jul 2004 16:58:06 -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 18771-80 for ; Wed, 7 Jul 2004 16:58:06 -0500 (EST) Received: from puzzle.pobox.com (puzzle.pobox.com [207.8.214.3]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2131772C10B for ; Wed, 7 Jul 2004 16:58:06 -0500 (EST) Received: from localhost.localdomain (localhost [127.0.0.1]) by puzzle.pobox.com (Postfix) with ESMTP id 27C931393C3 for ; Wed, 7 Jul 2004 18:21:21 -0400 (EDT) Received: from hackintosh (unknown [144.71.77.200]) by puzzle.pobox.com (Postfix) with ESMTP id 984BA1393C5 for ; Wed, 7 Jul 2004 18:21:19 -0400 (EDT) From: "Rich Holland" To: Subject: RE: SAP and TSReorg Date: Wed, 7 Jul 2004 18:20:39 -0400 Organization: Guidance Technologies, Inc. MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-Mailer: Microsoft Office Outlook, Build 11.0.5510 thread-index: AcRXjdnX+cHG/XEbSlql45Gz+DMMowM4XKSg X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 In-Reply-To: <141370-22004612112464268@M2W079.mail2web.com> Message-Id: <20040707222119.984BA1393C5@puzzle.pobox.com> X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 4603 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: holland@guidancetech.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Sorry for the late reply; just catching up on 3000+ Oracle-L messages. :-) I used TSReorg and LiveReorg at previous clients. We typically rebuilt indexes; our DBA had an algorithm he'd developed for determining which ones needed to be rebuilt. The only tables we really reorganized were ones where a significant reduction in data had taken place. In many cases, we didn't even do it then; the logic was that we'd just freed up 20G of white space in some tablespace by archiving last year's data, but we'd eat at least that much up this year -- why "consolidate" it when Oracle will use the existing white space just fine? The one thing we really did a lot of reorging for (nighly in some cases) was to re-order data in a table. Specifically, at a large manufacturer we were running MRP in R/3 3.x with huge planning horizons, and doing availability checking on nearly every one of the over 400,000 parts in our BOM's. What this means is that if a part we're scheduled to build 16 months from now requires 7 of a specific flat washer, we're going to "reserve" them right now. So every work order that's released has to go look at the part reservations to make sure that, given the current inventory and the current parts reservations, we have enough to build whatever it is we're trying to release onto the shop floor. Based on that, our "Reservation" table was CONSTANTLY being scanned by material number, but that's not very high up in the primary key. By re-building the table in the order of the index keyed on material number, we signifigantly improved performance on that table. This was back in the Oracle 7/8 days -- there are WAY nicer ways to do it these days. :-) Feel free to contact me off list if you want any more details, etc. Rich -- Rich Holland (913) 645-1950 SAP Technical Consultant print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E -----Original Message----- > From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On > Behalf Of dhotka@earthlink.net > Sent: Monday, June 21, 2004 7:46 AM > To: oracle-l@freelists.org > Subject: SAP and TSReorg > [...] > > I would like to hear from any of you who are using TSReorg to perform > reorgs in a SAP/Oracle environment=2E My client is asking for reorg > strategies=2E=2E=2EI can advise them=2E=2E=2Ebut I'd certainly like to hea= > r from anyone > specifically using TSReorg in a SAP/Oracle database environment=2E > > Thank you in advance=2E=2E=2E > > Dan Hotka ---------------------------------------------------------------- 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 -----------------------------------------------------------------