Re: Problem with Insertion time
Date: Thu, 14 Mar 2002 03:48:02 GMT
Message-ID: <S3Vj8.35203$q2.4517_at_sccrnsc01>
yes.
There are limits and things you can do.
IO is going to limit you. If the disk subsystem is slow nothing you do in
Oracle is going to make it go faster. The disk subsystem must be fast
enough to handle the transactions.
Also use bind variables.
Also use the array interface.
The more indexes you have on the table the more IO you generate and the
slower the inserts will be.(The indexes must be updated.)
Hopefully while your application is running you only define this insert
cursor once. Limit your hard parses.
That should be a start. You do not mention what version etc.
Jim
"Leader" <sohelcsc_at_yahoo.com> wrote in message
news:b1a93c73.0203130305.58a55806_at_posting.google.com...
> Hi All,
> I am facing problem with insertion in Oracle.
> Insert statement is taking more time. Suppose i want to insert 30,000
> rows at a time within few seconds. Is there any way in Oracle to tune
> the performance of Insertion time??
> Please help!!
> Hoque
Received on Thu Mar 14 2002 - 04:48:02 CET