The following settings and configurations maybe optimized in high volume transactions to achieve higher performance.
Variable | Description |
---|---|
STATUS_BEAT_LCR | This determines how often a log message is written showing number of processed LCRs (in LCR count) (use 0 to disable). As of Dbvisit Replicate 2.3.14 the default is 10,000. For high volume configurations consider increasing to higher number. |
OCI_COMMIT_MODE = NOWAIT BATCH | This may improve apply processing speed. Only set for non RAC target systems. See Configuration Variable Reference for more information. |
_ENABLE_5_19_PARSE = NO | Disables processing of auditing information. This information is used by CDC/Audit function or by querying the DBRSAPPLY_PKG package on the target database (e.g. in triggers). This information includes source sid, serial#, transaction id, os user, os machine, login name. If this information is not required, then this can be disabled. Please Internal Variables for more information |