From oracle-l-bounce@freelists.org Wed May 5 19:57:26 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i460vBw09750 for ; Wed, 5 May 2004 19:57:21 -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 i460v1609719 for ; Wed, 5 May 2004 19:57:11 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6E70272CF87; Wed, 5 May 2004 19:47:52 -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 19836-51; Wed, 5 May 2004 19:47:52 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B746F72CBC6; Wed, 5 May 2004 19:47:51 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 05 May 2004 19:46:38 -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 66F0C72C9F4 for ; Wed, 5 May 2004 19:46:38 -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 17976-85 for ; Wed, 5 May 2004 19:46:38 -0500 (EST) Received: from web25209.mail.ukl.yahoo.com (web25209.mail.ukl.yahoo.com [217.12.10.69]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id AD72872C7F5 for ; Wed, 5 May 2004 19:46:37 -0500 (EST) Message-ID: <20040506010029.32340.qmail@web25209.mail.ukl.yahoo.com> Received: from [165.187.10.2] by web25209.mail.ukl.yahoo.com via HTTP; Thu, 06 May 2004 02:00:29 BST Date: Thu, 6 May 2004 02:00:29 +0100 (BST) From: =?iso-8859-1?q?Connor=20McDonald?= Subject: Re: truncate a table with many extents To: oracle-l@freelists.org In-Reply-To: <9E0E38DB4ACFAA4593AD6C4A45C9D5F0128F9F@LOUMLVEM01.e2k.ad.ge.com> MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 4534 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: hamcdc@yahoo.co.uk Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Slap a trace on and see how frequently you're getting uet/fet operations and you might get an idea. For future such operations, a common technique is (iirc) along the lines of: - truncate reuse storage loop - alter table X deallocate unused keep nnn end loop so you can free the extents in a more incremental and controlled fashion hth connor --- "Adams, Matthew (GE Consumer & Industrial)" wrote: > 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. > ===== Connor McDonald Co-author: "Mastering Oracle PL/SQL - Practical Solutions" ISBN: 1590592174 web: http://www.oracledba.co.uk web: http://www.oaktable.net email: connor_mcdonald@yahoo.com Coming Soon! "Oracle Insight - Tales of the OakTable" "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" ------------------------------------------------------------ ____________________________________________________________ Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.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 -----------------------------------------------------------------