Valid for
Extract, Replicat
Description
Use LAGSTATS
to periodically collect, and optionally report, lag and other performance-related statistics to the report file.
Syntax
LAGSTATS [, INTERVALunit num_units] [, THRESHOLDunit num_units] [, REPORT]
INTERVAL
unit
num_units
The interval for which data is collected and optionally reported. For example, INTERVALSECONDS 30
collects statistics for the last thirty seconds; statistics related to peaks and averages are reset every thirty seconds.
unit
can be one of:
MSECS
(milliseconds)
CSECS
(centiseconds)
SECONDS
MINUTES
HOURS
DAYS
THRESHOLD
unit
num_units
Reports percentages of records processed above or below a time lag threshold. For example, THRESHOLDMSECS 500
reports the percentage of records replicated on the target database within 500 milliseconds of entry into the source database. You can specify up to four thresholds.
REPORT
Statistics are output to the report file whenever a reporting interval is passed. If REPORT
is not specified, you can retrieve statistics with the GGSCI SEND
command, using the LAGSNAPSHOT
option.