HeidiC
Member
I need to load over 560K records from Item Master Z table F4101Z to F4101 through JDE program R4101Z1I. It took me 10 hours to load 100K records and crashed with a blue screen. I thought filling Short Item Number (ITM) by R4101Z1I might take a lot of time so I pre-filled the ITM in F4101Z1, that somehow improved the performance. (It took 8 hours to load 51K records if I didn't pre-fill in ITM.)
My DBA told me he saw many cursors open (up to 46) at the back end. Is there anyway I can improve the performance of this program?
Thank you for your help in advance!
Heidi
Xe Update4 Win2K SP18 Oracle 8.1.7<P ID="edit"><FONT SIZE=-1>Edited by HeidiC on 3/1/02 02:57 PM.</FONT></P>
My DBA told me he saw many cursors open (up to 46) at the back end. Is there anyway I can improve the performance of this program?
Thank you for your help in advance!
Heidi
Xe Update4 Win2K SP18 Oracle 8.1.7<P ID="edit"><FONT SIZE=-1>Edited by HeidiC on 3/1/02 02:57 PM.</FONT></P>