Executing PLSQL loops parallely
793965Mar 12 2013 — edited Mar 12 2013Hi gems...good evening..
I am using single instance Oracle 11.2.0.2, RHEL6 OS.
We have a PLSQL procedure in our schema in which there are two huge loops.
The outer loop has nearly 3 lakhs of records and the inner loop has nearly 2.8 lakhs of records.
So, for each record in the outer loop, the inner loop is getting executed for 2.8 lakhs of time (or less depending on the criteria).
And in the inner loop, there are lots of processing.
Obviously, it is taking a lot of time.
Now, I have asked my developers about the dependency between the records in the outer loop. They told me that there is no dependency in between them.
Means each record in the outer loop and hence the entire process can be processed independently.
So, I got a question, can we use it in parallel way.
Please help....thanks in advance.