Skip to main content
Delphix

Masking Engine Commit-size

Introduction:

This article provides guidance on how to use the commit size feature in a Masking Job.

Recommendation:

The commit size determines how many rows are inserted, updated or deleted to the database. The default commit size is 10,000 and is represented as blank in the Masking Job GUI.  

This parameter can be increased to commit more frequently, which may require additional resources (i.e. redo logs and rollback segments). Decreasing may impact performance by forcing more frequent writes to the database. 

When increasing or decreasing the commit size consideration must be taken depending on the size of the rows being inserted and the size of the rollback segments.

 
  • Was this article helpful?