Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    4

    Unanswered: I can execute procedures in Parallel ?

    Hello , the question is :
    I can execute procedures in Parallel in Oracle 9i ?

    exemple

    Begin
    /*PARALLEL*/
    procedure A;
    /*PARALLEL*/
    procedure B;
    ...
    END;

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: I can execute procedures in Parallel ?

    Yes, using DBMS_JOB:

    DECLARE
    job1 INTEGER;
    job2 INTEGER;
    BEGIN
    DBMS_JOB.SUBMIT(job1,'PROCA;');
    DBMS_JOB.SUBMIT(job1,'PROCB;');
    END;
    /

    Provided your database is set up with at least 2 job queues processes.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •