Hi All,
I have typical code that we use for typical parallel processing using "dbms_parallel_execute"
dbms_parallel_execute.create_Task
dbms_parallel_execute.create_chunks_by_rowid
dbms_parallel_execute.run_task
get task status and retry to resume processingBut I am not able to do it successfully in production env though I tested same code in stage for many times.
I am not able to view the information of task in dba_parallel_execute_tasks while my job running in production oracle database.
It is simply going into the retry section
WHILE (l_retry < 2 AND l_task_status != DBMS_PARALLEL_EXECUTE.FINISHED)
LOOP
l_retry := l_retry + 1;
DBMS_PARALLEL_EXECUTE.resume_task (l_task_name);
l_task_status := DBMS_PARALLEL_EXECUTE.task_status (l_task_name);
END LOOP;
and coming with this exception
*ORA-06512: at "SYS.DBMS_PARALLEL_EXECUTE", line 458 ORA-06512: at
"SYS.DBMS_PARALLEL_EXECUTE", line 494 ORA-06512: at "pkg_name.", line 1902
ORA-29495: invalid state for resume task*
With exception it seems something went wrong with task status but I suspect task is itself not getting created and data is not getting chunked for a particular table upon this.
*Have you encountered this any time during your coding. I am really clueless what is going wrong. Why I am not able to see task in that data
dictionary and why its not processing anything I am not able to see chunked information when my job runs.