Note
This view is available starting with V4.0.0.
Purpose
This view displays the status and restore progress of log streams in the current tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| LS_ID | bigint(20) | NO | The ID of the log stream. |
| STATUS | varchar(100) | NO | The status of the log stream. Valid values:
|
| PRIMARY_ZONE | longtext | YES | The priority zone for the log stream. |
| UNIT_GROUP_ID | bigint(20) | NO | The ID of the unit group.
Note
|
| LS_GROUP_ID | bigint(20) | NO | The ID of the log stream group. For the system log stream (log stream 1) and broadcast log stream, the value of this field is 0, indicating that the log stream does not belong to a log stream group. |
| CREATE_SCN | bigint(20) unsigned | NO | The starting point of the log stream. |
| DROP_SCN | bigint(20) unsigned | NO | The point at which the log stream is dropped. This point marks the end of all user data. If the log stream is dropped, this field records the SCN when the log stream is dropped. If the log stream is not dropped, this field is empty. |
| SYNC_SCN | bigint(20) unsigned | NO | The synchronization point of the log stream. This point marks the SCN of the last transaction that is successfully synchronized. |
| READABLE_SCN | bigint(20) unsigned | NO | The readable point of the log stream. This point marks the minimum SCN of the log stream that can be read. |
| FLAG | varchar(2048) | NO | The flag of the log stream. Valid values:
NoteThis field is available starting with V4.2.0. |
| UNIT_LIST | varchar(1216) | NO | The list of units for the user log stream. The value of this field is empty for the system log stream and broadcast log stream if no specific location is specified.
Note
|
Sample query
Query the status and restore progress of log streams in the sys tenant.
obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.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 | UNIT_LIST |
+-------+--------+--------------+---------------+-------------+------------+----------+----------+--------------+------+-----------+
| 1 | NORMAL | zone1 | 0 | 0 | NULL | NULL | NULL | NULL | | |
+-------+--------+--------------+---------------+-------------+------------+----------+----------+--------------+------+-----------+
1 row in set
References
Query the status and restore progress of log streams in all tenants: CDB_OB_LS
For more information about log stream replicas, see Replica introduction.