4 Replies Latest reply on Aug 19, 2012 10:43 AM by APC

    what is means ? /*+ ROWID (dda) */

    Taerang
      Hi everyone

      i'm tested to DBMS_PARALLEL_EXECUTE of 11gR2 NF

      refer to link
      http://docs.oracle.com/cd/E11882_01/appdev.112/e10577/d_parallel_ex.htm
      http://www.oracle-base.com/articles/11g/dbms_parallel_execute_11gR2.php


      I saw ' /*+ ROWID (dda) */ ' to the many blogs and the document.

      *' /*+ ROWID (dda) */ ' hint is correct or incorrect ??*

      I think, " /*+ ROWID(t) */ " is right


      example :

      DECLARE
      l_sql_stmt VARCHAR2(32767);
      BEGIN
      l_sql_stmt := 'UPDATE /*+ ROWID (dda) */ test_tab t
      SET t.num_col = t.num_col + 10
      WHERE rowid BETWEEN :start_id AND :end_id';

      DBMS_PARALLEL_EXECUTE.run_task(task_name => 'test_task',
      sql_stmt => l_sql_stmt,
      language_flag => DBMS_SQL.NATIVE,
      parallel_level => 10);
      END;
      /