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.

About these ads

2 Comments

  1. 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. 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 Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 289 other followers