title: How to call multiple procedures in parallel in Oracle 12c?
body: <p>I have a procedure as follows,</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE engineering_all ( idx IN NUMBER )
  IS
  tempstmt VARCHAR2(2000);
  BEGIN
  create_table_like( 'results_temp', 'results', 1);
  
  tempstmt :=  'ALTER TABLE results_temp CACHE';
  EXECUTE IMMEDIATE tempstmt;
  
  engineering('CONSERVATIVE', idx);
  engineering('INTERMEDIATE', idx);
  engineering('AGGRESSIVE',   idx);
  END;
  /
  </code></pre>
  
  <p>Three calls to procedure engineering are independent of each other, so I want to parallelize this. I came across multiple ways like DBMS_PARALLEL_EXECUTE, DBMS_JOB, DBMS_SCHEDULER but not able to figure out which one is the most effective for my time-optimization objective. </p>
  
  <p>Please help me out to figure out which one to choose and how can I implement that? </p>