Re: Import Question
- From: Jared Still <jkstill@xxxxxxxxxx>
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 09 Jul 2004 09:58:07 -0700
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@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
-----------------------------------------------------------------
Other related posts: