The memorythreshold and size of the row determines the number of rows that should be copied from source to the destination table.īy default, the database migration tool uses memorythreshold of 300 MB. This parameter represents the maximum memory that a thread should use while copying the data from source to destination database. In this scenario, 10 threads are created and at a time a maximum of 10 tables data will be migrated.īased on requirements and available memory, you can modify the number of threads that should be used while migrating the data. To avoid OutOfMemoryError, whenever you increase the threadcount, ensure that you either decrease the maximum memory (memorythreshold) consumed by each thread or increase the total memory consumed by the tool ( heapspace).īy default, the database migration tool uses a threadcount of 10. If the total memory consumed by database migration tool is greater than the heapspace then it will result in database migration failure due to OutOfMemoryError. Hence reduces the total time taken for the database migration.īy increasing the threadcount, memory consumed by the database migration tool also increases, as more number of threads are copying the data simultaneously. By increasing the number of threads, more number of tables will be copied at a time (parallelly).
Each thread is responsible for copying the data from one source table to destination table. This parameter represents the number of threads that should be created while migrating data from source to destination database.