cancel
Showing results for 
Search instead for 
Did you mean: 

Client Import/Transport

Former Member
0 Kudos
289

Hi,

I am doing a client refresh from PRD to QAS using client export/import method. Exported PRD data using SCC8 and now importing it into QAS using STMS transport. The export took 8 hours while the import ran for about 3 days. My Oracle 10.2.0.4 DB size is about 180GB and have updated DB statistics prior to running the import.

I am looking at ways to improve the import performance.

1. During the import it generated hundreds of redo logs. Will turning off archive logs help to improve performance?

2. I am using a shared transport directory for all my servers DEV, QAS and PRD. The shared transport directory is in DEV.

As the exported file is located in DEV, the import in QAS has to read the exported file remotely, Will it helps if I transfer the

exported files to QAS and run the transport locally on QAS?

I would appreciate anyone who has done the above to share if this will improve the Import performance.

Thank you.

View Entire Topic
Former Member
0 Kudos

Hi,

Are you over writing the target client ? or has it been deleted first. Tiidy up the target client it will speed up your import.

Also have you thought about a remote client copy? you could depending on resourse parallel copy.

Mark

Read note: 68896