Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 1934 invoked from network); 2 Feb 2006 14:54:12 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 2 Feb 2006 14:54:12 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EF5F5291091; Thu, 2 Feb 2006 15:54:08 -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 10169-07; Thu, 2 Feb 2006 15:54:08 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6A272290CF7; Thu, 2 Feb 2006 15:54:08 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 02 Feb 2006 15:53:52 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CF7DE291083 for ; Thu, 2 Feb 2006 15:53:52 -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 10139-04 for ; Thu, 2 Feb 2006 15:53:52 -0500 (EST) Received: from smtp801.mail.ukl.yahoo.com (smtp801.mail.ukl.yahoo.com [217.12.12.138]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 9950E28DA45 for ; Thu, 2 Feb 2006 15:53:49 -0500 (EST) Received: (qmail 91535 invoked from network); 2 Feb 2006 20:53:45 -0000 Received: from unknown (HELO Primary) (oracle.expert@btinternet.com@86.141.101.241 with login) by smtp801.mail.ukl.yahoo.com with SMTP; 2 Feb 2006 20:53:44 -0000 Message-ID: <02dc01c6283a$c380a500$0200a8c0@Primary> From: "Jonathan Lewis" To: Cc: References: <02a001c62831$a23ca5f0$0200a8c0@Primary> Subject: Re: Disable logging in tablespace vs using hidden parameter _disable_logging Date: Thu, 2 Feb 2006 20:53:47 -0000 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-archive-position: 30732 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jonathan@jlcomp.demon.co.uk Precedence: normal Reply-To: jonathan@jlcomp.demon.co.uk X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net For a large import, the point I was making about commits is pretty irrelevant. I was only thinking about the usual potential for latch collision and redo wastage for highly concurrent systems, and 'row at a time' batch processing. Everything that could normally cause a redo-related problem still can cause a problem with _disable_logging set to true apart from one little detail, which is the log file write time. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html Cost Based Oracle: Fundamentals http://www.jlcomp.demon.co.uk/appearances.html Public Appearances - schedule updated 10th Jan 2006 ----- Original Message ----- From: "Juan Carlos Reyes Pacheco" To: Cc: Sent: Thursday, February 02, 2006 8:02 PM Subject: Re: Disable logging in tablespace vs using hidden parameter _disable_logging Thank you Jonathan, can you please extend your explanation about the > and avoid > commits. How important is to set commit=N in an import? Sorry for this questions, but I asked my boss to giveme a server(a normal 500U$ computer) to run some optimizations test, but he denied, so I can't do as much test as I would like and have to be guessing and asking. -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l