6.5 Agent Parameters - General

This topic defines the following configurable parameters for your Oracle GoldenGate Veridata Agent:

Parent topic: Administer

6.5.1 compare.xmldatatype.format

To use the INDENT/NO INDENT functionality of XMLSerialize, update the compare.xmldatatype.format to either true or false. By default, the comparison is done with INDENT. To select NO INDENT set compare.xmldatatype.format=false.

Note:

The compare.xmldatatype.format parameter is only for Oracle Agent.

Syntax

compare.xmldatatype.format=true

Default

true

Parent topic: Agent Parameters - General

6.5.2 coos.batch.fetch

Parameter to fetch coos data in batches.

Default Value

false

Parent topic: Agent Parameters - General

6.5.3 database.characterSet

The database.characterSet parameter is used for overriding the source database character for comparison.

The parameter value should be the name of the character set used to encode the character data (CHAR, VARCHAR2, CLOB and LONG).

This parameter should match the SOURCECHARSET OVERRIDE in the replicat parameter file at the target database.

This is supported only for Oracle databases.

Parent topic: Agent Parameters - General

6.5.4 database.transaction.isolation

The database.transaction.isolation property controls the transaction isolation level used during initial compare.

The default value for Sybase, DB2, SQL Server and Teradata is READ_UNCOMMITTED.

The only value supported for Oracle is READ_COMMITTED.

SQL Server versions 2005 above also support the value SNAPSHOT which requires that ALLOW_SNAPSHOT_ISOLATION is enabled in the database.

Confirm out of sync always uses the READ_COMMITTED transaction isolation level.

Default Value

database.transaction.isolation=READ_UNCOMMITTED

Parent topic: Agent Parameters - General

6.5.5 pool.checkInterval

Time interval to check the timeouts for idle connections.

Default Value

1/4th of pool.maxIdleTime

Parent topic: Agent Parameters - General

6.5.6 pool.maxIdle

Max number of idle database connections present in pool.

Default Value

20

Parent topic: Agent Parameters - General

6.5.7 pool.maxSize

Database connection pool maintained by Veridata. It defines the max number of database connections held by this pool. There will a separate pool maintained by Veridata for each user and for each PDB in-case of Container DB.

Default Value

20

Parent topic: Agent Parameters - General

6.5.8 pool.maxIdleTime

Timeout for idle connections in the connection pool. The value is in seconds.

Default Value

300

Parent topic: Agent Parameters - General

6.5.9 pool.maxStatements

The number of statements cached per connection. The default value is 20.

Default Value

20

Parent topic: Agent Parameters - General

6.5.10 server.port

The server.port property is the port where the Oracle GoldenGate Veridata Agent listens for connection requests.

Syntax

server.port=Port Number
For example:
server.port=7862

Parent topic: Agent Parameters - General

6.5.11 rowscn

Use this property if you want to skip initial delta comparison. Only the rows greater than the given SCN value will be compared.
This property is enabled only for Oracle Agent.

Note:

This property works either with or without delta. However if you enable delta, then ensure that ORA_ROWSCN is used as delta column which is the default delta column for Oracle tables.

Syntax

rowscn=<scn number>

Default Value

None

Parent topic: Agent Parameters - General

6.5.12 zlib.buffer.flush.size

The zlib.buffer.flush.size property is used to decide the extra flush() call.

Decrease the value to a lower value (for example, 700000) if the agent appears to be in hanged state and the CPU usage for agent process is about 100%.

The value should be between 10000 and 2000000.

Default Value

1000000

Parent topic: Agent Parameters - General