I got a simple package getting data from one Oracle DB to another Oracle DB. The total rows is around 1 millions. But it took forever to run it. The average loading speed is 5000 rows/minutes. My workstation configuration is 4cpu, 2.8GHz, 1GB RAM.
Even I run the package in the server, which is Inter Xeron CPU, 3.2 GHz, 3.75 RAM, the loading speed is still slow. I already set DefaultBufferSize to 70MB, and reduce DefaultBufferMazRows to 5000. But it 's still running slow. I am wondering which parameter should I have to adjust to improve the performance. Thank you in advance.