1.192 WARNLONGTRANS
Valid For
Extract
Description
Use the WARNLONGTRANS
parameter to specify a length of time that a transaction can be open before Extract generates a warning message that the transaction is long-running. Also use WARNLONGTRANS
to control the frequency with which Oracle GoldenGate checks for long-running transactions.
This parameter is valid for Oracle and SQL Server.
When WARNLONGTRANS
is specified, Oracle GoldenGate checks for transactions that satisfy the specified threshold, and it reports the first one that it finds to the Oracle GoldenGate error log, the Extract report file, and the system log. By default, Oracle GoldenGate repeats this check every five minutes.
To view a list of open transactions on demand, to output transaction details to a file, or to either cancel those transactions or force them to the trail, use the options of the SEND EXTRACT
command.
Default
One hour (and check every five minutes using a separate processing thread)
Syntax
WARNLONGTRANS duration [, CHECKINTERVAL interval] [, NOUSETHREADS] [, USELASTREADTIME]
-
duration
-
Sets a length of time after which an open transaction is considered to be long-running. The duration is specified as a whole number, followed by the unit of time in any of the following formats to indicate seconds, minutes, or hours. Do not put a space between the numeric value and the unit of time. The unit is not case-sensitive. The default is one hour.
S|SEC|SECS|SECOND|SECONDS M|MIN|MINS|MINUTE|MINUTES H|HOUR|HOURS D|DAY|DAYS
The following are examples of valid durations:
WARNLONGTRANS 1DAY WARNLONGTRANS 600sec WARNLONGTRANS 40s
-
CHECKINTERVAL
interval
-
Sets the frequency at which Oracle GoldenGate checks for transactions that satisfy
WARNLONGTRANS
and reports the longest running one. The interval is specified as a whole number, followed by the unit of time in any of the following formats to indicate seconds, minutes, or hours. Do not put a space between the numeric value and the unit of time. The unit is not case-sensitive. The default is five minutes, which is also the minimum valid value. The minimum value is 300 and the maximum is 20000000.S|SEC|SECS|SECOND|SECONDS M|MIN|MINS|MINUTE|MINUTES H|HOUR|HOURS D|DAY|DAYS
CHECKINTERVAL 1day CHECKINTERVAL 600SEC CHECKINTERVAL 2m
-
NOUSETHREADS
-
Valid for Oracle.
Specifies that the monitoring will be done by the main process thread. By default, it is done with a separate thread for performance reasons.
NOUSETHREADS
should only be used if the system does not support multi-threading. -
USELASTREADTIME
-
Valid for Oracle.
Forces Extract to always use the time that it last read the Oracle redo log to determine whether a transaction is long-running or not. By default, Extract uses the timestamp of the last record that it read from the redo log. This applies to an Extract that is running in archive log only mode, as configured with
TRANLOGOPTIONS
using theARCHIVEDLOGONLY
option.
Example
NOUSETHREADS
Parent topic: Oracle GoldenGate Parameters