Usually developers don't have any clue of the internals of a database.
So immediately when something doesn't perform as expected they start
blaming the database. You are no exception to this rule. In 80 percent
of all cases however, it is not the database but it is the application.
If you perform single record inserts and commit every record, how would
you expect the database is going to perform?
Apparently there is no DBA in your project. The error is not the
database, the error is that you don't have a DBA in your project (and
probably performed an out of the box install which of course doesn't
perform).
The best immediate optimization you can make is to hire a DBA, so that
at least in your next post the version of Oracle is included.
--
Sybrand Bakker
Senior Oracle DBA
Received on Mon Sep 26 2005 - 09:48:32 CDT
