Note
This view is available starting with V4.6.0.
Purpose
The DBA_OB_LOB_CHECK_TASKS view is used to record the progress of LOB consistency verification and task scanning for recovery under the current tenant.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| LS_ID | NUMBER(38) | NO | Log Stream ID |
| TABLE_NAME | VARCHAR2(256) | NO | Table Name |
| TABLE_ID | NUMBER(38) | NO | Table ID |
| TABLET_ID | NUMBER(38) | NO | Partition ID |
| TASK_ID | NUMBER(38) | NO | ID of the current batch task |
| START_TIME | VARCHAR2(256) | NO | Task Start Time |
| END_TIME | VARCHAR2(256) | NO | End Time |
| TRIGGER_TYPE | VARCHAR2(8) | NO | Task trigger type. Valid values: SYSTEM and USER |
| STATUS | VARCHAR2(10) | NO | Task status.
|
| MISS_CNT | NUMBER(38) | NO | Number of Missing Data Records in the Auxiliary Table Scanned by Consistency Verification |
| MISMATCH_LEN_CNT | NUMBER(38) | NO | Number of Data Records with Inconsistent Byte Lengths Scanned in Primary and Secondary Tables during Consistency Verification |
| ORPHAN_CNT | NUMBER(38) | NO | Number of Residual Data in Auxiliary Tables Scanned by Consistency Verification |
| CORRECT_CNT | NUMBER(38) | NO | Number of Abnormalities Restored for Deleted Auxiliary Tables in Consistency Recovery |
| RET_CODE | VARCHAR2(2048) | NO | Status at Task Completion |
| TASK_TYPE | VARCHAR2(10) | NO | TTL Task Type ("LOB_CHECK" or "LOB_CORRECT") |
| TASK_SCOPE | VARCHAR2(6) | NO | Task type. Valid values:
|
Sample query
obclient > SELECT * FROM DBA_OB_LOB_CHECK_TASKS;