Note This statement replaces the previous SET LOGREADER BATCH statement.
Access requirements
SYS_ADMIN_ROLE role
Usage
Use the SET REPLICATION BATCH statement to configure the number of transactions from the log that can be returned as a single transaction, see Setting transaction batches.
The transaction batch setting applies only to the current session and is valid for all reads from the SYS_LOG table that are started after the statement is executed.
Note Setting the batch transaction size does not alter the catchup position; the catchup position can be used to read all transactions in the batch again.
Parameters, clauses, keywords, and variables
▪ size: Maximum number of transactions that can be returned as a single transaction. The default value is 1, which means that no batching of transactions is done.