Client copy takes too much of time

[Former Member]

Hi All,

Recently, at one of my client sites I was aksed to do a client copy from Production to Development.

The procedure I followed was --

1. Checked tablespaces and increased them accordingly in Development.

2. Scheduled the export from Production. The data size is about 90 GB. It took around 1:30 hrs to export. Noted down the request numbers.

4. Logged on to the development system at OS level.

5. Added the request to buffer using tp addtobuffer

6. Started the import using command --

tp import <req.no> <targetsid> client=<targetclient> pf=<targetprofile> u0126

7. kept on monitoring the logs in tmp directory.

Then it took 16 hrs. to complete the import.

Please assist me in analyzing the cause of this. and if any parameters need to bec hanged then waht are they? and where are they?

Regards,

Mandar

[Former Member]

First of all...

You must bear in mind to review database parameters, set database to noarchivelog mode, review redo logs size and assure that you are using PSAPUNDO.

The most important is REDOLOG size, I suggest you to create at least four groups of redologs without mirroring to do the import and after that you can rebuild redolods by dropping and creating new ones.

Please see note 68896 that point's you to client import performance.

Regards,

Fernando Figueiredo