DBA_COMPARISON_SCAN displays details about all comparison scans in the database.
USER_COMPARISON_SCAN displays details about all comparison scans owned by the current user. This view does not have the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of comparison scan |
COMPARISON_NAME |
VARCHAR2(30) |
NOT NULL |
Name of comparison scan |
SCAN_ID |
NUMBER |
NOT NULL |
Scan ID |
PARENT_SCAN_ID |
NUMBER |
Scan ID of the immediate parent scan | |
ROOT_SCAN_ID |
NUMBER |
Scan ID of the root (top-most) parent | |
STATUS |
VARCHAR2(16) |
Status of scan: SUC, BUCKET DIF, FINAL BUCKET DIF, ROW DIF | |
CURRENT_DIF_COUNT |
NUMBER |
Current cumulative (including children) diff count of the scan | |
INITIAL_DIF_COUNT |
NUMBER |
Initial cumulative (including children) diff count of the scan | |
COUNT_ROWS |
NUMBER |
Number of rows in the scan | |
SCAN_NULLS |
VARCHAR2(1) |
Whether or not NULLs are part of this scan | |
LAST_UPDATE_TIME |
TIMESTAMP(6) |
The time that this row was last updated |