MAXSQLSTATEMENTS parameter to control the number of prepared SQL statements that can be used by Replicat both in regular processing mode and in
BATCHSQL mode. The value for
MAXSQLSTATEMENTS determines the number of open cursors that Replicat maintains. Make certain that the database can support the specified number of cursors, plus the cursors that other applications and processes use. Before changing
MAXSQLSTATEMENTS, contact Oracle Support.
MAXSQLSTATEMENTS for a coordinated Replicat, take into account that the specified maximum number of cursors is applied to each thread in the configuration, not as an aggregate threshold for Replicat as a whole. For example, if
MAXSQLSTATEMENTS 100 is specified, it is possible for each thread to have 99 open cursors without any warning or error from Replicat.
See "BATCHSQL" for more information about