Parallel Treatment When Procedure Executed From Rate Schedule

(Doc ID 1377745.1)

Last updated on OCTOBER 19, 2016

Applies to:

LODESTAR EIP - Version 1.6.1.4 and later
Information in this document applies to any platform.

Symptoms


=== ODM Issue Clarification ===
We have an issue when executing a procedure which does some parallel treatment, from Lodestar Rate Schedule
basically the procedure does the following :

EXECUTE IMMEDIATE 'alter session force parallel dml';
EXECUTE IMMEDIATE 'alter session enable parallel query';
INSERT /*+ APPEND PARALLEL */ into TABLE_DESTINATION SELECT /*+ PARALLEL*/ FROM TABLE_SOURCE

-> When executed from sqlplus from the lodestar server, The INSERT is done in PARALLEL mode so it takes roughly 1 hour. Below are the session environment values :
PARAMETER DFL VALUE
parallel_dml_mode NO FORCED

-> When executed with lodestar from the call procedure, The INSERT is NOT done in PARALLEL mode so it takes much more than 1 hour. Below are the session environment values :
PARAMETER DFL VALUE
parallel_dml_mode YES DISABLED

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms