Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> 8.1.7 hangs on inserts

8.1.7 hangs on inserts

From: Kris <free_heeler226_at_yahoo.com>
Date: Thu, 30 Aug 2001 12:02:13 -0600
Message-ID: <3B8E7FA5.8050507@yahoo.com>

I've got a Java process that inserts records into an table, it runs great. However, just before our DBA left for Greece for two weeks he exported the database and then imported it to a new instance. When I run the exact same process on the new instance it takes between three seconds and twenty minutes to insert every 1000 records. When I run the process against the original instance it chugs along at a consistent 1000 records every ten seconds.

Both instances are on the same machine, I'm the only user on the machine, the only thing that's changed in the Java code is the sid/username/password.

Since the DBA did an export/import I'm wondering what could be causing this problem and where is the best place to start looking for differences in the two instances.

Thanks,
Kris Received on Thu Aug 30 2001 - 13:02:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US