MAXSQLSTATEMENTS
Valid For
Replicat
Description
Use the 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.
When setting 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 BATCHSQL
mode.
Default
250 cursors
Syntax
MAXSQLSTATEMENTS number
Example
MAXSQLSTATEMENTS 200