From oracle-l-bounce@freelists.org Tue Oct 11 11:31:29 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9BGVTtP014776 for ; Tue, 11 Oct 2005 11:31:29 -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 j9BGVOvX014742 for ; Tue, 11 Oct 2005 11:31:24 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8099C1FBD77; Tue, 11 Oct 2005 11:31:19 -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 13954-08; Tue, 11 Oct 2005 11:31:19 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D91651FBD17; Tue, 11 Oct 2005 11:31:18 -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 X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: RE: How much time can save using _disable_logging on 10g Date: Tue, 11 Oct 2005 12:29:14 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: How much time can save using _disable_logging on 10g Thread-Index: AcXOfefAEbVK1SI2Tb+6mKUlhtdDpQAAVY5w From: "Marquez, Chris" To: "Juan Carlos Reyes Pacheco" Cc: , X-archive-position: 26699 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: cmarquez@collegeboard.org Precedence: normal Reply-To: cmarquez@collegeboard.org 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=-4.1 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 >>Can you tell me please how much time you saved I had to dig through my notes...I don't have a memory for this stuff ...that's why I take notes. This is from my own email to my co-workers; >> I was able to load theses TABLEs in about 24 to 32 minutes. >> Below are my EXPort and IMPort parameters. >> Also, I tried using the Oracle parameter; "_disable_logging = TRUE" >> ...it seemed to have a 15% - 25% time improvement...18 minutes. hth Chris Marquez Oracle DBA -----Original Message----- From: Juan Carlos Reyes Pacheco [mailto:juancarlosreyesp@gmail.com] Sent: Tuesday, October 11, 2005 12:07 PM To: Marquez, Chris Cc: mcdonald.connor@gmail.com; oracle-l@freelists.org Subject: Re: How much time can save using _disable_logging on 10g 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. On 10/11/05, Marquez, Chris wrote: > > > > >>shutdown abort with _disable_logging and you'll see some interesting > consequences > > Ahhhh yes we conversed on this topic a while back. I used _disable_logging > for migration purposes after a lot of TEST my process. > I kept wondering why my test db was crashing hard...we had some disk > issue at the time, so that seemed the culprit. > Turns out I kept leaving my TEST db up with _disable_logging enabled > during server reboots...it did not come back happily > > A great and very, very challenging recovery filled with undocumented > parameters that rendered my TEST database un-supported. > I was able to recover sometimes, but others not. > Think I was "bumping scn's" and allowing reset log corruption. > You have not lived until you have recovered a database this way...nasty! > :o) > Also, learned and documented the "clean way" to stop using > _disable_logging and put my db back in archive log mode. > > > Sorry, "yes" _disable_logging saved time during my migration (at the > risk of loosing it all on the *new* server, but not on the old server). > > Chris Marquez > Oracle DBA > > ________________________________ > From: oracle-l-bounce@freelists.org > [mailto:oracle-l-bounce@freelists.org] > On Behalf Of Connor McDonald > Sent: Monday, October 10, 2005 11:08 AM > To: oracle-l@freelists.org > Subject: Re: How much time can save using _disable_logging on 10g > > > shutdown immediate is still a clean shutdown. > > Try shutdown abort with _disable_logging and you'll see some > interesting consequences > > hth > connor > > > > -- > Connor McDonald > =========================== > email: connor_mcdonald@yahoo.com > web: http://www.oracledba.co.uk > > "Semper in excremento, sole profundum qui variat" -- 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