From oracle-l-bounce@freelists.org Fri Jul 9 10:30:26 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i69FUBx27557 for ; Fri, 9 Jul 2004 10:30:21 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i69FU1627524 for ; Fri, 9 Jul 2004 10:30:11 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4A5DC72CC1C; Fri, 9 Jul 2004 10:11: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 03617-34; Fri, 9 Jul 2004 10:11:07 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 69E8D72CBF4; Fri, 9 Jul 2004 10:11:06 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 09 Jul 2004 10:09:42 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 134B772C3A9 for ; Fri, 9 Jul 2004 10:09:42 -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 03617-06 for ; Fri, 9 Jul 2004 10:09:41 -0500 (EST) Received: from web80509.mail.yahoo.com (web80509.mail.yahoo.com [66.218.79.79]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 5C09D72C2DA for ; Fri, 9 Jul 2004 10:09:41 -0500 (EST) Message-ID: <20040709153347.64643.qmail@web80509.mail.yahoo.com> Received: from [63.73.199.69] by web80509.mail.yahoo.com via HTTP; Fri, 09 Jul 2004 08:33:47 PDT Date: Fri, 9 Jul 2004 08:33:47 -0700 (PDT) From: Fuad Arshad Subject: Re: Import Question To: oracle-l@freelists.org In-Reply-To: <791D0E1ECDECD04D89205F33806FC38701E91FE9@temmse06.tem.guidant.com> MIME-Version: 1.0 Content-type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 4776 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: fuadar@yahoo.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org how are youtrying to do the import. i.e what parameters are you using indexes=no etc . are the tables prebuilt or are you building them with the import. is there a commit=yes? "Vergara, Michael (TEM)" wrote: Hey gang...any suggestions on how to speed up an import? I am trying to import to a new SAP database server. Oracle 9.2.0.5 on HP-UX11i. There appears to be a lot of I/O activity, but overall I get a feeling of the system dragging. Some DB params are: db_cache_size =3D 2147483648 log_buffer =3D 2097152 sort_area_retained_size =3D 0 sort_area_size =3D 5242880 undo_management =3D AUTO db_writer_processes =3D 4 java_pool_size =3D 167772160 Any suggestions? Thanks, Mike --- =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= Michael P. Vergara Oracle DBA Guidant Corporation www.guidant.com ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------