Hi Folks,
I am trying to insert about 28M records into a table using bulk collect & Forall. I notice that 28.5M records get inserted within 20-25 minutes but the rest of the .2M (200K) records take almost the same time to complete fetch and insert. I am using a LIMIT of 500K in the bulk collect. Can you please explain why this strange behavior for the final set of insert ? Attaching some of the logs and logic that I am using.
TIA !
