Memory Consumption Control

RTL uses full incremental compilation to control memory consumption and you can control the net-change database size to reduce memory consumption.

• SQT Memory Consumption Control for RTL
  Control the maximum memory consumed by unpacked commands in the DSI SQT cache during transaction profiling in RTL .
• Net-Change Database Size
  Reduce memory consumption by the net-change database by triggering the net-change database to flush data to the replicate database once the net-change database size reaches a threshold size.
• Full Incremental Compilation
  Full incremental compilation improves replication performance for real-time loading (RTL) by reducing memory consumption during the processing of large compilable transactions that contain many commands.
• Memory Control Parameters and Replication Server Processing
  Replication Server actions depend on the values you set for memory control parameters.
• Incremental Parsing for RTL
  To further reduce memory consumption, enable incremental parsing by the DSI Scheduler thread by setting dsi_incremental_parsing on.