DBMS_PARALLEL_EXECUTE

Here is a recent thread from OTN forums. The question raised is WTF? whether a hint in the examples section of DBMS_PARALLEL_EXECUTE documentation have to be used or not and why it is there. What do you think about it? Have a look in the documentation and mark your choice in a poll:

PS. In my view it’s a bug. I left a comment in the documentation about it, but didn’t receive any reply yet.

This entry was written by Timur Akhmadeev, posted on May 31, 2010 at 22:22, filed under Hints, Oracle, PL/SQL and tagged , , , , . Bookmark the permalink. Follow any comments here with the RSS feed for this post. Post a comment or leave a trackback: Trackback URL.

2 Comments

  1. Rob van Wijk
    Posted May 31, 2010 at 23:28 | Permalink | Reply

    Hi Timur,

    I also noticed this documentation bug while preparing for a 11gR2 presentation in November last year. If I recall correctly, the code samples work the same (on the surface?) with or without the hint.

    Regards,
    Rob.

  2. Jeffrey Kemp
    Posted June 1, 2010 at 07:51 | Permalink | Reply

    The hint is invalid anyway – the optimizer will ignore it because it doesn’t refer to any table or table alias in the statement.

    update /*+ ROWID (dda) */ EMPLOYEES e
    SET e.salary = e.salary + 10
    WHERE rowid BETWEEN :start_id AND :end_id

Leave a comment