From oracle-l-bounce@freelists.org Mon Jun 6 13:34:25 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j56IYPMZ031550 for ; Mon, 6 Jun 2005 13:34:25 -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 j56IYPNi031546 for ; Mon, 6 Jun 2005 13:34:25 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DFB341BBDA0; Mon, 6 Jun 2005 12:31:15 -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 26175-06; Mon, 6 Jun 2005 12:31:15 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6985D1BBA76; Mon, 6 Jun 2005 12:31:15 -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 Subject: RE: ** import tuning Date: Mon, 6 Jun 2005 13:28:27 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: ** import tuning Thread-Index: AcVqoUUvjzsMbIFoQA+tzTfMxoOAnwAG+Efj From: "Marquez, Chris" To: , Content-Transfer-Encoding: 8bit X-archive-position: 20704 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-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL autolearn=ham version=2.63 These are notes I have found, taken, and used many times...and not always all of them at the same time...what these parameters "undo" you might have to "redo: later; index, stats, etc. Same of these are not very good for regularly reoccurring IMPorts...I tend to start hacking when I need to move a lot of data, one time, fast(er). hth Chris Marquez Oracle DBA ----------------------- Faster IMPORTS ----------------------- Set IMP parameter COMMIT = Y. Set IMP parameter RECORDLENGTH >= EXP RECORDLENGTH value. Set IMP parameter BUFFER = MB (Set in the MB range not KB range) Set IMP parameter STATISTICS = NONE (9i, n/a 8i) Set IMP parameter RECALCULATE_STATISTICS = N. (8i, n/a 9i) Set IMP parameter ANALYZE = N. (8i, n/a 9i) Set IMP parameter INDEXES = N (Import them later...separately) Set init.ora parameter LOG_ARCHIVE_START = FALSE *&* alter database noarchivelog; Set init.ora parameter _disable_logging = TRUE (Warning, this could be dangerous and unrecoverable in failure. Backup immediately after import) Use Locally Managed Tablespaces on target database. -----Original Message----- From: oracle-l-bounce@freelists.org on behalf of A Joshi Sent: Mon 6/6/2005 10:08 AM To: oracle-l@freelists.org Subject: ** import tuning Hi, I have a export taken with direct=y. This is done setting a high recordlengh = 64K. When importing using this export sould I set recordlength or buffer? How high is Ok for buffer? I am on 817 on sun 5.8. I need to do this operation frequently and need to tune it. Basically is export taken with direct option any different from regular export? Or is it better to just use regular export (non direct) with high buffer and use the same buffer for import. thanks for your help. --------------------------------- Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your mobile phone. -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l