RE: Import Question

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Fri, 9 Jul 2004 11:16:12 -0400
Message-ID: <564DE4477544D411AD2C00508BDF0B6A2133DDE7@usahm018.exmi01.exch.eds.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]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_at_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_at_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

---

Received on Fri Jul 09 2004 - 10:13:54 CDT