From oracle-l-bounce@freelists.org Tue Oct 11 12:05:03 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9BH52s9019761 for ; Tue, 11 Oct 2005 12:05:02 -0500 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 j9BH4tvX019721 for ; Tue, 11 Oct 2005 12:04:58 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0AB981FC059; Tue, 11 Oct 2005 12:04:33 -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 19529-02; Tue, 11 Oct 2005 12:04:32 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 632731FC097; Tue, 11 Oct 2005 12:04:32 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=UEcsx8mK7t41sfY38shhTGOKozFqrq+QUYL/kQzcDrKDAraon8mNmzkCuSXU1Ex9dnDrAXfRB74ceJ//8U1+JWskYwIXnzNqbbowQgH+ZVYlU6Mr9Zs+huJ87DP+cLgWwVdFU2UHBS4StmiWZDfFLzH4UscOUcLyNhOc3T56UWo= Message-ID: Date: Tue, 11 Oct 2005 13:02:19 -0400 From: Juan Carlos Reyes Pacheco To: rjamya Subject: Re: How much time can save using _disable_logging on 10g Cc: cmarquez@collegeboard.org, mcdonald.connor@gmail.com, oracle-l@freelists.org In-Reply-To: <9177895d0510110938n4205002kcae93e02462bc3c9@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Content-Disposition: inline References: <9177895d0510110938n4205002kcae93e02462bc3c9@mail.gmail.com> X-archive-position: 26707 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: juancarlosreyesp@gmail.com Precedence: normal Reply-To: juancarlosreyesp@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-3.8 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 rjamya, this is not Carys words, this come from Tao. Tao says "If you don't do anything, everything is done" now if you like this phylosophy too much you can loose your job. :) On 10/11/05, rjamya wrote: > For optimal performance, don't have the tables. If you don't have the > tables, no one will modify data. And like Cary says, best kind of > optimization is " not doing it " ... you can save a lot of time by not doing > this test. > > 8:) > Raj > > > On 10/11/05, Juan Carlos Reyes Pacheco wrote: > > Thanks Chris, I agree with you, a simple shutdown immediate crashed > > my test database too, but anyway is interesting to know its > > limitations. > > > > Can you tell me please how much time you saved :) only for statistics. > > when migrating. > > > > Thanks in Advance. > > > > -- Oracle Certified Profesional 9i 10g Orace Certified Professional Developer 6i 8 years of experience in Oracle 7,8i,9i,10g and developer 6i -- http://www.freelists.org/webpage/oracle-l