I need my original question answered, how are you measuring 'rows/second.' what periods of time are you getting 30 commits/second and what period of time are you getting 18 records/second? btw, the slow down due to concurrency is understandable do to you committing so often. also, let me understand your algorithm. table1 has 1000 records in it. You full scan this and bulk collect it to memory. you do some processing in memory you forall array insert 1000 records you repeat. you are reading the same 1000 records each time? ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------