> We are testing an application prototype and inserting 1000 rows at a> time from 1 table and populating into 2nd table in a loop and
inserting
> 1M rows. 2nd table have primary key on 2 column, 1 column unique key
and
> 2 non-unique indexes each having 6 columns. This is 10g on WIN2K.

This is not exactly clear...=20

are you doing the following

For x in (select stuff from table)

insert 1000 rows
end loop
commit;

you are stating you can do 30,000 of those per second at one point?
Please post pseudo-code. Please do NOT post all of the real code, just
an outline.=20

Please see the official ORACLE-L FAQ: http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.