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 without ON 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.

Examples

Example 1   

REPORT AT 17:00

Example 2   

REPORT ON SUNDAY AT 1:00