From oracle-l-bounce@freelists.org Fri Feb 18 09:57:01 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j1IFuwIu009221 for ; Fri, 18 Feb 2005 09:56:58 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j1IFutem009214 for ; Fri, 18 Feb 2005 09:56:55 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 525E2741C1; Fri, 18 Feb 2005 09:52:43 -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 03441-01; Fri, 18 Feb 2005 09:52:43 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8B89174304; Fri, 18 Feb 2005 09:52:42 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit Subject: RE: Urgent Reply requested. Truncate command Date: Fri, 18 Feb 2005 08:53:24 -0600 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Urgent Reply requested. Truncate command Thread-Index: AcUVvwYbWKJ6wI5eRAS2DFUWOfMWLAACie2A From: "Hollis, Les" To: , , X-archive-position: 16394 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Les.Hollis@ps.net Precedence: normal Reply-To: Les.Hollis@ps.net X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=2.1 required=5.0 tests=AWL,DEAR_FRIEND, NIGERIAN_SUBJECT2 autolearn=no version=2.60 X-Spam-Level: ** There has t be something really wrong in there as I just finished truncating a 37G table Table truncated. Elapsed: 00:01:26.29 Table dropped. Elapsed: 00:00:06.23 Took a minute 26 seconds. You might try dropping the indexes, truncating table then recreating indexes..... I chose to truncate the table before dropping for two reasons, 1) so it would not generate the redo and 2) the first test of just dropping the table took an hour and 52 minutes to drop it..... -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Powell, Mark D Sent: Friday, February 18, 2005 7:36 AM To: 'smishra_97@yahoo.com'; oracle-l@freelists.org Subject: RE: Urgent Reply requested. Truncate command A few details such as the tablespace management mode in use and the number of extents that the table and its indexes are in would be helpful. More that likely if dictionary management is in use Oracle is having to perform a ton of work cleaning up the sys.fet$ and uet$ base tables where free space and extent management information is kept. There is an article on this topic at the cooperative FAQ hosted at http://www.jlcomp.demon.co.uk/faq/ind_faq.html HTH -- Mark D Powell -- -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Sanjay Mishra Sent: Thursday, February 17, 2005 9:13 PM To: oracle-l@freelists.org Subject: *****SPAM***** Urgent Reply requested. Truncate command Dear friend=20 I am running a truncate on 15G table with 10G indexes and it is running from last 3 hours. Am I missed anything. Is there any way I can check if it running TIA Sanjay __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around=20 http://mail.yahoo.com=20 -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l