Profile Parameters

C Profile Parameters

This appendix describes how to configure the profiles used with the Oracle GoldenGate Veridata import and export utilities.

For more information about the parameters used in this configuration file, see Configuration File Element Reference.

C.1 General (profile-general)

Name on UI	Name to be used in configuration XML file	Default Values	Allowed Values	Type
Out-Of-Sync Output Format	oos-format	binary	binary, xml, both, none	Enumeration
Maximum Size of Each Out-Of-Sync XML Chunk (Rows)	oos-xml-chunk-size	500	1 to 100000	int
Report in-sync rows to report file	reports-insync	false	true, false	boolean
Report in-sync after in-flight rows to report file	reports-inflight	false	true, false	boolean

C.2 Sorting Method (sorting-method)

Name on UI	Name to be used in configuration XML file	Default Values	Allowed Values	Type
Sort Data Using	sort-method	database	server, database	Enumeration
Temporary Storage Directory for Source Data	sort-src-temp-dir	string	NA	NA
Temporary Storage Directory for Target Data	sort-tar-temp-dir	string	NA	NA

C.3 Initial Compare (initial-compare)

Name on UI	Name to be used in config XML file	Default Values	Allowed Values	Type
Max Concurrent Comparison Threads	max-thread	4	1 to 20	Int
Terminate when Maximum Records Out-Of-Sync	max-oos-record	100000	0 to 100000000	int
Output Out-Of-Sync Record Details to Report File	output-oos-rpt	false	true, false	boolean
Update Report file Every (seconds)	update-rpt-second	0	0 to 1000000	int
Update Report file Every (records)	update-rpt-record	0	0 to 100000000	int
Limit Number of Input Rows	limit-input-row	0	0 to 100000000	int
Source Oracle optimizer hint	src-oracle-hint	string	NA	NA
Target Oracle optimizer hint	tar-oracle-hint	string	NA	NA
Generate Messages	rpt-msg	none	none, info, warning, both	Enumeration
Generate Warning Messages For Out-Of-Sync Rows After (differences)	rpt-warn-msg-threshold	50	0 to 1000000	int
Use Static Listening Port For Agent During Row Hash On Source (0 to use dynamic port list)	src-agent-static-port	0	0 to 65535	int
Use Static Listening Port For Agent During Row Hash On Target (0 to use dynamic port list)	tar-agent-static-port	0	0 to 65535	int
Source Process Name Starting With (Must start with '$', followed by two letters, and end with ''. Example: $AA)	src-nsk-name	string	NA	NA
Source Process CPU Number	src-nsk-cpu	-1	-1 to 16	int
Source Process Priority	src-nsk-priority	0	0 to 1000000	int
Target Process Name Starting With (Must start with '$', followed by two letters, and end with ''. Example: $AA)	tar-nsk-name	string	NA	NA
Target Process CPU Number	tar-nsk-cpu	-1	-1 to 16	int
Target Process Priority	tar-nsk-priority	0	0 to 1000000	int

C.4 Confirm-Out-Of-Sync (confirm-out-of-sync)

Name on UI	Name to be used in configuration XML file	Default Values	Allowed Values	Type
Perform Confirm Out-Of-Sync Step By default, Perform Confirm Out-Of-Sync Step is enabled. You can make Initial Compare Terminate when Maximum Records Out-Of-Sync effective ONLY when Perform Confirm Out-Of-Sync Step is disabled. This way, the MOOS will include all OOS and not subject to 100k limit when COOS is enabled.	coos-enable	true	true, false	boolean
Run Concurrently With Initial Compare	coos-concurrent	true	true, false	boolean
Confirm-Out-Of-Sync Batch Size	Batch-size	1000	1 to 100000 Increase this value in the range of 10000, in case the `coos with join` strategy is used. For more information, see Fetching COOS rows using temporary table in Tuning Performance in the Using Oracle GoldenGate Veridata guide.	int
Delay Confirm-Out-Of-Sync By (seconds)	coos-delay	0	0 to 1000000	int
Terminate when Maximum Records Out-Of-Sync	coos-max-oos	100000	0 to 100000000	int
Output Out-Of-Sync Record Details to Report File	coos-output-oos-rpt	false	true, false	boolean
Update Report file Every (seconds)	coos-output-rpt-second	0	0 to 100000000	int
Update Report file Every (records)	coos-output-rpt-record	0	0 to 100000000	int
Source Oracle optimizer hint	coos-src-oracle-hint	string	NA	NA
Target Oracle optimizer hint	coos-tar-oracle-hint	string	NA	NA
Generate Messages	rpt-msg	none	none, info, warning, both	Enumeration
Generate Warning Messages For Out-Of-Sync Rows After (differences)	rpt-warn-msg-threshold	50	0 to 1000000	int
Use Static Listening Port For Agent During Row Hash On Source (0 to use dynamic port list)	src-agent-static-port	0	0 to 65535	int
Use Static Listening Port For Agent During Row Hash On Target (0 to use dynamic port list)	tar-agent-static-port	0	0 to 65535	int
Source Process Name Starting With (Must start with '$', followed by two letters, and end with ''. Example: $AA)	src-nsk-name	string	NA	NA
Source Process CPU Number	src-nsk-cpu	-1	-1 to 16	int
Source Process Priority	src-nsk-priority	0	0 to 1000000	int
Target Process Name Starting With (Must start with '$', followed by two letters, and end with ''. Example: $AA)	tar-nsk-name	string	NA	NA
Target Process CPU Number	tar-nsk-cpu	-1	-1 to 16	int
Target Process Priority	tar-nsk-priority	0	0 to 1000000	int

C.5 Repair (repair)

Name on UI	Name to be used in configuration XML file	Default Values	Allowed Values	Type
Run Repair Automatically after Compare	repair-after-compare	False	True, false	boolean
Repair batch size	batch-size	1000	1 to 100000	int
Repair transaction size	txn-size	1	0 to 100	int
Concurrent Repair Operations	concurrent-operation	1	1 to 100	int
Check changed values	check-change-value	true	true, false	boolean
Terminate when maximum repair warnings	terminate-max-warn	10000	0 to 2147483647	Int
Write Repair Success Messages to Report	write-success-rpt	true	true, false	boolean
Disable DB Triggers Session Based	disable-trigger	false	true, false	boolean
Report
Disable DB Triggers Session Based	disable-trigger	false	true, false	boolean