How to tune INSERT statement to insert more than 4 million records faster.
977159Dec 7 2012 — edited Dec 13 2012I have an insert statement whcih inserts records ranging 0.5 million to 5 million into a table on a daily basis. the insert has /*+ append */ in it. I have run the SELECT statement separately and it does not take time. It takes time while inserting into the table. it takes around 26 mins to insert 4.5 million records. For 2 million records it takes 4 mins.
I had tried one EXCHANGE PARTIITION method but in this to insert into another table temp table it is taking same amount of time.