Home -> Usenet -> comp.databases.oracle -> High volume loading to Oracle 8.x or Oracle 9i

High volume loading to Oracle 8.x or Oracle 9i

From: Roberto Jerez <rjerez_at_extensity.com>
Date: 19 Dec 2001 10:54:21 -0800
Message-ID: <7ca12392.0112191054.60e6484e_at_posting.google.com> 






I have several Java applications that load large amounts of data into
Oracle 8.x and Oracle 9i databases. I use Java JDBC to build batch
updates of around 2,000 rows and submit them to the database for
insert. The volume of data is increasing and the load time is becoming
unacceptable. My suspicion is that the database logging and index
building take up some time. So I removed the indexes from the database
(I apply them after the data is loaded) and this has improved the time
by about 20%. However the logging is still on.
My question: Is there a way to disable database logging during a batch
load operation while still using JDBC APIs? The database is offline
during the load process.


Thanks for any replies


Roberto Jerez
Received on Wed Dec 19 2001 - 19:54:21 CET












Original text of this message