9 Replies Latest reply: Aug 6, 2013 7:52 AM by Billy~Verreynne RSS

    Parallelism in PL/SQL block

    bijunator_II

      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?