Oracle Database Discussions

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!

Comparison of usage of /* APPEND PARALLEL*/ hint and DBMS_PARALLEL_EXECUTE

946981Jul 2 2012 — edited Jul 2 2012

I am trying to insert 10 million records from a source table to target table in the same instance.
What I observe is use of /* APPEND PARALLEL*/ is comparatively much faster than DBMS_PARALLEL_EXECUTE. Can anybody provide me with reasons of the same?

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 30 2012

Added on Jul 2 2012

#11g, #general-database-discussions, #performance, #pl-sql

5 comments

2,841 views