Re: Import Question

From: Jared Still <jkstill_at_cybcon.com>
Date: Fri, 09 Jul 2004 09:58:07 -0700
Message-Id: <1089392287.2159.584.camel@poirot>

Personally, I would write, beg, borrow or steal the scripts to export to pipes ( think netcat ) in parallel, with matching import pipes/processes on the receiving end.

And skip r3load entirely. In fact, forgoing the use of all SAP database utilities probably isn't a bad idea.

Jared

On Fri, 2004-07-09 at 07:52, 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 <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 - 11:50:44 CDT