scan_fetch_size

The number of rows to fetch from the primary database when Oracle LogMiner is scanning the log in each network round-trip.

Default

1

Value

An integer from 1 to 20.

Comments

  • The value of the scan_fetch_size parameter is a trade-off between the number of network round-trips and latency:
    • Higher value increases latency because Oracle LogMiner waits for the specified number of log records to be filled after reaching the end of the log file.
    • Lower value reduces latency but requires more network round-trips for Oracle LogMiner to return the scan results to the Replication Agent.

  • If the primary database is continuously updated, you can specify a higher scan_fetch_size parameter value. Otherwise, specify a lower value.