2 Replies Latest reply on May 30, 2013 2:11 PM by 1011767

    Multi Threading Oracle 11.2

      Have a database with 91 Million records. Need to reformat two columns. Have written a stored procedure and able to update. The update runs about 750,000 records /30 minutes with a commit for about 100,000 records. Rought ETA is 40 hours.

      Is there any way to multi thread this process and reduce the elapse time without blowing up the undo table space?

      What are the pros and cons of multi threading if at all possible?