Question Re: Remote client copy performance in Technology Q&A

Remote client copy performance

Former Member — Mon, 23 Nov 2009 04:30:11 GMT

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

Re: Remote client copy performance

Former Member — Mon, 23 Nov 2009 07:06:04 GMT

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

Re: Remote client copy performance

Former Member — Mon, 23 Nov 2009 21:22:27 GMT

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

Re: Remote client copy performance

Former Member — Tue, 24 Nov 2009 05:57:22 GMT

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.

Re: Remote client copy performance

former_member66264 — Tue, 24 Nov 2009 14:11:32 GMT

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