From oracle-l-bounce@freelists.org Sat Oct 8 16:35:12 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j98LZCmq006088 for ; Sat, 8 Oct 2005 16:35:12 -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 j98LZ8vX006077 for ; Sat, 8 Oct 2005 16:35:09 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 381AE1F91B8; Sat, 8 Oct 2005 16:35:07 -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 30483-10; Sat, 8 Oct 2005 16:35:07 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BAB271F905A; Sat, 8 Oct 2005 16:35:06 -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=BoX3LPK1dOpEnDPVw+BD2i5bVRe49bIGf9FfIEG+LptQ9Mgq2mYfY4Jy8MR+bl0YE30uqiEjZ5RzD/Q5a9Ndmgwz3zLE0IJgDw8p/BssTxLUfcX9UQ7YdOkfRmyGasgJxUFrpCFzK2VMGKblkpecP0l++CEQ2rKCgzCnbKablGA= Message-ID: Date: Sat, 8 Oct 2005 23:33:11 +0200 From: Alex Gorbachev To: juancarlosreyesp@gmail.com Subject: Re: How much time can save using _disable_logging on 10g Cc: oracle-l@freelists.org In-Reply-To: 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: X-archive-position: 26597 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: gorbyx@gmail.com Precedence: normal Reply-To: gorbyx@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=-2.5 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 Well, you can try 10046 trace your session that you want to speed up and check what's the portion of redo log related event (like log file sync and etc.). You won't be able to gain more than that. Normally, you should expect more improvement with data loading type of work. However, I would never set it up on any of my DB's (even development) - I cannot afford to loose my time with a simple crash. 2005/10/7, Juan Carlos Reyes Pacheco : > Hi, > To speed process on my personal computer, ONLY FOR MY TESTING > DATABASE, I want to use _disable_logging parameter. > How much can I expect to save in time using it. > > Thank you in advance. > -- > http://www.freelists.org/webpage/oracle-l > -- Best regards, Alex Gorbachev -- http://www.freelists.org/webpage/oracle-l