R3load system copy(Import) took lot of time

[gurbirbhatia]

Hi

We are upgrading SAP from 4.7 to ECC6 EHP5. Currently we have Solaris 9 ,oracle 9.2.0.8

From installation master we have export(system copy) the data (200 GB took 3.30Hrs) and than we are installing R/3 4.7 with oracle 10g using( system copy Exported data of 9i) and this ( sap r3load) took around 3 days to install. Can we increase the performance by setting any oracle or solaris level parameters

Gurbir Singh

[Former Member]

Hello,

What's the hardware configuration for the server ? And what migration parameters did you choose in SAPinst during IMPORT ?

Thanks

[gurbirbhatia]

Tnanks for reply!

we have Sparc platform Solaris 10 64bit server , T3-1 server with 16 core ,1,65Ghz, 32GB RAM,each core has 8 threads.

Import parameters are :

1. Standard System copy (R3 load), we give 12 parallel processes for R3load

tell me if any other info required

Gurbir Singh

[Former Member]

Hi,

Did you observe the CPU and memory utilization during the export?

Did you choose table splitting option?

Did you run the statistics for Oracle?

Are the Oracle parameters set according to SAP's recommendation?

Br,

Venky

[gurbirbhatia]

Hi Venky

Did you observe the CPU and memory utilization during the export?

Yes ! cpu only may be around 4% and memory around 24%

Did you choose table splitting option?

Yes

Did you run the statistics for Oracle?

No statistics while export

Are the Oracle parameters set according to SAP's recommendation?

Can you guide what are the parameters

Thanks

Gurbir Singh

[Former Member]

hi gurbir,

Please follow note# 1171650 (Oracle automated parameter check) and execute the script.

This should give you a report showing the discrepancies and recommendations.

Also, you can slightly increase your SGA and PGA.

Ensure you have enough Oracle processes and sessions configured.

Ensure the OS env variable CPIC_MAX_CONV is set to more than 500.

Let us know in case if you need help in Oracle recommendations once you execute the script.

Br,

Venky