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
{RECORD | RECORDS | SECOND | SECONDS | MINUTE | MINUTES | HOUR |HOURS} [, RATE]
-
count
-
The interval after which to output a count.
-
RECORD | RECORDS | SECOND | SECONDS | MINUTE | MINUTES | HOUR |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. The
Rate
statistic is the total number of records divided by the total time elapsed since the process started. TheDelta
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)