From oracle-l-bounce@freelists.org Tue Oct 11 13:22:28 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9BIMSvk000680 for ; Tue, 11 Oct 2005 13:22:28 -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 j9BIMEvX000659 for ; Tue, 11 Oct 2005 13:22:16 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DF5BB1FC51F; Tue, 11 Oct 2005 12:54:34 -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 25795-09; Tue, 11 Oct 2005 12:54:34 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5E42C1FC524; Tue, 11 Oct 2005 12:54:34 -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:references; b=m13ygNMIz9/z0PYpMUcLHYw3Kt0Ssu1x3YrbrQ5xnXNOMVft2fDeRXdqpuV0ZlZss+O4c/65t3S0eCX1JfLpPJEAegvGEXF4oZqJmGf2LteBqsrcmbYF7OnAN7PfeJvO55x7+PE5xwyTrBm/XYlCxX+fBgRY4YZOyyuhdh37e0s= Message-ID: <7765c8970510111052g252bacf6uc5a2f527cf09b7be@mail.gmail.com> Date: Tue, 11 Oct 2005 18:52:25 +0100 From: Niall Litchfield To: juancarlosreyesp@gmail.com Subject: Re: When to use _disable_logging on Oracle 10g Release 2 Cc: oracle list In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_11962_30609557.1129053145923" References: X-archive-position: 26716 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: niall.litchfield@gmail.com Precedence: normal Reply-To: niall.litchfield@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.3 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_Part_11962_30609557.1129053145923 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 10/11/05, Juan Carlos Reyes Pacheco wrote: > > Hi, > Well after a stress tests, and other test, in the previous days, > losing a test database because redo logs corruption. > > using the parameter _disable_logging on Oracle 10g Release 2 and > thanks to several comments in this list I can say. > > You can get useful improvements using this paramters, but... 2) > The only reason I found feasible to use it is when you have to import > urgently (for example for a presentation) in 0:30 or tomorrow. > Otherwise you can end losing your database. nope. you can always end up losing your database with this set, you better recognise it. time pressure is irrelevant (well actually improves the likelihood of making a simple error and losing the db yourself) _disable_logging would be better renamed _I_REALLY_REALLY_REALLY_DONT_CARE_ABOUT_THIS_DATA. If you set it, that is what you mean. oh, and importing for a presentation, what a weird pressure on a database. -- Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.com ------=_Part_11962_30609557.1129053145923 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 10/11/05, Juan Carlos Reyes Pacheco &l= t;juancarlosreyesp@gmail.com<= /a>> wrote:
Hi,
Well after a stress tests, and other test, in the previous days,
= losing a test database because redo logs corruption.

using the param= eter _disable_logging on Oracle 10g Release 2 and
thanks to several comm= ents in this list I can say.

You can get  useful improvements using this paramters, bu= t...

<snip> 

2)
The only reason I found feasible to use it is when you hav= e to import
urgently (for example for a presentation) in 0:30 or tomorrow.
Other= wise you can end losing your database.


nope. you can always end up losing your database with this set, you better recognise it. time pressure is irrelevant (well actually improves the likelihood of making a simple error and losing the db yourself) _disable_logging would be better renamed _I_REALLY_REALLY_REALLY_DONT_CARE_ABOUT_THIS_DATA. If you set it, that is what you mean.

oh, and importing for a presentation, what a weird pressure on a database. =

--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial= .pipex.com ------=_Part_11962_30609557.1129053145923-- -- http://www.freelists.org/webpage/oracle-l