For your import, make sure you have COMMIT=Y, a buffer size of greater than 10mg. COMMIT=Y does not require extremely large rollback space. Make sure you have a large temp area and sort area for the indexes that will be created. Just some thoughts from an old guy. Thank You Stephen P. Karniotis Compuware Corporation Direct: (313) 227-4350 Toll Free: (800) 462-7740 ext. 74350 Mobile: (248) 408-2918 Email: Stephen.Karniotis@xxxxxxxxxxxxx Web: www.compuware.com -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Powell, Mark D Sent: Friday, July 09, 2004 11:16 AM To: 'oracle-l@xxxxxxxxxxxxx' Subject: RE: Import Question Mike, don't you think it would be helpful to show us the import parameters in use? If you are doing a conventional import then I would recommend you use a large buffer= value. If any of the exported options are unnecessary for the import such as grants then set the associated parameter off for the import: grants=n. If the target tables exist and ignore=y is in use and some of these tables are large drop the indexes so they do not have to be maintained during the table load. Either build them after or let the import rebuild them. HTH -- Mark D Powell -- -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Vergara, Michael (TEM) Sent: Friday, July 09, 2004 10:53 AM To: Oracle-L (E-mail) Subject: Import Question 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 <http://www.guidant.com/> ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------