Details For all Finished Compare Pairs Page

Use the Details for Finished Compare Pair page to view near-real-time information about a compare pair that is finished.

The upper portion of the page shows specific information about the compare pair as follows:

Field	Description
Compare Pair Name	The name for the compare pair.
Source Table and Target Table	The names of the underlying source and target objects.
Compare Pair Run ID	The identifier used by Oracle GoldenGate Veridata Server while running a comparison. It is useful for locating messages related to this comparison in the veridata.log file, which is used for troubleshooting purposes when resolving support cases.
Compare Pair Start Time	The time when processing started for this compare pair.
Compare Pair Run Duration	How long it took to process this compare pair.
Run Status	The outcome of this comparison (Waiting, Canceled, Canceling, Running, Finished).
Comparison Status	The status of the comparison (see Possible comparison status conditions.) If delta processing is enabled for this compare pair, the delta symbol is displayed.
Repair Status	The repair status of compare pair. If compare pair is In-Sync during initial compare or, repair is never attempted, the column is left blank.
Overall Rows Compared	The total number of rows in the source and target objects that were compared during this run of the compare pair.
Overall Rows With Out-Of-Sync	The number of rows in the source and target objects that are out-of-sync.

Using the Charts

The charts on this page help you to determine what types of operations are causing the most out-of-sync conditions and which phases of processing are taking the most time to complete.

Overall Rows Compared Pie Chart

Plots the result from the Overall Rows Compared field according to the possible outcomes of the comparison: In-Sync or Out-Of-sync.

Operations Out-Of-Sync Pie Chart

Plots the number of out-of-sync rows according to their operation type:

Inserts: source table has the row, but the target does not.
Updates: source table has different row values from the target.
Deletes: target table has the row, but the source does not.

Compare Pair Performance Table

Lists performance statistics based on each phase of a run: the sorting phase (for source and target), the initial comparison phase, and the confirmation phase.

Note: sorting statistics are only available if the job profile specifies server-side sorting (row sorts are performed by Oracle GoldenGate Veridata, not by the database engines).

Start Time: The time that a run phase started.
Run Duration: The amount of time that it took to complete a run phase.
Rows Processed: The number of rows that were processed in a run phase.
Rows Per Second: The performance rate of a run phase, in terms of rows processed.
Bytes Processed: The overall volume of data, in bytes, that was processed in a run phase.
Bytes Per Second: The performance rate of a run phase, in terms of bytes processed.

Compare Pair Performance History Chart

Plots the performance of each of the run phases as a bar chart. To use this chart:

From View Step, select a run phase to plot.
- Initial comparison step: Select Initial Compare.
- Confirmation step: Select Confirm Out-Of-Sync.
- Sorting process: Select Sorting.
From View Performance History By, select the criterion for this performance analysis. This sets the units of measure for the vertical axis of the chart. You can measure:
- Number of rows or bytes that were processed
- Number of rows or bytes per second that were processed
- Run duration (the time spent processing the rows)

Other Actions From Here

To view a report of the results for this run of this compare pair, click View Comparison Report.

To view details about out-of-sync rows, including column values, click View Out-Of-Sync Rows. This link only appears if the compare pair has out-of-sync rows.

To edit this compare pair, click Compare Pair Configuration at the top of the page to go to the Compare Pair Configuration page.