Re: Paralellizing Pl/sql inserts

Lots of good suggestions here.

How is your big table partitioned? If it's something like 128 hash partitions it's going to be a pain, but if it's something more manageable, you could try splitting your 65 million row inserts into data by partition and do insert /*+ append */ bigtable (partition). Each of those can go in parallel (seperate stmts). Drop indexes first and recreate using massive parallel hint after inserts are done.

Let us know how it works out for you. It's an interesting problem.

Finn

--
http://www.freelists.org/webpage/oracle-l