SQL & PL/SQL

1 error has occurred

Your session has timed out.

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

BULK COLLECT & INSERT taking longer time

User_XOXLXJul 1 2021

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 !

Processing

Added on Jul 1 2021

#pl-sql

3 comments

2,199 views

SQL & PL/SQL

BULK COLLECT & INSERT taking longer time

Comments

Post Details