what is means ? /*+ ROWID (dda) */
TaerangAug 18 2012 — edited Aug 19 2012Hi 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;
/