REPORTCOUNT

Valid For

Extract and Replicat

Description

Use the REPORTCOUNT parameter to report a count of transaction records that Extract or Replicat processed since startup. Each transaction record represents a logical database operation that was performed within a transaction that was captured by Oracle GoldenGate. The record count is printed to the report file and to the screen.

Note:

This count might differ from the number of records that are contained in the Oracle GoldenGate trail. If an operation affects data that is larger than 4K, it must be stored in more than one trail record. Hence, a report count might show 1,000 records (the database operations) but a trail count might show many more records than that. To obtain a count of the records in a trail, use the Logdump utility.

You can schedule record counts at regular intervals or after a specific number of records. Record counts are carried over from one report to the other.

REPORTCOUNT can be used only once in a parameter file. If there are multiple instances of REPORTCOUNT, Oracle GoldenGate uses the last one.

Default

None

Syntax

REPORTCOUNT [EVERY] count
{RECORDS | SECONDS | MINUTES | HOURS} [, RATE]
count

The interval after which to output a count.

RECORDS | SECONDS | MINUTES | HOURS

The unit of measure for count, in terms of records, seconds, minutes, or hours.

RATE

Reports the number of operations per second and the change in rate, as a measurement of performance. See Example 2. The Rate statistic is the total number of records divided by the total time elapsed since the process started. The Delta statistic is the number of records since the last report divided by the time since the last report.

Note:

The calculations are done using microsecond time granularity. The time intervals are shown without fractional seconds, and the rate values are shown as whole numbers.

Examples

Example 1   

This example generates a record count every 5,000 records.

REPORTCOUNT EVERY 5000 RECORDS
Example 2   

This example generates a record count every ten minutes and also reports processing statistics.

REPORTCOUNT EVERY 10 MINUTES, RATE

The processing statistics are similar to this:

12000 records processed as of 2011-01-01 12:27:40 (rate 203,delta 308)