Remote client copy performance

[Former Member]

Hello experts,

I need an opinion on following possibilities that could speed up remote client copy:

Increasing maximum number of processes for parallel processing in dialog mode?

Increasing the update processes?

Decreasing the undo retention from default 900 seconds to 600 seconds (Oracle) ?

Increase the number of redo log files?

An opinion or any other insights would be highly appreciated.

Thank you,

Rohit

[former_member66264 · Accepted solution]

Hi,

You did not mention the rational behind you request: but have you considerd a client export / import?.

SCC8

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/69/c24c824ba111d189750000e8322d00/frameset.htm

Since this is an async process ( first export, at a later time import) sometimes you can gain some time.

Rgds

Nico

[Former Member]

Well, the answer is maybe.

You did not supply any information about your run and your system, how can we give you good advice? Any of your proposals might speed up the copy process, but we cannot tell (well decreasing the undo retention and changing the update work processes will not change much). If your hardware (cpu/disk/network) is not exhausted, then increase the number of parallel processes.

Besides that these notes contain good hints regarding copy speedup:

[489690 - CC INFO: Copying large production clients|https://service.sap.com/sap/support/notes/489690]

[446485 - CC-ADMIN: Special copying options|https://service.sap.com/sap/support/notes/446485]

Cheers Michael

[Former Member]

Michael,

Thanks for the reply . Here are the details:

- Source and target are on the same physical box. They share the NIC. Hence I donu2019t expect any network issues.

- Source destination DB size is approx 500 GB.

- All batch and dialog activity in source and target will not be allowed for the time period of refresh

- Server specifications :

CPU : 16

Memory : 32 GB

OS : HP UX B.11.00 A 9000/800

SAP R/3 Kernel : 640_REL

Database : ORACLE 10.2

Support pack level : 14

Thanks,

Rohit

[Former Member]

All batch and dialog activity in source and target will not be allowed for the time period of refresh

You may want to consider

1. Start Client copy in the background.

2. Switch database into nonarchiving mode.