Use TRANSHIST
to keep track of the size of transactions in a trail or file. Logdump tracks the transactions in an internal history table in descending order according to the number of bytes of data in each one. When the history table is full, the smallest transaction is removed to allow a larger transaction to be added to the list.
Use TRANSHIST
in conjunction with other Logdump commands to determine whether or not your applications generate large transactions and to identify their relative size. This information can be used when deciding how to group tables into different processing groups for faster throughput. For more information, see "Evaluating Transaction Size".
Note:
You can use the SEND EXTRACT
command with the SHOWTRANS
option to view a list of long-running transactions. Other options enable you to control whether those transactions are ignored or processed by Oracle GoldenGate.
Default
0 (do not maintain history)
Syntax
TRANSHIST n
Example
TRANSHIST 150