Note
This view is available starting with V4.0.0.
Purpose
This view displays the status and recovery progress of the log streams of the current tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| LS_ID | NUMBER | NO | The log stream ID. |
| STATUS | VARCHAR2(100) | NO | The status of the log stream. Valid values: CREATING: The log stream is being created.CREATED: The log stream is created.NORMAL: The log stream is available.DROPPING: The log stream is being dropped. All tablets on the log stream must be migrated before the log stream is dropped.TENANT DROPPING: The log stream is being dropped because its tenant is being dropped.WAIT OFFLINE: The log stream has been dropped. The data of the log stream is being garbage-collected.CREATE ABORT: The log stream is being dropped because the log stream creation failed or the log stream is not required. |
| CREATE_SCN | NUMBER | NO | The start SCN of the log stream. |
| DROP_SCN | NUMBER | NO | The end SCN of the log stream. |
| SYNC_SCN | NUMBER | NO | The synchronization SCN of the log stream. |
| READABLE_SCN | NUMBER | NO | The readable SCN of the log stream. |
| PRIMARY_ZONE | CLOB | YES | The election priority of the log stream. |
| UNIT_GROUP_ID | NUMBER | NO | The ID of the unit group. |
| LS_GROUP_ID | NUMBER | NO | The ID of the log stream group. |
Sample query
Query the status and recovery progress of the log streams of the current user tenant.
obclient [SYS]> SELECT * FROM SYS.DBA_OB_LS;
The query result is as follows:
+-------+--------+--------------+---------------+-------------+---------------------+----------+---------------------+---------------------+------+
| LS_ID | STATUS | PRIMARY_ZONE | UNIT_GROUP_ID | LS_GROUP_ID | CREATE_SCN | DROP_SCN | SYNC_SCN | READABLE_SCN | FLAG |
+-------+--------+--------------+---------------+-------------+---------------------+----------+---------------------+---------------------+------+
| 1 | NORMAL | zone1 | 0 | 0 | NULL | NULL | 1736391889135078000 | 1736391889135078000 | NULL |
| 1001 | NORMAL | zone1 | 1002 | 1001 | 1736152507462028000 | NULL | 1736391889135078000 | 1736391889135078000 | NULL |
+-------+--------+--------------+---------------+-------------+---------------------+----------+---------------------+---------------------+------+
2 rows in set