From oracle-l-bounce@freelists.org Wed May 5 16:25:27 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i45LPCX14092 for ; Wed, 5 May 2004 16:25:22 -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 i45LP2614055 for ; Wed, 5 May 2004 16:25:12 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E5C1A72D3CA; Wed, 5 May 2004 16:15:54 -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 15957-60; Wed, 5 May 2004 16:15:54 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 09E3972D140; Wed, 5 May 2004 16:15:54 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 05 May 2004 16:14:37 -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 79C1B72CC39 for ; Wed, 5 May 2004 16:14:37 -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 14943-100 for ; Wed, 5 May 2004 16:14:37 -0500 (EST) Received: from ext-ch1gw-2.online-age.net (ext-ch1gw-2.online-age.net [216.34.191.36]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3B25872CA1C for ; Wed, 5 May 2004 16:14:37 -0500 (EST) Received: from int-ch1gw-1.online-age.net (int-ch1gw-1 [3.159.232.65]) by ext-ch1gw-2.online-age.net (8.12.9/8.12.9/990426-RLH) with ESMTP id i45LSQr5003190 for ; Wed, 5 May 2004 17:28:26 -0400 (EDT) Received: from cinmlef03.e2k.ad.ge.com (localhost [127.0.0.1]) by int-ch1gw-1.online-age.net (8.12.9/8.12.3/990426-RLH) with ESMTP id i45LSPFx018735 for ; Wed, 5 May 2004 17:28:25 -0400 (EDT) Received: from LOUMLVEM01.e2k.ad.ge.com ([3.159.160.30]) by cinmlef03.e2k.ad.ge.com with Microsoft SMTPSVC(5.0.2195.6673); Wed, 5 May 2004 17:28:24 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.0.6521.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Subject: truncate a table with many extents Date: Wed, 5 May 2004 17:28:24 -0400 Message-ID: <9E0E38DB4ACFAA4593AD6C4A45C9D5F0128F9F@LOUMLVEM01.e2k.ad.ge.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: truncate a table with many extents Thread-Index: AcQy5+TyfafY8mtSRXOZ6Q8Zbze1Xg== From: "Adams, Matthew (GE Consumer & Industrial)" To: X-OriginalArrivalTime: 05 May 2004 21:28:24.0944 (UTC) FILETIME=[E5EB1700:01C432E7] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 4524 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: MATT.ADAMS@GE.COM Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org I'm truncating a table with around 14,000 extents on a 7.3.4 database on a slow machine. (Please don't ask how this happened, it's too=20 painful to re-live.) Is there anyway to determine how far the truncate has gotten at any given point? I thought I might see changes in sys.fet$ or sys.uet$ as extents are de-allocated, but I'm not seeing that. ---- Matt Adams - GE Appliances - matt.adams@appl.ge.com Just once, I wish we would encounter an alien menace that wasn't immune to bullets.=20 - The Brigadier ---------------------------------------------------------------- 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 -----------------------------------------------------------------