1.

What Are The Most Common Reasons Of An Extract Process Slowing Down?

Answer»

Some of the possible reasons are:

  • Long running batch transactions on a table.
  • Insufficient memory on the Extract side. Uncommitted, long running transactions can cause WRITING of a transaction to a TEMPORARY area (dirtmp) on disk. Once the transaction is committed it is read from the temporary location on the FILE system and converted to trail files.
  • SLOW or overburdened Network.

Some of the possible reasons are:


Discussion

No Comment Found

Related InterviewSolutions