while I think skipping the statistics as previously suggested will probably
help greatly there are the two following bug reprots for 11.2.0.2 and 11.2.0.3
that may be if interest
- -
Bug 12728995 - EXPDP slow while taking metadata export for transportable
tablespace (Doc ID 12728995.8)
Bug 15898478 - Transport EXPDP slow during TRANSPORT_SET_CHECK (Doc ID
15898478.8)
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Chitale, Hemant K <Hemant-K.Chitale@xxxxxx>
Sent: Monday, June 27, 2016 10:04:01 PM
To: Oracle-l Digest Users
Subject: RE: TTS Self-contained restriction workaround
MetaData export time is a function of the number and types of database objects
in those schemas. The size of the Production Database vis-a-vis the Test
Database should not have a material difference on the export time if both
databases have the same objects in those schemas. (A Table with multiple
Partitions becomes multiple rows of metadata !)
Unfortunately, PARALLEL cannot help.
I've seen Oracle EBusiness Suite MetaData Export taking as long.
Hemant K Chitale
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Deepak Sharma
Sent: Saturday, June 25, 2016 5:44 AM
To: Oracle-l Digest Users
Subject: TTS Self-contained restriction workaround
The requirements for TTS metadata export/import is that all tablespaces in a
group should be self-contained.
For example, if TS1 has a table that has a partition in TS9, then either move
that table to TS1 or include TS9 in the group of tablespaces for metadata
export.
In our environment we have lots of tables that have their partitions spread
across several tablespaces.
We could include all those tablespaces in a group, but the problem is that as
in example below, the TRANSPORT_TABLESPACES or TRANSPORT_DATAFILES do not allow
PARALLEL degree to be set.
And, we want to use PARALLEL just becuse these tablespaces have a lots and lots
of Metadata. Without parallel it would just take several hours for the
export/import.
nohup impdp \"/ as sysdba\" parfile=migrate_tts.par > migrate_tts.log 2>&1 &
## migrate_tts.par
DIRECTORY=MIG_DIR
LOGFILE=MIG_TTS.log
NETWORK_LINK=ttslink
TRANSPORT_FULL_CHECK=no
TRANSPORT_TABLESPACES=APP_DATA,APP_IDX,APP_DATA2
TRANSPORT_DATAFILES='/oradata/APP/APP_DATA_01.dbf','/oradata/APP/APP_IDX_01.dbf',...
-thanks
This email and any attachments are confidential and may also be privileged. If
you are not the intended recipient, please delete all copies and notify the
sender immediately. You may wish to refer to the incorporation details of
Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at
https://www.sc.com/en/incorporation-details.html
--
//www.freelists.org/webpage/oracle-l