This section describes the data transfer optimization implemented for the OracleScanner. Optimization is the means by which the scan task seeks to minimize the load on the communication channel by making scan device requests more efficiently.
The aim of optimization is to include as many scan input records in a single request as possible, thus reducing the communication overhead.
Using the trans before commit and max recs per trans attributes in the RTAP communication port point, transactions to the Oracle database can be optimized for both speed and efficiency (scan task memory usage).
Some factors to consider when selecting values for trans before commit and max recs per trans:
In general, trans before commit should be set to the maximum number of transactions required to process the largest scan input table. This will cause the data to be committed once for each scan input table. And depending on the size of the scan input table, max recs per trans should be set to the number of records of the largest scan input table.
If processing of scan input tables become heavily loaded, additional communication ports can be configured to off-load the processing to other OracleScanner(s). However, the maximum data transfer may be limited by the connection between the RTAP system and the Oracle database system.