Hi Tom,

I'm using DBMS_PARALLEL_EXECUTE package to run in parallel my PL/SQL procedure's work.

The chunks are generated by my own SQL on table which contains numeric field "priority" like this

   v_sql := '
    select rowid, rowid
    from tmp_table
    order by priority
  ';

  DBMS_PARALLEL_EXECUTE.CREATE_CHUNKS_BY_SQL(
    task_name   => v_task_name,
    sql_stmt => v_sql,
    by_rowid  => true
  );

And then I run task with parallel_level = 2

      v_sql_stmt :=  '
      declare
        v_schema_name varchar2(100);
        v_sql varchar2(1000);
      begin

        select schema_name into v_schema_name
        from tmp_table
        where rowid between :start_id and :end_id;
        
        v_sql := 
        ........

        execute immediate v_sql;
      end;
    ';

   DBMS_PARALLEL_EXECUTE.run_task (
      task_name => v_task_name,
      sql_stmt => v_sql_stmt,
      language_flag => DBMS_SQL.NATIVE,
      parallel_level => 2
    );

Next SQL gets result

  SELECT  *
  FROM    user_parallel_execute_chunks c
  WHERE   c.TASK_NAME=v_task_name;

CHUNK_ID           TASK_NAME              STATUS           START_ROWID             END_ROWID                              JOB_NAME
23645805 RUNCR_TASK$_23645803 PROCESSED ABVN77AAIAAOFnbAAB ABVN77AAIAAOFnbAAB   TASK$_17757_1 
23645806 RUNCR_TASK$_23645803 ASSIGNED ABVN77AAIAAOFnbAAC ABVN77AAIAAOFnbAAC   TASK$_17757_2 
23645807 RUNCR_TASK$_23645803 ASSIGNED ABVN77AAIAAOFnbAAD ABVN77AAIAAOFnbAAD   TASK$_17757_1         
23645808 RUNCR_TASK$_23645803 UNASSIGNED ABVN77AAIAAOFnbAAE ABVN77AAIAAOFnbAAE   null 
23645809 RUNCR_TASK$_23645803 UNASSIGNED ABVN77AAIAAOFnbAAF ABVN77AAIAAOFnbAAF   null 
23645810 RUNCR_TASK$_23645803 UNASSIGNED ABVN77AAIAAOFnbAAG ABVN77AAIAAOFnbAAG   null 
23645811 RUNCR_TASK$_23645803 UNASSIGNED ABVN77AAIAAOFnbAAH ABVN77AAIAAOFnbAAH   null 
23645804 RUNCR_TASK$_23645803 UNASSIGNED ABVN77AAIAAOFnbAAA ABVN77AAIAAOFnbAAA   null 

So, "order by" expression in SQL to creating chunks work correct because CHUNK_ID in user_parallel_execute_chunks increases in accordance with field "priority" in table tmp_table, but first chunks which were started have IDs greater than the minimum (23645804).

Is there a way to force to take in the work chunks in special order? I expected than chunks will work in ascending CHUNK_ID order (23645804, 23645805, 23645806...)

Thanks in advance.