RE: Import Question
- From: "Karniotis, Stephen" <Stephen.Karniotis@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 12 Jul 2004 09:39:21 -0400
Michael:
Replying a few days late here.
Does SAP have parameters internally that will help you control this? It
does not really sound like exp/imp but it does sound like SQL*Loader. Can
you determine what R3Load invokes? From there, we can help you a bit more.
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 Vergara, Michael (TEM)
Sent: Friday, July 09, 2004 11:28 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Import Question
Mark:
Oh...if only this were a conventional import!
This is an SAP system, and the export/import process uses
a SAP-written utility called "R3load". That I know of, there
are no settable parameters like the buffer parameter in an
Oracle import.
R3load writes to a flat file than is encoded and compressed
using SAP's proprietary programming. It works very well at
the compression angle. A 1.5TB database exported out to just
under 300GB of flat files.
The only tuning opportunities I have are on the database
server. I can send out the whole initSID.ora file, but
I thought that would be overkill for the first question.
Thanks for the support!
Mike
-----Original Message-----
From: Powell, Mark D [mailto:mark.powell@xxxxxxx]
Sent: Friday, July 09, 2004 8: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=3D 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=3Dn. If the target tables exist and ignore=3Dy 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 =3D3D 2147483648
log_buffer =3D3D 2097152
sort_area_retained_size =3D3D 0
sort_area_size =3D3D 5242880
undo_management =3D3D AUTO
db_writer_processes =3D3D 4
java_pool_size =3D3D 167772160
Any suggestions?
Thanks,
Mike
---
=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D=
3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D
=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D=
3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D
=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D=
3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=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
-----------------------------------------------------------------
----------------------------------------------------------------
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
-----------------------------------------------------------------
Other related posts:
