[Home] [Help] [Dependency Information]
Object Name: | DBA_COMPARISON_SCAN |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Details about a comparison scan
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Yes | Owner of comparison |
COMPARISON_NAME | VARCHAR2 | (128) | Yes | Name of comparison |
SCAN_ID | NUMBER | Yes | Scan id of scan | |
PARENT_SCAN_ID | NUMBER | Immediate parent scan's scan id | ||
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 (incl children) dif count of scan | ||
INITIAL_DIF_COUNT | NUMBER | Initial cumulative (incl children) dif count of scan | ||
COUNT_ROWS | NUMBER | Number of rows in the scan | ||
SCAN_NULLS | VARCHAR2 | (1) | Whether NULLs are part of this scan | |
LAST_UPDATE_TIME | TIMESTAMP(6) | (11) | The time that this row was updated |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, COMPARISON_NAME
, SCAN_ID
, PARENT_SCAN_ID
, ROOT_SCAN_ID
, STATUS
, CURRENT_DIF_COUNT
, INITIAL_DIF_COUNT
, COUNT_ROWS
, SCAN_NULLS
, LAST_UPDATE_TIME
FROM SYS.DBA_COMPARISON_SCAN;
|
|
|