2.104 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
number

The maximum number of cursors that Replicat (or each thread in a coordinated Replicat) can use. Valid values are from 1 to 250.

Example

MAXSQLSTATEMENTS 200