From oracle-l-bounce@freelists.org Tue Jul 20 08:08:12 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6KD7vP03643 for ; Tue, 20 Jul 2004 08:08:07 -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 i6KD7k603618 for ; Tue, 20 Jul 2004 08:07:56 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 72E7A72C9C8; Tue, 20 Jul 2004 07:47:14 -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 03822-04; Tue, 20 Jul 2004 07:47:14 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 64D6272C9D9; Tue, 20 Jul 2004 07:47:13 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 20 Jul 2004 07:45:36 -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 C43EB72C7CC for ; Tue, 20 Jul 2004 07:45:35 -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 01647-99 for ; Tue, 20 Jul 2004 07:45:35 -0500 (EST) Received: from brmea-mail-4.sun.com (brmea-mail-4.Sun.COM [192.18.98.36]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5DAF072C819 for ; Tue, 20 Jul 2004 07:45:35 -0500 (EST) Received: from phys-giza-1 ([129.147.4.102]) by brmea-mail-4.sun.com (8.12.10/8.12.9) with ESMTP id i6KD9D53018258 for ; Tue, 20 Jul 2004 07:09:13 -0600 (MDT) Received: from conversion-daemon.giza-mail1.Central.Sun.COM by giza-mail1.Central.Sun.COM (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) id <0I1500201J9P4M@giza-mail1.Central.Sun.COM> (original mail from Daniel.Fink@Sun.COM) for oracle-l@freelists.org; Tue, 20 Jul 2004 07:11:25 -0600 (MDT) Received: from sun.com (sr1-ubrm-03.Central.Sun.COM [129.147.4.9]) by giza-mail1.Central.Sun.COM (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) with ESMTP id <0I15007NJJB0IX@giza-mail1.Central.Sun.COM> for oracle-l@freelists.org; Tue, 20 Jul 2004 07:11:25 -0600 (MDT) Date: Tue, 20 Jul 2004 07:11:24 -0600 From: Daniel Fink Subject: Re: Delayed block cleanout and changing automatic undo tablespace In-reply-to: To: oracle-l@freelists.org Message-id: <40FD19FC.1010906@sun.com> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Accept-Language: en-us, en User-Agent: Mozilla/5.0 (X11; U; SunOS sun4u; en-US; rv:1.4) Gecko/20040414 References: X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 5477 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Daniel.Fink@Sun.COM Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org I'm going to take the easy question first... If you are using AUM, you cannot offline undo segments without switch= ing undo tablespaces. You also can't create new ones or drop=20 old ones. If something happens that creates a bunch of undo segments = (another issue), you are stuck with them until you are able to=20 drop the tablespace. If you bounce the database, you will see that a limited number of seg= ments are online. As transactions are processed, segments are=20 onlined or created as the system sees fit. You no longer have any con= trol over your undo. I have a rather detailed paper and presentation about undo at www.opt= imaldba.com/library.html. Regards, Daniel Fink Tim Onions wrote: > Many thanks for the fast response. Sorry to ask a dumb question but= with > AUTO UNDO in 9i how can one "...offline the undo segments..". There= are no > active transactions on the segments in the old large undo tablespac= e show > via V$transaction. >=20 > Thanks >=20 > T=AC > ---------------------------------------------------------------- > 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 -----------------------------------------------------------------