DB-Export Long runtime

[mk83]

Hi Guys,

I hope you will be able to help out, we are trying to test a migration from Oracle to SAPDB, the problem is that the export takes over 30hours to run, our Database has a size of 350+Gb, the tablespace that takes 75% of the time is PSAPBTABD, which uses the sapappl1.str to export, I have split this file up into smaller components, sapappl3-13.str, each of 4 hours each, but the .str that contains PCL4, still takes +/- 20 hours to run, SAP recomended I increase the Oracle share pool, but this has had no effect! I really need to shrink the export time to <15hours.

How can I increase the speed of a full table read on Oracle? The index used is the default one on the key fields (because it does actually have to read all the records).

We are running Oracle ver 8.1.7.3.0, I would appreciate any help,

Thanks in advance,
MK83

 

[karluk]

If you aren't doing so already, you should try running a direct path export. It's supposed to be much faster than a conventional export. To do this, specify DIRECT=Y in your parameter file.