VIEW: SYS.DBA_COMPARISON_SCAN_SUMMARY

Source

View Text - Preformatted

SELECT
  u.name                       owner,
  r.comparison_name            comparison_name,
  s.scan_id                    scan_id,
  s.parent_scan_id             parent_scan_id,
  s.spare3                     root_scan_id,
  decode(s.status, 1, 'SUC',
                   2, 'BUCKET DIF',
                   3, 'FINAL BUCKET DIF',
                   4, 'ROW DIF') status,
  s.spare1                     current_dif_count,
  s.spare2                     initial_dif_count,
  s.num_rows                   count_rows,
  decode(bitand(s.flags, 1), 1, 'Y', 'N') scan_nulls,
  s.last_update_time           last_update_time
FROM comparison_scan$ s, comparison$ r, user$ u
WHERE
    s.comparison_id = r.comparison_id
AND r.user# = u.user#

View Text - HTML Formatted

SELECT U.NAME OWNER
, R.COMPARISON_NAME COMPARISON_NAME
, S.SCAN_ID SCAN_ID
, S.PARENT_SCAN_ID PARENT_SCAN_ID
, S.SPARE3 ROOT_SCAN_ID
, DECODE(S.STATUS
, 1
, 'SUC'
, 2
, 'BUCKET DIF'
, 3
, 'FINAL BUCKET DIF'
, 4
, 'ROW DIF') STATUS
, S.SPARE1 CURRENT_DIF_COUNT
, S.SPARE2 INITIAL_DIF_COUNT
, S.NUM_ROWS COUNT_ROWS
, DECODE(BITAND(S.FLAGS
, 1)
, 1
, 'Y'
, 'N') SCAN_NULLS
, S.LAST_UPDATE_TIME LAST_UPDATE_TIME FROM COMPARISON_SCAN$ S
, COMPARISON$ R
, USER$ U WHERE S.COMPARISON_ID = R.COMPARISON_ID AND R.USER# = U.USER#