Agent Parameters - General
This topic defines the following configurable parameters for your Oracle GoldenGate Veridata Agent:
compare.xmldatatype.format
To use the INDENT/NO INDENT functionality of XMLSerialize, update the compare.xmldatatype.format to either true or false.
To select INDENT set compare.xmldatatype.format=true.
Note: The compare.xmldatatype.format parameter is only for Oracle Agent.
Syntax
compare.xmldatatype.format=falseDefault
false
coos.batch.fetch
Parameter to fetch COOS data in batches, instead of running individual queries, in turn accelerating the performance.
Default Value
false
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.
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
pool.maxIdleTime
Timeout for idle connections in the connection pool. The value is in seconds.
Default Value
300
pool.checkInterval
Time interval to check the timeouts for idle connections.
Default Value
1/4th of pool.maxIdleTime
pool.maxIdle
Max number of idle database connections present in pool.
Default Value
20
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
pool.maxStatements
The number of statements cached per connection. The default value is 20.
Default Value
20
server.port
The server.port property is the port where the Oracle GoldenGate Veridata Agent listens for connection requests.
Syntax
server.port=Port NumberFor example:
server.port=7862rowscn
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
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
network.checksum.level
Supported Value
REJECTED/ACCEPTED/REQUESTED/REQUIRED
Default Value
ACCEPTED
network.checksum.types
Default Value
SHA256
Example
network.checksum.types= SHA512
network.encryption.level
Supported Value
REJECTED/ACCEPTED/REQUESTED/REQUIRED
Default Value
ACCEPTED
network.encryption.types
This parameter is used to enable Network Encryption.
Example
network.encryption.types= AES256