From oracle-l-bounce@freelists.org Wed May 5 19:59:57 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i460xVc10272 for ; Wed, 5 May 2004 19:59:41 -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 i460xL610222 for ; Wed, 5 May 2004 19:59:31 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9851F72D3F2; Wed, 5 May 2004 19:50:12 -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 19964-88; Wed, 5 May 2004 19:50:12 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C12D872D069; Wed, 5 May 2004 19:50:11 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 05 May 2004 19:48:53 -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 2962072D1CE for ; Wed, 5 May 2004 19:48:53 -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 20309-23 for ; Wed, 5 May 2004 19:48:53 -0500 (EST) Received: from mail.sagelogix.com (unknown [69.15.85.3]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D686872C9F4 for ; Wed, 5 May 2004 19:48:52 -0500 (EST) Received: by mail.sagelogix.com (Postfix, from userid 70101) id 4087531791; Wed, 5 May 2004 18:51:05 -0600 (MDT) Received: from ocs.sagelogix.com (ocs.sagelogix.com [192.168.25.20]) by mail.sagelogix.com (Postfix) with ESMTP id 4B7E731793 for ; Wed, 5 May 2004 18:50:58 -0600 (MDT) Received: from 0-1pool58-86.nas22.thornton1.co.us.da.qwest.net by ocs.sagelogix.com with ESMTP id 1368131083800910; Wed, 05 May 2004 17:48:30 -0600 User-Agent: Microsoft-Entourage/10.1.4.030702.0 Date: Wed, 05 May 2004 19:02:02 -0600 Subject: Re: truncate a table with many extents From: Tim Gorman To: Message-ID: In-Reply-To: <9E0E38DB4ACFAA4593AD6C4A45C9D5F0128F9F@LOUMLVEM01.e2k.ad.ge.com> Mime-version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on mail.sagelogix.com X-Spam-Level: X-Spam-Status: No, hits=-4.9 required=2.3 tests=BAYES_00 autolearn=ham version=2.63 X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 4535 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: tim@sagelogix.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Monitor the values in USED_UBLK and USED_UREC in V$TRANSACTION (i.e. number of undo blocks and undo records used by the transaction); I believe USED_UREC comes pretty darn close to tracking the number of extents. Close enough, anyway... You can get to V$TRANSACTION from V$SESSION by joining V$SESSION.TADDR to V$TRANSACTION.ADDR. Hope this helps... on 5/5/04 3:28 PM, Adams, Matthew (GE Consumer & Industrial) at MATT.ADAMS@GE.COM 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. > > > > ---- > 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 > ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------