This appendix provides the profile parameter decryption for use in configuring profiles used with the Oracle GoldenGate Veridata import and export utilities.
For more information about the parameters used in this configuration file, see Section 5.3, "Configuration File Element Reference".
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 |
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 |
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 |
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 |
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 |