Question
DBMS_PARALLEL_EXECUTE.CREATE_CHUNKS_BY_SQL is called properly but START_ID IS NULL
I call DBMS_PARALLEL_EXECUTE.CREATE_CHUNKS_BY_SQL in different configuration and users. At my personel computer, it works well. below code assigns start_id to 1. But at business computer, it can not assign START_ID. I mean START_ID is null. I think there is a missing Grant.
begin
--sys.dbms_parallel_execute.drop_task(task_name => 'TASK_TEST');
sys.dbms_parallel_execute.create_task(task_name => 'TASK_TEST');
sys.DBMS_PARALLEL_EXECUTE.CREATE_CHUNKS_BY_SQL('TASK_TEST','SELECT 1 column_1, 2 column_2 FROM sys.dual',false);
end;
select start_id from sys.dba_parallel_execute_chunks;
--NULL ( at business computer/environment ) --WRONG result.
select start_id from sys.dba_parallel_execute_chunks;
--1 (at my personel computer/ Virtual Machine ) --EXPECTED result is OK.
Expected value is 1. I run that code in different computer. Which grant is missing ? Or where should I focus to eleminate the problem