Hi It's an Insert .... select. The select part is spending exactly the same amount of time(13 secs) from the extended trace. Rows Operation 0 LOAD TABLE CONVENTIONAL (crC1112 pr4448 pw=0 time11385671 us) 43,564 FILTER (crB7284 prD8 pw=0 time572425 us) Thanks ________________________________ From: Sidney Chen <huanshengchen@xxxxxxxxx> To: ca_raj@xxxxxxxxx Cc: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx> Sent: Tuesday, February 7, 2012 11:05 AM Subject: Re: Index Maintenance Vs Insert Response Time Hi Antony, Have you enabled entended sql trace to check the what's the major component of the current 6-7 minutes. Unless identifying what's responsible for the response time, we can only guess. what's the method to insert the rows, are inserted in a single insert...select... statment, in by inserting 45,000 times, in such a case, you may want to try the array insert method, the forall statment. -- Regards Sidney Chen -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l