how to improve the performance of insert in pro*c

i have to insert millians of records with one record 512 byte one day. i use pro*c 's array insert, and the table has a primary index and serveral not null constraints.
at first it works with 100/s and after a day it works with 30/s. i dont know how slow it will be.
who has the idea how to improve the performance!! thanks a lot Received on Wed Mar 05 2003 - 20:55:24 CST