1 Reply Latest reply: Aug 2, 2013 9:05 AM by Chrisjenkins-Oracle RSS

    ttMigrate and numThreads option


      Hello Chris,

      Please let me know the following:


      1. What is the benifit of using numThreads option with ttMigrate?

         While we used two threads in place, we saw that the performance is slower compared to using a single thread.


      2. Can you please explain the details of numThreads option?




        • 1. Re: ttMigrate and numThreads option

          The numThreads option is intended to speed up restoration by performing some processing in parallel using multiple threads. The main operations that benefit are (a) restoring the data for large tables (many rows) and (b) index creation. When operating with multiple threads dependency checking is necessary to ensure that one thread is not performign an operation that may depend on an object that has not yet been created by another thread. This can slow things down in cases where there are not many large tables with many indexes.

          Slow performance is most likely due to the need for a lot of dependency checking but if you file an SR with the specifics then we can look into it.