1.

What Are The Most Common Reasons Of The Replicate Process Slowing Down?

Answer»

Some of the possible reasons are:

  • Large amount of transactions on a particular table.
  • Blocking sessions on the destination DATABASE where non-Goldengate transactions are also taking place on the same table as the replicat PROCESSING.
  • If using DBFS, WRITING & reading of trail files may be slow if SGA parameters are not tuned.
  • For slow Replicat’s, LATENCY may be due to missing indexes on target.
  • Replicat having to process Update, delete of rows in very large tables.

Some of the possible reasons are:


Discussion

No Comment Found

Related InterviewSolutions