C Profile Parameters

Here you can find the profile parameter decryption for you 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.

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

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
Maximum Memory Usage (MB)	sort-max-memory	50	1 to 100000	int
Temporary Storage Directory for Source Data	sort-src-temp-dir	string
Temporary Storage Directory for Target Data	sort-tar-temp-dir	string

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
Target Oracle optimizer hint	tar-oracle-hint	string
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
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
Target Process CPU Number	tar-nsk-cpu	-1	-1 to 16	int
Target Process Priority	tar-nsk-priority	0	0 to 1000000	int

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	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	10	1 to 100	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
Target Oracle optimizer hint	coos-tar-oracle-hint	string
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
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
Target Process CPU Number	tar-nsk-cpu	-1	-1 to 16	int
Target Process Priority	tar-nsk-priority	0	0 to 1000000	int

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	10	1 to 100	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