Note
This view is available starting with V4.1.0.
Purpose
This view displays the log stream archiving progress of the current tenant.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| DEST_ID | NUMBER(38) | NO | The ID of the archiving destination. |
| LS_ID | NUMBER(38) | NO | The ID of the log stream. |
| ROUND_ID | NUMBER(38) | NO | The ID of the log stream round. |
| PIECE_ID | NUMBER(38) | NO | The ID of the latest piece. |
| INCARNATION | NUMBER(38) | NO | The ID of the incarnation. |
| START_SCN | NUMBER(38) | NO | The SCN at which archiving starts. |
| MIN_LSN | NUMBER(38) | NO | The minimum LSN of the current piece. |
| MAX_LSN | NUMBER(38) | NO | The maximum LSN of the current piece. |
| CHECKPOINT_SCN | NUMBER(38) | NO | The maximum archiving progress of the current piece. |
| STATUS | VARCHAR2(64) | NO | The archiving status. |
| FILE_ID | NUMBER(38) | NO | The ID of the largest archiving file in the current piece. |
| FILE_OFFSET | NUMBER(38) | NO | The offset of the largest archiving file in the current piece. |
| INPUT_BYTES | NUMBER(38) | NO | The size of the log data read, in bytes. |
| OUTPUT_BYTES | NUMBER(38) | NO | The size of the archived log data, in bytes. |
Sample query
Query the log stream archiving progress of the current user tenant.
obclient [SYS]> SELECT * FROM SYS.DBA_OB_LS_LOG_ARCHIVE_PROGRESS\G
The query result is as follows:
*************************** 1. row ***************************
DEST_ID: 1002
LS_ID: 1
ROUND_ID: 1
PIECE_ID: 1
INCARNATION: 1
START_SCN: 1736228322307513000
MIN_LSN: 67104768
MAX_LSN: 130864876
CHECKPOINT_SCN: 1736235046704454000
STATUS: DOING
FILE_ID: 2
FILE_OFFSET: 63760108
INPUT_BYTES: 63760108
OUTPUT_BYTES: 63760108
*************************** 2. row ***************************
DEST_ID: 1002
LS_ID: 1001
ROUND_ID: 1
PIECE_ID: 1
INCARNATION: 1
START_SCN: 1736228322307513000
MIN_LSN: 67104768
MAX_LSN: 92335200
CHECKPOINT_SCN: 1736235046402227000
STATUS: DOING
FILE_ID: 2
FILE_OFFSET: 25230432
INPUT_BYTES: 25230432
OUTPUT_BYTES: 25230432
2 rows in set