C Profile Parameters

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".

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
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    

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    
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

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 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

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 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