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 archive 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 incarnation ID. |
| START_SCN | NUMBER(38) | NO | The starting SCN of the archive. |
| 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 archive progress of the current piece. |
| STATUS | VARCHAR2(64) | NO | The archive status. |
| FILE_ID | NUMBER(38) | NO | The ID of the largest archive file of the current piece. |
| FILE_OFFSET | NUMBER(38) | NO | The offset of the largest archive file of the current piece. |
| INPUT_BYTES | NUMBER(38) | NO | The amount of log data read. |
| OUTPUT_BYTES | NUMBER(38) | NO | The amount of archived log data. |
Sample query
Query the log stream archiving progress of the current 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