Now I am inserting huge amount of DATA in ORACLE. Its about 6 million rows. I am using JAVA for chunked insert. So that I can commit after a while. Using JAVA threads improved the performance a lot. Using one where clause you can make chunks of the whole data for insertion then just use threads to inserts few chunks of data at a time. It will decrease the load on the DB also. Because it will not need to increase the memory size for cached data for the insertion data. By the way I will go for a procedure very soon...