RE: import table scan

From: Guang Mei <GMei_at_ph.com>
Date: Thu, 23 Jun 2005 10:43:07 -0400
Message-ID: <7E62D965D357694C993D4F0E13B3C39B0585A9A2@phexchange.ph.com>

For Export , try
direct=y
recordlength=65535

For Import, try

analyze=n , you can analyze table after imp finishes also put DB in no-archive log mode to reduce redo log writing you could also skip index import, only load data first, then rebuild indexes with nologging

HTH. Guang

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
Sent: Thursday, June 23, 2005 10:30 AM
To: oracle-l_at_freelists.org
Subject: RE: import table scan

We have a big oracle 9.2.0.4 database, in the 2 TB size range. The database stores aerial imagery and 99% of the storage is in 15-20 tables. Our tables are huge. Query performance from the database is great, but importing the export of this database takes a good deal of time, as one might expect.

I made the decision to do import/export because we don't have archive logging
and I can't bring the database down long enough to copy the datafiles, and import/export is easier to test. However, the import process spends ½ of its
time (I'm estimating) doing table scans. I witness this by going into OEM and viewing the Long Operations tab of the session.

I used the following for the export: exp \'sys/xxx @raster as sysdba\' buffer=20000000 file=/rasterbu1/rasterbu.dmp full=y COMPRESS=y consistent=n log=/rasterbu1/rasterbu.log

and this for the import: imp \'sys/xxx as sysdba\' file=/rasterbu1/rasterbu.dmp log=imp.log full=y

I don't have any reason to believe the database import will not work, but I would like to speed it up if possible.

Thanks for your help,
Chris

--

http://www.freelists.org/webpage/oracle-l

PRIVILEGED AND CONFIDENTIAL:
This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy all copies.

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jun 23 2005 - 10:48:22 CDT