5000 inserts into 2 long tables

[Luca]

Hello Bank Environment: Oracle 8.1.7 Linux RedHat 7.3 Pentium III 500 MHz, 1 GB memory Have an array in memory containing information to make 5000 inserts in 2 tables. I'm scanning the array and inserting each row in the tables 2. The commit will come after the end of the inserts.

My problem: is taking over an hour and still not finish. What can I do to improve this?

[] s Luca

[dr_gori]

The problem is even in inserts?
I tried to comment on just the inserts and run your program to see if it takes hours too?

And the problem is really the INSERT as well .... How many rows have this table? Have indexes? Has triggers? Send us this information!