REPORT
Valid For
Extract and Replicat
Description
Use the REPORT
parameter to specify the interval at which Extract or Replicat generates interim runtime statistics in a process report. The statistics are added to the existing report. By default, runtime statistics are displayed at the end of a run unless the process is intentionally killed.
The statistics for REPORT
are carried over from the previous report. For example, if the process performed 10 million inserts one day and 20 million the next, and a report is generated at 3:00 each day, then the first report would show the first 10 million inserts, and the second report would show those plus the current day's 20 million inserts, totalling 30 million. To reset the statistics when a new report is generated, use the STATOPTIONS
parameter with the RESETREPORTSTATS
option. See "STATOPTIONS" for more information.
For more information about the process reports, see Administering Oracle GoldenGate.
Default
Generate runtime statistics at the end of each run.
Syntax
REPORT {AT hh:mi | ON day | AT hh:mi ON day}
-
AT
hh:mi
-
Generates the report at a specific time of the day. Using
AT
withoutON
generates a report at the specified time every day. -
ON
day
-
Generates the report on a specific day of the week. Valid values are:
SUNDAY MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY SATURDAY
The values are not case-sensitive.
Parent topic: Oracle GoldenGate Parameters