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!

Parallelism in PL/SQL block

bijunator_IIAug 6 2013 — edited Aug 6 2013

Say I have a anonymous PL/SQL block with insert queries inserting huge data into certain table.

For faster execution I have added hints in the insert statements and in the select statements on all the tables.

All the tables involved are partitioned. But when I checked the sessions while execution, I could not find parallel sessions. Why?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 3 2013

Added on Aug 6 2013

#general-database-discussions

9 comments

1,535 views