Re: how can i tune the insert statement?

Hi

Do you use Bind variable ?
disabled all the indexes on the table,
commit at every 1000 transactions,
look for bulk insert in pl/sql.

hth

Chris

sohelcsc_at_yahoo.com (Leader) wrote in message news:<b1a93c73.0201150726.6027f2e4_at_posting.google.com>...
> Hi all,
> i am trying to insert 1 million rows in oracle from java front_end.
> but it is taking 7 rows per second. i think we can increase the number.
> but i don't know how i can tune the insert statement. can anyone help
> me please?
Received on Tue Jan 15 2002 - 22:05:05 CET