PARALLEL hint ignored in PL/SQL block?

From: Vladimir Barac <vbarac_at_Alghanim.com>
Date: Thu, 31 Jul 2008 10:28:37 +0300
Message-ID: <9E84D391605564489C53192A8DE5B1120179FABF@ALGMAIL.Alghanim.com>

Hi

When following DML is executed standalone

Insert into tableA select /*+ parallel(B) parallel(C) */ * from tableB_at_link B, tableC_at_link C where <some conditions>;

tableB and tableC are accessed in parallel and everything is fine.

However, if this is executed within PL/SQL block (or within stored procedure), tableB and tableC are not accessed in parallel. What may be the reason for this behavior? My goal is to improve performance of datamart batch load jobs.

Thanks,

Vladimir Barac
Database administrator | Alghanim Industries P.O. Box 223, Safat 13003, Kuwait
Tel: +965 881 111  / ext. 2960

---

This e-mail message and any attachments to it are for the sole use of the intended recipients and may contain confidential and privileged information. This e-mail message and any attachments are the property of Yusuf A. Alghanim & Sons w.l.l. or any of its subsidiaries or affiliates (“Alghanim Industries”). Any unauthorized review, use, disclosure, or distribution of this e-mail message or its attachments is prohibited. Any opinions expressed in this message are those of the author and do not necessarily reflect the opinion of Alghanim Industries. If you are not an intended recipient, please notify the sender by reply e-mail and destroy all copies of the original message and any attachments.

---

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jul 31 2008 - 02:28:37 CDT