Monitoring Propagation of Transactions to the Oracle Database

Since the AWT cache group uses the replication agent to asynchronously propagate transactions to the Oracle database, these transactions remain in the transaction log buffer and transaction log files until the replication agent confirms they have been fully processed by the Oracle database.

You can monitor the propagation for these transactions with the ttLogholds built-in procedure.

When you call the ttLogHolds built-in procedure, the description field contains _ORACLE to identify the transaction log hold for the AWT cache group propagation.

Command> call ttLogHolds();
< 0, 18958336, Checkpoint                    , cache1.ds0 >
< 0, 19048448, Checkpoint                    , cache1.ds1 >
< 0, 19050904, Replication                   , ADC6160529:_ORACLE >
3 rows found.

See the Show Replicated Log Records section in the Oracle TimesTen In-Memory Database Replication Guide.

You can also improve performance by configuring parallel propagation to the Oracle Database. See Improving AWT Throughput with Parallel Propagation to the Oracle Database.